如何将html type = time插入数据库

Question

hello guys i need help on inserting my html type-time into my database..this is my form html.

<tr>
  <td><font color="black">Time:</td>
  <td colspan = "2"><input type = "time" name = "time_hr"></td>
  </tr>

this is the post method

@$time_hr=$_POST['time_hr'];

this is my query

$query = " INSERT INTO receipt VALUES ('','$cust_data','$cust_address','$cust_id',
          '$sets','$time_hr',$cold','$hot','$price','$q','$sum','$deposit','$amount','$booking_date' ,'PENDING')";

i was wondering how to insert it into my database. my xampp structure for time is varchar.

please and thank you and sorry for any inconvenience.

Answer 1

You have syntax error in your query. You are missing one single quote near $cold variable. Try following query.

$query = " INSERT INTO receipt VALUES ('', '$cust_data', '$cust_address', '$cust_id', 
'$sets', '$time_hr', '$cold', '$hot', '$price', '$q', '$sum', '$deposit', '$amount', 
'$booking_date', 'PENDING')";

Also try echo mysql_error() to know if any other error is there in the query.