PEAR之DB_DataObject快速安装
系统 WINXP+IIS+PHP5+MYSQL5
1. 安装
首先安装PEAR, 进入DOS命令行,进入PHP目录,运行go-pear,一切默认吧,安装完成.
然后安装PEAR PACKAGE
pear install db
pear install mdb2
pear install mdb2 (之后会有提示,安装MySQL模块)
pear install db_dataobject
安装完成后,安装包如下
C:\PHP>pear list
INSTALLED PACKAGES, CHANNEL PEAR.PHP.NET:
=========================================
PACKAGE VERSION STATE
Archive_Tar 1.3.2 stable
Console_Getopt 1.2.3 stable
DB 1.7.13 stable
DB_DataObject 1.8.8 stable
Date 1.4.7 stable
MDB2 2.4.1 stable
MDB2_Driver_mysql 1.4.1 stable
PEAR 1.6.1 stable
Structures_Graph 1.0.2 stable
到这里,DB_DataObject就算安装完成了.
2 快速入门
建立一个MySQL库
SQL文件如下:
Code
接下来就要生成数据库中的表对象
到C:\PHP\DB\scripts目录下 建立配置文件CreateTable.ini
[DB_DataObject]
database = mysql://root:pass@localhost/Shj_CMS
schema_location = E:\\web\\cms\\DataObjects
class_location = E:\\web\\cms\\DataObjects
require_prefix = E:\\web\\cms\\DataObjects
extends = DB_DataObject
generator_strip_schema = 1
class_prefix = DataObject_
debug = 5
extends_location = DB/DataObject.php
db_driver = MDB2
进入CMD到本目录,运行命令DB_DataObject_createTables.bat CreateTable.ini
就可以看到E:\\web\\cms\\DataObjects目录下已经生成了所有表的对象.
到E:\web\cms目录下建立文件config.ini 内容如下:
[DB_DataObject]
database = mysql://root:pass@localhost/Shj_CMS
schema_location = E:\web\cms\DataObjects
class_location = E:\web\cms\DataObjects
require_prefix = E:\web\cms\DataObjects
class_prefix = DataObject_
db_driver = MDB2
quote_identifiers = 1
debug = 0
建立文件db.php
Code
浏览本文件,大功告成!
关于utf8编码, 可以在对应的对象加入构造函数解决
function ClassName() {
$this->query('set names utf8');
}
1. 安装
首先安装PEAR, 进入DOS命令行,进入PHP目录,运行go-pear,一切默认吧,安装完成.
然后安装PEAR PACKAGE
pear install db
pear install mdb2
pear install mdb2 (之后会有提示,安装MySQL模块)
pear install db_dataobject
安装完成后,安装包如下
C:\PHP>pear list
INSTALLED PACKAGES, CHANNEL PEAR.PHP.NET:
=========================================
PACKAGE VERSION STATE
Archive_Tar 1.3.2 stable
Console_Getopt 1.2.3 stable
DB 1.7.13 stable
DB_DataObject 1.8.8 stable
Date 1.4.7 stable
MDB2 2.4.1 stable
MDB2_Driver_mysql 1.4.1 stable
PEAR 1.6.1 stable
Structures_Graph 1.0.2 stable
到这里,DB_DataObject就算安装完成了.
2 快速入门
建立一个MySQL库
SQL文件如下:
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
接下来就要生成数据库中的表对象
到C:\PHP\DB\scripts目录下 建立配置文件CreateTable.ini
[DB_DataObject]
database = mysql://root:pass@localhost/Shj_CMS
schema_location = E:\\web\\cms\\DataObjects
class_location = E:\\web\\cms\\DataObjects
require_prefix = E:\\web\\cms\\DataObjects
extends = DB_DataObject
generator_strip_schema = 1
class_prefix = DataObject_
debug = 5
extends_location = DB/DataObject.php
db_driver = MDB2
进入CMD到本目录,运行命令DB_DataObject_createTables.bat CreateTable.ini
就可以看到E:\\web\\cms\\DataObjects目录下已经生成了所有表的对象.
到E:\web\cms目录下建立文件config.ini 内容如下:
[DB_DataObject]
database = mysql://root:pass@localhost/Shj_CMS
schema_location = E:\web\cms\DataObjects
class_location = E:\web\cms\DataObjects
require_prefix = E:\web\cms\DataObjects
class_prefix = DataObject_
db_driver = MDB2
quote_identifiers = 1
debug = 0
建立文件db.php
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
浏览本文件,大功告成!
关于utf8编码, 可以在对应的对象加入构造函数解决
function ClassName() {
$this->query('set names utf8');
}
┉┉┉┉┉┉┉┉┉┉┉┉┉┉┉
赠人玫瑰 手留余香
┉┉┉┉┉┉┉┉┉┉┉┉┉┉┉