Insert array value into MySQL by PHP [duplicate]

Question

How can I insert this array to database using loop?

Array ( 
[0] => 1 
[1] => 0 
[2] => 0 
)

I try like this way:

$chimp= Array ( 
    [0] => 1 
    [1] => 0 
    [2] => 0 
    ) 

foreach ($reponse as  $value) {
        $values= mysql_real_escape_string($value);
                foreach ($chimp as $valuech  ) {
                    $valuesch= mysql_real_escape_string($valuech);

     $query = mysql_query("INSERT INTO reponses (nom_reponse,id_question,id_categorie,correct2) VALUES ('$values','$last_id','$categorie','$valuesch')") 
        or die(mysql_error());


                        }
                        }

I need the steps to insert $reponse and $chimp data in each row?

For starters you don't show the $response array... Suggestion use mysqli instead of deprecated mysql , then use mysqli prepare — lukesUbuntu
– lukesUbuntu, Commented Jun 12, 2015 at 1:30
i'm able to insert the first foreach for reponse ; but i could not insert the second value for this array . the question is how can insert the value 0 0 1 to database thanks for replay — 4code
– 4code, Commented Jun 12, 2015 at 1:33

chris85 · Accepted Answer · 2015-06-12 01:55:35Z

0

You are looping incorrectly currently your insert will execute 9 times. Whereas you want it to execute three times.

Example of current execution:

http://sandbox.onlinephpfunctions.com/code/ef1821fb0fe7dcc96a3f48e9ec8453 8cdfb5db62

You need to use the key to pair up both array values, you could do that with a for loop or by using the key in the foreach, http://php.net/manual/en/control-structures.foreach.php.

<?php
$reponse = array (1, 0 ,0);
$chimp = array (1, 0, 0);
foreach ($reponse as $key => $value) {
    $values= mysql_real_escape_string($value);
    $valuesch= mysql_real_escape_string($chimp[$key]);
    $query = mysql_query("INSERT INTO reponses (nom_reponse,id_question,id_categorie,correct2) VALUES ('$values','$last_id','$categorie','$valuesch')") 
        or die(mysql_error());
    }
}

I don't know where $last_id or $categorie are coming from so make sure those values are correct.

Here's how the loop will process now. http://sandbox.onlinephpfunctions.com/code/1b8af87984c348a326a64e2d453ddcdf17b65b5f

I didn't touch the SQL, looks right to me presuming your column names are correct.

answered Jun 12, 2015 at 1:55

chris85

23.9k7 gold badges36 silver badges51 bronze badges

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

1 Comment

4code Over a year ago

thanks a lot sir for replay this is a good example that help me to understand and it work for me :)

Collectives™ on Stack Overflow

Insert array value into MySQL by PHP [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related