<?php
// http://dcabasson.developpez.com/articles/javascript/ajax/ajax-autocompletion-pas-a-pas/
header('Content-Type: text/xml;charset=utf-8');
echo(utf8_encode("<?xml version='1.0' encoding='UTF-8' ?><options>"));
if (isset($_GET['debut'])) {
    $debut = utf8_decode($_GET['debut']);
} else {
    $debut = "";
}
$debut = strtolower($debut);

//require('../../conf.php');
$serveur = "localhost";
$user = "ED";
$passwd = "ed435732";
$bdd = "alise";
mysql_connect($serveur,$user,$passwd) or die("Impossible de se connecter");
mysql_select_db($bdd) or die("Impossible d'acc&eacute;der à la base");
function generateOptions($debut) {
    $MAX_RETURN = 10;
    $i = 0;
    $rq = "SELECT `NCCENR` FROM `comsimp2006` WHERE `NCCENR` LIKE '".$debut."%' ORDER BY `NCCENR` LIMIT 10";
    $result = mysql_query($rq);
    while($row = mysql_fetch_assoc($result)) {
        
            echo(utf8_encode("<option><desc>".$row['NCCENR']."</desc></option>"));
        
        }
    
}

generateOptions($debut);

echo("</options>");
?>
