php使用mysql类_php实现mysql（MySQL与MySQLi方式）操作类

这篇文章主要介绍了PHP实现的mysql操作类,结合实例形式分析了MySQL与MySQLi方式连接与操作MySQL数据库的常用方法封装与使用技巧,需要的朋友可以参考下

本文实例讲述了PHP实现的mysql操作类。分享给大家供大家参考，具体如下：

首先是mysql方式

class ConnectionMySQL{

//主机

private $host="localhost";

//数据库的username

private $name="root";

//数据库的password

private $pass="";

//数据库名称

private $table="phptest";

//编码形式

private $ut="utf-8";

//构造函数

function __construct(){

$this->ut=$ut;

$this->connect();

}

//数据库的链接

function connect(){

$link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());

mysql_select_db($this->table,$link) or die("没该数据库：".$this->table);

mysql_query("SET NAMES '$this->ut'");

}

function query($sql, $type = '') {

if(!($query = mysql_query($sql))) $this->show('Say:', $sql);

return $query;

}

function show($message = '', $sql = '') {

if(!$sql) echo $message;

else echo $message.'
'.$sql;

}

function affected_rows() {

return mysql_affected_rows();

}

function result($query, $row) {

return mysql_result($query, $row);

}

function num_rows($query) {

return @mysql_num_rows($query);

}

function num_fields($query) {

return mysql_num_fields($query);

}

function free_result($query) {

return mysql_free_result($query);

}

function insert_id() {

return mysql_insert_id();

}

function fetch_row($query) {

return mysql_fetch_row($query);

}

function version() {

return mysql_get_server_info();

}

function close() {

return mysql_close();

}

//向$table表中插入值

function fn_insert($table,$name,$value){

$this->query("insert into $table ($name) value ($value)");

}

//根据$id值删除表$table中的一条记录

function fn_delete($table,$id,$value){

$this->query("delete from $table where $id=$value");

echo "id为". $id." 的记录被成功删除!";

}

}

$db = new ConnectionMySQL();

$db->fn_insert('test','id,name,sex',"'','hongtenzone','M'");

$db->fn_delete('test', 'id', 1);

?>

mysqli的方式：

class Mysql{

private $LocalHost = 'localhost';

private $LoaclUser = '';

private $LocalPass = '';

private $LocalBase = '';

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 &#