PHP updating table from values with multidimensional array

Question

My php code is

for($i=1;$i<$rows;$i++)
{
    $flag=0;
   $result = mysqli_query($con,"SELECT id FROM `TABLE 1` ");
   while($row = mysqli_fetch_array($result))
   {
     //echo $row['id']."<br>";
     echo $cols[$i][0];
     if($row['id']==$cols[$i][0])//id exists in database=> update
     {
        echo"<br> ".$cols[$i][4];
        mysqli_query($con,"UPDATE `TABLE 1` SET `price`=$cols[$i][4]  WHERE `id`=07");
        //echo $cols[$i][0];
        $flag=1;
     }
    }
    if($flag==0)//Add new record in to database
    {
       //code for insert
    } 
}

It does not update the price

mysqli_query($con,"UPDATE TABLE 1 SET price=$cols[$i][4] WHERE id=07");

It update the value i.e. price if I enter it e.g.

mysqli_query($con,"UPDATE TABLE 1 SET price=100 WHERE id=07");

$cols[$i][4] Is an array and it gives the correct value when I echo it, but when the same value is applied for the update statement it does not take it.

Why do you have the SELECT at all? It seems entirely redundant. — Strawberry
– Strawberry, Commented Nov 8, 2013 at 13:18

doublesharp · Accepted Answer · 2013-11-08 13:22:48Z

1

Given the complexity of the variable you are inserting into your SQL statement - a multidimensional array - you can't just include it in the string like you would a simple variable ($var[0][1] vs $var). Either concatenate the string with . or surround the variable with curly braces { and }.

// using concatenation
$sql = "UPDATE `TABLE 1` SET price=".$cols[$i][4]." WHERE `id`=07";
// using curly braces
$sql = "UPDATE `TABLE 1` SET price={$cols[$i][4]} WHERE `id`=07";
mysqli_query( $con, $sql );

I would also recommend avoiding spaces and keywords in your table names if possible, it reduces the chances of errors in your SQL.

answered Nov 8, 2013 at 13:22

doublesharp

27.9k6 gold badges56 silver badges76 bronze badges

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

Comments

Jimesh Gajera · Accepted Answer · 2013-11-08 13:17:24Z

0

Try below query,

mysqli_query($con,"UPDATE `TABLE 1` SET `price`= '".$cols[$i][4]."'  WHERE `id`=07");

answered Nov 8, 2013 at 13:17

Jimesh Gajera

6122 gold badges11 silver badges32 bronze badges

Collectives™ on Stack Overflow

PHP updating table from values with multidimensional array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related