1.11M Members

php function to gett me year-month-day-hour-min-sec

 
0
 

i am using xammp for my database.
i have a col called "today_date" andy type "DATE".
in php i am using function "now()" to store todays date. the format is year-month-day.

now let say i have one more col called "today_date_time" and type "datetime".
is there a php function that can get me a date and time of today and format is year-month-day-hour-min-sec

 
1
 

Is this what you mean?

putenv("TZ=Europe/London"); // Set to your timezone (server may be in a different zone).
$now_datetime = date("Y-m-d-H-i-s", time()); // eg. 2012-12-09-03-34-25
 
0
 

i tryied this date('Y-m-d H:i:s',time()) but didnt worked. it does print
eg 2012-12-09 03:34:25. but i cant seem to store in database.

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

i will not use php ever, I will use mysql stuff to add time and date

insert into table1 (col1,col2,today_date,today_datetime) values ('col1value','col2value',current_date(),current_timestamp())
 
0
 

error:
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

$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(mysql_error()); //date() //date,timestamp
 
1
 

try without braces
current_date, current_timestamp

 
0
 

it does print eg 2012-12-09 03:34:25. but i cant seem to store in database

What is the format of the field you want to store the value into?

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

PHP functions can not be parsed within a double quoted string (as far as I know). Assign a value to a variable first and then use this variable in a query.

$temp_time = 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' , '$temp_time')")
or die(mysql_error()); //date() //date,timestamp
Isn't it about time forums rewarded their contributors?

Earn rewards points for helping others. Gain kudos. Cash out. Get better answers yourself.

It's as simple as contributing editorial or replying to discussions labeled or OP Kudos

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article