NOW() with PHP

[hasek522]

Is this the correct way in php and sql to input the current date

 

$sql = "INSERT INTO accounts (userid,accountid,amount,description,date) VALUES(

'" . $userid . "', '"

. $accountid. "', '"

. $amount. "', '"

. $description . "', NOW() )";

[ratcateme]

in php you can use time() mysql supports CURRENT_TIMESTAMP()

 

Scott.

[hasek522]

hmm ok so now i have:

$sql = "INSERT INTO transactions (userid,accountid,amount,description,date) VALUES(

'" . $userid . "', '"

. $accountid. "', '"

. $amount. "', '"

. $description . "', CURRENT_TIMESTAMP() )";

 

changed account to transactions (my own mistake) and did the current time stamp but am still not getting this sql statement to work.

[ratcateme]

that looks fine to me do you have

mysql_query($sql) or die(mysql_error());

on the end of your query and does it get an error

 

Scott.

[DarkWater]

I personally use NOW() and have never used CURRENT_TIMESTAMP().  Try NOW() and show us the error (if any).

[ratcateme]

dev.mysql.com says that

CURRENT_TIMESTAMP and CURRENT_TIMESTAMP() are synonyms for NOW().

so it really doesn't matter.

 

Scott.

[DarkWater]

But NOW() is less typing. =P

[Barand]

I use NOW() if the field is type DATETIME and CURDATE() if the field is type DATE

[hasek522]

Ok i tried doing the mysqlerror method and nothing showed up.

[DarkWater]

So what's the actual problem?

[hasek522]

ok so now the actual problem is the SQL insert statement dosnt actually insert the data.

[DarkWater]

Do you actually call mysql_query() on the SQL string?  Someone did that recently and asked for help. =P

[dannyb785]

dude, just do $now = strtotime("now") and then insert the variable $now into the database. Does the same exact thing.

[Third_Degree]

$sql = "INSERT INTO `transactions` ( `userid`, `accountid`, `amount`, `description`, `date` ) VALUES ( '" . $userid . "', '" . $accountid . "', '" . $amount . "', '" . $description . "', '" . date( 'Y-m-d' ) . "'" );
mysql_query( $sql ) or die( mysql_error( ) );

 

Try it?

[hasek522]

ok i figured things out, thanks for all the help