75 lines
1.5 KiB
PHP
75 lines
1.5 KiB
PHP
<?php
|
|
require_once __DIR__.'/auth_guard.php';
|
|
ini_set('display_errors', 1);
|
|
ini_set('display_startup_errors', 1);
|
|
error_reporting(E_ALL);
|
|
// database information
|
|
require_once("../config.php");
|
|
global $link;
|
|
dbConnect();
|
|
$sqlusers = "SELECT * from user limit 10";
|
|
$filtrados = mysqli_query($link, $sqlusers);
|
|
$return = new stdClass();
|
|
$return->records = [];
|
|
$return->header = [];
|
|
$return->flag = true;
|
|
$return->queryRecordCount = $filtrados->num_rows;
|
|
$return->totalRecordCount = 10000;
|
|
|
|
while ($row = mysqli_fetch_assoc ($filtrados))
|
|
{
|
|
if($return->flag){
|
|
foreach ($row as $key => $value) {
|
|
$return->header[] = $key;
|
|
}
|
|
$return->flag = false;
|
|
}
|
|
|
|
$return->records[] = $row;
|
|
}
|
|
//print("<pre>".print_r($return,true)."</pre>");
|
|
$lista = json_encode($return->records, JSON_UNESCAPED_UNICODE | JSON_FORCE_OBJECT);
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<meta charset="utf-8">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
<title></title>
|
|
|
|
<link rel="stylesheet" type="text/css" href="jquery.dynatable.css">
|
|
<script type="text/javascript" src="<?php echo $CFG->wwwroot ?>js/jquery-3.4.1.min.js"></script>
|
|
<script type="text/javascript" src="jquery.dynatable.js"></script>
|
|
|
|
</head>
|
|
<body>
|
|
|
|
|
|
<table id="my-final-table">
|
|
<thead>
|
|
<?php
|
|
foreach ($return->header as $key => $value) {
|
|
echo '<th>'. $value .'</th>';
|
|
}
|
|
?>
|
|
</thead>
|
|
<tbody>
|
|
</tbody>
|
|
</table>
|
|
|
|
|
|
<script type="text/javascript">
|
|
|
|
|
|
|
|
var data = <?php echo $lista; ?>;
|
|
|
|
$('#my-final-table').dynatable({
|
|
dataset: {
|
|
records: data
|
|
}
|
|
});
|
|
|
|
</script>
|
|
</body>
|
|
</html>
|