sql in database gives different result in php

Question

I got the following sql:

SELECT COUNT(pu_id) FROM purchasing WHERE MONTH(pu_create_date)=MONTH(NOW())

In Mysql it gives the result 0 as expected.

When I put it in PHP I get the result 1 of $numMonth. This is the php code:

$database = new Database();
$db = $database->getConnection();

$stmt= $db->query('SELECT COUNT(pu_id) FROM purchasing WHERE MONTH(pu_create_date)=MONTH(NOW())') ;
$numMonth = $stmt->execute();
echo $numMonth;

Why do I get two different results?

pu_id = unique key

pu_create_date = timestamp

in this instance 1 is true as it is the boolean response from the execute method — Professor Abronsius
– Professor Abronsius, Commented Jun 29, 2020 at 18:12

Barmar · Accepted Answer · 2020-06-29 18:13:27Z

3

You have to fetch the row from the query.

$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_NUM);
$numMonth = $row[0];
echo $numMonth;

answered Jun 29, 2020 at 18:13

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

sql in database gives different result in php

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