39 lines
837 B
PHP
39 lines
837 B
PHP
|
<?php
|
||
|
|
require_once("../config.php");
|
||
|
|
require_once("../runtime/encrypt.php");
|
||
|
|
dbConnect();
|
||
|
|
global $link;
|
||
|
|
|
||
|
|
$users = [];
|
||
|
|
|
||
|
|
$hoy = date("Y-m-d");
|
||
|
|
|
||
|
|
$sqlusers = "
|
||
|
|
SELECT user.userid,user.nombre,user.numempl,user.apellido, categoria.nombre as cat
|
||
|
|
FROM user
|
||
|
|
INNER JOIN asignacion ON asignacion.uid = user.userid
|
||
|
|
INNER JOIN categoria ON categoria.id = asignacion.catid
|
||
|
|
WHERE asignacion.catid = 48
|
||
|
|
";
|
||
|
|
|
||
|
|
|
||
|
|
$resultusers = mysqli_query($link, $sqlusers);
|
||
|
|
|
||
|
|
if( $resultusers ){
|
||
|
|
mysqli_data_seek($resultusers, 0);
|
||
|
|
while ($row = mysqli_fetch_assoc ($resultusers)){
|
||
|
|
$users[] = $row;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
//print_r($users);
|
||
|
|
|
||
|
|
echo '<table><tbody>';
|
||
|
|
|
||
|
|
foreach ($users as $index => $value) {
|
||
|
|
echo "<tr><td>".$value['numempl']."</td><td>".$value['nombre']."</td><td>".$value['apellido']."</td><td>".$value['cat']."</td></tr>";
|
||
|
|
}
|
||
|
|
|
||
|
|
echo '</tbody></table>';
|
||
|
|
|
||
|
|
?>
|