PHP Insert multiple records into mysql from one json string [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 7 years ago.

Improve this question

$array = array(); 
foreach ($Addproduct_image as $row) { 
$array[] = '("' . mysql_real_escape_string($row["image"]) . '", ' . $row["color"] . ' , ' . $last_ID .')'; } 
$stmt1 = $this->con->prepare("INSERT INTO Product_img_col (image, color, pro_ID) VALUES '.implode(",", $array[])"); 
if ($stmt1->execute()) {return true;} else{return false;}

// Data to add.
{"name":"world","color":"world",($Default_Value)}]

I want to add this data into multiple rows. I think I will have to use implode function for multiple rows with a default value for third column "$default-value". I am not very good in PHP can anyone please help .

$array = array(); foreach ($Addproduct_image as $row) { $array[] = '("' . mysql_real_escape_string($row["image"]) . '", ' . $row["color"] . ' , ' . $last_ID .')'; } $stmt1 = $this->con->prepare("INSERT INTO Product_img_col (image, color, pro_ID) VALUES '.implode(",", $array[])"); print_r($array); if ($stmt1->execute()) {return true;} else{return false;} I tried this — jerry
– jerry, Commented Aug 6, 2018 at 8:49
@jerry Refering to your ealier comment on an awnser; we are not here to do your work. We simply help if it aint working or see how to fix it, but its not we do your work. — Dorvalla
– Dorvalla, Commented Aug 6, 2018 at 8:49
@Dorvalla Let me Re-edit my question I tried something which was not working. — jerry
– jerry, Commented Aug 6, 2018 at 8:55
Possible duplicate of Parse JSON string contents into PHP Array — AymDev
– AymDev, Commented Aug 6, 2018 at 8:56

Dan Walker · Accepted Answer · 2018-08-06 09:11:49Z

0

As you are trying to add all items to the query you will need to remove the [] from the implode(",", $array[]) so it reads implode(",", $array).

You could try adding echo "INSERT INTO Product_img_col (image, color, pro_ID) VALUES '.implode(",", $array[])"); to your page so you have the query that you can test in phpMyAdmin or similar. This should help you debug.

Also if color is a string you should really put it inside quotes as you have done with image.

answered Aug 6, 2018 at 9:11

Dan Walker

4536 silver badges17 bronze badges

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

Comments

Vatev · Accepted Answer · 2018-08-06 08:45:13Z

-1

Use json_decode to get a php array from your JSON.
for each element in the array use json_encode to turn it into JSON again, and then insert that as a single row

answered Aug 6, 2018 at 8:45

Vatev

7,5801 gold badge36 silver badges42 bronze badges

1 Comment

jerry Over a year ago

I need code as well. I am not very good in PHP.

Pradeep · Accepted Answer · 2018-08-06 09:33:48Z

$connect = mysqli_connect("localhost", "root", "", "test");
$query = '';
$filename = "employee_data.json";
$data = file_get_contents($filename); //Read the JSON file in PHP
$array = json_decode($data, true); //Convert JSON String into PHP Array
foreach($array as $row) //Extract the Array Values by using Foreach Loop
{
      $query .= "INSERT INTO tbl_employee(name, gender, designation) VALUES ('".$row["name"]."', '".$row["gender"]."', '".$row["designation"]."'); ";  // Make Multiple Insert Query 
}

 if(mysqli_multi_query($connect, $query)) //Run Mutliple Insert Query
    {
         echo 'Imported JSON Data';
    }

JSON_File - employee_data.json

[  
       {  
         "name": "Michael Bruce",  
         "gender": "Male",  
         "designation": "System Architect"  
       },  
       {  
         "name": "Jennifer Winters",  
         "gender": "Female",  
         "designation": "Senior Programmer"  
       },  
       {  
         "name": "Donna Fox",  
         "gender": "Female",  
         "designation": "Office Manager"  
       }

     ]

For more details see the example in the below URL, It may help you

https://www.webslesson.info/2016/04/get-multiple-json-data-insert-into-mysql-database-in-php.html

Collectives™ on Stack Overflow

PHP Insert multiple records into mysql from one json string [closed]

3 Answers 3

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Linked

Related