PHP - Insert date into mysql

Question

I am trying to insert date into mysql but everytime it fails and comes out as 0000-00-00 in phpmyadmin  My date format is like 2012-08-06  yyyy-mm-dd  and the date field type in database is date    date    2012-08-06   mysql query  INSERT INTO data table  title  date of event                VALUES       POST  post title                                 date        or die mysql error        tried changing - to   or removing them  it doesn t work

User · Answer

How to debug SQL queries when you stuck  Print you query and run it directly in mysql or phpMyAdmin   date    2012-08-06    query   INSERT INTO data table  title  date of event                VALUES       POST  post title                                 date        echo  query  mysql query  query  or die mysql error        that way you can make sure that the problem is not in your PHP-script  but in your SQL-query  How to submit questions on SQ-queries  Make sure that you provided enough closure   Table schema Query Error message is any

User · Answer

date  year  -   month  -   day    new date date  Y-m-d   strtotime  dob      status 0     insert date   date  Y-m-d H i s       latest insert id 0     insertSql  insert into participationDetail  formId name city emailId dob mobile status social media1 social media2 visa status tnc status data gender insertDate values     formid        name        city        email        new date        mobile        status        link1        link2        visa check        tnc check       json encode  detail arr JSON HEX APOS         gender        insert date

User · Answer

try converting the date first    date    2012-08-06    mysql query  INSERT INTO data table  title  date of event                 VALUES        POST  post title                                     date                     or die mysql error

User · Answer

try   date    2012-08-06    date date  Y-m-d  strtotime  date

User · Answer

try CAST function in MySQL   mysql query  INSERT INTO data table  title  date of event  VALUES       POST  post title        CAST      date     AS DATE     or die mysql error

User · Answer

Unless you want to insert different dates than  today   you can use CURDATE      sql    INSERT INTO data tables  title  date of event  VALUES    s   CURDATE       sql   sprintf   sql    POST  post title       PS  Please do not forget to sanitize your MySQL input  especially via mysql real escape string

[php] PHP - Insert date into mysql

Examples related to php

Examples related to mysql

Examples related to date

Examples related to insert

Examples related to format