Hello everybody.
There is a row in my db table I have set it's type as "TIMESTAMP". How should I fill in?
Should get the current timestamp in php and send it to that row, correct?
So how can I do that?
Niloofar24 15 Posting Whiz
lps 71 Posting Pro in Training
Why you need to get the timestamp from php and update timestamp field in table? We can always use the CURRENT_TIMESTAMP() directly from mysql. Refer https://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html for more options.
Niloofar24 15 Posting Whiz
Well, I still haven't got what to do exactly. Where should I put CURRENT_TIMESTAMP() in the script? I'm using PDO.
Would you please help me more?
edbr 22 Junior Poster
in your database (phpadmin for example) use default current_timestamp and in attribute on update current_timestamp
lps 71 Posting Pro in Training
UPDATE mytable SET timestamp_field = CURRENT_TIMESTAMP()
Niloofar24 15 Posting Whiz
I understood. Thanks friends.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.