php 代码 100分
求一个用php做的注册和登录页面能提交到mysql的，端口是3307，数据库名是bbs，
表名是user-info，注册的是register.php 登录的是login.php
求代码，用来参考学习
——解决思路———————-
<br /><?php<br /><br />if(!in_array($_POST['type'],array('login','reg'))){<br /> echo -1;<br /> exit();<br />}<br />if($_POST['type']=='login'){<br /> $username=addslashes($_POST['username']);<br /> $pwd=$_POST['pwd'];<br /> $sql="SELECT * FROM test WHERE name='$username'";//test改为user-info<br /> $db=new DB();<br /> if($user_exists=$db->execute_dql($sql)){<br /> if(md5($pwd)==$user_exists[0]['pwd']){<br /> session_start();<br /> $_SESSION['username']=$user_exists[0]['name'];<br /> echo 1;<br /> exit();<br /> }<br /> }else{<br /> echo -1;<br /> exit();<br /> }<br />}elseif($_POST['type']=='reg'){<br /> $username=addslashes($_POST['username']);<br /> $pwd=md5($_POST['pwd']);<br /> $sql_exists="SELECT * FROM test WHERE name='$username'";//test改为user-info<br /> $db=new DB();<br /> if($db->execute_dql($sql_exists)){//已存在该用户<br /> echo -2;<br /> exit();<br /> }<br /> $sql="INSERT INTO test(name,pwd) VALUES('$username','$pwd')";//test改为user-info<br /> if($code=$db->execute_dml($sql)){<br /> session_start();<br /> $_SESSION['username']=stripslashes($username);<br /> echo 1;<br /> exit();<br /> }else{<br /> echo -1;<br /> exit();<br /> }<br />}<br /><br />class DB{<br /> private $conn;<br /> private $host="localhost";//localhost:3307<br /> private $user="root";<br /> private $password="123456";<br /> private $db="test";//bbs<br /> private $res;<br /><br /> function __construct(){<br /> $this->conn=mysql_connect($this->host,$this->user,$this->password);<br /> if(!$this->conn){<br /> die("连接数据库失败".mysql_error());<br /> }<br /> mysql_select_db($this->db,$this->conn);<br /> mysql_query("SET NAMES utf8");<br /> }<br /> function execute_dql($sql){<br /> $this->res=mysql_query($sql,$this->conn) or die(mysql_error());<br /> $r=array();<br /> while($row=mysql_fetch_assoc($this->res)){<br /> $r[]=$row;<br /> }<br /> return $r;<br /> }<br /> function execute_dml($sql){<br /> $b=mysql_query($sql,$this->conn) or die(mysql_error());<br /> if(!$b){<br /> return 0;//失败<br /> }else{<br /> if(mysql_affected_rows($this->conn)>0){<br /> return 1;//成功<br /> }else{<br /> return 2;//没有影响到行数<br /> }<br /> }<br /> }<br /> function __destruct(){<br /> if(!empty($this->res)){<br /> mysql_free_result($this->res);<br /> }<br /> mysql_close($this->conn);<br /> }<br />}<br /><br />?><br />
exe.php
<br /><?php<br /><br />if(!in_array($_POST['type'],array('login','reg'))){<br /> echo -1;<br /> exit();<br />}<br />if($_POST['type']=='login'){<br /> $username=addslashes($_POST['username']);<br /> $pwd=$_POST['pwd'];<br /> $sql="SELECT * FROM test WHERE name='$username'";//test改为user-info<br /> $db=new DB();<br /> if($user_exists=$db->execute_dql($sql)){<br /> if(md5($pwd)==$user_exists[0]['pwd']){<br /> session_star<strong>2本文来源gaodaima#com搞(代@码$网6</strong><pre>搞gaodaima代码
t();
$_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);
}
}
?>
——解决思路———————-
多看看就有的，加油楼主
转载请注明原文链接：php 代码 100分,该如何解决
