1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
|
<?php
define('DB_HOST', '127.0.0.1');
define('DB_NAME', 'tests');
define('DB_USER', 'root');
define('DB_PWD' , '');
$bdd = new PDO('mysql:host='.DB_HOST.'; dbname='.DB_NAME,DB_USER,DB_PWD, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));
$query = "SELECT `data`, `nome`,count(*) as conta FROM `tab` group by `data`,`nome` order by `data`, `nome`";
$prepared = $bdd->prepare($query);
$prepared->execute();
$result = $prepared->fetchAll();
$arrDate = array();
$arrNomi = array();
$arrFina = array();
foreach($result as $subArray) {
if (!in_array($subArray['data'],$arrDate)) {$arrDate[] = $subArray['data'];}
if (!in_array($subArray['nome'],$arrNomi)) {$arrNomi[] = $subArray['nome'];}
$arrFina[$subArray['data']][$subArray['nome']] = $subArray['conta'];
}
?>
<table border="1px">
<tr align='center' >
<td>
</td><?php
foreach($arrDate as $key => $value) {?>
<td><?php print $value;?></td><?php
} ?>
</tr>
<?php
foreach($arrNomi as $keyNomi => $valNomi) {?>
<tr align='center' style="border:1px solid black">
<td><?php print $valNomi;?></td><?php
foreach($arrDate as $keyDate => $valDate) {?>
<td><?php print (isset($arrFina[$valDate][$valNomi]) ? $arrFina[$valDate][$valNomi] : "");?></td><?php
}?>
</tr><?php
}?>
</table> |
Partager