将下列代码单独存到dbconn.php里,作为php连接mysql数据库用
|
看如下语句: private $Address; //数据库主机名 private $UserName; //用户名 private $PassWord; //密码 private $DatabaseName; //数据库名 private $conn; //数据库链接标识 private $db_selected; //数据库选择标识 private $result; //数据库查询返回结构集 private $fields; private $rResult; function connlink($Address,$UserName,$PassWord,$DatabaseName){ $this->Address=$Address; $this->UserName=$UserName; $this->PassWord=$PassWord; $this->DatabaseName=$DatabaseName; $this->conn=mysql_connect($this->Address,$this->UserName,$this->PassWord); if(!$this->conn) { die('数据库连接出现错误: '.mysql_error()); } $this->db_selected=mysql_select_db($this->DatabaseName,$this->conn); } } $Address="localhost"; //数据库主机名 $UserName="root"; //用户名 $PassWord="root"; //密码 $DatabaseName="yourdata"; //数据库名 $Conn=mysql_connect($Address,$UserName,$PassWord); if(!$Conn){ die('数据库连接出现错误: '.mysql_error()); } mysql_query("set names UTF8"); //解决从数据库中读取中文乱码问题,如果是gb2312可以不设置 $db_selected=mysql_select_db($DatabaseName,$Conn); $conn=new connlink($Address,$UserName,$PassWord,$DatabaseName);
|
原载: No.1网络工作室 http://www.noonenet.cn/