慕课 php 开发APP接口（四）完结

#单例模式连接数据库

#新建 Db.php

<?php

class Db{
    static private $_instance;
    static private $_connectSource;
    private $_dbConfig = array(
        'host'=>'127.0.0.1',
        'user'=>'root',
        'password'=>'qazxswedcvfrt',
        'database'=>'mukeapi',
    );

    private function __construct(){

    }

    static public function getInstance(){
        if(!(self::$_instance instanceof self)){
            self::$_instance = new self();
        }
        return self::$_instance;
    }

    public function connect(){
        if(!self::$_connectSource){
            self::$_connectSource  = mysql_connect($this->_dbConfig['host'],$this->_dbConfig['user'],$this->_dbConfig['password']);

            if(!self::$_connectSource){
                die('mysql connect error'.mysql_error());
            }
            mysql_select_db('mukeapi',self::$_connectSource );
            mysql_query('set names UTF8',self::$_connectSource);
        }

        return self::$_connectSource;
    }

}

$connect = Db::getInstance()->connect();
$sql = "SELECT * FROM `category`";
$result = mysql_query($sql,$connect);
var_dump($result);

#创建 list.php 文件

<?php

require_once('./response.php');
require_once('./Db.php');

$page = isset($_GET['page'])? $_GET['page']:1;
$pageSize = isset($_GET['pagesize'])? $_GET['pagesize']:10;

if(!is_numeric($page) || !is_numeric($pageSize)){
    return Response::show(401,'bu he fa');
}

$offset = ($page -1) * $pageSize;
$sql = "select * from video where status = 1 order by orderby limit {$offset},{$pageSize}";

try{
    $connect = Db::getInstance()->connect();
}catch (Exception $e){
    return Response::show(403,'database connect error');
}

$result = mysql_query($sql,$connect);

$videos = array();
while($video = mysql_fetch_assoc($result)){
    $videos[] = $video;
}

if($videos){
    return Response::show(200,'success',$videos);
}else{
    return Response::show(401,'bu he fa');
}

在mysqladmin 管理工具中执行 sql 语句开是否正确，修改Db的connect 函数的 die 改成

    throw new Exception('mysql connect error');

待续。。。