php mysqli multi_query - ignore second query

Question

If I execute example.php, everything looks fine, but the second query (with a2,b2,c2) is not inserted into my table. I tried more queries, but it is always the second which is "ignored". Is it bug, feature or my mistake..? PHP v5.3.3, MySQL v5.1.73

example.php:

$conn = new mysqli($servername, $username, $password, $dbname);
...
$query = "INSERT into mytable (a,b,c) values ('a1','b1','c1');";
$query .= "INSERT into mytable (a,b,c) values ('a2','b2','c2');";
$query .= "INSERT into mytable (a,b,c) values ('a3','b3','c3');";
$query .= "INSERT into mytable (a,b,c) values ('a4','b4','c4')";
...
if ($conn->multi_query($query) === TRUE)
...

Is it the post mistake only, missing the semicolon on the 4th row? — Kancho Iliev, Nov 01 '17 at 11:18
check for errors then, I don't see any checking here. `mysqli_error($conn)` — Funk Forty Niner, Nov 01 '17 at 11:18
And is some of a,b or c columns main index or unique. If yes - what about data - may be there is problem. — Kancho Iliev, Nov 01 '17 at 11:24
2 Kancho Iliev : unique is "a", but it is not the problem here, im inserting 100 % unique data.. — pEpe, Nov 01 '17 at 11:37

score -1 · Answer 1 · answered Nov 01 '17 at 11:20

-1

have you tried this?

 $query = "INSERT into mytable (a,b,c) values ('a1','b1','c1')";
    $query .= ",('a2','b2','c2')";
    $query .= ",('a3','b3','c3')";
    $query .= ",('a4','b4','c4')";
    ...
    ...

    $query .=";";
if ($conn->multi_query($query) === TRUE)

answered Nov 01 '17 at 11:20

romal tandel

481
12
19

1

"Have you tried" is a comment and this is just like changing 4 quarters for a dollar. – Funk Forty Niner Nov 01 '17 at 11:24

php mysqli multi_query - ignore second query

1 Answers1