PHP 连接mysql的问题 新手!!!
<br /> <?php<br /> include('../config/config_db.php');<br /> include('../class/db/class_db.php');<br /> <br /> <br /> <br /> $username= $_POST["username"];<br /> $password=$_POST["password"];<br /> <br /> echo "username:".$username."--"."password:".$password."</br>";<br /> echo "db_host:".$db_host."--"."db_name:".$db_name."--"."db_pass:".$db_pass."--"."db_dabase:".$db_dabase;<br /> $mysqldb==new MySQLDB($db_host,$db_name,$db_pass,$db_dabase);<br /> <br /> <br /> <br /> $sql = "select * from loginuser where username='".$username."'";<br /> $result = $mysqldb->Query($sql);//查询<br /> $rs = $mysqldb->getRows($result);//获得记录集<br /> $num = $mysqldb->getRowsNum($result);//获得记录数<br /> <br /> if($num>0){<br /> //如果是 登陆<br /> session_start();<br /> $_SESSION['username']=$username;<br /> $_SESSION['password']=$password;<br /> echo "<script>location.href='index.php';</script>";<br /> }else{<br /> echo "登录错误";<br /> }<br /> ?><br />
<br /> <?php<br /> <br /> $db_host = 'localhost';<br /> $db_name = 'root';<br /> $db_pass = '123456';<br /> $db_dabase = 'test';<br /> $db_ut = 'utf8';<br /> <br /> ?><br />
<br /> <?php<br /> Class MySQLDB<br /> {<br /> var $host;<br /> var $user;<br /> var $passwd;<br /> var $database;<br /> var $conn;<br /> <br /> //利用构造函数实现变量初始化<br /> //同时连接数据库操作<br /> function MySQLDB($host,$user,$password,$database)<br /> {<br /> $this->host = $host;<br /> $this->user = $user;<br /> $this->passwd = $password;<br /> $this->database = $database;<br /> $this->conn=mysql_connect($this->host, $this->user,$this->passwd) or die("Could not connect to $this->host");<br /> mysql_select_db($this->database,$this->conn) or die("Could not switch to database $this->database");<br /> mysql_query("set names 'gbk'");<br /> }<br /> <br /> //该函数用来关闭数据库连接<br /> function Close()<br /> {<br /> MySQL_close($this->conn);<br /> }<br /> <br /> //该函数实现数据库查询操作<br /> function Query($queryStr)<br /> {<br /> $res =Mysql_query($queryStr, $this->conn) or die("Could not query database");<br /> return $res;<br /> }<br /> <br /> <br /> } <br />