<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<script src="jquery-1.11.2.min.js"></script>
</head> <body>
<h1>登录界面</h1>
<div>用户名：<input type="text" id="uid"/></div>
<div>密码：<input type="text" id="pwd"/></div>
<div><input type="button" id="btn" value="登录"/></div>
<br />
用户名：
<input type="text" id="uidz"/>
<div style="color:red" id="xs"></div>
</body> <script type="text/javascript">
$(document).ready(function(e) { $("#uidz").blur(function(){
var uid = $(this).val();
$.ajax({ url:"chuli.php",
data:{uid:uid},
dataType:"TEXT",
type:"POST",
success: function(data){
if(data=="1")
{
$("#xs").text("该用户名已经存在！");
}
else
{
$("#xs").text("");
} } }); }) $("#btn").click(function(){ var uid = $("#uid").val();
var pwd = $("#pwd").val(); $.ajax({ url:"chuli.php",
data:{uid:uid,pwd:pwd},
type:"POST",
dataType:"TEXT",
success: function(data){ if(data == "OK")
{
window.location = "index.php";
}
else
{
alert(data);
} } }); }) });
</script> </html>
使用Jquery必须在页面内引入一个Jquery包
<?php
include("mydbda.php");
/*$uid = $_POST["uid"];
$pwd = $_POST["pwd"];
//1.造连接对象
$db = new mysqli("localhost","root","123","mydb"); //2.判断是否连接成功
if(mysqli_connect_error())
{
echo "连接失败"; //退出整个程序
exit;
}
else
{
$sql = "select count(*) from login where UserName='".$uid."' and Password='".$pwd."'"; $result = $db->query($sql); $row = $result->fetch_row(); if($row[0]==0)
{
echo "用户名或密码错误";
}
else
{
echo "OK";
}
}*/ $uid = $_POST["uid"]; $db = new mydbda();
$sql = "select count(*) from login where UserName='".$uid."'"; $str = $db->Select($sql,"CX","mydb"); echo $str;
?>
<?php
class mydbda
{
var $host = "localhost";
var $username = "root";
var $password = "123";
var $database = "mydb"; /**
功能：执行SQL语句，返回结果
参数：$sql:要执行的SQL语句
$type：SQL语句的类型，CX代表查询，QT代表其他
$data:要操作的数据库
返回值：如果是查询，返回结果集
如果是其他语句，执行成功返回OK，失败返回NO
*/
function Select($sql,$type,$data)
{ //1.造连接对象
$db = new mysqli($this->host,$this->username,$this->password,$data); //2.判断是否连接成功
if(mysqli_connect_error())
{
echo "连接失败"; //退出整个程序
exit;
}
else
{
//4.执行SQL语句 $result = $db->query($sql); if($type == "CX")
{
$str = ""; while($row = $result->fetch_row())
{
for($i=0;$i<count($row);$i++)
{
$str=$str.$row[$i]."^";
}
$str = substr($str,0,strlen($str)-1);
$str = $str."|"; }
$str = substr($str,0,strlen($str)-1);
return $str;
}
else
{
if($result)
{
return "OK";
}
else
{
return "NO";
}
} }
} }
?>