Php and mysql don't insert tuple

Website Building
#1

$sql = "INSERT INTO ORDERS(pid, bid, amount, totalPrice, orderDate) VALUES (".$pid.",'".$bid."',".$amount.",".$totalPrice.",'".date("Y-m-d h:i:sa")."');"; $conn->query( $sql);

This doesn’t insert tuple in ORDERS table.

#2

I solved it by changing “Y-m-d H:i:s”

1 Like
#3