Menu
Community /Pin to ProfileBookmark
@NogDogDec 27.2007 — #First thing that jumps out at me is that it appears you are missing a comma between the last two values in your query.
To get more useful debug info, you could change the "or die" after the query to something like:
The above is good for debugging, but you'll probably want to do some sort of error_log() for the production version rather than outputting database info to the browser should a query fail.
Error Please Help
Part of code!
[code=php]<?php
if($_REQUEST[‘do’]){
$page=$_SERVER[‘PHP_SELF’];
$cxn = mysqli_connect(“localhost”, “phpworker”, “030892w”, “worker”); //Host, User, Pass, DBName
$projectName=stripslashes($_REQUEST[‘projectName’]);
if(strlen($projectName) <= 0){
header(“location: {$page}?msg=ERROR”);
}
$projectDesc=stripslashes($_REQUEST[‘projectDesc’]);
if(strlen($projectDesc) <= 0){
header(“location: {$page}?msg=ERROR”);
}
$email=stripslashes($_REQUEST[’email’]);
if(strlen($email) <= 0){
header(“location: {$page}?msg=ERROR”);
}
$owner=$_SESSION[‘user’];
$rdate=date(“D-M-Y h:i:s”);
$sql=”
INSERT INTO `projects` (`owner`, `projectName`, `projectDesc`, `ownerEmail`, `rdate`) VALUES (‘$owner’, ‘$projectName’, ‘$projectDesc’, ‘$email’ ‘$rdate’)
“;
$result = mysqli_query($cxn, $sql) or die (“There was an Error.”);
}
?>
Can someone help it just shows “There was an Error.”
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogDec 27.2007 — #First thing that jumps out at me is that it appears you are missing a comma between the last two values in your query.To get more useful debug info, you could change the "or die" after the query to something like:
[code=php]
$result = mysqli_query($cxn, $sql) or die ("There was an Error: " . mysqli_error($cxn) . "<br>n" . $sql);
[/code]The above is good for debugging, but you'll probably want to do some sort of error_log() for the production version rather than outputting database info to the browser should a query fail.