se vuoi usare lo stesso file devi aggiungerci una query che indica cosa deve tornare e poi indichi il file in altri due AutoComplete.
Codice PHP:
<script type="text/javascript" src="prototype.js"></script>
<script type="text/javascript" src="effects.js"></script>
<script type="text/javascript" src="controls.js"></script>
<form name="autocompleteTest" action="">
<input type="text" value="" name="findmeName" id="findmeName">
<div id="suggestBoxListName" class="suggestBox"></div>
<script type="text/javascript">
new Ajax.Autocompleter("findmeName", "suggestBoxListName", "requestScript.php", {minChars: 1});
</script>
<input type="text" value="" name="findmeSurname" id="findmeSurname">
<div id="suggestBoxListSurname" class="suggestBox"></div>
<script type="text/javascript">
new Ajax.Autocompleter("findmeSurname", "suggestBoxListSurname", "requestScript.php", {minChars: 1});
</script>
<input type="text" value="" name="findmePhone" id="findmePhone">
<div id="suggestBoxListPhone" class="suggestBox"></div>
<script type="text/javascript">
new Ajax.Autocompleter("findmePhone", "suggestBoxListPhone", "requestScript.php", {minChars: 1});
</script>
</form>
Ed adatti lo script php di consequenza
Codice PHP:
<?php
include("dbMYSQL.inc.php");
$findme = $_POST['findmeName'];
$var = 'nome';
if(!$findme){
$findme = $_POST['findmeSurname'];
$var = 'cognome';
}
if(!$findme){
$findme = $_POST['findmePhone'];
$var = 'telefono';
}
$list = '<ul>';
$sql = "SELECT $var FROM clienti WHERE nome LIKE '%$findme%'";
$result = mysql_query($sql, $dbm);
if(mysql_num_rows($result ) > 0){
while($row = mysql_fetch_array($result)){
$list .= "[*]".$row[$var]."";
}
}
else
{
$list .= '[*]Nessun risultato pertinente ...';
}
$list .= '[/list]';
mysql_free_result($result);
echo $list;
unset($list);
?>
Provala però che non l'ho testata e ci possono essere errori di sintassi