這里聲明一點,上例中不小心把數(shù)據(jù)庫表中l(wèi)astupd字段錯打成lastudp,本例子予以更正。
除上訴字段數(shù)據(jù)庫與上例一致。
工程仍沿用上例,如下圖:
代碼依次為:
database.php:與上例一致。
companies_controller.php:
-
class?CompaniesController?extends?AppController
-
{
-
????var?$name?=?'Companies';
-
????
-
????function?index()
-
????{
-
????????$this->set('companies',?$this->Company->findAll());
-
????}
-
????
-
????function?view($id?=?null)
-
????{
-
????????$this->Company->id?=?$id;
-
????????$this->set('company',?$this->Company->read());
-
????}
-
????
-
????function?add()
-
????{
-
????????if?(!emptyempty($this->data))
-
????????{
-
????????????if?($this->Company->save($this->data))
-
????????????{
-
????????????????$this->flash('Your?post?has?been?saved.','/companies');
-
????????????}
-
????????}
-
????}
-
????
-
????function?edit($id?=?null)
-
????{
-
????????if?(emptyempty($this->data))
-
????????{
-
????????????$this->Company->id?=?$id;
-
????????????$this->data?=?$this->Company->read();
-
????????}
-
????????else
-
????????{
-
????????????if?($this->Company->save($this->data['Company']))
-
????????????{
-
????????????????$this->flash('Your?post?has?been?updated.','/companies');
-
????????????}
-
????????}
-
????}
-
????
-
????function?delete($id)
-
????{
-
????????$this->Company->del($id);
-
????????$this->flash('The?post?with?id:?'.$id.'?has?been?deleted.',?'/companies');
-
????}
-
}
- ?>
company.php:
-
class?Company?extends?AppModel
-
{
-
????var?$name?=?'Company';
-
????
-
????var?$validate?=?array(
-
????????'company'?=>?VALID_NOT_EMPTY,
-
????????'price'???=>?VALID_NOT_EMPTY,
-
????????'change'??=>?VALID_NOT_EMPTY,
-
????????'lastupd'?=>?VALID_NOT_EMPTY
-
????);
-
}
- ?>
index.thtml:
-
Test?companies
-
-
-
Id |
-
company |
-
price |
-
change |
-
last?update |
- foreach?($companies?as?$company):??>
-
-
echo?$company['Company']['id'];??>
|
-
- echo?$html->link($company['Company']['company'],?"/companies/view/".$company['Company']['id']);??>
-
????
- echo?$html->link('Delete',?"/companies/delete/{$company['Company']['id']}",?null,?'Are?you?sure?')?>
|
-
echo?$company['Company']['price'];??>
|
-
echo?$company['Company']['change'];??>
|
-
echo?$company['Company']['lastupd'];??>
|
- endforeach;??>??
-
- echo?$html->link('add',?"/companies/add");??>
view.thtml:
-
Company:?echo?$company['Company']['company']?>
-
id:?echo?$company['company']['id']?>
-
Price:?echo?$company['Company']['price']?>
-
Change:?echo?$company['Company']['change']?>
-
LastUpdate:?echo?$company['Company']['lastupd']?>
-
-
- echo?$html->link('edit',?"/companies/edit/".$company['Company']['id']);??>
add.thtml:
edit.thtml:
如此訪問http://localhost/cakephp/companies即可測試代碼。