写了个连接mysql的类
dbConn.inc 放在lib下
<?php
class dbConn{ var $link;
function connect($dbhost, $dbuser, $dbpw, $dbname = ''){
if(!$this->link=mysql_connect('localhost','root','sa')){
die('Error:' . mysql_error());
}
if($dbname){
@mysql_select_db($dbname, $this->link);
}
}
function select_db($dbname) {
return mysql_select_db($dbname, $this->link);
}
function query($query_str) {
$result=mysql_query($query_str,$this->link);
return "create success";
}
function close() {
return mysql_close($this->link);
}
}
?>
然后在Validation文件中调用
<?php
include($_SERVER["DOCUMENT_ROOT"] .'/lib/dbConn.inc');$conn= new dbConn('localhost','root','sa');
$conn->select_db('test');
$FullName=$_POST['fullname'];
$UserName=$_POST['username'];
$Password=$_POST['password'];
$CPassword=$_POST['confirmpassword'];
$Email=$_POST['email'];$query_str= <<<EOQ2
Insert INTO member VALUES('$UserName','$Password','$FullName','$Email');
EOQ2;?>
就报了这个错,: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\Apache\htdocs\lib\dbConn.inc on line 17困惑,请高手解答路径是没问题的
dbConn.inc 放在lib下
<?php
class dbConn{ var $link;
function connect($dbhost, $dbuser, $dbpw, $dbname = ''){
if(!$this->link=mysql_connect('localhost','root','sa')){
die('Error:' . mysql_error());
}
if($dbname){
@mysql_select_db($dbname, $this->link);
}
}
function select_db($dbname) {
return mysql_select_db($dbname, $this->link);
}
function query($query_str) {
$result=mysql_query($query_str,$this->link);
return "create success";
}
function close() {
return mysql_close($this->link);
}
}
?>
然后在Validation文件中调用
<?php
include($_SERVER["DOCUMENT_ROOT"] .'/lib/dbConn.inc');$conn= new dbConn('localhost','root','sa');
$conn->select_db('test');
$FullName=$_POST['fullname'];
$UserName=$_POST['username'];
$Password=$_POST['password'];
$CPassword=$_POST['confirmpassword'];
$Email=$_POST['email'];$query_str= <<<EOQ2
Insert INTO member VALUES('$UserName','$Password','$FullName','$Email');
EOQ2;?>
就报了这个错,: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\Apache\htdocs\lib\dbConn.inc on line 17困惑,请高手解答路径是没问题的
echo $message=$conn->query($query_str);
mysql_query($query_str);mysql_close();
Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Apache\htdocs\dbConn.inc on line 17Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in D:\Apache\htdocs\dbConn.inc on line 17
function dbConn($dbhost, $dbuser, $dbpw, $dbname = ''){
mysql_connect($dbhost,$dbuser,$dbpw) or die('Error:' . mysql_error());
if($dbname){
mysql_select_db($dbname);
}
}
function select_db($dbname) {
mysql_select_db($dbname);
}
function query($query_str) {
$result=mysql_query($query_str);
return $result;
}
function close() {
return mysql_close();
}