PDO fetch returning zero

Question

I have this code which i am testing from last couple of hour but unable to understand that why TodayAttendanceCount is not returning 0.

    $sqlCheckLoginEntryCount = "SELECT Count(*) TodayAttendanceCount FROM AttendanceMachineLogin
                                WHERE Date(RecordAddDateTime) = :RecordAddDateTime
                                AND TimeTrackId = :TimeTrackId";

   $statementEntryCount = $connPDO->prepare($sqlCheckLoginEntryCount);

   $queryParams = array(
        ':TimeTrackId'          =>    $TimeTrackId,
        ':RecordAddDateTime'    =>    $RecordAddDateTime
    );

   $statementEntryCount->execute($queryParams);

   $queryData = $statementEntryCount->fetch();

   echo '\n ';
   //var_dump($queryData);
   echo "\n Attendance Count". $queryData['TodayAttendanceCount'] ." ;";

I have executed the same query in MySqlWorkbench which is working fine and there is data and it is fine from the database side.

I think everything was ok, you have to run sql directly in phpmyadmin check what results you are getting — jvk, Aug 15 '18 at 06:14
@whoami Yeah i have already done this as i mentioned in the question. It is working fine. — Muhammad Faizan Khan, Aug 15 '18 at 06:23
Are you simply missing the `AS`, shouldn't it be `SELECT Count(*) AS TodayAttendanceCount` in your query? — Tobias K., Aug 15 '18 at 06:36
Can you add what you get from `TodayAttendanceCount` if not `0`? And how did that `var_dump` look? — Tobias K., Aug 15 '18 at 14:22

score 0 · Answer 1 · answered Aug 15 '18 at 06:15

0

Remove : part at the $queryParams. It isn't needed. The code will look like this.

$queryParams = array(
    'TimeTrackId'          =>    $TimeTrackId,
    'RecordAddDateTime'    =>    $RecordAddDateTime
);

answered Aug 15 '18 at 06:15

david

3,225
9
30
43

no the problem still persist. I have done many query with colon. it doesn't make any difference – Muhammad Faizan Khan Aug 15 '18 at 06:19
what about this? $queryData->TodayAttendanceCount – david Aug 15 '18 at 06:20
This is not write, throwing exception as expected. – Muhammad Faizan Khan Aug 15 '18 at 06:31

score -1 · Answer 2 · answered Aug 15 '18 at 07:00

-1

Try this:

    $sqlCheckLoginEntryCount = "SELECT Count(*) As TodayAttendanceCount FROM AttendanceMachineLogin
                                WHERE Date(RecordAddDateTime) = ':RecordAddDateTime'
                                AND TimeTrackId = :TimeTrackId";

   $statementEntryCount = $connPDO->prepare($sqlCheckLoginEntryCount);

   $queryParams = array(
        'TimeTrackId'          =>    $TimeTrackId,
        'RecordAddDateTime'    =>    $RecordAddDateTime
    );

   $statementEntryCount->execute($queryParams);

   $queryData = $statementEntryCount->fetch(PDO::FETCH_ASSOC);

   echo '\n ';
   //var_dump($queryData);
   echo "\n Attendance Count ". $queryData['TodayAttendanceCount'];

Hope I pushed you further.

answered Aug 15 '18 at 07:00

ThS

4,597
2
15
27

An explanation of what you've changed and how this should solve the problem would help. – Nigel Ren Aug 15 '18 at 07:21
@NigelRen the `SQL` query misses the `As` keyword. The array of the desired values shouldn't have preceding colons in the array keys. – ThS Aug 15 '18 at 07:26
`as` is optional in MySQL, also check out https://stackoverflow.com/questions/9778887/is-the-leading-colon-for-parameter-names-passed-to-pdostatementbindparam-opt – Nigel Ren Aug 15 '18 at 07:29
but we shouldn't rely on this behaviour and in the official documentation the colons are ommited. – ThS Aug 15 '18 at 07:34
I'm in favour of not using undocumented features, but there is a difference between something that happens to work (but shouldn't) and something that doesn't work at all. As such although it's good to change it - will it solve OP's problem? – Nigel Ren Aug 15 '18 at 07:39
good point, but, that's why we have "best practices" in the programming/programmers industry. So, we should, only, rely on official documentations. The OP may or may not be helped out with that but these points "will" help another person, let me say: if you know something good share it ! – ThS Aug 15 '18 at 07:48

PDO fetch returning zero

2 Answers2