Show Log
");
// connect and access to MySql db
$link = mysqli_connect('localhost', 'root', '');
if (!$link) die('Cannot connet to DB'.mysqli_error());
$db_selected = mysqli_select_db($link, 'opengatem');
if (!$db_selected) die('Cannot select DB'.mysqli_error());
mysqli_set_charset($link, 'utf8');
$result = mysqli_query($link, 'SELECT * FROM sessionview where userId like "'.$userId.'" and device like "'.$device.'" and "'.$fromTime.'"");
print('');
$count=0;
while ($field = mysqli_fetch_field($result)) {
print('| '.$field->name.' | ');
$count++;
}
print('
');
// show rows
while ($row = mysqli_fetch_row($result)) {
print('');
for($i=0; $i<$count; $i++){
print('| '.$row[$i].' | ');
}
print('
');
}
print("");
$close_flag = mysqli_close($link);
?>