写的一个简简单单的php数据库调用类和调用例子.

来源：互联网发布：mysql 链接服务器编辑：程序博客网时间：2024/06/05 02:20
<?phpclass C_MySQL{var $link_id;  var $result;public function __construct() {$test=true;if($test){$host="127.0.0.1";$name="root";$pass="root";$db="wxads";$code="utf-8";}else{$host="114.215.110.13";$name="root";$pass="XXXXXX";$db="wxtest";}define('CLIENT_MULTI_RESULTS', 131072);$conn = mysql_connect ($host,$name,$pass,1,CLIENT_MULTI_RESULTS) or die ( "连接失败" );  mysql_select_db ($db, $conn );mysql_query ( "SET NAMES '".$code."'", $conn);  $this->link_id = $conn; }  function __destruct (){mysql_close($this->link_id);}private function fetcharray() {  $data = array ();  while ( $row = mysql_fetch_array ( $this->result ) ){  array_push ( $data, $row );  }mysql_free_result ( $this->result );  return $data;  }  public function EXE_select($sql) { $this->result = mysql_query ( $sql, $this->link_id ); if($this->result)return $this->fetcharray();elsereturn mysql_error();}public function EXE_delete($sql) {return $this->EXE_update($sql);}public function EXE_update($sql) { $tmp=mysql_query ( $sql, $this->link_id );if($tmp)return mysql_affected_rows($this->link_id);elsereturn mysql_error();}public function EXE_insert($sql) { $tmp=mysql_query ( $sql, $this->link_id );if($tmp)return mysql_insert_id($this->link_id);elsereturn mysql_error();}   } function D($sql){$db=new C_MySQL();switch(strtolower(substr($sql,0,6))){case 'select':return $res=$db->EXE_select($sql);break;case 'delete':return $res=$db->EXE_delete($sql);break;case 'update':return $res=$db->EXE_update($sql);break;case 'insert':return $res=$db->EXE_insert($sql);break;}}$sql="delete from  `user` where WX_ID='XXXXXXXXXXXXXX'";$res=D($sql);echo ($res);?>
0 0