• 欢迎访问搞代码网站,推荐使用最新版火狐浏览器和Chrome浏览器访问本网站!
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏搞代码吧

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

php 搞代码 4年前 (2022-01-25) 16次浏览 已收录 0个评论

首先建立数据库cake_ext,并执行如下sql文:

  1. CREATE TABLE `companies` (
  2. `id` int(11) NOT NULL auto_increment,
  3. `company` varchar(50) NOT NULL,
  4. `price` decimal(8,2) NOT NULL,
  5. `change` decimal(8,2) NOT NULL,
  6. `lastudp` date NOT NULL,
  7. PRIMARY KEY (`id`)
  8. ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  9. — —————————-
  10. — Records
  11. — —————————-
  12. INSERT INTO `companies` VALUES (‘1’, ‘3m Co’, ‘71.72’, ‘0.02’, ‘2008-10-21’);
  13. INSERT INTO `companies` VALUES (‘2’, ‘Alcoa Inc’, ‘29.01’, ‘0.42’, ‘2008-10-20’);
  14. INSERT INTO `companies` VALUES (‘3’, ‘AT&T Inc.’, ‘31.61’, ‘-0.48’, ‘2008-10-21’);
  15. INSERT INTO `companies` VALUES (‘4’, ‘Boeing Co.’, ‘75.43’, ‘0.53’, ‘2008-10-13’);
  16. INSERT INTO `companies` VALUES (‘5’, ‘United Technologies Corporation’, ‘63.26’, ‘0.55’, ‘2008-10-09’);
  17. INSERT INTO `companies` VALUES (‘6’, ‘Intel Corporation’, ‘19.88’, ‘0.31’, ‘2008-10-15’);
  18. INSERT INTO `companies` VALUES (‘7’, ‘Exxon Mobil Corp’, ‘68.10’, ‘-0.43’, ‘2008-10-17’);

如下图所示建立工程:

数据库配置文件如下:

  1. class DATABASE_CONFIG
  2. {
  3. var $default = array(‘driver’ => ‘mysql’,
  4. ‘connect’ => ‘mysql_connect’,
  5. ‘host’ => ‘localhost’,
  6. ‘login’ => ‘root’,
  7. ‘password’ => ‘root’,
  8. ‘database’ => ‘cake_ext’,
  9. 本@文来源[email protected]搞@^&代*@码网(搞代gaodaima码 ‘prefix’ => );
  10. var $test = array(‘driver’ => ‘mysql’,
  11. ‘connect’ => ‘mysql_connect’,
  12. ‘host’ => ‘localhost’,
  13. ‘login’ => ‘root’,
  14. ‘password’ => ‘root’,
  15. ‘database’ => ‘cake_ext’,
  16. ‘prefix’ => );
  17. }

companies_controller.php:

  1. <?php
  2. class CompaniesController extends AppController
  3. {
  4. var $name = ‘Companies’;
  5. function index()
  6. {
  7. $this->set(‘companies’, $this->Company->findAll());
  8. }
  9. function view($id = null)
  10. {
  11. $this->Company->id = $id;
  12. $this->set(‘company’, $this->Company->read());
  13. }
  14. }
  15. ?>

company.php:

  1. <?php
  2. class Company extends AppModel
  3. {
  4. var $name = ‘Company’;
  5. }
  6. ?>

index.thtml:

  1. Test companies

  2. <?php foreach ($companies as $company): ?>
  3. <?php endforeach; ?>
  4. Id company price change last update
    <?php echo $company[‘Company’][‘id’]; ?>
  5. <?php echo $html->link($company[‘Company’][‘company’], “/companies/view/”.$company[‘Company’][‘id’]); ?>
  6. <?php echo $company[‘Company’][‘price’]; ?> <?php echo $company[‘Company’][‘change’]; ?> <?php echo $company[‘Company’][‘lastudp’]; ?>

view.thtml:

  1. Company: <?php echo $company[‘Company’][‘company’]?>


  2. 搞代码网(gaodaima.com)提供的所有资源部分来自互联网,如果有侵犯您的版权或其他权益,请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected],我们会在看到邮件的第一时间内为您处理,或直接联系QQ:872152909。本网站采用BY-NC-SA协议进行授权
    转载请注明原文链接:攻克CakePHP系列二 表单数据显示_PHP

    喜欢 (0)
    [搞代码]
    分享 (0)
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址