load_lang(); $db = new Database(); $query = "SELECT lastname, firstname, phone, mail, user_id FROM ".$_SESSION['tablename']['users']." WHERE (lower(lastname) like lower(?) or lower(firstname) like lower(?)) ORDER BY lastname, firstname"; $returnId = $db->query($query,array($_REQUEST['searchValue'].'%',$_REQUEST['searchValue'].'%')); // $db->show(); //$returnId = $db->query($query); if (!$returnId) { $return['status'] = 0; $return['msg'] = 'fail'; echo json_encode($return); exit; } $return['status'] = 1; $return['msg'] = 'Recherche effectué'; $return['query'] = $query; $return['searchValue'] = $_REQUEST['searchValue']; while ($line = $returnId->fetchObject()) { if($line->user_id != $_SESSION['user']['UserId']) { $line->phone = str_replace(' ','',$line->phone); $return['rechercheColleague'] .= '
' .functions::xssafe($line->mail). ' ' .functions::xssafe($line->phone). '
'; } } echo json_encode($return);