PDO FETCH all在HTML中返回一行

Question

foreach($ligne as $value){

    $result = $bdd->query('SELECT count(d.DNUMERO) as nbr, SUM(d.DINIPPL) as total FROM dossier d, cliregroup c, doinfsup i WHERE i.DSNUMERO = d.DNUMERO AND d.DNUMCLI = c.NUMCLI AND i.INFOSUPPLM REGEXP "([1][4-6][0-9a-zA-Z]{6}[0-9]{4})" AND INFOSUPPLM NOT REGEXP "([0-1][0-4][0-9a-zA-Z]{6}[0-9]{4})" AND i.DSNUMERO LIKE "16%" AND c.CODEREGROUP LIKE "'.$value.'"');

    $table = $result->fetchAll();

    print_r($table);
}

<?php include_once('header.html'); ?>

我的$table返回一行，而不是整个表(最后一行)。在php文件中，它很好：

<?php print_r($table); ?>

<table class="table">
    <?php foreach ($table as $key => $q): ?>
        <?php foreach ($secteur as $key => $s): ?>             
            <tr>
                <th><?php echo $key; ?></th>
                <td><?php echo $q['nbr']; ?></td>
                <td><?php echo $q['total']; ?></td>
            </tr>
        <?php endforeach; ?>
    <?php endforeach; ?>
</table>
</body>
</html> 

Answer 1

您每次都会在循环中覆盖$table。尝试一个数组：

$table[] = $result->fetchAll();

其他问题：

<?php foreach ($table as $key => $q): ?>
    <?php foreach ($secteur as $key => $s): ?>

• 你用第二个循环覆盖了$key。
• $secteur是从哪里来的？它还没有定义。也许你指的是$q