function db_retrieve_logs() { global $link; mysqli_set_charset($link, "utf8"); $stm = $link->stmt_init(); $stm->prepare('SELECT RECORDED, IP, USERS.NAME, ID_USER, ID_TAB, ID_RECORD, OPERATION, DESCRIPTION, NEWVAL FROM LOG, USERS WHERE USERS.ID=ID_USER ORDER BY RECORDED DESC'); $stm->execute(); $logdata = $stm->get_result(); $rv = array(); while ($rw = $logdata->fetch_row()) { $rv[] = array($rw[0], $rw[1], $rw[2] . '(' . $rw[3] . ')', tabNameForID($rw[4]), $rw[5], operationNameForID($rw[6]), $rw[7], $rw[8]); } $stm->close(); return $rv; }
function db_export_log() { global $link; $stm = $link->stmt_init(); $stm->prepare('SELECT LOG.ID, RECORDED, IP, ID_USER, USERS.NAME, USERS.ROLE, ID_TAB, ID_RECORD, OPERATION, DESCRIPTION, NEWVAL FROM LOG JOIN USERS ON USERS.ID=LOG.ID_USER ORDER BY RECORDED DESC'); $stm->execute(); $st = $stm->get_result(); print '"ID","RECORDED","IP","ID_USER","USERNAME","USERROLE","ID_TAB","ID_RECORD","OPERATION","DESCRIPTION","NEWVALUE"'; print_nl(); while ($rw = $st->fetch_row()) { print $rw[0] . ',"' . $rw[1] . '","' . ddq($rw[2]) . '",' . $rw[3] . ',"' . ddq($rw[4]) . '","' . ddq($rw[5]) . '",' . $rw[6] . ',' . $rw[7] . ',"' . operationNameForID($rw[8]) . '","' . ddq($rw[9]) . '","' . ddq($rw[10]) . '"'; print_nl(); } $stm->close(); }