当前位置：Gxlcms > PHP教程 > php代码100分,该如何解决

php代码100分,该如何解决

时间：2021-07-01 10:21:17 帮助过：24人阅读

php 代码 100分
求一个用php做的注册和登录页面能提交到mysql的，端口是3307，数据库名是bbs，
表名是user-info，注册的是register.php 登录的是login.php
求代码，用来参考学习
------解决思路----------------------
  1. <br><!--?php<br /--><br>if(!in_array($_POST['type'],array('login','reg'))){<br>
  2. echo -1;<br>
  3. exit();<br>}<br>if($_POST['type']=='login'){<br>
  4. $username=addslashes($_POST['username']);<br>
  5. $pwd=$_POST['pwd'];<br>
  6. $sql="SELECT * FROM test WHERE name='$username'";//test改为user-info<br>
  7. $db=new DB();<br>
  8. if($user_exists=$db->execute_dql($sql)){<br>
  9. if(md5($pwd)==$user_exists[0]['pwd']){<br>
  10. session_start();<br>
  11. $_SESSION['username']=$user_exists[0]['name'];<br>
  12. echo 1;<br>
  13. exit();<br>
  14. }<br>
  15. }else{<br>
  16. echo -1;<br>
  17. exit();<br>
  18. }<br>}elseif($_POST['type']=='reg'){<br>
  19. $username=addslashes($_POST['username']);<br>
  20. $pwd=md5($_POST['pwd']);<br>
  21. $sql_exists="SELECT * FROM test WHERE name='$username'";//test改为user-info<br>
  22. $db=new DB();<br>
  23. if($db->execute_dql($sql_exists)){//已存在该用户<br>
  24. echo -2;<br>
  25. exit();<br>
  26. }<br>
  27. $sql="INSERT INTO test(name,pwd) VALUES('$username','$pwd')";//test改为user-info<br>
  28. if($code=$db->execute_dml($sql)){<br>
  29. session_start();<br>
  30. $_SESSION['username']=stripslashes($username);<br>
  31. echo 1;<br>
  32. exit();<br>
  33. }else{<br>
  34. echo -1;<br>
  35. exit();<br>
  36. }<br>}<br><br>class DB{<br>
  37. private $conn;<br>
  38. private $host="localhost";//localhost:3307<br>
  39. private $user="root";<br>
  40. private $password="123456";<br>
  41. private $db="test";//bbs<br>
  42. private $res;<br><br>
  43. function __construct(){<br>
  44. $this->conn=mysql_connect($this->host,$this->user,$this->password);<br>
  45. if(!$this->conn){<br>
  46. die("连接数据库失败".mysql_error());<br>
  47. }<br>
  48. mysql_select_db($this->db,$this->conn);<br>
  49. mysql_query("SET NAMES utf8");<br>
  50. }<br>
  51. function execute_dql($sql){<br>
  52. $this->res=mysql_query($sql,$this->conn) or die(mysql_error());<br>
  53. $r=array();<br>
  54. while($row=mysql_fetch_assoc($this->res)){<br>
  55. $r[]=$row;<br>
  56. }<br>
  57. return $r;<br>
  58. }<br>
  59. function execute_dml($sql){<br>
  60. $b=mysql_query($sql,$this->conn) or die(mysql_error());<br>
  61. if(!$b){<br>
  62. return 0;//失败<br>
  63. }else{<br>
  64. if(mysql_affected_rows($this->conn)>0){<br>
  65. return 1;//成功<br>
  66. }else{<br>
  67. return 2;//没有影响到行数<br>
  68. }<br>
  69. }<br>
  70. }<br>
  71. function __destruct(){<br>
  72. if(!empty($this->res)){<br>
  73. mysql_free_result($this->res);<br>
  74. }<br>
  75. mysql_close($this->conn);<br>
  76. }<br>}<br><br>?><br>


exe.php
  1. <br><!--?php<br /--><br>if(!in_array($_POST['type'],array('login','reg'))){<br>
  2. echo -1;<br>
  3. exit();<br>}<br>if($_POST['type']=='login'){<br>
  4. $username=addslashes($_POST['username']);<br>
  5. $pwd=$_POST['pwd'];<br>
  6. $sql="SELECT * FROM test WHERE name='$username'";//test改为user-info<br>
  7. $db=new DB();<br>
  8. if($user_exists=$db->execute_dql($sql)){<br>
  9. if(md5($pwd)==$user_exists[0]['pwd']){<br>
  10. session_start();<br>
  11. $_SESSION['username']=$user_exists[0]['name'];<br>
  12. echo 1;<br>
  13. exit();<br>
  14. }<br>
  15. }else{<br>
  16. echo -1;<br>
  17. exit();<br>
  18. }<br>}elseif($_POST['type']=='reg'){<br>
  19. $username=addslashes($_POST['username']);<br>
  20. $pwd=md5($_POST['pwd']);<br>
  21. $sql_exists="SELECT * FROM test WHERE name='$username'";//test改为user-info<br>
  22. $db=new DB();<br>
  23. if($db->execute_dql($sql_exists)){//已存在该用户<br>
  24. echo -2;<br>
  25. exit();<br>
  26. }<br>
  27. $sql="INSERT INTO test(name,pwd) VALUES('$username','$pwd')";//test改为user-info<br>
  28. if($code=$db->execute_dml($sql)){<br>
  29. session_start();<br>
  30. $_SESSION['username']=stripslashes($username);<br>
  31. echo 1;<br>
  32. exit();<br>
  33. }else{<br>
  34. echo -1;<br>
  35. exit();<br>
  36. }<br>}<br><br>class DB{<br>
  37. private $conn;<br>
  38. private $host="localhost";//localhost:3307<br>
  39. private $user="root";<br>
  40. private $password="123456";<br>
  41. private $db="test";//bbs<br>
  42. private $res;<br><br>
  43. function __construct(){<br>
  44. $this->conn=mysql_connect($this->host,$this->user,$this->password);<br>
  45. if(!$this->conn){<br>
  46. die("连接数据库失败".mysql_error());<br>
  47. }<br>
  48. mysql_select_db($this->db,$this->conn);<br>
  49. mysql_query("SET NAMES utf8");<br>
  50. }<br>
  51. function execute_dql($sql){<br>
  52. $this->res=mysql_query($sql,$this->conn) or die(mysql_error());<br>
  53. $r=array();<br>
  54. while($row=mysql_fetch_assoc($this->res)){<br>
  55. $r[]=$row;<br>
  56. }<br>
  57. return $r;<br>
  58. }<br>
  59. function execute_dml($sql){<br>
  60. $b=mysql_query($sql,$this->conn) or die(mysql_error());<br>
  61. if(!$b){<br>
  62. return 0;//失败<br>
  63. }else{<br>
  64. if(mysql_affected_rows($this->conn)>0){<br>
  65. return 1;//成功<br>
  66. }else{<br>
  67. return 2;//没有影响到行数<br>
  68. }<br>
  69. }<br>
  70. }<br>
  71. function __destruct(){<br>
  72. if(!empty($this->res)){<br>
  73. mysql_free_result($this->res);<br>
  74. }<br>
  75. mysql_close($this->conn);<br>
  76. }<br>}<br><br>?><br>

------解决思路----------------------
多看看就有的，加油楼主

人气教程排行

本站所有资源全部来源于网络，若本站发布的内容侵害到您的隐私或者利益，请联系我们删除！