使用pdo从mysql检索今天的日期数据

Question

I have some data in my table which are [name][address][phone_number] and the date in this format 2015-10-14 14:37:38. I am using php PDO. How can I query out just today date from the table?

The following code is my code to query out result for the past 7 days which worked perfectly. However, whenever I replace it with 1 it doesn't work:

$query = $digital->query('SELECT * FROM sales WHERE `datetime` BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW() ORDER BY sale_id DESC'); 

What I want is to be able to query out all today data inserted into database.

Answer 1

You can use this, haven't tested.

<?php
$todaysDate = date('Y-m-d'); //if your date is stored in y-m-d format
        try
        {
            $s = $conn->query("SELECT * from sales where datetime LIKE '%$todaysDate%'");
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }
        $results = $s->fetch(PDO::FETCH_OBJ);

?>

Your query results is now in $results variable.

Extended version

    <?php
try
        {
            $s = $conn->query("SELECT * from sales");
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }

    while($results = $s->fetch(PDO::FETCH_OBJ))
    {
        $date = explode(" ", $results->datetime);
        if($date[0] == date('Y-m-d'))
        {
            //write code here to display data
        }
    }

?>

Make sure you replace all the columnNames and tablename. Edit :- Here's a sqlfiddle pertaining to my first solution. http://sqlfiddle.com/#!9/7c2f1/3