PHP封装的实现读取数据库的类

<?php

include '../config.php';

class getData{

    public $table;
    public $db;
    public  $link;

    public function __construct($table){
        
        $this->table = $table;
        $this->link = mysql_connect(DBHOST,DBUSER,DBPWD,DBNAME); 
        $this->db = mysql_select_db(DBNAME,$this->link);
       
    }

    private function query($query){  // 基础组件 执行SQL语句
        mysql_query("SET NAMES utf8");
        return mysql_query($query,$this->link);
    }

    public function get($limit){ // 功能: 获取条数为$limit条包含全字段数据的数据

        $query = "SELECT * FROM `".$this->table."`LIMIT 0 , $limit";
        $result = $this->query($query);
        return $this->toArray($result);
    }

    private function toArray($source){ // 基础组件 根据查询语句将数据打包成数组
       
        $arr = array();
        while($row = mysql_fetch_array($source)){
            $arr[] = $row;
        }
        return $arr;
    }
}


class read extends getData{
   
    function getDataArray($table,$limit){
        $data = new getData($table);
        return $data->get(10);
    }
}


$d =read::getDataArray('categories',10);
print_r($d);


# $d = getDataArray('categories',10); // 从表categories中获取包含10条全字段数据的数组
# print_r($d);