PHP连接MYSQL数据库的类

代码 
 1 <?php    
 2     class Mysql{
 3         private $host;
 4         private $name;
 5         private $pass;
 6         private $con;
 7         public function __construct($host,$name,$pass,$con){
 8             $this->host = $host;
 9             $this->name = $name;
10             $this->pass = $pass;
11             $this->con = $con;
12         }
13         public function Connect(){
14             if($this->con=="pcon"){
15                 $this->con = mysql_pconnect($this->host,$this->name,$this->pass); //永久连接    
16              }else{
17                 $this->con = mysql_connect($this->host,$this->name,$this->pass);//即时连接
18             }
19         }
20         public function CreateDB(){
21                 if(mysql_query("create database newdb",$this->con)){ //创建数据库
22                     echo "数据库创建成功";    
23                 }else{
24                     echo "数据库创建失败";
25                 }
26         }
27         public function __destruct(){//析构函数
28             mysql_close($this->con); //关闭连接    
29         }
30     }
31     $db = new Mysql("127.1","root","admin","con"); //调用构造，传入参数
32     $db->Connect();
33     $db->CreateDB();
34     $db->CreateTB();
35 ?>

 

posted on 2010-12-28 16:11  funkys  阅读(169)  评论(0)    收藏  举报