[SOLVED] Problem with adding variables into MySQL database

[peddel]

$dag = date("d", time());
	$maand = date("m", time());
	$jaar = date("Y", time());
	$uur = date("H", time());
	$minuten = date("i", time());
	$sql = 'INSERT INTO `ivoo_voorontwerp`.`testtabel` (`id`, `dag`, `maand`, `jaar`, `uur`, `minuten`, `PR`, `tag`, `waarde`, `eenheid`, `verschil`, `bovengrensOperator`, `ondergrensOperator`, `bovengrensOpvolging`, `ondergrensOpvolging`, `ploeg`, `oorsprongData`, `periodiciteit`) VALUES (0,\'$dag\', \'$maand\', \'$jaar\', \'$uur\', \'$minuten\', \'PR1\', \'naam\', \'$naam\', \'\', \'\', \'\', \'\', \'\', \'\', \'$ploeg\', \'operator\', \'\');';
	$result = @mysql_query($sql);
	if(!$result){print("Query mislukt [".mysql_error()."]");}

 

if u execute this and trough phpmyadmin check the items in the table, i find that it has inputted this :

 

id 	dag 	maand 	jaar 	uur 	minuten
1 	$dag 	$maand 	$jaar 	$uur 	$minuten

 

i dont know why it doesnt take the values of those variables, can someone help?

[GingerRobot]

Variables inside single quotes are not evaluated. They are treated as literals. That is:

 

$foo = 'bar';
echo $foo;//echos bar
echo "$foo";//echos bar
echo '$foo';//echos $foo

 

So, wrap your $sql string in double quotes. It'll also then save you the headache of escaping all those single quotes inside your query.

[peddel]

thx for the answer,

this did the job