[Resolved] Date does not insert into MySQL DB

rcoursey

I have this code to INSERT info into the DB:

$title = trim($title);
$title = addslashes($title);
$comments = trim($comments);
$comments = addslashes($comments);
$active = intval($active);
$playcreatedt=time();
$result = dbquery("INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, '$title', '$comments', '$active', '$playcreatedt', NULL)");

Every Item is entered EXCEPT the $playcreatedt (Timestamp). Any ideas why it will not insert into the DB?

stolzyboy

have you simply echo the $variable out to see if anything is in there

rcoursey

No, I used phpMyadmin to browse the the records. I could see all of the inserts were made except the playcreatedt. The column type for this is "timestamp".

stolzyboy

use this and see if it says any errors and shows the query on the screen with the timefield in it

$title = trim($title); 
$title = addslashes($title); 
$comments = trim($comments); 
$comments = addslashes($comments); 
$active = intval($active); 
$playcreatedt=time(); 
$query= "INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, '$title', '$comments', '$active', '$playcreatedt', NULL);";
echo "This is your query " . $query;
$result = mysql_query($query) or die(mysql_error());

kevinsequeira

$result = dbquery("INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, '$title', '$comments', '$active', '$playcreatedt', NULL)");

change to

$sql ="INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, '$title', '$comments', '$active', '$playcreatedt', NULL)";
echo $sql;
$result = mysql_query($sql);

what does sql look like

reg
kevin

rcoursey

Here is the result of the query:

This is your query INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, 'Test for php', '', '0', '1055781448', NULL);No Database Selected

There was no database selected because this was handled by the query function.

After connecting I get:

This is your query INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, 'Test for php', '', '0', '1055781626', NULL);

kevinsequeira

and when u run this directly in your databse it works fine ??

INSERT INTO plays (playid, title, comments, active, playcreatedt, lastchange) VALUES (NULL, 'Test for php', '', '0', '1055781626', NULL);

reg
kevin

rcoursey

Another thing I forgot to mention is that even though the query had a value for the $playcreatedt it did not insert.

stolzyboy

try changing your TIMESTAMP field to a varchar and see what happens

rcoursey

Sorry for the delay in responding.

I used the insert directly into the database and it did not cause an error. But, the date was not added.

Just a question, why would changing the type to varchar be important?

kevinsequeira

timestamp field takes in exactly 14 digits but with varchar(14) it doesnt matter what the length is as long as it doesnt exceed 14

reg
kevin

stolzyboy

well cuz timestamp is automatically done when you either insert or update a record, so your insert into that field may be screwing it up

try not inputting anything into it and just let mysql do it itself

or try using

values (now(), 'otherfieldvalue', 'etc...')

kevinsequeira

well timestamp doesnt take in exactly 14 digits always. take a look at the documentation

http://www.mysql.com/doc/en/DATETIME.html

what have u defined timestamps length to be, maybe thats where the issue is

reg
kevin

rcoursey

The length of playcreatedt is 14 in the structure.

rcoursey

I resolved the issue by setting the value of the playcreatedt field to "NOW()" in the values clause of the INSERT statement.

Thanks for all the help. PHP Builder is the best!