Workbar重制计划-D1-注册

今天算是重制计划正式开始的第一天，发现自己马马虎虎做过一遍之后，哪怕是换框架，换后端，换数据库，也是比较容易上手的。有问题百度就行了，看视频的效率还是有点慢，尤其是经常找不到对应源码的时候。

进度简介

1. 简单搭建登陆&注册的前段页面
2. 完成注册页面的后端php代码

注意点

• php的变量要始终带着$，从C#过来不太习惯

前端代码

<div class="header">
  <div class="am-g">
    <h1>Workbar重制版</h1>
    <p>XXXXXXXXXXXXXXXXXXXXXXX<br/>代码编辑，代码生成，界面设计，调试，编译</p>
  </div>
  <hr />
</div>
<div class="am-g">
  <div class="am-u-lg-6 am-u-md-8 am-u-sm-centered">
    <h3>注册</h3>
    <hr>
    <form method="post" class="am-form" action="test.php">
      <label for="name">用户名:</label>
      <input type="text" name="name" id="name" value="">
      <br>
      <label for="email">邮箱:</label>
      <input type="email" name="email" id="email" value="">
      <br>
      <label for="password">密码:</label>
      <input type="password" name="password" id="password" value="">
      <br>
      <label for="password_confirm">确认密码:</label>
      <input type="password" name="password_confirm" id="password_confirm" value="">
      <br>
      <br >
      <div class="am-cf">
        <input type="submit" name="" value="注 册" class="am-btn am-btn-primary am-btn-sm am-fl">
        <input type="submit" name="" value="返 回" class="am-btn am-btn-default am-btn-sm am-fr">
      </div>
    </form>
    <hr>
    <p>© 2017 Workbar development group</p>
  </div>
</div>

后端代码

<?php
/**
 * Created by PhpStorm.
 * User: Douglas_Young
 * Date: 2017/2/5
 * Time: 21:43
 */
    $name=$_POST["name"];
    $email=$_POST["email"];
    $password=$_POST["password"];
    $psw_confirm = $_POST["password_confirm"];
    if($name == "" ||$email == "" || $password == "" || $psw_confirm == "")
    {
        echo "<script>alert('请确认信息完整性！'); history.go(-1);</script>";
    }
    else
    {
        if($password!=$psw_confirm){
            echo "<script>alert('两次密码输入不一致！'); history.go(-1);</script>";
        }
        else{
            mysql_connect("localhost","root","***");   //连接数据库
            mysql_select_db("demodb");  //选择数据库
            $sql = "select email from _user where email = '$_POST[email]'"; //SQL语句
            $result = mysql_query($sql);    //执行SQL语句
            $num = mysql_num_rows($result); //统计执行结果影响的行数
            if($num)    //如果已经存在该用户
            {
                echo "<script>alert('用户名已存在'); history.go(-1);</script>";
            }
            else    //不存在当前注册用户名称
            {
                $sql_insert = "insert into _user (name,password,email) values('$_POST[name]','$_POST[password]','$_POST[email]')";
                $res_insert = mysql_query($sql_insert);
                //$num_insert = mysql_num_rows($res_insert);
                if($res_insert)
                {
                    echo "<script>alert('注册成功！'); history.go(-1);</script>";
                }
                else
                {
                    echo "<script>alert('系统繁忙，请稍候！'); history.go(-1);</script>";
                }
            }
        }

    }
?>

吐槽一下，phpstorm真的是个轻量化开发工具？打开速度比VS2013还慢