Vfrdtyky

my code is not showing all the results that my query shows in the SQL, and i«m not sure why I would like someone to help me find the problem, I have the following code below:
My query in php (it shows 2 results in SQL of 2 different cards from the same person, but in php it just shows one result)

$sql='SELECT Card.*

FROM Card

WHERE ValidUntil <= Cast(DateAdd( DD ,7 , GetDate() ) as Date)

ORDER BY ValidUntil ASC';

$stm = $conn->query($sql);

My cycle in php after my query:

OLD CODE

if (!$stm)

{

    echo "";

}

else

{

    while ($rows2 = $stm->fetch())

    {

    $CType = isset($rows2['CardType']) ? $rows2['CardType'] : NULL;

    $CNr = isset($rows2['CardNr']) ? $rows2['CardNr'] : NULL;

    $CValFrom = isset($rows2['ValidFrom']) ? $rows2['ValidFrom'] : NULL;

    $CValUntil = isset($rows2['ValidUntil']) ? $rows2['ValidUntil'] : NULL;

    $CLTCCTime = isset($rows2['LastTccTime']) ? $rows2['LastTccTime'] : NULL;

    echo

'

';

    $tableHeaders = [

    ['variable' => 'CType', 'title' => 'Tipo'],

    ['variable' => 'CNr', 'title' => 'Nr.'],

    ['variable' => 'CValFrom', 'title' => 'Válido Desde'],

    ['variable' => 'CValUntil', 'title' => 'Válido Até'],

    ['variable' => 'CLTCCTime', 'title' => 'Dia/Hora no Último Terminal'],

    ];



    foreach($tableHeaders as $tableHeader):

        $variable = $tableHeader['variable'];

        if (isset($$variable) AND !is_null($$variable) AND !empty(trim($$variable))):

            echo '<th>' . $tableHeader['title'] . '</th>';

        endif;

    endforeach;



    echo '</tr></thead>';

echo '<tbody><tr>';



        $tableDatas1 = [

        ['variable1' => 'CType', 'data1' => $CType],

        ['variable1' => 'CNr', 'data1' => $CNr],

        ['variable1' => 'CValFrom', 'data1' => $mytime1],

        ['variable1' => 'CValUntil', 'data1' => $mytime2],

        ['variable1' => 'CLTCCTime', 'data1' => $mytime3],

        ];



        foreach($tableDatas1 as $tableData1):

            $variable1 = $tableData1['variable1'];

            if (isset($$variable1) AND !is_null($$variable1) AND !empty(trim($$variable1))):



                echo '<td class="text_body">' . $tableData1['data1'] . '</td>';

            endif;

        endforeach;



        echo '</tr></br>';

    }

}

echo '</tbody></table></body>';

After reading the comments I started changing my code, and at some point it shows all the results that it should, but it was showing for each row one tableheader and I only want a single one, and the results below it, I have made the following changes, but now it still appears only one result again

if (!$stm)

{

    echo "";

}

else

{

    $rowsCabecalho = $stm->fetch();

    $CType = isset($rowsCabecalho['CardType']) ? $rowsCabecalho['CardType'] : NULL;

    $CNr = isset($rowsCabecalho['CardNr']) ? $rowsCabecalho['CardNr'] : NULL;

    $CValFrom = isset($rowsCabecalho['ValidFrom']) ? $rowsCabecalho['ValidFrom'] : NULL;

    $CValUntil = isset($rowsCabecalho['ValidUntil']) ? $rowsCabecalho['ValidUntil'] : NULL;

    $CLTCCTime = isset($rowsCabecalho['LastTccTime']) ? $rowsCabecalho['LastTccTime'] : NULL;

        $CCodingDate = isset($rowsCabecalho['CodingDate']) ? $rowsCabecalho['CodingDate'] : NULL;

    echo '<div class="informaltable"><p></p><table cellspacing="2" border="0"><thead><tr>';

    $tableHeaders = [

    ['variable' => 'CType', 'title' => 'Tipo'],

    ['variable' => 'CNr', 'title' => 'Nr.'],

    ['variable' => 'CValFrom', 'title' => 'Válido Desde'],

    ['variable' => 'CValUntil', 'title' => 'Válido Até'],

    ['variable' => 'CLTCCTime', 'title' => 'Dia/Hora no Último Terminal'],

    ];

    foreach($tableHeaders as $tableHeader):

        $variable = $tableHeader['variable'];

        if (isset($$variable) AND !is_null($$variable) AND !empty(trim($$variable))):

            echo '<th>' . $tableHeader['title'] . '</th>';

        endif;

    endforeach;

    echo '</tr></thead><tbody>';

}



if (!$stm)

{

    echo "";

}

else

{

    while ($rows2 = $stm->fetch())

    {

        $CType = isset($rows2['CardType']) ? $rows2['CardType'] : NULL;

        $CNr = isset($rows2['CardNr']) ? $rows2['CardNr'] : NULL;

        $CValFrom = isset($rows2['ValidFrom']) ? $rows2['ValidFrom'] : NULL;

        $CValUntil = isset($rows2['ValidUntil']) ? $rows2['ValidUntil'] : NULL;

        $CLTCCTime = isset($rows2['LastTccTime']) ? $rows2['LastTccTime'] : NULL;

        $CCodingDate = isset($rows2['CodingDate']) ? $rows2['CodingDate'] : NULL;



        echo '<tr>';

        $tableDatas1 = [

        ['variable1' => 'CType', 'data1' => $CType],

        ['variable1' => 'CNr', 'data1' => $CNr],

        ['variable1' => 'CValFrom', 'data1' => $mytime1],

        ['variable1' => 'CValUntil', 'data1' => $mytime2],

        ['variable1' => 'CLTCCTime', 'data1' => $mytime3],

        ];

        foreach($tableDatas1 as $tableData1):

            $variable1 = $tableData1['variable1'];

            if (isset($$variable1) AND !is_null($$variable1) AND !empty(trim($$variable1))):

                echo '<td class="text_body">' . $tableData1['data1'] . '</td>';

            endif;

        endforeach;

        echo '</tr>';

    }

}

echo '</tbody></table></body>';

Solution:

Remove $rowsCabecalho = $stm->fetch(); from your code. First, you never use $rowsCabecalho and second, don't call $stm->fetch() twice.

Use PDOStatement::fetch like this:

<?php

...

while ($row = $stmt->fetch()) {

   foreach($row => $value) {

      echo $value;

   }

   // your code ...

}

...



?>

Update:

If you want to print the header, and then the rows, you may try with this:

<?php

echo '<div class="informaltable"><p></p><table cellspacing="2" border="0"><thead><tr>';

$tableHeaders = [

['variable' => 'CType', 'title' => 'Tipo'],

['variable' => 'CNr', 'title' => 'Nr.'],

['variable' => 'CValFrom', 'title' => 'Válido Desde'],

['variable' => 'CValUntil', 'title' => 'Válido Até'],

['variable' => 'CLTCCTime', 'title' => 'Dia/Hora no Último Terminal'],

];

foreach($tableHeaders as $tableHeader):

    $variable = $tableHeader['variable'];

    echo '<th>' . $tableHeader['title'] . '</th>';

endforeach;

echo '</tr></thead><tbody>';



if (!$stm)

{

    echo "";

}

else

{

    while ($rows2 = $stm->fetch())

    {

        $CType = isset($rows2['CardType']) ? $rows2['CardType'] : NULL;

        $CNr = isset($rows2['CardNr']) ? $rows2['CardNr'] : NULL;

        $CValFrom = isset($rows2['ValidFrom']) ? $rows2['ValidFrom'] : NULL;

        $CValUntil = isset($rows2['ValidUntil']) ? $rows2['ValidUntil'] : NULL;

        $CLTCCTime = isset($rows2['LastTccTime']) ? $rows2['LastTccTime'] : NULL;

        $CCodingDate = isset($rows2['CodingDate']) ? $rows2['CodingDate'] : NULL;



        echo '<tr>';

        $tableDatas1 = [

        ['variable1' => 'CType', 'data1' => $CType],

        ['variable1' => 'CNr', 'data1' => $CNr],

        ['variable1' => 'CValFrom', 'data1' => $mytime1],

        ['variable1' => 'CValUntil', 'data1' => $mytime2],

        ['variable1' => 'CLTCCTime', 'data1' => $mytime3],

        ];

        foreach($tableDatas1 as $tableData1):

            $variable1 = $tableData1['variable1'];

            if (isset($$variable1) AND !is_null($$variable1) AND !empty(trim($$variable1))):

                echo '<td class="text_body">' . $tableData1['data1'] . '</td>';

            endif;

        endforeach;

        echo '</tr>';

    }

}

echo '</tbody></table></body>';

?>