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>
每次
通过循环都会覆盖$table
。 尝试使用数组:
$table[] = $result->fetchAll();
其他问题:
<?php foreach ($table as $key => $q): ?>
<?php foreach ($secteur as $key => $s): ?>
- 使用第二个循环覆盖
$key
。 $secteur
从何而来? 它没有定义。 也许你的意思是$q
?