Problem Inserting Multiple Arrays into Database

Question

I was inserting multiple arrays into my database using this code:

$queries_cols = array(); 

for($i=0; $i<count($cols); $i++) 
{ 
    $queries_cols [] = "('".$cols[$i]."','".$int_manha1_1[$i]."','".$int_manha1_2[$i]."','" .$int_tarde2_1[$i]."','".$int_tarde2_2[$i]."','".$h1_1[$i].$h1_2[$i]."','".$h2_1[$i].$h2_2[$i]."')" ; 
}

$query_col = "INSERT into cols_ponto_diaria values '".implode(",", $queries_cols)."'";

$result = mysql_query($query_col) or die("Erro: ".mysql_error());

And when I submit the form it output an error:

Erro: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''('Ricardo','08:30:00','12:15:00','14:45:00','18:00:00','0115','1215')'' at line 1

Can anyone find where is the error? I've tried a few solutions but without any success.

Thanks in advance.

First port of call: Output the actual query that gets generated using echo $query_col;. — Pekka
– Pekka, Commented Jul 31, 2010 at 18:18

Alexandros V · Accepted Answer · 2010-07-31 18:24:56Z

1

You could easily find it by printing $query_col as soon as you have it ready.

Anyway, the error I believe is in the implode() call. You don't need the extra quotes.

So instead of

$query_col = "INSERT into cols_ponto_diaria values '".implode(",", $queries_cols)."'";

try

$query_col = "INSERT into cols_ponto_diaria values ".implode(",", $queries_cols);

answered Jul 31, 2010 at 18:24

Alexandros V

5604 silver badges11 bronze badges

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

1 Comment

l3gion Over a year ago

Yeah, I got it. :) Thanks anyway.

Srinivas Reddy Thatiparthy · Accepted Answer · 2010-07-31 18:21:15Z

1

Remove the single quote at the end of this expression,

INSERT into cols_ponto_diaria values

Don't append the single quote at the end of the expression.

."'"

answered Jul 31, 2010 at 18:21

Srinivas Reddy Thatiparthy

11.2k4 gold badges48 silver badges68 bronze badges

1 Comment

l3gion Over a year ago

I saw your reply after I found the solution. Thank you Srinivas Reddy Thatiparthy.

l3gion · Accepted Answer · 2010-07-31 18:23:45Z

0

Solution found. I tried several things and I forgot to try this approach. :(

Sorry for disturbing.

Here's the correct syntax:

$query_col = "INSERT into cols_ponto_diaria values ".implode(",", $queries_cols);

regards

answered Jul 31, 2010 at 18:23

l3gion

732 silver badges9 bronze badges

Collectives™ on Stack Overflow

Problem Inserting Multiple Arrays into Database

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related