攻克CakePHP系列二表单数据显示

首先建立数据库cake_ext，并执行如下sql文：

CREATETABLE`companies`( 
`id`int(11)NOTNULLauto_increment, 
`company`varchar(50)NOTNULL, 
`price`decimal(8,2)NOTNULL, 
`change`decimal(8, 
`lastudp`dateNOTNULL, 
PRIMARYKEY(`id`) 
)ENGINE=MyISAMAUTO_INCREMENT=8DEFAULTCHARSET=utf8; 

------------------------------ 
--Records 
------------------------------ 
INSERTINTO`companies`VALUES('1','3mCo','71.72','0.02','2008-10-21'); 
INSERTINTO`companies`VALUES('2','AlcoaInc','29.01','0.42','2008-10-20'); 
INSERTINTO`companies`VALUES('3','AT&TInc.','31.61','-0.48','2008-10-21'); 
INSERTINTO`companies`VALUES('4','BoeingCo.','75.43','0.53','2008-10-13'); 
INSERTINTO`companies`VALUES('5','UnitedTechnologiesCorporation','63.26','0.55','2008-10-09'); 
INSERTINTO`companies`VALUES('6','IntelCorporation','19.88','0.31','2008-10-15'); 
INSERTINTO`companies`VALUES('7','ExxonMobilCorp','68.10','-0.43','2008-10-17');

如下图所示建立工程：

数据库配置文件如下：

class
DATABASE_CONFIG
{
var
$default=
array
(@H_403_149@'driver'=>@H_403_149@'MysqL',
@H_403_149@'connect'=>@H_403_149@'MysqL_connect',
@H_403_149@'host'=>@H_403_149@'localhost',
@H_403_149@'login'=>@H_403_149@'root',
@H_403_149@'password'=>@H_403_149@'root',
@H_403_149@'database'=>@H_403_149@'cake_ext',
@H_403_149@'prefix'=>@H_403_149@'');
var
$test=
array
(@H_403_149@'driver'=>@H_403_149@'MysqL',
@H_403_149@'prefix'=>@H_403_149@'');
}

companies_controller.PHP：

PHP 
classCompaniesControllerextendsAppController 
{ 
var$name=@H_403_149@'Companies'; 
 
functionindex() 
{ 
$this->set(@H_403_149@'companies',$this->Company->findAll()); 
} 
 
functionview($id=null) 
{ 
$this->Company->id=$id; 
$this->set(@H_403_149@'company',$this->Company->read()); 
} 
} 
?>

company.PHP：

PHP
class
Company
extends
AppModel
{
var
$name=@H_403_149@'Company';
}
?>

index.thtml：

Testcompanies 
 
 
Id 
company 
price 
change 
lastupdate 
 
PHPforeach($companiesas$company):?> 
 
PHPecho$company[@H_403_149@'Company'][@H_403_149@'id'];?> 
 
PHPecho$html->link($company[@H_403_149@'Company'][@H_403_149@'company'],@H_403_149@"/companies/view/".$company[@H_403_149@'Company'][@H_403_149@'id']);?> 
 
PHPecho$company[@H_403_149@'Company'][@H_403_149@'price'];?> 
PHPecho$company[@H_403_149@'Company'][@H_403_149@'change'];?> 
PHPecho$company[@H_403_149@'Company'][@H_403_149@'lastudp'];?> 
 
PHPendforeach;?> 

view.thtml：

Company:PHPecho$company[@H_403_149@'Company'][@H_403_149@'company']?>
Id:PHPecho$company[@H_403_149@'Company'][@H_403_149@'id']?>
Price:PHPecho$company[@H_403_149@'Company'][@H_403_149@'price']?>
Change:PHPecho$company[@H_403_149@'Company'][@H_403_149@'change']?>
LastUpdate:PHPecho$company[@H_403_149@'Company'][@H_403_149@'lastudp']?>

访问http://localhost/cakePHP/companies即可运行测试程序。

本代码参考自官方自带例子：http://book.cakephp.org/view/326/The-Cake-Blog-Tutorial

攻克CakePHP系列二 表单数据显示

class

var

array

var

array

class

extends

var

function

function

class

extends

var

Testcompanies

foreach

as

endforeach

Company:PHPecho$company[@H_403_149@'Company'][@H_403_149@'company']?>

猜你在找的PHP相关文章

攻克CakePHP系列二表单数据显示