How to insert the current timestamp into MySQL database using a PHP insert query

Question

In my MySQL database  I have a table with structure  username - varchar insert time - timestamp   This table was created in MySQL using the phpMyAdmin tool and for the insert time column  I have mentioned default value as 0000-00-00 00 00 00   Now the problem is  I have to update this default value with the current timestamp later on  using a PHP script   I tried doing the following PHP code    update query    UPDATE db tablename SET insert time now                       WHERE username    somename    When the PHP script is run  it fails  and is unable to insert anything into the database   What am I doing wrong

User · Answer

This format is used to get current timestamp and stored in mysql   date   date  Y-m-d H i s       update query    UPDATE db tablename SET insert time    date   WHERE username      somename

User · Answer

Don t like any of those solutions   this is how i do it    update query    UPDATE db tablename SET insert time now   WHERE username                   sqlEsc  somename             then i use my own sqlEsc function   function sqlEsc  val         global  mysqli      return mysqli real escape string  mysqli   val

User · Answer

Forgot to put the variable in the sql statement without quotations        update query           UPDATE db tablename SET insert time NOW   WHERE username      somename

User · Answer

Your usage of now   is correct  However  you need to use one type of quotes around the entire query and another around the values   You can modify your query to use double quotes at the beginning and end  and single quotes around  somename    update query    UPDATE db tablename SET insert time now   WHERE username   somename

User · Answer

Instead of NOW   you can use UNIX TIMESTAMP   also    update query    UPDATE db tablename                   SET insert time UNIX TIMESTAMP                    WHERE username   somename      Difference between UNIX TIMESTAMP and NOW   in MySQL

User · Answer

What error message are you getting   I d guess your actual error is because your php variable isn t wrapped in quotes  Try this   update query    UPDATE db tablename SET insert time now   WHERE username      somename

[php] How to insert the current timestamp into MySQL database using a PHP insert query

Examples related to php

Examples related to mysql

Examples related to timestamp