. */ /** * @brief List of users for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ $db = new Database(); $stmt = $db->query( "select lastname, firstname, user_id from ".$_SESSION['tablename']['users'] . " where (" . "lower(lastname) like lower(:what) " . " or lower(firstname) like lower(:what) " . " or lower(user_id) like lower(:what) " . ") and status <> 'DEL'" . " order by lastname, firstname", array(':what' => $_REQUEST['what'] . "%") ); $listArray = array(); while ($line = $stmt->fetchObject()) { $listArray[$line->user_id] = functions::show_string($line->lastname)." ".functions::show_string($line->firstname); } echo "

\n"; $authViewList = 0; $flagAuthView = false; foreach($listArray as $key => $what) { if(isset($authViewList) && $authViewList>= 10) { $flagAuthView = true; } echo "
• ".$what."
\n"; if($flagAuthView) { echo "
• ...
\n"; break; } $authViewList++; } echo "

";