Insert Date and Time in MySQL from Dreamweaver
hello,
i trying build "leave feedback" form using php , mysql, can't insert date , time database. inserted hidden field form , used dreamweaver "insert record" wizard generated following code:
if ((isset($_post["mm_insert"])) && ($_post["mm_insert"] == "frmfeedback")) {
$insertsql = sprintf("insert feedback (name, email, comments, `date`) values (%s, %s, %s, %s)",
getsqlvaluestring($_post['name'], "text"),
getsqlvaluestring($_post['email'], "text"),
getsqlvaluestring($_post['comments'], "text"),
getsqlvaluestring($_post['hdate'], "date"));
do have add else code?
thanks
you don't put in hidden field, it's impossible know problem is. however...
the first thing need realize mysql stores dates , times in 1 format only: iso-recommended yyyy-mm-dd hh:mm:ss. if attempt insert date in other format, mysql stores 0000-00-00 00:00:00. although might seem nuisance, avoids ambiguity of different national customs when storing dates. american 7/4/2009 july 4. european, it's 7 april.
so, store date today, must 2009-04-21. other format result in 0000-00-00 date.
moving on... today's date want insert? 1 way use datetime column, , insert nothing it. datetime column automatically populated current date , time. automatically update whenever update record. prevent value being updated in update form, retrieve existing value , resubmit in update query.
More discussions in Dreamweaver support forum
adobe
Comments
Post a Comment