PHP date() format when inserting into datetime in MySQL

The problem is that you’re using 'M' and 'D', which are a textual representations, MySQL is expecting a numeric representation of the format 2010-02-06 19:30:13

Try: date('Y-m-d H:i:s') which uses the numeric equivalents.

edit: switched G to H, though it may not have impact, you probably want to use 24-hour format with leading 0s.

Related Posts:

  1. How to use mysqli_query() in PHP?
  2. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  3. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  4. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  5. what does “/index.php?admin/admin_dashboard” in my url mean
  6. How can I prevent SQL injection in PHP?
  7. How to create a foreign key in phpmyadmin
  8. If variable equals value php [duplicate]
  9. MySQL – count total number of rows in php
  10. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  11. Foreach only outputs if id is 0
  12. Which is better and faster ? WordPress Queries or SQL Query
  13. Grouping posts by a custom meta value
  14. SQL Query in WordPress – Getting Impossible WHERE error
  15. Problem with admin login after deployment
  16. Find out how many times the user has logged in
  17. WordPress(wpdb class) and mysql stored procedures
  18. Are these WordPress tables safe to add indexes to?
  19. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  20. Multiple meta_key in one global $wpdb;
  21. Custom array from a query only write the last row of the query
  22. WordPress plugins for database queries
  23. Is it possible to create a WordPress table using array and loop?
  24. WordPress member notification
  25. Update MySQL query so that it functions again
  26. Can’t Query Custom Table Using $wpdb Method
  27. SQL syntax error when getting data for a url
  28. Moving wordpress site from localhost to live server using GoDaddy cPanel
  29. How does WP work in conjunction with a web server?
  30. Database Structure on Different Servers
  31. WordPress create database not working
  32. WordPress Block developer from exporting Database via PHP
  33. Can’t run database query
  34. Is there a page length limit?
  35. WordPress doesn’t display accents after migration
  36. $wpdb returns duplicate posts
  37. Using WPDB->Insert()
  38. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  39. Active DB queries in WordPress?
  40. Update postmeta after theme switch
  41. How to stop $wpdb from prepending database name
  42. Mixing variables into an array when inserting values
  43. Location of core code for database connection and get_header
  44. wpdb prepare insert table doesn’t work
  45. Should I use WordPress to skin a database website?
  46. php include not working in custom page
  47. How do I display offsite database info on my wordpress site?
  48. Creating Database Table vs. Adding MetaData to Post & User
  49. Make a database query using WordPress
  50. Changing MySQL password via WHM – does this affect WordPress?
  51. Force Users To Relogin
  52. Query posts by custom taxonomy and sort by post_modified
  53. WordPress $wpdb get posts from category and sort by custom meta
  54. WordPress tables and aliases?
  55. What’s the sql for this condition?
  56. WordPress and MySQL: trying to print data using PHP from user_meta custom field data
  57. Import CSV to MySQL, with custom registration field information
  58. database optimization and server errors
  59. WordPress Custom SQL Table with UserID Filter for results
  60. Locally restoring a ManageWP full site backup
  61. Create a form with custom autocomplete address field and CSV import values
  62. WordPress doesn’t save changes some times
  63. Match tag names with form titles
  64. Most commented posts by time period (last 12h, last 24h and etc)
  65. Error missing MySQL extension
  66. Use $wpdb or other PHP script method to find/replace in WP database
  67. email alert for product availability
  68. Run Username SQL Query from WordPress Child Theme Functions File
  69. How can I add a new row in a separate database when someone registers via WordPress?
  70. Issue with fetching mysql data and displaying results via shortcode in webpage
  71. SQL syntax error. However, it works normally at phpmyadmin
  72. Basic wpdb update question
  73. Replace a character in all post titles and slugs
  74. Update Custom Post Type Taxonomies with SQL
  75. Hide posts if user is added to it WP_query
  76. How can I fetch data from another website to my wordpress website with mysql database
  77. Setting up WordPress Locally on WAMP for a new site (with one already)
  78. I can’t update my data through $wpdb
  79. A $_POST should occur when submit form but is not?
  80. WordPress insert query is not working : Showing no Error
  81. How to get INSERT errors from $wpdb?
  82. Getting Error Trying to Create Table
  83. Custom route and query
  84. Output: “Array”
  85. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  86. How to unserialize data from MySQL
  87. How to use mysql LIKE with wpdb?
  88. Pull MySQL data from multiple tables and merge into 1 PHP array
  89. Copy usermeta value where ID matches in the same table
  90. string literals in query
  91. Export Yoast Keywords from MySQL/phpMyAdmin
  92. Same database; different WordPress
  93. Submitting a form, using Ajax, to run a SQL Select query based on user input from the form
  94. Some Post Content Does Not Show Up In DB Search
  95. WordPress WP_Query without query GET parameters
  96. How do I prepare strings for insertions as values into a MySQL table?
  97. Known Issues in WordPress When Upgrading PHP to ver 7
  98. MySQL query for taxonomy-meta
  99. Array Formation Issue
  100. Using CFDB7 vs Custom MySQL Database [closed]

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)