>[info]新建 models/Article.php 文件,內容為(數據庫密碼請自行更改):
建議使用mysqli或者pdo進行數據庫操作,由于新版本的php使用mysql會報錯
~~~
<?php
/**
* Article model
*/
class Article
{
public static function first() {
$connect = mysqli_connect("localhost", 'root', 'password', 'database') or die('連接失敗'.mysqli_connect_error());
mysqli_query($connect,"set names utf8");
$query = mysqli_query($connect, "select * from table limit 1,2");
if(mysqli_num_rows($query) > 0) {
while($row = mysqli_fetch_assoc($query)){
echo $row['title']."<br/>";
echo $row['author']."<br/>";
echo $row['tags']."<br/>";
echo $row['description']."<br/>";
echo "<br/><hr/>";
}
}
mysqli_close($connect);
}
}
~~~
>[info]修改 controllers/HomeController.php 文件:
~~~
<?php
/**
* HomeController
*/
class HomeController extends BaseController
{
public function home(){
Article::first();
}
}
~~~
>[warning]刷新,這時候會得到 Article 類未找到的信息,因為我們沒有更新自動加載配置:
~~~
composer dump-autoload
~~~
再次刷新網頁:

這個時候model數據庫操作實現!