Storing array of elements in different rows of MYSQL from PHP is not working

Question

Below is my JSON data, where the value has array of data.

{"products":"[31, 49, 48, 47]"}

I need to store different products in different rows of my sql database.

Below is the PHP code where I able to get only the value.

$obj = json_decode($json);
$product_ids =  $obj->{'products'};

The result of $product_ids is [31, 49, 48, 47]

Now I have to traverse through the array of values in $product_idsand store each value in different rows of MYSQL database.

To store the values in different rows of MYSQL I tried the below code.

for($x = 0; $x < sizeof($product_ids); $x++)
{
$row = $product_ids[$x];
$q = mysql_query("Insert into table_name(column_name) values ('$row') ");
}

But I am not able to achieve what I actually want. Above code stores only the square bracket([) inside MYSQL, I am not able to store the elements of the array.

I am very new to PHP. Any help would be really greatfull.

Thanks.

if json was so '{"products":[31, 49, 48, 47]}; your code will be fine. Now $product_ids is string [31, 49, 48, 47]. You should remove brackets from the string an use explode() function. For example so $product_ids = explode(', ', trim($obj->{'products'}, '[]')); — splash58
– splash58, Commented Feb 3, 2016 at 9:57
Yeah.. Removed the brackets using the following code $string_ids = str_replace(array('[',']'),array(' '),$product_ids);. But Only "3" is stored in database. — Ramz
– Ramz, Commented Feb 3, 2016 at 10:02

Kevin Kopf · Accepted Answer · 2016-02-03 11:18:08Z

1

While obtaining the JSON value, I suggest you drop the square brackets. If it's vital for you to have them in your JSON, remove them in your PHP code.

$product_ids = trim($product_ids, "[]");

Once removed, you can extract numbers in your string into an array:

$productIdArray = explode(",", $product_ids);

Now, in $productIdArray you will have your values:

Array (
    0 => "31",
    1 => "49",
    2 => "48",
    3 => "47"
)

And now you can iterate over this array in order to put the required values into your database.

foreach($productIdArray as $productId) {
    mysql_query("INSERT INTO table_name(column_name) VALUES ('$productId') ");
}

Also please reconsider using mysql_*, it's deprecated

edited Feb 3, 2016 at 11:18

answered Feb 3, 2016 at 10:08

Kevin Kopf

14.3k15 gold badges57 silver badges69 bronze badges

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

Comments

splash58 · Accepted Answer · 2016-02-03 10:40:13Z

0

if json was so {"products":[31, 49, 48, 47]} your code will be fine. Now $product_ids is string [31, 49, 48, 47]. You should remove brackets from the string an use explode() function. For example so

$json = '{"products":"[31, 49, 48, 47]"}';

$obj = json_decode($json);
$product_ids = explode(', ', trim($obj->{'products'}, '[]'));
for($x = 0; $x < sizeof($product_ids); $x++)
{
$row = $product_ids[$x];
$q = mysql_query("Insert into table_name(column_name) values ('$row') ");
}

Demo

answered Feb 3, 2016 at 10:40

splash58

26.2k3 gold badges25 silver badges35 bronze badges

Comments

Ninju · Accepted Answer · 2016-02-03 10:17:28Z

0

Try this

$obj = '{"products":"[31, 49, 48, 47]"}';
$objArray = json_decode($obj,true);
$objArray = explode(',',trim($objArray['products'], "[]"));
foreach ($objArray as $key => $value){

   $q = mysql_query("Insert into table_name(column_name) values ('trim($value)') ");
}

answered Feb 3, 2016 at 10:17

Ninju

2,5322 gold badges16 silver badges21 bronze badges

Comments

Vadivel S · Accepted Answer · 2016-02-03 10:33:53Z

0

try like this

<?php

$json = '{"product":[31,49,48,47]}'; 
$obj = json_decode($json,true);
$product_ids= $obj['product'];
for($x = 0; $x < sizeof($product_ids); $x++)
{
$row = $product_ids[$x];
// $q = mysql_query("Insert into table_name(column_name) values ('$row') ");
}?>

work fine

answered Feb 3, 2016 at 10:33

Vadivel S

6608 silver badges15 bronze badges

Collectives™ on Stack Overflow

Storing array of elements in different rows of MYSQL from PHP is not working

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related