注册,登录.php

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;
    }
?>
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值