Home >Backend Development >PHP Tutorial >php 代码 100分
php 代码 100分
- WBOYOriginal
- 2016-06-23 13:45:50931browse
求一个用php做的注册和登录页面能提交到mysql的，端口是3307，数据库名是bbs，
表名是user-info，注册的是register.php 登录的是login.php
求代码，用来参考学习
回复讨论(解决方案)
这种代码网上很多吧，随便一搜一大把。
其实php的登录注册，说白了就是php执行select跟insert SQL语句，然后做些相应的跳转。
我想要的是代码，能给我提供学习
骚年，百度/google一下就有了，何必在这等别人给你写呢
随便下载个开源的你就可以看到了。
不是这缺就是哪个对方不对的，改起来麻烦，我对php还不是很熟悉，我是做java 我们部门要求掌握php的一些基础知识，所以喽
<?phpif(!in_array($_POST['type'],array('login','reg'))){ echo -1; exit();}if($_POST['type']=='login'){ $username=addslashes($_POST['username']); $pwd=$_POST['pwd']; $sql="SELECT * FROM test WHERE name='$username'";//test改为user-info $db=new DB(); if($user_exists=$db->execute_dql($sql)){ if(md5($pwd)==$user_exists[0]['pwd']){ session_start(); $_SESSION['username']=$user_exists[0]['name']; echo 1; exit(); } }else{ echo -1; exit(); }}elseif($_POST['type']=='reg'){ $username=addslashes($_POST['username']); $pwd=md5($_POST['pwd']); $sql_exists="SELECT * FROM test WHERE name='$username'";//test改为user-info $db=new DB(); if($db->execute_dql($sql_exists)){//已存在该用户 echo -2; exit(); } $sql="INSERT INTO test(name,pwd) VALUES('$username','$pwd')";//test改为user-info if($code=$db->execute_dml($sql)){ session_start(); $_SESSION['username']=stripslashes($username); echo 1; exit(); }else{ echo -1; exit(); }}class DB{ private $conn; private $host="localhost";//localhost:3307 private $user="root"; private $password="123456"; private $db="test";//bbs private $res; function __construct(){ $this->conn=mysql_connect($this->host,$this->user,$this->password); if(!$this->conn){ die("连接数据库失败".mysql_error()); } mysql_select_db($this->db,$this->conn); mysql_query("SET NAMES utf8"); } function execute_dql($sql){ $this->res=mysql_query($sql,$this->conn) or die(mysql_error()); $r=array(); while($row=mysql_fetch_assoc($this->res)){ $r[]=$row; } return $r; } function execute_dml($sql){ $b=mysql_query($sql,$this->conn) or die(mysql_error()); if(!$b){ return 0;//失败 }else{ if(mysql_affected_rows($this->conn)>0){ return 1;//成功 }else{ return 2;//没有影响到行数 } } } function __destruct(){ if(!empty($this->res)){ mysql_free_result($this->res); } mysql_close($this->conn); }}?> exe.php
<?phpif(!in_array($_POST['type'],array('login','reg'))){ echo -1; exit();}if($_POST['type']=='login'){ $username=addslashes($_POST['username']); $pwd=$_POST['pwd']; $sql="SELECT * FROM test WHERE name='$username'";//test改为user-info $db=new DB(); if($user_exists=$db->execute_dql($sql)){ if(md5($pwd)==$user_exists[0]['pwd']){ session_start(); $_SESSION['username']=$user_exists[0]['name']; echo 1; exit(); } }else{ echo -1; exit(); }}elseif($_POST['type']=='reg'){ $username=addslashes($_POST['username']); $pwd=md5($_POST['pwd']); $sql_exists="SELECT * FROM test WHERE name='$username'";//test改为user-info $db=new DB(); if($db->execute_dql($sql_exists)){//已存在该用户 echo -2; exit(); } $sql="INSERT INTO test(name,pwd) VALUES('$username','$pwd')";//test改为user-info if($code=$db->execute_dml($sql)){ session_start(); $_SESSION['username']=stripslashes($username); echo 1; exit(); }else{ echo -1; exit(); }}class DB{ private $conn; private $host="localhost";//localhost:3307 private $user="root"; private $password="123456"; private $db="test";//bbs private $res; function __construct(){ $this->conn=mysql_connect($this->host,$this->user,$this->password); if(!$this->conn){ die("连接数据库失败".mysql_error()); } mysql_select_db($this->db,$this->conn); mysql_query("SET NAMES utf8"); } function execute_dql($sql){ $this->res=mysql_query($sql,$this->conn) or die(mysql_error()); $r=array(); while($row=mysql_fetch_assoc($this->res)){ $r[]=$row; } return $r; } function execute_dml($sql){ $b=mysql_query($sql,$this->conn) or die(mysql_error()); if(!$b){ return 0;//失败 }else{ if(mysql_affected_rows($this->conn)>0){ return 1;//成功 }else{ return 2;//没有影响到行数 } } } function __destruct(){ if(!empty($this->res)){ mysql_free_result($this->res); } mysql_close($this->conn); }}?> 上面发错了，前台页面，用了jquery
<html><head><meta http-equiv="content-type" content="text/html;charset=utf-8"><script language="javascript" type="text/javascript" src="jquery.min.js"></script><script type="text/javascript">$(function(){ $(':button[name=login]').click(function(){ var username=$('#l_username').val(); var pwd=$('#l_pwd').val(); if($.trim(username)=='' || $.trim(pwd)==''){ alert('用户名或密码不能为空'); return false; } $.ajax({ type:'post', url:'exe.php', data:{ username:username, pwd:pwd, type:'login' }, success:function(res){ if(res==1){ window.location.reload(); }else{ alert('用户名或密码错误'); } } }); }) $(':button[name=reg]').click(function(){ var username=$('#r_username').val(); var pwd=$('#r_pwd').val(); var pwd1=$('#r_pwd1').val(); if($.trim(username)=='' || $.trim(pwd)=='' || $.trim(pwd1)==''){ alert('用户名或密码不能为空'); return false; } if($.trim(pwd)!=$.trim(pwd1)){ alert('两次输入不匹配'); return false; } $.ajax({ type:'post', url:'exe.php', data:{ username:username, pwd:pwd, type:'reg' }, success:function(res){ if(res==1){ alert('注册成功'); window.location.reload(); }else if(res==-2){ alert('用户名已存在'); }else{ alert('注册失败'); } } }); })})</script></head><body><?phpsession_start();if(isset($_SESSION['username']) && !empty($_SESSION['username'])){ echo $_SESSION['username'].' 欢迎回来';}else{?><div> <h3>登录</h3> 用户名：<input type="text" id="l_username"><br/> 密 码：<input type="password" id="l_pwd"><br/> <input type="button" name="login" value="登录" ></div><hr><div> <h3>注册</h3> 用户名：<input type="text" id="r_username"><br/> 密 码：<input type="password" id="r_pwd"><br/> 确 认：<input type="password" id="r_pwd1"><br/> <input type="button" name="reg" value="注册"></div><?php }?></body></html> 楼主你赢啦。
网上有好多啊，搜一搜。
搜搜更健康。
多看看就有的，加油楼主
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：读取txt文件数据存入数据库的问题Next article：自定义表单的原理是什么