高手帮忙看下,这个用什么实现呢js还是php? 这是windows的自动完成-_-!打开你的internet选项,“内容”标签下有个“自动完成”选项 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 呵呵,大抵明白lz的意思如果真的是windows的自动完成,就算我说废话了否则就给Ajax的代码你看看,是根据zip code自动填充city和state的,意思应该是和你说的差不多数据库如下:CREATE DATABASE test;CREATE TABLE `zipcodes` ( `zipcode` varchar(6) NOT NULL default '', `city` varchar(20) NOT NULL default '', `state` varchar(20) NOT NULL default '', PRIMARY KEY (`zipcode`,`city`,`state`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO `zipcodes` (`zipcode`, `city`, `state`) VALUES ('510160', 'zsb', 'gz'),('510420', 'gw', 'GZ');1.html代码如下:HTML<script>function createRequestObject() { var ro; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ ro = new ActiveXObject("Microsoft.XMLHTTP"); }else{ ro = new XMLHttpRequest(); } return ro;}var http = createRequestObject();function sndReq(zip) { http.open('get', 'zipcode.php?zip='+zip); http.onreadystatechange = handleResponse; http.send(null);}function handleResponse() { if(http.readyState == 4){ var response = http.responseText; var update = new Array(); if(response.indexOf('|' != -1)) { update = response.split('|'); document.getElementById("city").value = update[0]; document.getElementById("state").value = update[1]; } }}</script><h3>Enter A United States Zipcode, Then Tab</h3><table align="center"> <tr> <td>Enter Zipcode:</td> <td><input type="text" id="zipcode" name="zipcode" onBlur="sndReq(this.value);"/></td> </tr> <tr> <td>City:</td> <td><input type="text" id="city" name="city"/></td> </tr> <tr> <td>State:</td> <td><input type="text" id="state" name="state"/></td> </tr></table>zipcode.php代码如下:<?php$dbuser = 'root';$dbpass = '123456';$cn = mysql_connect("localhost", $dbuser, $dbpass);$db = mysql_select_db("test");$sql = "select city, state from zipcodes where zipcode = " . $_REQUEST['zip'];$rs = mysql_query($sql);$row = mysql_fetch_array($rs);echo $row['city'] . "|" . $row['state'];mysql_close($cn);?>试试添入510160或者510420,就自动从数据库中读出相应的city 和state并添入 谢谢edwardrong(明年-今日) ,明白了点,可是还有别的方法么,用js应该也可以吧~ 谢谢edwardrong(明年-今日) ,明白了点,可是还有别的方法么,用js应该也可以吧~----------------------------------------------ajax:Asynchronous JavaScript and XML. apache mysql问题 1064问题 小弟学做的表单提交,做了空值判断,但是提交时还会出现空值 权限设置的问题(急) 怎样将一个表中的数据一一对应的导入另一个表中 菜鸟发问:asp开发的系统能和php开发的系统整合吗? 关于mysql数值型数据定义问题。最后的40份,全给拉。 大家好,问个小事儿? 求助:session时效问题 高分请教linux下php安装和配置 抓取数据放入数据库。。。谢谢!!! 关于smarty参数的问题 为什么本地调试是好的,上传到服务器就不行了?
CREATE DATABASE test;
CREATE TABLE `zipcodes` (
`zipcode` varchar(6) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`state` varchar(20) NOT NULL default '',
PRIMARY KEY (`zipcode`,`city`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;INSERT INTO `zipcodes` (`zipcode`, `city`, `state`) VALUES ('510160', 'zsb', 'gz'),
('510420', 'gw', 'GZ');1.html代码如下:
HTML
<script>
function createRequestObject() {
var ro;
var browser = navigator.appName;
if(browser == "Microsoft Internet Explorer"){
ro = new ActiveXObject("Microsoft.XMLHTTP");
}else{
ro = new XMLHttpRequest();
}
return ro;
}var http = createRequestObject();function sndReq(zip) {
http.open('get', 'zipcode.php?zip='+zip);
http.onreadystatechange = handleResponse;
http.send(null);
}function handleResponse() {
if(http.readyState == 4){
var response = http.responseText;
var update = new Array(); if(response.indexOf('|' != -1)) {
update = response.split('|');
document.getElementById("city").value = update[0];
document.getElementById("state").value = update[1];
}
}
}
</script>
<h3>Enter A United States Zipcode, Then Tab</h3>
<table align="center">
<tr>
<td>Enter Zipcode:</td>
<td><input type="text" id="zipcode" name="zipcode" onBlur="sndReq(this.value);"/></td>
</tr>
<tr>
<td>City:</td>
<td><input type="text" id="city" name="city"/></td>
</tr>
<tr>
<td>State:</td>
<td><input type="text" id="state" name="state"/></td>
</tr>
</table>zipcode.php代码如下:
<?php
$dbuser = 'root';
$dbpass = '123456';$cn = mysql_connect("localhost", $dbuser, $dbpass);
$db = mysql_select_db("test");$sql = "select city, state from zipcodes where zipcode = " . $_REQUEST['zip'];
$rs = mysql_query($sql);
$row = mysql_fetch_array($rs);echo $row['city'] . "|" . $row['state'];mysql_close($cn);
?>试试添入510160或者510420,就自动从数据库中读出相应的city 和state并添入
ajax:Asynchronous JavaScript and XML.