封装一个DB类，用来专门操作数据库，以后凡是对数据库的操作，都由DB类的对象来实现。这样有了自己的DB类，写项目时简单的sql语句就不用每次写了，直接调用就行，很方便！
1.封装一个DB类。一个类文件应该只有一个类，其他的内容全部都没有。类文件的命名规则：类名.class.php
下面是创建DB类的代码：
<?<span>php
</span><span>//</span><span>封装一个DB类，用来专门操作数据库，以后凡是对数据库的操作，都由DB类的对象来实现</span>
<span>class</span><span> DB{
</span><span>//</span><span>属性</span>
<span>private</span> <span>$host</span><span>;
</span><span>private</span> <span>$port</span><span>;
</span><span>private</span> <span>$user</span><span>;
</span><span>private</span> <span>$pass</span><span>;
</span><span>private</span> <span>$dbname</span><span>;
</span><span>private</span> <span>$charset</span><span>;
</span><span>private</span> <span>$prefix</span>; <span>//</span><span>表前缀</span>
<span>private</span> <span>$link</span>; <span>//</span><span>连接资源（连接数据库，一般会返回一个资源，所以需要定义一个link属性）
//构造方法(作用：为了初始化对象的属性)，会被自动调用</span>
<span>/*</span><span>
* @param1 array $arr，默认为空，里面是一个关联数组，里面有7个元素
* array('host' => 'localhost','port' => '3306');
</span><span>*/</span>
<span>public</span> <span>function</span> __construct(<span>$arr</span> = <span>array</span><span>()){
</span><span>//</span><span>初始化</span>
<span>$this</span>->host = <span>isset</span>(<span>$arr</span>['host']) ? <span>$arr</span>['host'] : 'localhost';<span>//</span><span>先判断是否有自己的host，如果有就用自己的host，否则就使用默认的localhost</span>
<span>$this</span>->port = <span>isset</span>(<span>$arr</span>['port']) ? <span>$arr</span>['port'] : '3306'<span>;
</span><span>$this</span>->user = <span>isset</span>(<span>$arr</span>['user']) ? <span>$arr</span>['user'] : 'root'<span>;
</span><span>$this</span>->pass = <span>isset</span>(<span>$arr</span>['pass']) ? <span>$arr</span>['pass'] : 'root'<span>;
</span><span>$this</span>->dbname = <span>isset</span>(<span>$arr</span>['dbname']) ? <span>$arr</span>['dbname'] : 'mydatabase'<span>;
</span><span>$this</span>->charset = <span>isset</span>(<span>$arr</span>['charset']) ? <span>$arr</span>['charset'] : 'utf8'<span>;
</span><span>$this</span>->prefix = <span>isset</span>(<span>$arr</span>['prefix']) ? <span>$arr</span>['prefix'] : ''<span>;
</span><span>//</span><span>连接数据库（类是要操作数据库，因此要连接数据库）</span>
<span>$this</span>-><span>connect();
</span><span>//</span><span>设置字符集</span>
<span>$this</span>-><span>setCharset();
</span><span>//</span><span>选择数据库</span>
<span>$this</span>-><span>setDbname();
}
</span><span>/*</span><span>
* 连接数据库
</span><span>*/</span>
<span>private</span> <span>function</span><span> connect(){
</span><span>//</span><span>mysql扩展连接</span>
<span>$this</span>->link = <span>mysql_connect</span>(<span>$this</span>->host . ':' . <span>$this</span>->port,<span>$this</span>->user,<span>$this</span>-><span>pass);
</span><span>//</span><span>判断结果</span>
<span>if</span>(!<span>$this</span>-><span>link){
</span><span>//</span><span>结果出错了
//暴力处理，如果是真实线上项目（生产环境）必须写入到日志文件</span>
<span>echo</span> '数据库连接错误：<br/>'<span>;
</span><span>echo</span> '错误编号' . <span>mysql_errno</span>() . '<br/>'<span>;
</span><span>echo</span> '错误内容' . <span>mysql_error</span>() . '<br/>'<span>;
</span><span>exit</span><span>;
}
}
</span><span>/*</span><span>
* 设置字符集
</span><span>*/</span>
<span>private</span> <span>function</span><span> setCharset(){
</span><span>//</span><span>设置</span>
<span>$this</span>->db_query("set names {<span>$this</span>->charset}"<span>);
}
</span><span>/*</span><span>
* 选择数据库
</span><span>*/</span>
<span>private</span> <span>function</span><span> setDbname(){
</span><span>$this</span>->db_query("use {<span>$this</span>->dbname}"<span>);
}
</span><span>/*</span><span>
* 增加数据
* @param1 string $sql，要执行的插入语句
* @return boolean，成功返回是自动增长的ID，失败返回FALSE
</span><span>*/</span>
<span>public</span> <span>function</span> db_insert(<span>$sql</span><span>){
</span><span>//</span><span>发送数据</span>
<span>$this</span>->db_query(<span>$sql</span><span>);
</span><span>//</span><span>成功返回自增ID</span>
<span>return</span> <span>mysql_affected_rows</span>() ? <span>mysql_insert_id</span>() : <span>FALSE</span><span>;
}
</span><span>/*</span><span>
* 删除数据
* @param1 string $sql，要执行的删除语句
* @return Boolean，成功返回受影响的行数，失败返回FALSE
</span><span>*/</span>
<span>public</span> <span>function</span> db_delete(<span>$sql</span><span>){
</span><span>//</span><span>发送SQL</span>
<span>$this</span>->db_query(<span>$sql</span><span>);
</span><span>//</span><span>判断结果</span>
<span>return</span> <span>mysql_affected_rows</span>() ? <span>mysql_affected_rows</span>() : <span>FALSE</span><span>;
}
</span><span>/*</span><span>
* 更新数据
* @param1 string $sql，要执行的更新语句
* @return Boolean，成功返回受影响的行数，失败返回FALSE
</span><span>*/</span>
<span>public</span> <span>function</span> db_update(<span>$sql</span><span>){
</span><span>//</span><span>发送SQL</span>
<span>$this</span>->db_query(<span>$sql</span><span>);
</span><span>//</span><span>判断结果</span>
<span>return</span> <span>mysql_affected_rows</span>() ? <span>mysql_affected_rows</span>() : <span>FALSE</span><span>;
}
</span><span>/*</span><span>
* 查询：查询一条记录
* @param1 string $sql，要查询的SQL语句
* @return mixed，成功返回一个数组，失败返回FALSE
</span><span>*/</span>
<span>public</span> <span>function</span> db_getRow(<span>$sql</span><span>){
</span><span>//</span><span>发送SQL</span>
<span>$res</span> = <span>$this</span>->db_query(<span>$sql</span><span>);
</span><span>//</span><span>判断返回</span>
<span>return</span> <span>mysql_num_rows</span>(<span>$res</span>) ? <span>mysql_fetch_assoc</span>(<span>$res</span>) : <span>FALSE</span><span>;
}
</span><span>/*</span><span>
* 查询：查询多条记录
* @param1 string $sql，要查询的SQL语句
* @return mixed，成功返回一个二维数组，失败返回FALSE
</span><span>*/</span>
<span>public</span> <span>function</span> db_getAll(<span>$sql</span><span>){
</span><span>//</span><span>发送SQL</span>
<span>$res</span> = <span>$this</span>->db_query(<span>$sql</span><span>);
</span><span>//</span><span>判断返回</span>
<span>if</span>(<span>mysql_num_rows</span>(<span>$res</span><span>)){
</span><span>//</span><span>循环遍历</span>
<span>$list</span> = <span>array</span><span>();
</span><span>//</span><span>遍历</span>
<span>while</span>(<span>$row</span> = <span>mysql_fetch_assoc</span>(<span>$res</span><span>)){
</span><span>$list</span>[] = <span>$row</span><span>;
}
</span><span>//</span><span>返回</span>
<span>return</span> <span>$list</span><span>;
}
</span><span>//</span><span>返回FALSE</span>
<span>return</span> <span>FALSE</span><span>;
}
</span><span>/*</span><span>
* mysql_query错误处理
* @param1 string $sql，需要执行的SQL语句
* @return mixed，只要语句不出错，全部返回
</span><span>*/</span>
<span>private</span> <span>function</span> db_query(<span>$sql</span><span>){
</span><span>//</span><span>发送SQL</span>
<span>$res</span> = <span>mysql_query</span>(<span>$sql</span><span>);
</span><span>//</span><span>判断结果</span>
<span>if</span>(!<span>$res</span><span>){
</span><span>//</span><span>结果出错了
//暴力处理，如果是真实线上项目（生产环境）必须写入到日志文件</span>
<span>echo</span> '语句出现错误：<br/>'<span>;
</span><span>echo</span> '错误编号' . <span>mysql_errno</span>() . '<br/>'<span>;
</span><span>echo</span> '错误内容' . <span>mysql_error</span>() . '<br/>'<span>;
</span><span>exit</span><span>;
}
</span><span>//</span><span>没有错误</span>
<span>return</span> <span>$res</span><span>;
}
</span><span>//</span><span>__sleep方法</span>
<span>public</span> <span>function</span><span> __sleep(){
</span><span>//</span><span>返回需要保存的属性的数组</span>
<span>return</span> <span>array</span>('host','port','user','pass','dbname','charset','prefix'<span>);
}
</span><span>//</span><span>__wakeup方法</span>
<span>public</span> <span>function</span><span> __wakeup(){
</span><span>//</span><span>连接资源</span>
<span>$this</span>-><span>connect();
</span><span>//</span><span>设置字符集和选中数据库</span>
<span>$this</span>-><span>setCharset();
</span><span>$this</span>-><span>setDbname();
}
</span><span>/*</span><span>
* 获取完整的表名
</span><span>*/</span>
<span>protected</span> <span>function</span><span> getTableName(){
</span><span>//</span><span>完整表名：前缀+表名</span>
<span>return</span> <span>$this</span>->prefix . <span>$this</span>-><span>table;
}
}
</span><span>//</span><span>这个DB类，一般不写析构（不释放资源） </span>2.使用DB类，但是如果要使用某一个类来创建对象，必须要保证该类已经被加载到代码区里。可以使用一个魔术函数来实现对类的自动加载
自动加载：当一个脚本文件在执行某些语句的时候（实例化）需要去代码区里寻找对应的类，如果找不到会通过自动加载函数来将对应的类文件进行加载。
魔术函数：__autoload()
比如我们在index.php页面中需要使用DB类，那么我们就直接调用即可，具体代码如下：
<?<span>php
</span><span>//</span><span>使用DB类的对象来访问数据库
//先加载类文件
//include_once 'DB.class.php';
//如果想使用其他类，又需要加载（所以使用魔术函数__autoload来实现类的自动加载）
//显示的写出魔术函数__autoload
//参数：需要加载的类的名字</span>
<span>function</span> __autoload(<span>$a</span><span>){
</span><span>//</span><span>将对应的类文件加载进来</span>
<span>if</span>(<span>is_file</span>("<span>$a</span>.class.php"<span>)){
</span><span>include_once</span> "<span>$a</span>.class.php"<span>;
}
}
</span><span>//</span><span>实例化</span>
<span>$db</span> = <span>new</span> DB(<span>array</span>('dbname' => 'mydatabase'<span>));
</span>
Mana satu lebih mudah, thinkphp atau laravel?
Bagaimanakah prestasi thinkphp?
pangkalan data phpstudy tidak boleh memulakan penyelesaian
Bagaimana untuk membaca lajur dalam excel dalam python
Bagaimana untuk membuka fail bak
Pengenalan kepada kaedah memintas rentetan dalam js
Bagaimana untuk menggunakan arahan mencari untuk mencari fail dalam linux
Ringkasan ralat soket biasa
![[Web front-end] Permulaan pantas Node.js](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
