[hwoarang69]

i am using xampp. col name "date_time" and its type is "datetime"

ex: 2012-12-07 03:00:00

so i used this in my sql query to store in database

$sql = mysql_query("INSERT INTO item  ...
                   ,date('Y-m-d H:i:s',time()),...

but the query doesnt work. any idea what i did wrong?

This post has been edited by hwoarang69: 08 December 2012 - 10:26 PM

[Atli]

The date format you use looks fine. Without seeing more of the actual code, it's not really easy to guess what could be wrong. Perhaps you forgot the quotes around the date value? How, exactly, is it not working? Are you getting any error messages?

With that said, keep in mind that MySQL also has functions specifically designed to provide the current date for it's DATETIME and TIMESTAMP fields. One of those is the NOW() function. It can be used like this:

INSERT INTO `theTable`(`theField`) VALUES(NOW())

[creativecoding]

Is that literally what your code is? If it's not can you show us what the query actually is? We're not magic, we can't tell you what the error is without seeing the whole picture.

[hwoarang69]

for type "date" i use "now()"
for type "datetime" its "date('Y-m-d H:i:s',time())"
for type "timestamp" no idea.

full query

//add this product into the database now
$sql = mysql_query("INSERT INTO item 
	(image_user_name, image_folder_name, main_category,
          sub_category, price, description, features, key_words, 
          sold, item_add_date)
	
         VALUES('$image_user_name_p','$image_folder_name',
              '$main_category_p','$sub_category_p',
	      '$price_p','$description_p','$feature_p',
'$key_word_p', '0' , date('Y-m-d H:i:s',time())") 
	or die("additem sql_query error"); //date() //date,timestamp

error is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'time())' at line 4

This post has been edited by hwoarang69: 08 December 2012 - 11:57 PM

[creativecoding]

Ah, well there's your problem. You cannot call functions inside of strings.

You can do something like this:

//add this product into the database now
$timestamp = date('Y-m-d H:i:s',time());
$sql = mysql_query("INSERT INTO item 
	(image_user_name, image_folder_name, main_category,
          sub_category, price, description, features, key_words, 
          sold, item_add_date)
	
         VALUES('$image_user_name_p','$image_folder_name',
              '$main_category_p','$sub_category_p',
	      '$price_p','$description_p','$feature_p',
'$key_word_p', '0' , '$timestamp'") 
	or die("additem sql_query error"); //date() //date,timestamp

I would recommend you stop using mysql_* functions and move onto PDO or MySQLi - Both provide more security.

[Atli]

hwoarang69, on 09 December 2012 - 06:12 AM, said:

for type "date" i use "now()"
for type "datetime" its "date('Y-m-d H:i:s',time())"
for type "timestamp" no idea.

The NOW() functions works fine for all three. There is no need to be creating the date string in PHP like you are doing.