## 2.5 模型類
~~~
1. 創建一個模型類
2. 訪問模型
3. 模型訪問數據，并打印
~~~
### 1. 創建一個模型類
*D:\wamp\www\web.com\core\lib\model.php*
~~~
<?php
namespace core\lib;
class model extends \PDO
{
public function __construct()
{
$dsn = 'mysql:host=localhost;dbname=demo;charset=UTF8;';
$username = 'root';
$password = 'root';
try {
parent::__construct($dsn, $username, $password);
} catch (\Exception $e) {
p($e->getMessage());
die;
}
}
}
~~~
### 2. 訪問模型
*D:\wamp\www\web.com\app\ctrl\indexCtrl.php*
~~~
<?php
namespace app\ctrl;
class indexCtrl
{
public function index()
{
$model = new \core\lib\model();
$sql = "SELECT * FROM `cat`";
p($model->query($sql));
}
}
~~~
### 3. 模型訪問數據，并打印
~~~
<?php
namespace app\ctrl;
class indexCtrl
{
public function index()
{
$model = new \core\lib\model();
$sql = "SELECT * FROM `cat`";
$ret = $model->query($sql);
p($ret);
// foreach ($model->query($sql) as $key => $value) {
// p($value);
// }
p($ret->fetchAll());
}
}
~~~
> 備注：PDOStatement <http://php.net/manual/zh/class.pdostatement.php>
### 效果如圖
