ajax_auto_anc_card.php

Go to the documentation of this file.

<?php 
//This file is part of NOALYSS and is under GPL 
//see licence.txt
  /**
   *@file
   *@brief no used ?? 
   */
if ( ! defined ('ALLOWED') ) die('Appel direct ne sont pas permis');
$cn=Dossier::connect();
 
 
if ( isset($_REQUEST['pa_id']) )
{   
    $res=$cn->exec_sql("select po_name,po_description 
            from  poste_analytique 
            where 
                  pa_id=$1  
              and (po_description ilike '%'|| $2||'%' or po_name ilike '%'|| $3 ||'%')
            order by po_id limit 12",
        array($_REQUEST['pa_id'],$_POST['anccard'],$_POST['anccard']));
}
else
{
       $res=$cn->exec_sql("select po_name,po_description
                from  poste_analytique 
                where 
                      po_description ilike '%'|| $1 ||'%' 
                   or po_name ilike '%'|| $2||'%' 
                order by po_id limit 12 ",
        array($_POST['anccard'],$_POST['anccard']));
}
$nb=Database::num_row($res);
        echo "<ul>";
for ($i = 0;$i< $nb;$i++)
{
        $row=Database::fetch_array($res,$i);
        echo "<li>";
        echo $row['po_name'];
        echo '<span class="informal"> '.$row['po_description'].'</span></li>';
}
        echo "</ul>";
?>