php 代码 100分,该如何解决

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_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 />

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