asked on Parse error: syntax error, unexpected ':', expecting ']' in /home/content/15/6807515/html/loaddata.php on line 19
I am trying to auto timestamp I changed my code to below but I get the error
Parse error: syntax error, unexpected ':', expecting ']' in /home/content/15/6807515/html/loaddata.php on line 19
$con = mysql_connect("$dbhost","$dbuser","$dbpass");
mysql_select_db($dbname);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$sql="INSERT INTO gpscoordinates (UserName, Password1, Group1,Latitude,Longitude,dp_datatime)
VALUES
('$_POST[User]','$_POST[Password1]','$_POST[Group1]','$_POST[Latitude]','$_POST[Longitude]',''$_POST[DATETIME: Auto NOW()', NOW()] ')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
PHPMicrosoft SQL Server
Last Comment
Dolamite Jenkins
What is in your variable $_POST? What is your expected in $_POST[DATETIME: Auto NOW()', NOW()]?
ASKER
I apologize I don't understand the question... $POST isnt a variable but PHP command ....
Ah, $_POST is an associative array retrieved from POST body. You are addressing an element in $_POST, DATETIME: Auto NOW()', NOW(). I am wondered what is in $_POST. Can you print_r($_POST)?
ASKER
all of the $POST work except $_POST, DATETIME: Auto NOW()', NOW().... tonite I added $_POST, DATETIME: Auto NOW()', NOW().
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks