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
| // $arg1 = Valeur du nom de famille
// $arg2 = Valeur du prénom
// $cp = champ où la lettre a été tappée
function get_name($arg1,$arg2,$cp) {
$sql = "SELECT peoId,peLastName,peFirstName FROM ".table(2)." WHERE ";
if(isset($arg1))
$sql .= " peLastName LIKE '".$arg1."%' ";
if(isset($arg1) && isset($arg2))
$sql .= " AND ";
if(isset($arg2))
$sql .= " peFirstName LIKE '".$arg2."%' ";
$sql .= " ORDER BY ".$cp." ASC LIMIT 0,20";
$query = mysql_query($sql);
$total = mysql_num_rows($query);
echo "<ul>";
if($total==0)
echo "<li onClick='createPeople()'>Créer</li>";
else {
switch($cp) {
case "peLastName" :
while($tab = mysql_fetch_array($query)) {
echo "<li onClick='afficher_credit(".$tab['peoId'].")'>".$tab["peLastName"]." ".$tab["peFirstName"]."</li>";
}
break;
case "peFirstName": while($tab = mysql_fetch_array($query)) {
echo "<li onClick='afficher_credit(".$tab['peoId'].")'>".$tab["peFirstName"]." ".$tab["peLastName"]."</li>";
}
break;
}
}
} |
Partager