login.html
<!doctype html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport"
content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>Document</title>
</head>
<body>
<form action="submit.php" method="post">
username:<input type="text" name="username">
password:<input type="text" name="password">
tel: <input type="text" name="tel">
<input type="submit" value="登录" name="type">
<input type="submit" value="注册" name="type">
</form>
</body>
</html>
submit.php
<?php
/**
* Created by PhpStorm.
* User: dllo
* Date: 16/8/11
* Time: 上午10:11
*/
// php文件外部引入
//include_once
require_once "initsql.php";
header("Content-type:text/html;charset=utf-8");
$type = $_POST["type"];
$username= $_POST["username"];
$password = $_POST["password"];
$tel = $_POST["tel"];
switch ($type){
case "登录":
$sql = "SELECT * FROM user WHERE username = '{$username}' AND password = '{$password}'";
$result = mysql_query($sql);
if ($result){
// $row = mysql_fetch_assoc($result);
// print_r($row);
// if ($row["id"] > 0){
// echo "登陆成功";
// }
// 查询结果的个数
if (mysql_num_rows($result) > 0){
echo "登陆成功";
} else{
echo "登陆失败";
}
}else{
echo "用户名或密码不正确!";
}
break;
case "注册":
$sql = "SELECT * FROM user WHERE username = '{$username}'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0){
echo "用户名已存在,请重新注册";
}else{
$sql = "INSERT INTO user (id,username,password,tel) VALUES (NULL,'{$username}','{$password}','{$tel}')";
mysql_query($sql);
if (mysql_insert_id() > 0){
echo "注册成功";
}else{
echo "注册失败";
}
}
break;
}
?>