. */ /** * @brief List of users for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ $db = new dbquery(); $db->connect(); $what = $db->protect_string_db($_REQUEST['what']); $db->query("select society as tag1, lastname as tag2 from ".$_SESSION['tablename']['contacts'] ." where (lower(lastname) like lower('" .$what."%') or lower(society) like lower('" .$what."%')) and user_id = '" .$_SESSION['user']['UserId']."' order by lastname, society"); $listArray = array(); while($line = $db->fetch_object()) { if (empty($line->tag2)) array_push($listArray, $line->tag1); else array_push($listArray, $line->tag2); } echo "

\n"; $authViewList = 0; foreach($listArray as $what) { if($authViewList >= 10) { $flagAuthView = true; } if(stripos($what, $_REQUEST['what']) === 0) { echo "
• ".$what."
\n"; if($flagAuthView) { echo "
• ...
\n"; break; } $authViewList++; } } echo "

";