我想实现验证用户名是否存在问题!<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body><script type="text/javascript" src="ajax.js"></script>
<script type="text/javascript" src="ajax1.js"></script>
<form id="form1" name="form1" method="post" action="login.php" onsubmit="ok()">
<table width="794" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><div align="center">用户注册</div></td>
</tr>
<tr>
<td width="348"><div align="right">用户名:</div></td>
<td width="440"><label>
<input type="text" name="name" onblur="ok(form1)" />
<div id="name1" ><font color="#006633"">请输入用户名!</font></div>
</label></td>
</tr>
<tr>
<td><div align="right">密码:</div></td>
<td><label>
<input type="password" name="password" />
<input name="c_name" type="hidden" value="not" />
</label></td>
</tr>
<tr>
<td colspan="2"><label>
<div align="center">
<input type="submit" name="Submit" value="提交" />
<input type="reset" name="Submit2" value="重置" />
</div>
</label></td>
</tr>
</table>
</form></body>
</html>主页面代码·
function ok(from){
if(from.name.value=="")
{
name1.innerHTML="用户名不能为空";
}
else
{
var user=from.name.value;
var url="cheakname.php?user="+user;
var xmlhttp=false;
if(window.ActiveXObject)
{
xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
}
else if(window.XMLHttpReuqest)
{
xmlhttp= new XMLHttpRequest();
}
xmlhttp.open("GET",url,true);
xmlhttp.onreadystatechange=function(){
if(xmlhttp.readyState==4)
{
var msg=xmlhttp.responseText;
if(msg=="2")
{
name1.innerHTML="用户名被占用";
return false;
}
elseif(msg=="1")
{
name1.innerHTML="恭喜!可以注册!";
}
else
{
name1.innerHTML="未知错误!";
}
}
}
xmlhttp.send(null);
}
//Ajax验证页面代码 ·
<?php require_once('Connections/conn.php');
$conn=mysql_connect("localhost","root","root")or die("不能连接到数据库");
mysql_select_db("user",$conn)or die("can't connect to the servers");
$reback=0;
$sql="select * from user where name='".$_GET['user']."'";
$rst=mysql_query($sql)or die('execute error');
while ($row = mysql_fetch_assoc($rst))
{
print_r($rst);
}?>检测页面。 为什么编译无法通过呢。除了JS页面其他页面都没有报错··
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body><script type="text/javascript" src="ajax.js"></script>
<script type="text/javascript" src="ajax1.js"></script>
<form id="form1" name="form1" method="post" action="login.php" onsubmit="ok()">
<table width="794" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td colspan="2"><div align="center">用户注册</div></td>
</tr>
<tr>
<td width="348"><div align="right">用户名:</div></td>
<td width="440"><label>
<input type="text" name="name" onblur="ok(form1)" />
<div id="name1" ><font color="#006633"">请输入用户名!</font></div>
</label></td>
</tr>
<tr>
<td><div align="right">密码:</div></td>
<td><label>
<input type="password" name="password" />
<input name="c_name" type="hidden" value="not" />
</label></td>
</tr>
<tr>
<td colspan="2"><label>
<div align="center">
<input type="submit" name="Submit" value="提交" />
<input type="reset" name="Submit2" value="重置" />
</div>
</label></td>
</tr>
</table>
</form></body>
</html>主页面代码·
function ok(from){
if(from.name.value=="")
{
name1.innerHTML="用户名不能为空";
}
else
{
var user=from.name.value;
var url="cheakname.php?user="+user;
var xmlhttp=false;
if(window.ActiveXObject)
{
xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
}
else if(window.XMLHttpReuqest)
{
xmlhttp= new XMLHttpRequest();
}
xmlhttp.open("GET",url,true);
xmlhttp.onreadystatechange=function(){
if(xmlhttp.readyState==4)
{
var msg=xmlhttp.responseText;
if(msg=="2")
{
name1.innerHTML="用户名被占用";
return false;
}
elseif(msg=="1")
{
name1.innerHTML="恭喜!可以注册!";
}
else
{
name1.innerHTML="未知错误!";
}
}
}
xmlhttp.send(null);
}
//Ajax验证页面代码 ·
<?php require_once('Connections/conn.php');
$conn=mysql_connect("localhost","root","root")or die("不能连接到数据库");
mysql_select_db("user",$conn)or die("can't connect to the servers");
$reback=0;
$sql="select * from user where name='".$_GET['user']."'";
$rst=mysql_query($sql)or die('execute error');
while ($row = mysql_fetch_assoc($rst))
{
print_r($rst);
}?>检测页面。 为什么编译无法通过呢。除了JS页面其他页面都没有报错··
function ok(from){
if(from.name.value==""){
name1.innerHTML="用户名不能为空";
}
else
{
var user = from.name.value;
var url = "cheakname.php?user="+user;
var xmlhttp = false;
if(window.ActiveXObject){
xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
}else if(window.XMLHttpReuqest){
xmlhttp= new XMLHttpRequest();
}
xmlhttp.onreadystatechange = function(){
if(xmlhttp.readyState==4){
var msg=xmlhttp.responseText;
if(msg=="2"){
name1.innerHTML="用户名被占用";
return false;
}else if(msg=="1"){
name1.innerHTML="恭喜!可以注册!";
}else{
name1.innerHTML="未知错误!";
}
}
}
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
}
//require_once('Connections/conn.php');
$conn=mysql_connect("localhost","root","root")or die("不能连接到数据库");
mysql_select_db("user",$conn)or die("can't connect to the servers");
if($conn)
{
echo"数据库连接成功!";
}
$name=$_POST['name'];
$password=$_POST['password'];
$sql="insert into user(name,password) values('$name','$password')";
/*$rst=$conn->execute($sql);*/
$ret=mysql_query($sql,$conn);
if($ret==false)
{
echo"失败";
}
else
{
echo"成功";
}
?>
我注册完在MYsql中可以看到注册信息·
$conn=mysql_connect("localhost","root","root")or die("不能连接到数据库");
mysql_select_db("user",$conn)or die("can't connect to the servers");
$reback=0;
$sql="select * from user where name='".$_GET['user']."'";
$rst=mysql_query($sql)or die('execute error');
while ($row = mysql_fetch_assoc($rst))
{
print_r($row);
}?>