MatthewPatten Posted December 12, 2014 Share Posted December 12, 2014 Hello everyone! I am trying to insert a student into a table (with TIMESTAMP; works with VARCHAR, not TIMESTAMP). Can anyone help? Variable $time_stamp = date("D M j G:i:s T Y"); Populate DB Query ("DROP TABLE IF EXISTS enrolled") || !$link->query("CREATE TABLE enrolled(course_id VARCHAR(50), student_id VARCHAR(50), user_ip VARCHAR(50), time_stamp TIMESTAMP(6)) Insert Query INSERT INTO enrolled(course_id,student_id,user_ip,time_stamp) VALUES('$course','$number','$user_ip','$time_stamp') Link to comment https://forums.phpfreaks.com/topic/293058-create-table-with-timestamp-and-mysqli-query/ Share on other sites More sharing options...
cyberRobot Posted December 12, 2014 Share Posted December 12, 2014 It looks like TIMESTAMP is formatted as "YYYY-MM-DD HH:MM:SS". More information can be found here: http://dev.mysql.com/doc/refman/4.1/en/datetime.html Also note that MySQL has some built-in functions for adding timestamps. Have you tried using NOW(): http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_now Note that you can find more time-related functions here: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html Link to comment https://forums.phpfreaks.com/topic/293058-create-table-with-timestamp-and-mysqli-query/#findComment-1499411 Share on other sites More sharing options...
MatthewPatten Posted December 12, 2014 Author Share Posted December 12, 2014 It looks like TIMESTAMP is formatted as "YYYY-MM-DD HH:MM:SS". More information can be found here: http://dev.mysql.com/doc/refman/4.1/en/datetime.html Also note that MySQL has some built-in functions for adding timestamps. Have you tried using NOW(): http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_now Note that you can find more time-related functions here: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html Finally got the NOW() function working! Link to comment https://forums.phpfreaks.com/topic/293058-create-table-with-timestamp-and-mysqli-query/#findComment-1499412 Share on other sites More sharing options...
Barand Posted December 12, 2014 Share Posted December 12, 2014 The point of using a timestamp column is so you do not have to enter a datetime value - it is automatically entered. For example CREATE TABLE student ( student_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(30), created TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); INSERT INTO student (name) VALUES ('Barand'); Then mysql> SELECT * FROM student; +------------+--------+---------------------+ | student_id | name | created | +------------+--------+---------------------+ | 1 | Barand | 2014-12-12 14:54:09 | +------------+--------+---------------------+ Link to comment https://forums.phpfreaks.com/topic/293058-create-table-with-timestamp-and-mysqli-query/#findComment-1499417 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.