php实现mysql数据库操作类分享

代码如下:
<?php
/*
数据库操作类
*/
class Mysql{
 private $LocalHost = 'localhost';
 private $LoaclUser = 'root';
 private $LocalPass = '123456';
 private $LocalBase = 'jiangxibaiyi';
 private $LocalCode = 'UTF8';
 private $PreFix;
 private $Conn;
 private $Start     = 0;
 private $Error     = false; //数据库连接状态, false表示未连接或连接不正常
 public  $Err       = true;  //Sql执行结果

 private $Table;
 private $Field     = '*';
 private $Where     = '';
 private $Order     = '';

 private $PageSize  = 0; //分页显示->每页多少条，0为不分页显示
 private $PageCount = 1; //分页显示->总共有多少条
 private $PageNum   = 1; //分页显示->总共有多少页
 private $PageNo    = 1; //分页显示->当前第几页
 private $PageKey   = 'page'; //分页url参数键
 private $PageStart = 0; //分页显示->当前从第几条开始返回

 
 private $Select;
 private $Rest;

 private $Result    = false;//结果集

 public $FormArray = array();

 public $Instr_ID  = 0;
 private $j =  0;

 
 public function Parameter($Loca, $Root, $Pass, $Base, $Code, $PreFix = ''){
  $this->LoaclUser = $Root;
  $this->LocalBase = $Base;
  $this->LocalCode = $Code;
  $this->LocalHost = $Loca;
  $this->LocalPass = $Pass;
  $this->PreFix    = $PreFix;
  return $this;
 }
 private function Connection( $Sql ){
  !function_exists(mysqli_connect) ? die('查询失败，无法加载mysqli扩展') : null;
  $this->Conn = @new mysqli( $this->LocalHost, $this->LoaclUser, $this->LocalPass, $this->LocalBase);
  $this->Error = mysqli_connect_errno() == 0 ? true : false;
  !$this->Error ? die('数据库连接错误，请检查数据库连接参数') : null;
  $this->Conn->query('SET NAMES ' . $this->LocalCode);
  $this->Rest = $this->Conn->query($Sql);
  $this->Err  = mysqli_error($this->Conn);
  $this->Instr_ID = mysqli_insert_id($this->Conn);
  $this->Rest->free_result;
  $this->Conn->close;
  $this -> FormArray = '';
  return $this;
 }

 public function null(){
  $this->PageSize  = 0;
  //$this->PageCount = 1;
  $this->PageStart = 1;
  $this->Field     = ' * ';