1
I am developing a code where I have some related tax notes for a user ( unique id ) and when you take the information comes me several lines with the user name and the corresponding tax note , however I would like it to be grouped .
How are you today :
How I wanted you to stay :
Follows my code :
<?php
session_start();
$serverName = "DB_NAME";
$connectionInfo = array( "Database"=>"TABELA_NAME", "UID"=>"USUARIO", "PWD"=>"SENHA" );
$conn = sqlsrv_connect($serverName, $connectionInfo);
if ($conn === false) {
die(print_r(sqlsrv_errors(), true));
}
$query = ("SELECT * FROM PEDIDOS");
$params = array();
$options = array('Scrollable' => SQLSRV_CURSOR_KEYSET);
$stmt = sqlsrv_query($conn, $query, $params, $options);
?>
<?php include("cabecalho.php")?>
<br>
<!-- ##### Breadcrumb Area Start ##### -->
<center>
<a href="index.php" class="nav-brand"><img src="img/logo.png" alt=""></a>
</center>
<br>
<center>
<table class="table">
<thead class="thead-dark">
<tr>
<th>
<center>PEDIDOS</center>
</th>
<th><a onClick="window.print()" /><i class="fas fa-print"></a></th>
</tr>
</thead>
</table>
</center>
<?php while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) { ?>
<center>
<table class="table">
<thead class="thead-dark">
<tr>
<th>
<center>ID_Usuarios</center>
</th>
<th>
<center>Nota Fiscal</center>
</th>
<th>
<center>Data</center>
</th>
<th>
<center>Frete</center>
</th>
</tr>
</thead>
<tbody>
<td>
<center>
<?php echo $row['ID']; ?>
</center>
</td>
<td>
<?php echo $row['NF']; ?>
</td>
<td>
<center>
<?php echo date('d/m/y');?>
</center>
</td>
<td>
<?php echo $row['FRETE']; ?>
</td>
</tbody>
</table>
</center>
<br><br><br>
<?php }
?>
<!-- ##### Breadcrumb Area End ##### -->
<?php include("rodape.php")?>
I don’t quite understand the problem.. Do you want when the id doesn’t repeat itself? Don’t find it more business to control that in the code?
– rLinhares