jquery做得ajax异步登录

最新推荐文章于 2023-06-21 11:50:57 发布

wusuoweijv

最新推荐文章于 2023-06-21 11:50:57 发布

阅读量426

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/wangkeweinet/article/details/52942350

版权

php 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1.数据库

# Host: localhost (Version: 5.5.47)
# Date: 2016-10-27 08:52:02
# Generator: MySQL-Front 5.3 (Build 4.234)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "ct_user"
#

DROP TABLE IF EXISTS `ct_user`;
CREATE TABLE `ct_user` (
`username` varchar(10) DEFAULT NULL,
`password` varchar(10) DEFAULT NULL,
`id` int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

#
# Data for table "ct_user"
#

/*!40000 ALTER TABLE `ct_user` DISABLE KEYS */;
INSERT INTO `ct_user` VALUES ('lisi','1',1),('1','1',2);
/*!40000 ALTER TABLE `ct_user` ENABLE KEYS */;

2.登陆页 logo.html

<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<script type="text/javascript" src="../xzq/jquery-2.0.0.min.js"></script>
<script type="text/javascript">

$(function(){
$("#send").click(function(){

$.ajax({
url: "ab.php",
type:"post",
data:{username:$("#username").val(),password:$("#password").val()},
dataType:"text",
success: function(data){
if(data="success")
{
location.href="index.php";

}
else
{
location.href="logo.html";
}
}});

});
});
</script>
</head>
<body>
<div id="result">一会看显示结果</div>
<p><span>姓名：</span><input type="text" name="username" id="username"/></p>
<p><span>密码：</span><input type="text" name="password" id="password" /></p>
<input type="button" name="send" id="send" value="提交" />

</body>
</html>

2.数据库配置文件 config

<?php

define(DBHost, "localhost"); //自定义常量DBhost（服务器名）
define(DBUser, "root"); //自定义常量DBUser（登录服务器的用户名）
define(DBPassword, "root");

$connect=mysql_connect(DBHost,DBUser,DBPassword) or die("无法连接数据库服务器！");//连接服务器
mysql_select_db(test,$connect);
//mysql_query(" set names 'gb2312'");

?>

3.ab.php 数据处理页面

<?php
header("Content-type:text/html;charset=utf-8");
$username = $_POST['username'];
//

//
$password = $_POST['password'];

require("config.php");

$sql1="select * from ct_user where username='$username' and password='$password'";
$result= mysql_query($sql1,$connect);
$num_rows = mysql_num_rows($result);
if($num_rows>0)
{
echo "success";
}
else
{
echo "eeeee";
}

?>

4.登录成功后提示的页面

<!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=gb2312" />
<title>无标题文档</title>
</head>

<body>
恭喜你成功登录
</body>
</html>