Build MySQL Query using a string INTO the Statement

Question

I build an "INSERT INTO" MySQL query using a string, but this query updates just column "date" and return me "0" as value of column "id"

$c= "2013-11-29 12:00:00";//whole code
$d= "2013-11-30 12:00:00";
$date_3 = date("Y-m-d g:i:s", strtotime("$c"));
$date_4 = date("Y-m-d g:i:s", strtotime("$d"));
$results = array($date_1);
$i = $date_3;
$allCane="";
while ($i <= $date_4) {
$i = date("Y-m-d g:i:s", strtotime($i));
array_push($results, $i);
$k= $i . "\n";
$chunks = str_split($k, 19);
$nexstring = join('\')', $chunks);
$cane = implode(', (\'{$id}\', \'', str_split($nexstring, 21));
$allCane .= $cane; // appends $cane to $allCane
$i = date("Y-m-d g:i:s",strtotime("+1 day", strtotime($i)));
}
$string ='(\'{$id}\', \' '.$allCane;
$string=substr($string,0,-12);
echo $string;//('{$id}', ' 2013-11-29 12:00:00'), ('{$id}', ' 2013-11-30 12:00:00')
$id=54;

$insert = mysql_query("INSERT INTO events (id, date) VALUES $string");
// i build the query using $string.

Sintax of $insert is correct, but actually I'm not able to update the column "id".

Any way to make working $id into the string?

Please don't use mysql_* functions anymore, they are deprecated. See Why shouldn't I use mysql_* functions in PHP? for details. Instead you should learn about prepared statements and use either PDO or MySQLi. If you can't decide which, this article will help you. If you pick PDO, here is a good tutorial. — Marcel Korpel
– Marcel Korpel, Commented Nov 14, 2013 at 16:07
In such cases, just write your SQL into a variable and not directly into your mysql command. That way you can output the generates query and debug it. Debugging is everything! — ToBe
– ToBe, Commented Nov 14, 2013 at 16:14
It seems your $string has the literal string '$id' in it. This won't magically be replaced by the $id variable. You need to set $id before you set $string and then add $id to it. — gen_Eric
– gen_Eric, Commented Nov 14, 2013 at 16:16
Or you need to use str_replace to replace '$id' with the value of $id. — gen_Eric
– gen_Eric, Commented Nov 14, 2013 at 16:21

Ghazanfar Mir · Accepted Answer · 2013-11-14 16:10:32Z

1

Variables enclosed inside single quotes ('') aren't parsed, therefore, always use double quotes ("") when enclosing variable names in a string..

USE BELOW

$insert = mysql_query("INSERT INTO events (id, date) VALUES ('{$id}', ' 2013-11-29 12:00:00'), ('{$id}', ' 2013-11-30 12:00:00')");

answered Nov 14, 2013 at 16:10

Ghazanfar Mir

3,5412 gold badges28 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Build MySQL Query using a string INTO the Statement

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related