这里声明一点，上例中不小心把数据库表中lastupd字段错打成lastudp，本例子予以更正。

除上诉字段数据库与上例一致。

工程仍沿用上例，如下图：

代码依次为：

database.php：与上例一致。

companies_controller.php：

1. <?php
2. class CompaniesController extends AppController
3. {
4. var $name = 'Companies';
6. function index()
7. {
8. $this->set('companies', $this->Company->findAll());
9. }
11. function view($id = null)
12. {
13. $this->Company->id = $id;
14. $this->set('company', $this->Company->read());
15. }
17. function add()
18. {
19. if (!emptyempty($this->data))
20. {
21. if ($this->Company->save($this->data))
22. {
23. $this->flash('Your post has been saved.','/companies');
24. }
25. }
26. }
28. function edit($id = null)
29. {
30. if (emptyempty($this->data))
31. {
32. $this->Company->id = $id;
33. $this->data = $this->Company->read();
34. }
35. else
36. {
37. if ($this->Company->save($this->data['Company']))
38. {
39. $this->flash('Your post has been updated.','/companies');
40. }
41. }
42. }
44. function delete($id)
45. {
46. $this->Company->del($id);
47. $this->flash('The post with id: '.$id.' has been deleted.', '/companies');
48. }
49. }
50. ?>

company.php：

1. <?php
2. class Company extends AppModel
3. {
4. var $name = 'Company';
6. var $validate = array(
7. 'company' => VALID_NOT_EMPTY,
8. 'price' => VALID_NOT_EMPTY,
9. 'change' => VALID_NOT_EMPTY,
10. 'lastupd' => VALID_NOT_EMPTY
11. );
12. }
13. ?>

index.thtml：

1. Test companies

2. <?php foreach ($companies as $company): ?>
   <?php endforeach; ?>

   Id	company	price	change	last update
   	<?php echo $html->link($company['Company']['company'], "/companies/view/".$company['Company']['id']); ?> <?php echo $html->link('Delete', "/companies/delete/{$company['Company']['id']}", null, 'Are you sure?')?>

4. <?php echo $html->link('add', "/companies/add"); ?>

view.thtml：

1. Company:

2. Id:

3. Price:

4. Change:

5. LastUpdate:

6. 
   
8. <?php echo $html->link('edit', "/companies/edit/".$company['Company']['id']); ?>

add.thtml：

1. Add Company

4. Company:
5. <?php echo $html->input('Company/company', array('size' => '40'))?>
6. <?php echo $html->tagErrorMsg('Company/company', 'Company is required.') ?>
9. Price:
10. <?php echo $html->input('Company/price', array('size' => '40'))?>
11. <?php echo $html->tagErrorMsg('Company/company', 'Price is required.') ?>
14. Change:
15. <?php echo $html->input('Company/change', array('size' => '40'))?>
16. <?php echo $html->tagErrorMsg('Company/change', 'Change is required.') ?>
19. Last Update:
20. <?php echo $html->input('Company/lastupd', array('size' => '40'))?>
21. <?php echo $html->tagErrorMsg('Company/lastupd', 'Last Update is required.') ?>
24. <?php echo $html->submit('Save') ?> <?php echo $html->link('return', "/companies/index"); ?>

edit.thtml：

1. Edit Company

3. <?php echo $html->hidden('Company/id'); ?>
5. Company:
6. <?php echo $html->input('Company/company', array('size' => '40'))?>
7. <?php echo $html->tagErrorMsg('Company/company', 'Company is required.') ?>
10. Price:
11. <?php echo $html->input('Company/price', array('size' => '40'))?>
12. <?php echo $html->tagErrorMsg('Company/company', 'Price is required.') ?>
15. Change:
16. <?php echo $html->input('Company/change', array('size' => '40'))?>
17. <?php echo $html->tagErrorMsg('Company/change', 'Change is required.') ?>
20. Last Update:
21. <?php echo $html->input('Company/lastupd', array('size' => '40'))?>
22. <?php echo $html->tagErrorMsg('Company/lastupd', 'Last Update is required.') ?>
25. <?php echo $html->submit('Save') ?> <?php echo $html->link('return', "/companies/index"); ?>

如此访问http://localhost/cakephp/companies即可测试代码。