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

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

";