. */ /** * @brief List of structures for autocompletion * * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); $db = new Database(); $query = "SELECT id, label as tag FROM ".$_SESSION['tablename']['contact_purposes']." WHERE lower(label) like lower(?)"; $arrayPDO = array('%'.$_REQUEST['what'].'%'); if(isset($_GET['id']) && $_GET['id'] <> ''){ $query .= ' and id <> ?'; $arrayPDO = array_merge($arrayPDO, array($_GET['id'])); } $query .= " order by label"; $stmt = $db->query($query, $arrayPDO); $listArray = array(); while($line = $stmt->fetchObject()) { // array_push($listArray, $line->tag); $listArray[$line->id] = $line->tag; } echo "

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

";