public static function search($id = '', $userid = '', $action = '') { $where = ''; if (!empty($id)) { $where .= " log.`id`={$id} AND"; } if (!empty($userid)) { $where .= " log.`userid`={$userid} AND"; } if (!empty($action)) { $where .= " log.`action`='{$action}' AND"; } if (substr($where, -3) == "AND") { $where = substr($where, 0, -3); } // $logs = array(); $query = "\n\t\t\tSELECT\tlog.`id` AS id,\n log.`time` AS time,\n log.`userid` AS userid,\n log.`ipAddress` AS ipAddress,\n log.`action` AS action,\n log.`url` AS url,\n log.`info` AS info\n\t\t\tFROM\t`" . SESSION_NAME . "log` log\n WHERE {$where}"; //echo "query-->{$query}<br>"; if (!sql_select($query, $results)) { return false; } settype($response, 'array'); while ($row = $results->fetch(PDO::FETCH_ASSOC)) { $nlog = Log::load($row['id']); $response[] = $nlog; } return $response; }