Conquer CakePHP series two-form data display

First, create the database cake_ext and execute the following SQL:

2. Create Table 'companys '(
4. 'Id' int (11) not null auto_increment,
6. 'Company' varchar (50) not null,
8. 'Price' decimal (8, 2) not null,
10. 'Change' decimal (8, 2) not null,
12. 'Lastup' date not null,
14. Primary Key ('id ')
16. )Engine=MyISAM Auto_increment=8DefaultCharset=Utf8;
20. ------------------------------
22. -- Records
24. ------------------------------
26. Insert into 'companys' values ('1', '3 M co', '71. 72 ', '0. 02', '2017-10-21 ');
28. Insert into 'companys' values ('2', 'alcoa inc', '29. 01', '0. 42', '2017-10-20 ');
30. Insert into 'companys' values ('3', 'at & T Inc. ', '31. 61', '-0.48', '2017-10-21 ');
32. Insert into 'companys' values ('4', 'boeing Co. ', '75. 43', '0. 53', '2017-10-13 ');
34. Insert into 'companys' values ('5', 'United Technologies Corporation ', '63. 26', '0. 55', '2017-10-09 ');
36. Insert into 'companys' values ('6', 'intel Corporation ', '19. 88', '0. 31', '2017-10-15 ');
38. Insert into 'companys' values ('7', 'exxon Mobil Corp ', '68. 10','-100', '2017-10-17 ');

Create a project as shown in:

The database configuration file is as follows:

2. ClassDatabase_config
4. {
6. VaR $ Default=Array('Driver'=>'Mysql',
8. 'Connect'=>'Mysql _ connect',
10. 'Host'=>'Localhost',
12. 'Login'=>'Root',
14. 'Password'=>'Root',
16. 'Database'=>'Cake _ ext',
18. 'Prefix'=>'');
22. VaR $ Test=Array('Driver'=>'Mysql',
24. 'Connect'=>'Mysql _ connect',
26. 'Host'=>'Localhost',
28. 'Login'=>'Root',
30. 'Password'=>'Root',
32. 'Database'=>'Cake _ ext',
34. 'Prefix'=>'');
36. }

Companies_controller.php:

2. <? PHP
4. ClassCompaniescontrollerExtendsAppcontroller
6. {
8. VaR $ Name='Companys';
12. FunctionIndex ()
14. {
16. $ This-> Set ('Companys',$ This-> Company-> findall ());
18. }
22. FunctionView ($ ID= NULL)
24. {
26. $ This-> Company-> id =$ ID;
28. $ This-> Set ('Company',$ This-> Company-> Read ());
30. }
32. }
34. ?>

Company. php:

1. <? PHP
2. ClassCompanyExtendsAppmodel
3. {
4. VaR $ Name='Company';
5. }
6. ?>

Index. thtml:

2. <H1> test companies
4. <Table>
6. <Tr>
8. <TH> id </Th>
10. <TH> company </Th>
12. <TH> price </Th>
14. <TH> change </Th>
16. <TH> last update </Th>
18. </Tr>
20. <? PHPForeach($ Companies As $ Company):?>
22. <Tr>
24. <TD> <? PHPEcho $ Company['Company'] ['Id'];?> </TD>
26. <TD>
28. <? PHPEcho $ Html-> Link ($ Company['Company'] ['Company'],"/Companies/View /".$ Company['Company'] ['Id']);?>
30. </TD>
32. <TD> <? PHPEcho $ Company['Company'] ['Price'];?> </TD>
34. <TD> <? PHPEcho $ Company['Company'] ['Change'];?> </TD>
36. <TD> <? PHPEcho $ Company['Company'] ['Lastup'];?> </TD>
38. </Tr>
40. <? PHPEndforeach;?>
42. </Table>

View. thtml:

2. <H1> company: <? PHPEcho $ Company['Company'] ['Company']?> </H1>
4. <P> <small> ID: <? PHPEcho $ Company['Company'] ['Id']?> </Small> </P>
6. <P> price: <? PHPEcho $ Company['Company'] ['Price']?> </P>
8. <P> change: <? PHPEcho $ Company['Company'] ['Change']?> </P>
10. <P> lastupdate: <? PHPEcho $ Company['Company'] ['Lastup']?> </P>

Access http: // localhost/CakePHP/companies to run the test.Program.

BenCodeReference from the official example: http://book.cakephp.org/view/326/The-Cake-Blog-Tutorial