Path: C:\
<?php
$id = $_GET['id']; $arq = $_GET['arq'];
$result = sqlsrv_query( $conn3, "SELECT
b.id_Usuario as usuario
,Convert(varchar(11), b.dt_Dow,106)+' às '+Convert(varchar(5), b.dt_Dow,108) as dtDow
,b.ds_IP as dsIP
FROM [dtbtransporte].[dbo].[tbdArqDow] as a
left join [dtbtransporte].[dbo].[tbdArqDowMov] as b on a.id_Arq = b.id_Arq
WHERE a.id_Arq = $id order by b.dt_Dow asc", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
?>
<aside role="complementary" class="col-md-9" style="height:100%">
<div>
<h3>Arquivo : <?php echo $arq;?></h3>
</div>
<div class="row" >
<div class="col-md-12" >
<table class="table">
<thead>
<tr>
<th class="col-md-5">Usuário</th>
<th class="col-md-4" style="text-align:center">Dia/Hora</th>
<th class="col-md-3" style="text-align:center">nº IP</th>
</tr>
</thead>
</table>
<div style="width:100%; height: calc(60vh - 100px); overflow: auto">
<table class="table">
<tbody align="left">
<?php $n=0;
while($linhas = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC)){
$n++;
$usu[$n] = $linhas ['usuario'];
$dsIP[$n] = $linhas ['dsIP'];
$dtDow[$n] = $linhas ['dtDow'];
}
for ($i = 1; $i <= $n; $i ++){$u=$usu[$i];
$result2 = sqlsrv_query($conn2, "SELECT nome FROM [Auxiliar].[dbo].[usuarios] WHERE id = $u ", array(), array( "Scrollable" => SQLSRV_CURSOR_KEYSET ));
while($linhas2 = sqlsrv_fetch_array($result2, SQLSRV_FETCH_ASSOC)){$usuario=$linhas2['nome'];}
echo "<tr>";
echo "<td class='col-md-5'>".$usuario."</td>";
echo "<td class='col-md-4' style='text-align:center'>".$dtDow[$i]."</td>";
echo "<td class='col-md-3' style='text-align:center'>".$dsIP[$i]."</td>";
echo "</tr>";
}echo'</tbody></table></div>';
?>
</div>
</div>
</aside>