- 浏览: 213587 次
- 性别:
- 来自: 南宁
文章分类
最新评论
-
rogermmg:
把商品 分享到facebook,twitter 等等 连接代码集合 -
qq398705749:
qkjava 写道不知道涉及到放大的页面一共有几个就一个呀
局部图片放大功能 magiczoom -
qkjava:
不知道涉及到放大的页面一共有几个
局部图片放大功能 magiczoom -
qq398705749:
lz12366 写道mysql_connect,mysql_q ...
创建在网页的mysql表 -
lz12366:
mysql_connect,mysql_query都是jque ...
创建在网页的mysql表
【转】 用PHP封装的数据库操作方法(MYSQL、ACCESS)
/**
* MYSQL操作类
* function:Open() 打开一个MYSQL连接,无返回值;
* function:Close() 关闭一个已打开的MYSQL连接,无返回值;
* function:Sql($sql) 执行一条SQL语句,
@param $sql SQL语句,
return 执行语句后的记录集;
* function:Rows() 获得记录的总条数,
return 记录的总条数;
* function:Get($field,$row) 获取指定记录行和指定字段的值,
@param $field 字段名称,
@param $row 记录行数,
return 当前记录字段的值;
* function:Next_row() 移动到下一条记录,无返回值;
*/
class Mysql_odb
{
private $mysql_server;
private $mysql_db;
private $mysql_user;
private $mysql_pwd;
private $mysql_charset;
private $mysql_link;
private $mysql_rs;
private $mysql_rows;
/**
* MYSQL连接类构造函数
* @param $mysql_server_var - MYSQL服务器名
* @param $mysql_db_var - MYSQL数据库名
* @param $mysql_user_var - MYSQL用户名
* @param $mysql_pwd_var - MYSQL用户密码
* @param $mysql_charset_var - MYSQL连接编码方式
*/
function __construct()
{
global $mysql_server,$mysql_db,$mysql_user,$mysql_pwd,$mysql_charset;
$this->mysql_server = $mysql_server;
$this->mysql_db = $mysql_db;
$this->mysql_user = $mysql_user;
$this->mysql_pwd = $mysql_pwd;
$this->mysql_charset = $mysql_charset;
}
public function Open()
{
$this->mysql_link = mysql_connect($this->mysql_server,$this->mysql_user,$this->mysql_pwd) or die("mysql error:".mysql_error());
mysql_query("set names '".$this->mysql_charset."';",$this->mysql_link);
}
public function Close()
{
mysql_close($this->mysql_link);
}
public function Sql($sql)
{
mysql_select_db($this->mysql_db,$this->mysql_link);
$this->mysql_rs = mysql_query($sql,$this->mysql_link);
return $this->mysql_rs;
}
public function Rows()
{
$this->mysql_rows = 0;
if($this->mysql_rs != 1 && $this->mysql_rs != 0)
{
$this->mysql_rows = mysql_num_rows($this->mysql_rs);
}
return $this->mysql_rows;
}
public function Get($field,$row)
{
$result = mysql_result($this_>mysql_rs,$row,$field);
return $result;
}
public function Next_row()
{
return "NULL";
}
function __destruct()
{
unset($this->mysql_server);
unset($this->mysql_db);
unset($this->mysql_user);
unset($this->mysql_pwd);
unset($this->mysql_link);
unset($this->mysql_rs);
unset($this->mysql_charset);
unset($this->mysql_rows);
}
}
/**
* ACCESS操作类
* function:Open() 打开一个ACCESS连接,无返回值;
* function:Close() 关闭一个已打开的ACCESS连接,无返回值;
* function:Sql($sql) 执行一条SQL语句,
@param $sql SQL语句,
return 执行语句后的记录集;
* function:Rows() 获得记录的总条数,
return 记录的总条数;
* function:Get($field,$row) 获取指定记录行和指定字段的值,
@param $field 字段名称,
@param $row 记录行数,
return 当前记录字段的值;
* function:Next_row() 移动到下一条记录,无返回值;
*/
class Access_odb
{
private $access_db;
private $access_user;
private $access_pwd;
private $access_str;
private $access_charset;
private $access_link;
private $access_rs;
private $access_rows;
/**
* ACCESS连接类构造函数
* @param $access_db_var - ACCESS数据库名
* @param $access_user_var - ACCESS用户名
* @param $access_pwd_var - ACCESS用户密码
* @param $access_charset_var - ACCESS连接编码方式
*/
function __construct()
{
global $access_db,$access_user,$access_pwd,$access_charset;
$this->access_db = $access_db;
$this->access_user = $access_user;
$this->access_pwd = $access_pwd;
$this->access_charset = $access_charset;
}
public function Open()
{
//$this->access_str = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath($this->access_db);
$this->access_str = "DRIVER={Driver do Microsoft Access (*.mdb)};DBQ=".realpath($this->access_db);
$this->access_link = odbc_connect($this->access_str,$this->access_user,$this->access_pwd,SQL_CUR_USE_ODBC) or die("odbc error:".odbc_error());
//$this->odbc_exec($this->access_link,"set names {$this->access_charset}");
}
public function Close()
{
odbc_close($this->access_link);
}
public function Sql($sql)
{
$re_sql = iconv($this->access_charset,"gb2312",$sql);
$this->access_rs = odbc_exec($this->access_link,$re_sql);
return $this->access_rs;
}
public function Rows()
{
$this->access_rows = 0;
if($this->access_rs != 1 && $this->access_rs != 0)
{
/**
* $this->access_rows = odbc_num_rows($this->access_rs);
* 因为ODBC驱动不支持,这段代码无法得到记录集的行数
*/
ob_start();
$this->access_rows = odbc_result_all($this->access_rs);
ob_clean();
}
return $this->access_rows;
}
/**
* get_result取结果集的值
* @param $field - 要得到值的字段名或字段编号
* @return 返回取得的值
*/
public function Get($field,$row)
{
//$rs = odbc_result($this->access_rs,$field);
$list = odbc_fetch_array($this->access_rs,$row);
$result = iconv("gb2312",$this->access_charset,$list[$field]);
return $result;
}
public function Next_row()
{
odbc_fetch_row($this->access_rs);
}
function __destruct()
{
unset($this->access_db);
unset($this->access_user);
unset($this->access_pwd);
unset($this->access_str);
unset($this->access_link);
unset($this->access_rs);
unset($this->access_charset);
unset($this->access_rows);
}
}
/**
* ACCESS操作类(COM方法)
* function:Open() 打开一个ACCESS连接,无返回值;
* function:Close() 关闭一个已打开的ACCESS连接,无返回值;
* function:Sql($sql) 执行一条SQL语句,
@param $sql SQL语句,
return 执行语句后的记录集;
* function:Rows() 获得记录的总条数,
return 记录的总条数;
* function:Get($field,$row) 获取指定记录行和指定字段的值,
@param $field 字段名称,
@param $row 记录行数,
return 当前记录字段的值;
* function:Next_row() 移动到下一条记录,无返回值;
*/
class Access_codb
{
private $access_db;
private $access_user;
private $access_pwd;
private $access_str;
private $access_charset;
private $access_link;
private $access_rs;
private $access_rows;
private $access_array;
private $field_count;
/**
* ACCESS连接类构造函数
* @param $access_db_var - ACCESS数据库名
* @param $access_user_var - ACCESS用户名
* @param $access_pwd_var - ACCESS用户密码
* @param $access_charset_var - ACCESS连接编码方式
*/
function __construct()
{
global $access_db,$access_user,$access_pwd,$access_charset;
$this->access_db = $access_db;
$this->access_user = $access_user;
$this->access_pwd = $access_pwd;
$this->access_charset = $access_charset;
$this->access_array = array();
}
public function Open()
{
$this->access_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath($this->access_db);
$this->access_link = new COM("ADODB.Connection");
$this->access_link->Open($this->access_str); //or die("ado error:".$this->access_link->ErrorMsg());
}
public function Close()
{
$this->access_link->Close;
}
public function Sql($sql)
{
$this->access_rs = new COM("ADODB.RecordSet");
$re_sql = iconv($this->access_charset,"gb2312",$sql);
$this->access_rs->Open($re_sql,$this->access_link,1,1);
$this->field_count = $this->access_rs->Fields->Count;
$i = 0;
while(!$this->access_rs->Eof)
{
$i++;
$arr = array();
for($j = 0 ; $j < $this->field_count ; $j++)
{
$field_name = $this->access_rs->Fields[$j]->Name;
$field_value = $this->access_rs->Fields[$j]->Value;
$field_value = iconv("gb2312",$this->access_charset,strval($field_value));
$arr[$field_name] = $field_value;
}
$this->access_array[$i] = $arr;
$this->access_rs->MoveNext();
}
return $this->access_array;
}
public function Rows()
{
$this->access_rows = $this->access_rs->RecordCount();
return $this->access_rows;
}
/**
* get_result取结果集的值
* @param $field - 要得到值的字段名或字段编号
* @return 返回取得的值
*/
public function Get($field,$row)
{
$result = $this->access_array[$row][$field];
return $result;
}
public function Next_row()
{
$this->access_rs->MoveNext();
}
function __destruct()
{
unset($this->access_db);
unset($this->access_user);
unset($this->access_pwd);
unset($this->access_str);
unset($this->access_link);
unset($this->access_rs);
unset($this->access_charset);
unset($this->access_rows);
unset($this->access_array);
unset($this->field_count);
}
}
/**
* MYSQL操作类
* function:Open() 打开一个MYSQL连接,无返回值;
* function:Close() 关闭一个已打开的MYSQL连接,无返回值;
* function:Sql($sql) 执行一条SQL语句,
@param $sql SQL语句,
return 执行语句后的记录集;
* function:Rows() 获得记录的总条数,
return 记录的总条数;
* function:Get($field,$row) 获取指定记录行和指定字段的值,
@param $field 字段名称,
@param $row 记录行数,
return 当前记录字段的值;
* function:Next_row() 移动到下一条记录,无返回值;
*/
class Mysql_odb
{
private $mysql_server;
private $mysql_db;
private $mysql_user;
private $mysql_pwd;
private $mysql_charset;
private $mysql_link;
private $mysql_rs;
private $mysql_rows;
/**
* MYSQL连接类构造函数
* @param $mysql_server_var - MYSQL服务器名
* @param $mysql_db_var - MYSQL数据库名
* @param $mysql_user_var - MYSQL用户名
* @param $mysql_pwd_var - MYSQL用户密码
* @param $mysql_charset_var - MYSQL连接编码方式
*/
function __construct()
{
global $mysql_server,$mysql_db,$mysql_user,$mysql_pwd,$mysql_charset;
$this->mysql_server = $mysql_server;
$this->mysql_db = $mysql_db;
$this->mysql_user = $mysql_user;
$this->mysql_pwd = $mysql_pwd;
$this->mysql_charset = $mysql_charset;
}
public function Open()
{
$this->mysql_link = mysql_connect($this->mysql_server,$this->mysql_user,$this->mysql_pwd) or die("mysql error:".mysql_error());
mysql_query("set names '".$this->mysql_charset."';",$this->mysql_link);
}
public function Close()
{
mysql_close($this->mysql_link);
}
public function Sql($sql)
{
mysql_select_db($this->mysql_db,$this->mysql_link);
$this->mysql_rs = mysql_query($sql,$this->mysql_link);
return $this->mysql_rs;
}
public function Rows()
{
$this->mysql_rows = 0;
if($this->mysql_rs != 1 && $this->mysql_rs != 0)
{
$this->mysql_rows = mysql_num_rows($this->mysql_rs);
}
return $this->mysql_rows;
}
public function Get($field,$row)
{
$result = mysql_result($this_>mysql_rs,$row,$field);
return $result;
}
public function Next_row()
{
return "NULL";
}
function __destruct()
{
unset($this->mysql_server);
unset($this->mysql_db);
unset($this->mysql_user);
unset($this->mysql_pwd);
unset($this->mysql_link);
unset($this->mysql_rs);
unset($this->mysql_charset);
unset($this->mysql_rows);
}
}
/**
* ACCESS操作类
* function:Open() 打开一个ACCESS连接,无返回值;
* function:Close() 关闭一个已打开的ACCESS连接,无返回值;
* function:Sql($sql) 执行一条SQL语句,
@param $sql SQL语句,
return 执行语句后的记录集;
* function:Rows() 获得记录的总条数,
return 记录的总条数;
* function:Get($field,$row) 获取指定记录行和指定字段的值,
@param $field 字段名称,
@param $row 记录行数,
return 当前记录字段的值;
* function:Next_row() 移动到下一条记录,无返回值;
*/
class Access_odb
{
private $access_db;
private $access_user;
private $access_pwd;
private $access_str;
private $access_charset;
private $access_link;
private $access_rs;
private $access_rows;
/**
* ACCESS连接类构造函数
* @param $access_db_var - ACCESS数据库名
* @param $access_user_var - ACCESS用户名
* @param $access_pwd_var - ACCESS用户密码
* @param $access_charset_var - ACCESS连接编码方式
*/
function __construct()
{
global $access_db,$access_user,$access_pwd,$access_charset;
$this->access_db = $access_db;
$this->access_user = $access_user;
$this->access_pwd = $access_pwd;
$this->access_charset = $access_charset;
}
public function Open()
{
//$this->access_str = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath($this->access_db);
$this->access_str = "DRIVER={Driver do Microsoft Access (*.mdb)};DBQ=".realpath($this->access_db);
$this->access_link = odbc_connect($this->access_str,$this->access_user,$this->access_pwd,SQL_CUR_USE_ODBC) or die("odbc error:".odbc_error());
//$this->odbc_exec($this->access_link,"set names {$this->access_charset}");
}
public function Close()
{
odbc_close($this->access_link);
}
public function Sql($sql)
{
$re_sql = iconv($this->access_charset,"gb2312",$sql);
$this->access_rs = odbc_exec($this->access_link,$re_sql);
return $this->access_rs;
}
public function Rows()
{
$this->access_rows = 0;
if($this->access_rs != 1 && $this->access_rs != 0)
{
/**
* $this->access_rows = odbc_num_rows($this->access_rs);
* 因为ODBC驱动不支持,这段代码无法得到记录集的行数
*/
ob_start();
$this->access_rows = odbc_result_all($this->access_rs);
ob_clean();
}
return $this->access_rows;
}
/**
* get_result取结果集的值
* @param $field - 要得到值的字段名或字段编号
* @return 返回取得的值
*/
public function Get($field,$row)
{
//$rs = odbc_result($this->access_rs,$field);
$list = odbc_fetch_array($this->access_rs,$row);
$result = iconv("gb2312",$this->access_charset,$list[$field]);
return $result;
}
public function Next_row()
{
odbc_fetch_row($this->access_rs);
}
function __destruct()
{
unset($this->access_db);
unset($this->access_user);
unset($this->access_pwd);
unset($this->access_str);
unset($this->access_link);
unset($this->access_rs);
unset($this->access_charset);
unset($this->access_rows);
}
}
/**
* ACCESS操作类(COM方法)
* function:Open() 打开一个ACCESS连接,无返回值;
* function:Close() 关闭一个已打开的ACCESS连接,无返回值;
* function:Sql($sql) 执行一条SQL语句,
@param $sql SQL语句,
return 执行语句后的记录集;
* function:Rows() 获得记录的总条数,
return 记录的总条数;
* function:Get($field,$row) 获取指定记录行和指定字段的值,
@param $field 字段名称,
@param $row 记录行数,
return 当前记录字段的值;
* function:Next_row() 移动到下一条记录,无返回值;
*/
class Access_codb
{
private $access_db;
private $access_user;
private $access_pwd;
private $access_str;
private $access_charset;
private $access_link;
private $access_rs;
private $access_rows;
private $access_array;
private $field_count;
/**
* ACCESS连接类构造函数
* @param $access_db_var - ACCESS数据库名
* @param $access_user_var - ACCESS用户名
* @param $access_pwd_var - ACCESS用户密码
* @param $access_charset_var - ACCESS连接编码方式
*/
function __construct()
{
global $access_db,$access_user,$access_pwd,$access_charset;
$this->access_db = $access_db;
$this->access_user = $access_user;
$this->access_pwd = $access_pwd;
$this->access_charset = $access_charset;
$this->access_array = array();
}
public function Open()
{
$this->access_str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath($this->access_db);
$this->access_link = new COM("ADODB.Connection");
$this->access_link->Open($this->access_str); //or die("ado error:".$this->access_link->ErrorMsg());
}
public function Close()
{
$this->access_link->Close;
}
public function Sql($sql)
{
$this->access_rs = new COM("ADODB.RecordSet");
$re_sql = iconv($this->access_charset,"gb2312",$sql);
$this->access_rs->Open($re_sql,$this->access_link,1,1);
$this->field_count = $this->access_rs->Fields->Count;
$i = 0;
while(!$this->access_rs->Eof)
{
$i++;
$arr = array();
for($j = 0 ; $j < $this->field_count ; $j++)
{
$field_name = $this->access_rs->Fields[$j]->Name;
$field_value = $this->access_rs->Fields[$j]->Value;
$field_value = iconv("gb2312",$this->access_charset,strval($field_value));
$arr[$field_name] = $field_value;
}
$this->access_array[$i] = $arr;
$this->access_rs->MoveNext();
}
return $this->access_array;
}
public function Rows()
{
$this->access_rows = $this->access_rs->RecordCount();
return $this->access_rows;
}
/**
* get_result取结果集的值
* @param $field - 要得到值的字段名或字段编号
* @return 返回取得的值
*/
public function Get($field,$row)
{
$result = $this->access_array[$row][$field];
return $result;
}
public function Next_row()
{
$this->access_rs->MoveNext();
}
function __destruct()
{
unset($this->access_db);
unset($this->access_user);
unset($this->access_pwd);
unset($this->access_str);
unset($this->access_link);
unset($this->access_rs);
unset($this->access_charset);
unset($this->access_rows);
unset($this->access_array);
unset($this->field_count);
}
}
发表评论
-
转载 Win7+IIS7下用FastCGI模式配置PHP环境
2011-07-26 16:53 1719Win7+IIS7下用FastCGI模式配置PHP环境 ... -
php导入excel 收藏
2011-06-28 16:17 1542php导入excel PHP-Exc ... -
收藏的smarty总觉
2011-06-27 15:52 922nl2br[换行符替换成<br />]regex_ ... -
设为首页与加入收藏二种表现方法
2011-06-23 09:20 697文字型的 设为首页: <a href=# onCl ... -
无法载入 mcrypt 扩展,<br />请检查 PHP 配置
2011-06-22 16:27 1193无法载入 mcrypt 扩展,<br />请检 ... -
php批量导入数据库
2011-06-22 13:41 4581文章来源:Slyar Home 转载请注明,谢谢 ... -
删除提示框
2011-06-09 17:05 749<a href="article_delete ... -
session_start() 转
2011-06-09 15:47 770session_start()这个问题 ... -
php 分两排显示数据
2011-06-01 23:20 828分排显示建议使用CSS处理,并非PHP程序逻辑范围如你现在 ... -
PHPlot PHP图形类
2011-05-21 15:28 1082PHPLOT 是一个用来创建图表的PHP图形类,需要 P ... -
json jquery 的实例应用
2011-05-12 10:22 761jQuery通过Ajax向PHP服务端发送请求并返回JSON数 ... -
做网站的一些菜鸟问题
2011-05-10 12:06 709最近做了个网站想购买个虚拟主机 可是不知道怎么上传数据库 第一 ... -
windows 2003 +apache+php虚拟主机配置windows2003serve
2011-03-27 18:32 1260windows 2003 +apache+php虚拟主机配置w ... -
域名指向————域名解析:
2011-03-27 18:23 772域名指向————域名解析: 域名解析也叫域名指向、服务器设置 ... -
企业(群发)发邮箱到会员qq邮箱碰到都问题
2011-03-18 20:00 1597今天发企业邮件到会员到qq邮箱都那里,邮件里面有图片,但是发过 ... -
今天用了一个好用的远程控制软件 不用得着qq咯
2011-03-11 14:53 901teamviewer,一打开的时候你会有自己的id号,和密码, ... -
关于怎么在局域网内可以通过虚拟域名来访问的apache上的网站的对答
2011-03-10 10:49 5126E2011-03-10 10:34:12 可以的 Botak2 ... -
职业资格证书制度与职业技能鉴定问答
2011-03-08 17:19 856职业资格证书制度与职业技能鉴定问答 一 ... -
just a simple for a mail() amd get array()
2011-03-05 17:40 849<?php// this would come from ... -
php群发邮件
2011-03-05 17:32 1763发过邮件的人都知道,从别人那里申请的邮箱,没法群发。有些人说Q ...
相关推荐
对PHP的数据库连接以及增查改删的简易封装,可以用来做小型的网站。
如处理前端请求的后台程序(test.php) 表封装类(user.class.php) 数据库封装类(db.class.php) 配置信息(configuration.php) 以下例子有四个文件:configuration.php db.class.php user.class.php test.php,...
C#操作mysql数据库的封装类,带注释,代码完整,适合企业级开发
Access数据库的简单封装 Access数据库的简单封装 Access数据库的简单封装
该类可以简单的操作各类数据库,包括MySql、Access、Oracle、MSSql等,例子中只演示了操作Access和Mysql,两个数据库都已经包含在压缩包了
服务端封装数据库操作客户端调用,服务端封装数据库操作客户端调用
对连接MYSQL及之后的操作进行一个封装类。
MySQL数据库操作MFC封装类,增加了事务处理及回滚。在实际项目使用。CSQLConnection封装数据库的连接,CSQLResult封装记录集的操作。
用QT 封装的操作Sql server,MySql,SQLite,ODBC数据库的接口类,我在QT5.8下使用没问题,非常好用!
我学习过程中自己参考书本写的,注释详细,我也自己写了使用说明放在里面,...你要是要学javabean,还想知道javabean怎么封装数据库,这个最好不过了. 数据库的链接你得改下用户名,密码之类东西,你打开.java文件就会看懂的.
zynq平台mysql数据库C++操作代码 zynq平台mysql数据库C++操作代码 zynq平台mysql数据库C++操作代码 zynq平台mysql数据库C++操作代码 zynq平台mysql数据库C++操作代码 zynq平台mysql数据库C++操作代码 zynq平台mysql...
php数据库连接mysql封装类,改类能让初学着更好的实用php连接mysql
MYSQL 数据库访问封装类 MYSQL 数据访问方式,php4支持以mysql_开头的过程访问方式,php5开始支持以mysqli_开头的过程和mysqli面向对象 访问方式,本封装类以mysql_封装 数据访问的一般流程: 1,连接...
新手学习,php7中mysql数据库操作类实例,非常清晰易懂
php数据库操作封装类免费下载
nodejs封装好的mysql数据库模块,使用mysql连接池以及附带百万mysql测试数据,实现mysql数据库的增删改查功能,使用方法很详细。
mysql 封装类,不错 Mysql封装类 php 数据库 操作类 db 数据库
c#.NET万能数据库访问封装类(ACCESS、SQLServer、Oracle)
用户封装到MySql数据库案例,主要是如何连接MySql数据库及将数据封装到数据库,及增删改查,采用MVC模式+三层结构