Skip to main content
typo: "codes" -> "code". see https://ell.stackexchange.com/a/258853/165353
Source Link
starball
  • 59.1k
  • 52
  • 311
  • 1k

ImI'm using jQuery datepicker the format of the datepicker is this 08/25/2012

iI have errors when inserting to my database it insertinserts only 0000-00-00 00 00 00

my codesMy code is:

<?php
$id = $_POST['id'];
$name = $_POST['name'];
$date = $_POST['date'];
$sql = mysql_query( "INSERT INTO user_date VALUE( '', '$name', '$date')" ) or die ( mysql_error() );
echo 'insert successful';
?>

imI'm sure my insert is correct....

Im using jQuery datepicker the format of the datepicker is this 08/25/2012

i have errors when inserting to my database it insert only 0000-00-00 00 00 00

my codes is

<?php
$id = $_POST['id'];
$name = $_POST['name'];
$date = $_POST['date'];
$sql = mysql_query( "INSERT INTO user_date VALUE( '', '$name', '$date')" ) or die ( mysql_error() );
echo 'insert successful';
?>

im sure my insert is correct....

I'm using jQuery datepicker the format of the datepicker is this 08/25/2012

I have errors when inserting to my database it inserts only 0000-00-00 00 00 00

My code is:

<?php
$id = $_POST['id'];
$name = $_POST['name'];
$date = $_POST['date'];
$sql = mysql_query( "INSERT INTO user_date VALUE( '', '$name', '$date')" ) or die ( mysql_error() );
echo 'insert successful';
?>

I'm sure my insert is correct.

Source Link
Butternut
  • 853
  • 1
  • 9
  • 22

PHP mysql insert date format

Im using jQuery datepicker the format of the datepicker is this 08/25/2012

i have errors when inserting to my database it insert only 0000-00-00 00 00 00

my codes is

<?php
$id = $_POST['id'];
$name = $_POST['name'];
$date = $_POST['date'];
$sql = mysql_query( "INSERT INTO user_date VALUE( '', '$name', '$date')" ) or die ( mysql_error() );
echo 'insert successful';
?>

im sure my insert is correct....