操作mysql数据库的类.doc
文本预览下载声明
操作mysql数据库的类适用环境: PHP5.2.x??/ mysql 5.0.x??????代码作者: Silence??????联系方式: QQ????????????函数说明:
引用
????操作mysql数据库的类????
??????代码:??
复制代码
class Mysql {
????private $server = ;
????private $user = ;
????private $password = ;
????private $database = ;
????private $linkMode = 1;
????private $link_id = 0;
????private $query_id = 0;
????private $query_times = 0;
????private $result = array ();
????private $fetchMode = MYSQL_ASSOC;
????private $err_no = 0;
????private $err_msg;
????private $character;
????//======================================
????// 函数: mysql()
????// 功能: 构造函数
????// 参数: 参数类的变量定义
????// 说明: 构造函数将自动连接数据库
????// 如果想手动连接去掉自动连接函数
????//======================================
????public function __construct($server, $user, $password, $database, $character = UTF8, $linkMode = 0) {
????????if (empty ( $server ) || empty ( $user ) || empty ( $database ))
????????????$this-halt ( 提交的数据库信息不完整!请检查服务器地址,用户和数据库是否正确有效 );
????????
????????$this-server = $server;
????????$this-user = $user;
????????$this-password = $password;
????????$this-database = $database;
????????$this-linkMode = $linkMode;
????????$this-character = $character;
????????$this-connect ();
????}
????//======================================
????// 函数: connect($server,$user,$password,$database)
????// 功能: 连接数据库
????// 参数: $server 主机名, $user 用户名
????// 参数: $password 密码, $database 数据库名称
????// 返回: 0:失败
????// 说明: 默认使用类中变量的初始值
????//======================================
????public function connect($server = , $user = , $password = , $database = ) {
????????$server = $server ? $server : $this-server;
????????$user = $user ? $user : $this-user;
????????$password = $password ? $password : $this-password;
????????$database = $database ? $database : $this-database;
????????
????????$this-link_id = $this-linkMode ? mysql_pconnect ( $server, $user, $password, $database ) : mysql_connect ( $server, $user, $password, $database );
????????
????????if (!
显示全部