Insert current date in datetime format mySQL

by

If you’re looking to store the current time just use MYSQL’s functions.

mysql_query("INSERT INTO `table` (`dateposted`) VALUES (now())");

If you need to use PHP to do it, the format it Y-m-d H:i:s so try

$date = date('Y-m-d H:i:s');
mysql_query("INSERT INTO `table` (`dateposted`) VALUES ('$date')");

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. Just using mysql real escape string [closed]
  3. Create hyperlink from html table row to open record on a new page
  4. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  5. Many-to-many relationships examples
  6. SELECT COUNT(*) AS count – How to use this count
  7. How to execute two mysql queries as one in PHP/MYSQL?
  8. Storing files in database Vs file system
  9. How to upload images into MySQL database using PHP code
  10. selecting unique values from a column
  11. MySQL Join two tables with comma separated values
  12. How can I Use Prepared Statements in CodeIgniter
  13. PDOstatement (MySQL): inserting value 0 into a bit(1) field results in 1 written in table
  14. How to echo out table rows from the db (php)
  15. How to display Unicode data with PHP [duplicate]
  16. PDO fetchAll group key-value pairs into assoc array
  17. MySQL Performance – “IN” Clause vs. Equals (=) for a Single Value [duplicate]
  18. Connect DATABASE Error TYPE: 2002: Permission denied
  19. MySQL skipping first row
  20. How to reverse order output of a MySQL query
  21. MySQL statement takes more than minute to execute
  22. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  23. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  24. PHP 7 RC3: How to install missing MySQL PDO
  25. Select mySQL based only on month and year
  26. Mysql InnoDB engine in Laravel
  27. MySQL: Group by two columns and sum
  28. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  29. Which MySQL datatype to use for an IP address? [duplicate]
  30. phpmysql error – #1273 – #1273 – Unknown collation: ‘utf8mb4_general_ci’

Leave a Comment