>[info]修改 models/Article.php 為:
~~~
<?php
/**
* Article model
*/
class Article
{
public static function first() {
$connect = mysqli_connect("localhost", 'root', 'root', 'uwebcms6') or die('連接失敗'.mysqli_connect_error());
mysqli_query($connect,"set names utf8");
$query = mysqli_query($connect, "select * from uwebcms_document limit 1,2");
if(mysqli_num_rows($query) > 0) {
while($row = mysqli_fetch_assoc($query)){
$result[] = $row;
}
return $result;
}
mysqli_close($connect);
}
}
~~~
>[info]將包含查詢結果的數組返回。修改 HomeController:
~~~
<?php
/**
* HomeController
*/
class HomeController extends BaseController
{
public function home(){
$article = Article::first();
require dirname(__FILE__).'/../views/home.php';
}
}
~~~
>[info]在views文件夾下新建home.php文件
~~~
<!DOCTYPE html>
<html>
<head>
<title>view視圖調用測試</title>
</head>
<style type="text/css">
table, tr, th, td {
border: 1px solid #000;
border-collapse:collapse;
}
</style>
<body>
<table>
<tr>
<th>標題</th>
<th>作者</th>
<th>標簽</th>
<th>描述</th>
</tr>
<?php foreach($article as $key=>$value) { ?>
<tr>
<td><? echo $value['title']; ?></td>
<td><? echo $value['author']; ?></td>
<td><? echo $value['tags']; ?></td>
<td><? echo $value['description']; ?></td>
</tr>
<?php } ?>
</table>
</body>
</html>
~~~
刷新頁面后同樣出現了數據:

此時視圖調用成功實現!