PHP Date in MySQL Query

Question

What's wrong with this query?

 $query = $db->query("select username from roomsbooked where username='$_SESSION[username]' and timeslot='$_SESSION[timeslot]' and number='$_SESSION[roomNumberToBook]' and dateofbooking='$_SESSION[dateEntered]'");

The dateofbooking field in the database is a "date" field.

$_SESSION[dateEntered] is defined as:

$_SESSION["dateEntered"] = DateTime::createFromFormat('d/m/Y', $_POST["Date"]);

When the script runs it gets to the query but nothing happens there after.

I've made that change but it's still showing "0000-00-00" in the database field. — BaronK
– BaronK, Commented Dec 9, 2014 at 10:52

Hanky Panky · Accepted Answer · 2014-12-09 10:41:30Z

3

MySQL Doesnt use d/m/Y format, you have to do

DateTime::createFromFormat('Y-m-d', $_POST["Date"]);

answered Dec 9, 2014 at 10:41

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Date in MySQL Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related