How do I insert data from a json array into mysql database? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 11 years ago.

Improve this question

I am trying for some time now to insert data from a JSON array into mysql database using php but what ever I try it is not working.

my array looks like so...

Array  
(  
    [] => -4.0533  
    [bert] => 2
    [earnie] => 0.25  
    [bigbird] => 0.25  
    [grouch] => 1.25  
)

I am trying to insert this data into mysql database that has a table named "useramounts" the table contains 2 columns. (username,amount) so that each row contains a username and the associated amount

this is probably very simple for you guys but I have never attempted this before. I have tried to google a solution but to no avail. Can anyone help me?

What have you tried so far? Perhaps reading up on PHP/MySQL and following a tutorial is a better place to start. If you have a specific question during the process, feel free to ask it here. — Joel
– Joel, Commented Feb 13, 2014 at 18:13
thanks joel for your polite response but i give up now so dont worry about it. — hd-pixel
– hd-pixel, Commented Feb 13, 2014 at 18:15
possible duplicate of Insert JSON array in mysql db from a php file — jww
– jww, Commented Feb 13, 2014 at 18:37
@noloader: The linked question does have an answer that is encouraging bad practice (it's creating an insert per loop). — Menno
– Menno, Commented Feb 13, 2014 at 18:43

Community · Accepted Answer · 2023-11-17 20:08:53Z

What have you tried?

Try this approach:

Convert JSON to PHP array (json_decode())
Loop through the array, get the key and value for each entry (foreach(){}, array_keys())
Create a single string with an insert and add VALUES() for each row

Execute the query after the loop

 $keys = array_keys($array);              // get the value of keys
 $rows = array();                         // create a temporary storage for rows
 foreach($keys as $key) {                 // loop through
     $value = $array[$key];               // get corresponding value
     $rows[] = "('" . $key . "', '" . $value . "')";
                                          // add a row to the temporary storage 
 }
 $values = implode(",", $rows);           // 'glue' your rows into a query
 $query = "INSERT INTO ... VALUES " . $values;
                                          // write the rest of your query
 ...                                      // execute query

As soon as you find a concrete question, feel free to open another post.

Collectives™ on Stack Overflow

How do I insert data from a json array into mysql database? [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related