[RESOLVED] simple date issue but confused

crafterscafe

I have a form that I collect three fields ; email, newsletter,comment. I want to record the date that the person submits form. I have a field in the database named date and it is set to date for type.

Here is the php code i can not figure out how to record the date. I just keep getting query could not be executed. I took out any reference to date in the html file.

I am using PHP 4.7.1

<?php
/ this page recieves and handles the date generated by bailmeout.html./
//trim the incoming data
$date = "(now)";
$Array["email"] = trim
($Array["email"]);
$Array["newsletter"] = trim
($Array["newsletter"]);
$Array["comment"] = trim
($Array["comment"]);
//set the variables for the database access:
$Host = "mysql.ixwebhosting.com";
$User = "xxxxx";
$Password = "xxxxxxx";
$DBName = "xxxx";
$TableName ="bailout";
$Link = mysql_connect ($Host, $User, $Password);
$Query="INSERT into $TableName values ('0', '$date', '$email', '$newsletter', '$comment')";
if (mysql_db_query($DBName, $Query, $Link)) {
//print ("The query was successfully executed!<br>\n");
header ("location: http://crafterscafe.com/store/index.php?main_page=page&id=16");
exit;
} else {
print ("The query could not be executed!<br>\n");
}
mysql_close ($Link);?>

djjjozsi

$Query="INSERT into $TableName values ('0', NOW() , '$email', '$newsletter', '$comment')";

date and time functions collection

i suggest ask a moderator to remove your mysql database information from your Post,

and change your password + mysql user name if you can.

array_map is a good function to call a function on each of your index inside an array.

use mysql_real_escape_string() instead of trim()

crafterscafe

i have tried that and it is not working. Here is what I have now.

<?php
/ this page recieves and handles the date generated by bailmeout.html./
//trim the incoming data
//$date = "NOW()";
$Array["email"] = trim
($Array["email"]);
$Array["newsletter"] = trim
($Array["newsletter"]);
$Array["comment"] = trim
($Array["comment"]);
//set the variables for the database access:
$Host = "mysql.ixwebhosting.com";
$User = "xxxx";
$Password = "xxxxx";
$DBName = "smlwfar_contest";
$TableName ="bailout";
$Link = mysql_connect ($Host, $User, $Password);
$Query="INSERT into $TableName values ('0', NOW(), '$email', '$newsletter', '$comment')";
if (mysql_db_query($DBName, $Query, $Link)) {
//print ("The query was successfully executed!<br>\n");
header ("location: http://crafterscafe.com/store/index.php?main_page=page&id=16");
exit;
} else {
print ("The query could not be executed!<br>\n");
}
mysql_close ($Link);?>

ps I realized what I posted as soon as I did it...info is changed. thanks for letting me know

crafterscafe

your post was correct - I figured out that I can not create a table in mysql panel from my hosting comp and I have to create using php. when I did it worked out.

thanks

djjjozsi

if you need to troubleshoot, you should print the query.

	print ("The query could not be executed!<br> Test in phpmyadmin: $Query");

i'm not sure, but you're using an old technique to run query:

i'm using this connection template:

$hostname='XXXXXXXX'; //// specify host, i.e. 'localhost'
$user='***********'; //// specify username
$pass='***********'; //// specify password
$dbase='XXXXXXXXXX'; //// specify database name
$connection = mysql_connect("$hostname" , "$user" , "$pass")
or die ("Can't connect to MySQL". mysql_error());
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");

i'm sure your query is working, but you don't need to determine the primary key's value. notice that, date as a field name is not suggested, its a reserved name such as order group ect...

$sql="INSERT INTO bailout (`email`,`newsletter`,`comment`,`date`) VALUES ('$email','$newsletter','$comment', NOW()) ";
echo $sql; //just for test
mysql_query($sql) or die(mysql_error());

maybe this helped.