PHP Date Variable in MySQL Query

Question

The following query works fine when not using a variable for the date&time. However, I would like to use a variable for "2014-09-29 09:00:00".

    $query = '  SELECT *
                FROM dateTime1
                WHERE dateBooked="2014-09-29 09:00:00"';

(The "dateBooked" field is of datetime format.)

I below doesn't work:

$dateX = '2014-09-29 09:00:00';

$query = '  SELECT *
            FROM dateTime1
            WHERE dateBooked=' .$dateX;

John Conde · Accepted Answer · 2014-09-15 23:22:00Z

2

You're missing quotes around your date:

$query = "  SELECT *
        FROM dateTime1
        WHERE dateBooked='" .$dateX . "'";

or

$query = "  SELECT *
        FROM dateTime1
        WHERE dateBooked='$dateX'";

answered Sep 15, 2014 at 23:22

John Conde

220k100 gold badges464 silver badges504 bronze badges

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

4 Comments

user557846 Over a year ago

oh sure answer the easy ones, like you NEED the rep points ;)

John Conde Over a year ago

Lol. I was too busy today to be active here. It felt good to just to give an answer.

user557846 Over a year ago

after 100k you should not be allowed to answer questions that don't require 3 phD's P)

Bzyzz Over a year ago

Beauty! fastest answer I've ever had :)

DeFeNdog · Accepted Answer · 2014-09-15 23:23:55Z

1

Try this:

$dateX = '2014-09-29 09:00:00';
$query = '  SELECT *
                        FROM dateTime1
                        WHERE dateBooked="' . $ dateX . '"';

answered Sep 15, 2014 at 23:23

DeFeNdog

1,2081 gold badge14 silver badges26 bronze badges

Collectives™ on Stack Overflow

PHP Date Variable in MySQL Query

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related