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, primary key (`id`) ) engine=myisam auto_increment=8 default charset=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');
如下图所示建立工程：
数据库配置文件如下：
class database_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：
set('companies', $this->company->findall()); } function view($id = null) { $this->company->id = $id; $this->set('company', $this->company->read()); } } ?>
company.php：
index.thtml：
test companies id company price change last update
link($company['company']['company'], /companies/view/.$company['company']['id']); ?>
view.thtml：
company: id:
price:
change:
lastupdate:
访问http://localhost/cakephp/companies即可运行测试程序。
本代码参考自官方自带例子：http://book.cakephp.org/view/326/the-cake-blog-tutorial
http://www.bkjia.com/phpjc/319623.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/319623.htmltecharticle首先建立数据库cake_ext，并执行如下sql文： createtable`companies`( `id`int(11)notnullauto_increment, `company`varchar(50)notnull, `price`decimal(8,2)notnull, `change`...