1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
|
<?php
header('Content-Type: text/xml;charset=utf-8');
echo(utf8_encode("<?xml version='1.0' encoding='UTF-8' ?><options>"));
include 'connexion_mysql.php';
mysql_query("SET NAMES 'utf8'");
$query = "SELECT Distinct Nom FROM Stagiaires";
$result = mysql_query($query);
$queue = array();
while($tab= mysql_fetch_array($result,MYSQL_NUM)) array_unshift($queue, strtolower($tab[0]));
if (isset($_GET['debut']))
{
$debut = utf8_decode($_GET['debut']);
} else {
$debut = "";
}
$debut = strtolower($debut);
function generateOptions($debut,$queue)
{
$MAX_RETURN = 10;
$i = 0;
foreach ($queue as $element) {
if ($i<$MAX_RETURN && substr($element, 0, strlen($debut))==$debut) {
echo(utf8_encode("<option>".$element."</option>"));
$i++;
}
}
}
generateOptions($debut,$queue);
echo("</options>");
?> |
Partager