【京东账户】——Mysql/PHP/Ajax爬坑之用户登录
一、引言
实现京东的账户项目,功能模块之一,用户登录。要用到的是Apach环境,Mysql、PHP以及Ajax。
二、依据功能创建库、表、记录
- 创建库:jd
- 创建表:登录表
- 添加三条记录
CREATE DATABASE jd CHARSET=UTF8;
USE jd;
CREATE TABLE t_login(
uid INT PRIMARY KEY AUTO_INCREMENT,
uname VARCHAR(32),
upwd VARCHAR(32)
);
INSERT INTO t_login VALUES
(10,'zhangsan','123456'),
(20,'lisi','123456'),
(30,'wangwu','123456');
三、创建php
①jd.sql ②init.php ③login_do.php
- 获取参数 uname/upwd
- 查询数据库
- 如果用户输入{uname/upwd}
- 返回值 -1 -2 -3 1 判断成功/失败
-
//login_do.php <?php header("Content-Type:text/plain;charset=utf-8"); @$uname = $_REQUEST['uname']or die("-1"); @$upwd = $_REQUEST['upwd']or die("-2"); require('init.php'); $sql = "SELECT*FROM t_login WHERE uname = '$uname' AND upwd = '$upwd'"; $result = mysqli_query($conn,$sql); $row = mysqli_fetch_assoc($result); if($row===NULL){ //满足所有条件,只有一个用户;不满足,一个都没有,所以,只抓取一条记录 echo "-3"; }else{ echo "1"; } ?>
//init.php <?php $conn = mysqli_connect("127.0.0.1","root","","jd",3306); mysqli_query($conn,"SET NAMES UTF8"); ?>
测试:地址栏输入 http://127.0.0.1/jd_store/data/login_do.php?uname=zhangsan&upwd=123456 返回 1