php登录注册
turn ava -c ota width href sql center
在度娘帮助下终于完成php登录注册,在这个过程中学习到了一些php 中的MySQL()函数。
登录页面html:
登录 html{font-size:12px;} fieldset{width:300px; margin: 0 auto;} legend{font-weight:bold; font-size:14px;} label{float:left; width:70px; margin-left:10px;} .left{margin-left:80px;} .input{width:150px;} span{color: #666666;}
立即注册 function InputCheck(LoginForm) { if (LoginForm.username.value == "") { alert("请输入用户名!"); LoginForm.username.focus(); return (false); } if (LoginForm.password.value == "") { alert("请输入密码!"); LoginForm.password.focus(); return (false); } } 登录页面php:
登录
//包含数据库连接文件 include(‘conn.php‘); session_start();
//登录 if(!isset($_POST[‘submit‘])){ exit(‘非法访问!‘); } $username = htmlspecialchars($_POST[‘username‘]); $password = $_POST[‘password‘];
//包含数据库连接文件 include(‘conn.php‘); //检测用户名及密码是否正确; $check_query = mysql_query("select username,password from user where username=‘$username‘ limit 1"); $num = mysql_num_rows($check_query); if($num){ $row = mysql_fetch_array($check_query); if($username==$row[0] && $password==$row[1]){ echo $username,‘ 欢迎你!进入 用户中心‘; exit; }else{ exit(‘登录失败!账号或密码错误,点击此处 返回 重试‘); } }?>
注册页面:
注册 html{font-size:12px;} fieldset{width:300px; margin: 0 auto;} legend{font-weight:bold; font-size:14px;} label{float:left; width:70px; margin-left:10px;} .left{margin-left:80px;} .input{width:150px;} span{color: #666666;}
密码长度6-18位
注册页面php:
注册 //包含数据库连接文件 include(‘conn.php‘); if(!isset($_POST[‘submit‘])){ exit(‘非法访问!‘); } $username = $_POST[‘username‘]; $password = $_POST[‘password‘]; $repassword = $_POST[‘repassword‘]; $phone = $_POST[‘phone‘]; //注册信息判断 if(strlen($password) < 6){ exit(‘错误:密码长度不符合规定。返回‘); } if($username == "" || $password == "" || $repassword == "" || $phone ==""){ echo ""; }else{ if($password == $repassword){ //检测用户名是否已经存在 $check_query = mysql_query("select id from user where username=‘$username‘ limit 1"); if(mysql_fetch_array($check_query)){ //echo "mysql_fetch_array($check_query)"; echo ‘错误:姓名 ‘,$username,‘ 已存在。返回/登录‘; exit; } //写入数据 $password = $password; $regdate = time(); $sql = "INSERT INTO user(username,phone,password)VALUES(‘$username‘,‘$phone‘,‘$password‘)"; if(mysql_query($sql,$conn)){ exit(‘用户注册成功!点击此处 登录‘); } else { echo ‘抱歉!添加数据失败:‘,mysql_error(),‘‘; echo ‘点击此处 返回 重试‘; } }else{ echo ""; } } ?>
money.php
账单 table{width:500px;marigin: 0 auto} table tr{height: 30px;} table tr td{text-align: center;} table tr:nth-child(2n+1){background: #F4F4F4; } //包含数据库连接文件 include(‘conn.php‘); ?>
总账:
$p = "select*from total"; $money = mysql_query($p); $q = "select*from Bill";//设置查询指令 $result = mysql_query($q);//执行查询 while($s = mysql_fetch_assoc($money)){ while($row = mysql_fetch_assoc($result)){ $s["qian"] = $s["qian"] + $row["in_outcome"]; } echo "".$s["qian"].""; } ?> 编号 进出账目 来源/接收 $q = "select*from Bill";//设置查询指令 $result = mysql_query($q);//执行查询 while($row = mysql_fetch_assoc($result))//将result结果集中查询结果 { //echo "$row[in_outcome]"; echo"".$row["id"]."".$row["in_outcome"]."".$row["username"].""; }; ?> php登录注册
eth turn ava -c ota width href sql center
来源: http://www.bubuko.com/infodetail-2111383.html