PHP AdminDB::check_for_error Examples

Example #1

File: SecurityUtilDB.php Project: razagilani/srrs

<?php

//NOT TESTED. NEED TO TEST.
@define('BASE_DIR', dirname(__FILE__) . '/../..');
include_once 'AdminDB.class.php';
$db = new AdminDB();
//get users ids to delete
$date = date('Y-m-d', time() - 30 * 24 * 60 * 60);
$query = 'SELECT memberid FROM' . ' ' . $db->get_table('login') . ' ' . 'WHERE last_login <' . ' ' . $date . ' ' . 'OR last_login IS NULL';
$result = $db->db->query($query);
$db->check_for_error($result);
$memberids = array();
print $query;
while ($id = $result->fetchRow()) {
    $memberids[] = $id['memberid'];
    #print $id['memberid'];
}
//delet users
$db->del_users($memberids);
CmnFns::write_log('Users deleted based because of inactivity. ' . join(', ', 'memberids'), 'sessionID');