mysqli – Date and time from PHP writes 0000-00-00 00:00:00 in MySQL

I have a PHP with a JS datepicker for date and time that save all the string in this format \”19.08.2012 @ 20:18\” in a a variable called $date.

If I place this variable directly in the query, it writes \”0000-00-00 00:00:00\” in the database.

At the moment I have a big black hole in my head, so need help.

How can I write the correct selected date and time in the database?

---

Sorry I thought not so important, here is the code.

index.php

<script type=\"text/javascript\">
$(function() {
    $(\"#date\").datetimepicker({
        dateFormat:\'dd.mm.yy\',
        separator: \' @ \'
    });
});
</script>

<form action=\"setting.php\" method=\"post\">
 <table>
 <tr>
  <td><label for=\"date\">Date:</label></td>
  <td><input type=\"text\" id=\"date\" name=\"date\"/></td>
 </tr>
</table>
<input type=\"submit\" name=\"submit\" />

setting.php

if(isset($_POST[\'save_autoresp\'])) {
    create($_POST[\'date\']);
    header(\"Location: admin.php\");
    exit();
} else {
    header(\"Location: index.php\");
    exit();
}

functions.php

.......
.......
// Write the fields to the table
$query_create = mysqli_query($link, \"INSERT INTO table VALUES (null, \'$id\', \'$date\')\") or die (\'Could not connect: \' . mysqli_error($link));
.......
.......

The date field in teh MySQL database is \”datetime\”.

Rating: 4 out of 5 based on 3 ratings

Posts Related to mysqli - Date and time from PHP writes 0000-00-00 00:00:00 in MySQL

• Jul 25th, 2012 Javascript datestring constructor changes timezone Wednesday AM 01:15:55


• Aug 11th, 2012 php - Get content from MySQL database into html page Saturday AM 04:29:49


• Aug 18th, 2012 php - How to refresh a div everytime a database is updated? Saturday PM 13:10:34


• Aug 11th, 2012 Is it possible to get the timezone from your visitor? in php or his date and time? Saturday AM 01:20:18


• Aug 16th, 2012 Javascript duplicate form input Thursday PM 14:33:37


• Jul 17th, 2012 Date string conversion to unix timestamp in JavaScript / jQuery Tuesday AM 01:09:55


• Jul 23rd, 2012 Easiest ways to use vars from PHP in HTML Monday AM 00:30:32


• Jul 14th, 2012 jquery - set value onClick of table cell Saturday AM 00:12:10


• Jul 24th, 2012 How to change the contents of an HTML table with php + javascript Tuesday PM 13:44:42


• Jul 08th, 2012 arrays - javascript convert to string Sunday PM 12:02:01

The post mysqli – Date and time from PHP writes 0000-00-00 00:00:00 in MySQL appeared first on Javascript ASK.

via Javascript ASK http://javascriptask.phpfogapp.com/mysqli-date-and-time-from-php-writes-0000-00-00-000000-in-mysql.html