使用通配符查询数据库就可以了:
select * from tbl where field like '".$inputboxvalue."%'$inputbox;
$sql="select * from tbl where field like '".$inputboxvalue."%'"
mysql_query($sql)
while($obj=mysql_fetch_object())
{
echo $obj->field;
}
select * from tbl where field like '".$inputboxvalue."%'$inputbox;
$sql="select * from tbl where field like '".$inputboxvalue."%'"
mysql_query($sql)
while($obj=mysql_fetch_object())
{
echo $obj->field;
}
<input name=root maxlength=1 onkeyup="getData(this.value)">
<div id=listData></div>
<IE:Download ID="oDownload" STYLE="behavior:url(#default#download)" />
<script language=JScript>
var aa="";
function onDownloadDone(s){
aa=s;
document.all.listData.innerHTML=aa;
}
function getData(val)
{
document.all.listData.innerHTML="";
oDownload.startDownload('test.php?key='+val,onDownloadDone);
}
</script>test.php:
<?
$arr=array( 'a'=>array('aa','ab','ac'),
'b'=>array('ba','bb','bc'),
'c'=>array('ca','cb','cc'));
if(in_array($key,array_keys($arr))){
$tmpArr=$arr[$key];
echo "<select name=aaa>";
for($n=0;$n<count($tmpArr);$n++){
echo "<option value=".$n.">".$tmpArr[$n];
}
echo "</select>";
}
?>