攻克CakePHP系列二 表單數據顯示

CakePHP表單數據顯示的方法步驟


首先建立數據庫cake_ext,並執行如下sql文:


CREATE TABLE `companies` (
`id` int(11) NOT NULL auto_increment,
`company` varchar(50) NOT NULL,
`price` decimal(8,2) NOT NULL,
`change` decimal(8,2) NOT NULL,
`lastudp` date NOT NULL,
PRIMARYKEY(`id`)
)ENGINE=MyISAMAUTO_INCREMENT=8DEFAULTCHARSET=utf8;


— —————————-
— Records
— —————————-
INSERT INTO `companies` VALUES (1, 3m Co, 71.72, 0.02, 2008-10-21);
INSERT INTO `companies` VALUES (2, Alcoa Inc, 29.01, 0.42, 2008-10-20);
INSERT INTO `companies` VALUES (3, AT&T Inc., 31.61, -0.48, 2008-10-21);
INSERT INTO `companies` VALUES (4, Boeing Co., 75.43, 0.53, 2008-10-13);
INSERT INTO `companies` VALUES (5, United Technologies Corporation, 63.26, 0.55, 2008-10-09);
INSERT INTO `companies` VALUES (6, Intel Corporation, 19.88, 0.31, 2008-10-15);
INSERT INTO `companies` VALUES (7, Exxon Mobil Corp, 68.10, -0.43, 2008-10-17);
如下圖所示建立工程:


數據庫配置文件如下:


classDATABASE_CONFIG
{
var$default=array(driver=>mysql,
connect=>mysql_connect,
host=>localhost,
login=>root,
password=>root,
database=>cake_ext,
prefix=>);


var$test=array(driver=>mysql,
connect=>mysql_connect,
host=>localhost,
login=>root,
password=>root,
database=>cake_ext,
prefix=>);
}
companies_controller.php:


<?php
classCompaniesControllerextendsAppController
{
var$name=Companies;


functionindex()
{
$this->set(companies,$this->Company->findAll());
}


functionview($id= null)
{
$this->Company->id =$id;
$this->set(company,$this->Company->read());
}
}
?>
company.php:



<?php
classCompanyextendsAppModel
{
var$name=Company;
}
?>
index.thtml:


<h1>Test companies</h1>
<table>
<tr>
<th>Id</th>
<th>company</th>
<th>price</th>
<th>change</th>
<th>last update</th>
</tr>
<?phpforeach($companiesas$company): ?>
<tr>
<td><?phpecho$company[Company][id]; ?></td>
<td>
<?phpecho$html->link($company[Company][company],”/companies/view/”.$company[Company][id]); ?>
</td>
<td><?phpecho$company[Company][price]; ?></td>
<td><?phpecho$company[Company][change]; ?></td>
<td><?phpecho$company[Company][lastudp]; ?></td>
</tr>
<?phpendforeach; ?>
</table>
view.thtml:


<h1>Company: <?phpecho$company[Company][company]?></h1>
<p><small>Id: <?phpecho$company[Company][id]?></small></p>
<p>Price: <?phpecho$company[Company][price]?></p>
<p>Change: <?phpecho$company[Company][change]?></p>
<p>LastUpdate: <?phpecho$company[Company][lastudp]?></p>
訪問http://localhost/cakephp/companies即可運行測試程序。



本代碼參考自官方自帶例子:http://book.cakephp.org/view/326/The-Cake-Blog-Tutorial

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *