一个普遍通用的PHP连接MYSQL数据库类

一个普遍通用的PHP连接MYSQL数据库类db_host=$db_host;$this->db_user=$db_user;$this->db_pwd=$db_pwd;$this->db_database=$db_database;$this->conn=$conn;$this->coding=$coding;$this->connect();}/*数据库连接*/publicfunctionconnect(){if($this->conn=="pconn"){//永久链接$this->conn=mysql_pconnect($this->db_host,$this->db_user,$this->db_pwd);}else{//即使链接$this->conn=mysql_connect($this->db_host,$this->db_user,$this->db_pwd);}if(!mysql_select_db($this->db_database,$this->conn)){if($this->show_error){$this->show_error("数据库不可用：",$this->db_database);}}mysql_query("SETNAMES$this->coding");/*数据库执行语句，可执行查询添加修改删除等任何sql语句*/publicfunctionquery($sql){if($sql==""){$this->show_error("SQL语句错误：","SQL查询语句为空”);}$this->sql=$sql;$result=mysql_query($this->sql,$this->conn);if(!$result){//调试中使用，sql语句出错时会自动打印出来if($this->show_error){$this->show_error("错误SQL语句：",$this->sql);}}else{$this->result=$result;}return$this->result;}/*创建添加新的数据库*/publicfunctioncreate_database($database_name){$database=$database_name;$sqlDatabase='createdatabase'.$database;$this->query($sqlDatabase);}/*查询服务器所有数据库*///将系统数据库与用户数据库分开，更直观的显示？publicfunctionshow_databases(){$this->query("showdatabases");echo"现有数据库：".$amount=$this->db_num_rows($rs);echo"
";$i=1;while($row=$this->fetch_array($rs)){echo"$i$row[Database]";echo"
";$i++;}//以数组形式返回主机中所有数据库名}publicfunctiondatabases(){$rsPtr=mysql_list_dbs($this->conn);$i=0;$cnt=mysql_num_rows($rsPtr);while($i<$cnt){$rs[]=mysql_db_name($rsPtr,$i);$i++;}return$rs;}/*查询数据库下所有的表*/publicfunctionshow_tables($database_name){$this->query("showtables");echo"现有数据库：".$amount=$this->db_num_rows($rs);echo"
";$i=1;while($row=$this->fetch_array($rs)){$columnName="Tables_in_".$database_name;echo"$i$row[$columnName]";echo"
";$i++;}}/*mysql_fetch_row()array$row[0],$row[1],$row[2]mysql_fetch_array()array$row[0]或$row[id]mysql_fetch_assoc()array用$row->content字段大小写敏感mysql_fetch_object()object用$row[id],$row[content]字段大小写敏感*//*取得结果数据*/publicfunctionmysql_result_li(){returnmysql_result($str);}/*取得记录集，获取数组-索引和关联，使用$row['content']*/publicfunctionfetch_array(){returnmysql_fetch_array($this->result);//获取关联数组，使用$row['字段名']publicfunctionfetch_assoc(){}returnmysql_fetch_assoc($this->result);//获取数字索引数组，使用$row[0],$row[1],$row[2]publicfunctionfetch_row(){returnmysql_fetch_row($this->result);}//获取对象数组，使用$row->contentpublicfunctionfetch_Object(){returnmysql_fetch_object($this->result);}//简化查询selectpublicfunctionfindall($table){$this->query("SELECT*FROM$table");}//简化查询selectpublicfunctionselect($table,$columnName="*",$condition='',$debug=''){$condition=$condition?'Where'.$condition:NULL;if($debug){echo"SELECT$columnNameFROM$table$condition";}else{$this->query("SELECT$columnNameFROM$table$condition");}}//简化删除delpublicfunctiondelete($table,$condition,$url=''){if($this->query("DELETEFROM$tableWHERE$condition")){if(!empty($url))$this->Get_admin_msg($url,'删除成功！');}}//简化插入insertpublicfunctioninsert($table,$columnName,$value,$url=''){if($this->query("INSERTINTO$table($columnName)VALUES($value)")){if(!empty($url))show_msg($url,'添加成功！');}//简化修改updatepublicfunctionupdate($table,$mod_content,$condition,$url=''){if($this->query("UPDATE$tableSET$mod_contentWHERE$condition")){if(!empty($url))show_msg($url);}}/*取得上一步INSERT操作产生的ID*/publicfunctioninsert_id(){returnmysql_insert_id();}//指向确定的一条数据记录publicfunctiondb_data_seek($id){if($id>0){$id=$id-1;}if(!@mysql_data_seek($this->result,$id)){$this->show_error("SQL语句有误：","指定的数据为空");}return$this->result;}//根据select查询结果计算结果集条数publicfunctiondb_num_rows(){if($this->result==null){if($this->show_error){$this->show_error("SQL语句错误","暂时为空，没有任何内容！");}}else{returnmysql_num_rows($this->result);}}//根据insert,update,delete执行结果取得影响行数publicfunctiondb_affected_rows(){returnmysql_affected_rows();}//输出显示sql语句publicfunctionshow_error($message="",$sql=""){if(!$sql){echo"".$message."";echo"
";}else{echo"