Inserting JSON Data into Database Table

Question

Is something like in the link below possible in Symfony2 ?

http://www.kodingmadesimple.com/2014/12/how-to-insert-json-data-into-mysql-php.html

My plan is to create a CRON Job that would hit a specific route which will execute logic in a controller that would persist json data into a database table at a set time every day.

So basically, I would grab the JSON file, extract the values I want and store them in variables, then persist them to a database table.

Guilherme Viebig · Accepted Answer · 2015-02-26 14:39:58Z

5

If you're using doctrine, you can simply do:

$data = json_decode($jsondata, true);
$entity = new Entity();

$entity->setName($data['personal']['name']);
$entity->setGender($data['personal']['gender']);

Then you just need to use the entitymanager, to persist it depending on you context:

$em->persist($entity);
$em->flush();

edited Feb 26, 2015 at 14:39

answered Feb 23, 2015 at 21:32

Guilherme Viebig

6,9403 gold badges30 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting JSON Data into Database Table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related