PHP and mysql

any body can help me please,

Date format for SQL is Y-m-d

dear pritaeas,
we can not use "dd-mm-yyyy" OR "dd NmeOfMonth YYYY "in php form? and how to convert format to send as a mysql format date.

Use a datepicker (javascript) in your form.

yes i am using datepickep code is below

<script> $(document).ready(function(){ $("#date").datepicker({ dateFormat:"dd-mm-yy" }); }); </script>

but when i transfer date in database shows 0000-00-00 00:00:00

In the insert query you can use the DATE() function, see:

• http://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_date

thaks for response ,
sir, cn you give any example. in insert query with DATE().

Example:

$sql = "INSERT INTO `tentb` (`edate`) VALUES(DATE($edate))";

But you should be using prepared statements, so:

$sql = $db->prepare("INSERT INTO `tentb` (`edate`) VALUES(DATE(:edate))"); $sql->execute([':edate' => $edate]);

thx Cereal,
i check this quiry but I got error please, check

$edate=$_POST['edate']; $ldate=$_POST['ldate']; $cdetail=$_POST['cdetail']; $tdetail=$_POST['tdetail']; $sql1 =$conn1->prepare ("INSERT INTO `tentb` (`edate`) VALUES(DATE(:edate))"); $sql1->execute([':edate'=>$edate]); $result1=$conn1->query($sql1); if($result1){ echo "Data has saved"; header("refresh:2; url=tenderadd.php");} else{ $msg='Error'. $conn1->connect_error; header("refresh:2; url=tenderadd.php"); }

Error: Call to a member function execute() on a non-object in C:\wamp\www\SprintWeb\tenderadd.php on line 26

Is $conn1 a PDO or a MySQLi resource? It connects to the database correctly? Follow the documentation of the chosen library to properly work with prepared statements. If you just want to verify if the DATE() works fine for you, then use the first example.