probleem data en tijd in mysql
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
<?
$datetime = date("j-n-Y H:i");
$query="INSERT INTO gastenboek (name, email, content, ip, datetime) ";
$query .= "VALUES ('"; // let op positie van de enkele aanhalingstekens
$query .= $_POST["name"] ."', '" ;
$query .= $_POST["email"] ."', '" ;
$query .= $_POST["comment"] ."', '" ;
$query .= "$ip" ."', '" ;
$query .= "$datetime" ."');" ;
$result = mysql_query($query) or die ("FOUT: " . mysql_error());
?>
$datetime = date("j-n-Y H:i");
$query="INSERT INTO gastenboek (name, email, content, ip, datetime) ";
$query .= "VALUES ('"; // let op positie van de enkele aanhalingstekens
$query .= $_POST["name"] ."', '" ;
$query .= $_POST["email"] ."', '" ;
$query .= $_POST["comment"] ."', '" ;
$query .= "$ip" ."', '" ;
$query .= "$datetime" ."');" ;
$result = mysql_query($query) or die ("FOUT: " . mysql_error());
?>
En waarom zet je variabelen tussen quotes als je ze toch al aan elkaar dotterd?
Probeer onderstaande eens
Code (php)
1
2
3
4
5
6
2
3
4
5
6
<?
$query = "
INSERT INTO gastenboek (name, email, content, ip, datetime)
VALUES ('".mysql_real_escape_string($_POST["name"])."', '".mysql_real_escape_string($_POST["email"])."', '".mysql_real_escape_string($_POST["comment"])."', '".$ip."', NOW()) ";
$result = mysql_query($query) or die ("FOUT: " . mysql_error());
?>
$query = "
INSERT INTO gastenboek (name, email, content, ip, datetime)
VALUES ('".mysql_real_escape_string($_POST["name"])."', '".mysql_real_escape_string($_POST["email"])."', '".mysql_real_escape_string($_POST["comment"])."', '".$ip."', NOW()) ";
$result = mysql_query($query) or die ("FOUT: " . mysql_error());
?>
[url-http://www.phphulp.nl/php/tutorial/data-verwerking/foutafhandeling-query-sql/735/]Klik voor Foutafhandeling[/url]