. */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); $req = new request(); $select = array(); $select[$_SESSION['tablename']['users']]= array('lastname', 'firstname', 'user_id'); $where = " (lower(lastname) like lower(:input) " ."or lower(firstname) like lower(:input) " ."or user_id like :input) and (status = 'OK' or status = 'ABS') and enabled = 'Y'"; $other = 'order by lastname, firstname'; $arrayPDO = array(":input" => $_REQUEST['Input']."%"); $res = $req->PDOselect($select, $where, $arrayPDO, $other, $_SESSION['config']['databasetype'], 11,false,"","","", false); echo "

\n"; for($i=0; $i< min(count($res), 10) ;$i++) { echo "
• ".functions::xssafe(functions::show_string($res[$i][0]['value'])) .', ' . functions::xssafe(functions::show_string($res[$i][1]['value'])) .' (' . functions::xssafe($res[$i][2]['value']).")
\n"; } if(count($res) == 11) { echo "
• ...
\n"; } echo "

";