攻克CakePHP系列三表单数据增删改

下面的代码是CakePHP下对表单数据的增加，删除，修改实现代码

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

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

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

代码依次为：

database.php：与上例一致。

companies_controller.php：

company.php：

index.thtml：

<h1>Test companies</h1>
<table>
<tr>
<th>Id</th>
<th>company</th>
<th>price</th>
<th>change</th>
<th>last update</th>
</tr>
<?php foreach ($companies as $company): ?>
<tr>
<td><?php echo $company['Company']['id']; ?></td>
<td>
<?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?')?>
</td>
<td><?php echo $company['Company']['price']; ?></td>
<td><?php echo $company['Company']['change']; ?></td>
<td><?php echo $company['Company']['lastupd']; ?></td>
</tr>
<?php endforeach; ?>
</table>
<p>
<?php echo $html->link('add', "/companies/add"); ?>
</p>

view.thtml：

<h1>Company: <?php echo $company['Company']['company']?></h1>
<p><small>Id: <?php echo $company['Company']['id']?></small></p>
<p>Price: <?php echo $company['Company']['price']?></p>
<p>Change: <?php echo $company['Company']['change']?></p>
<p>LastUpdate: <?php echo $company['Company']['lastupd']?></p>
<br/>
<p>
<?php echo $html->link('edit', "/companies/edit/".$company['Company']['id']); ?>
</p>

add.thtml：

<h1>Add Company</h1>
<form method="post" action="<?php echo $html->url('/companies/add')?>">
<p>
Company:
<?php echo $html->input('Company/company', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/company', 'Company is required.') ?>
</p>
<p>
Price:
<?php echo $html->input('Company/price', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/company', 'Price is required.') ?>
</p>
<p>
Change:
<?php echo $html->input('Company/change', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/change', 'Change is required.') ?>
</p>
<p>
Last Update:
<?php echo $html->input('Company/lastupd', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/lastupd', 'Last Update is required.') ?>
</p>
<p>
<?php echo $html->submit('Save') ?> <?php echo $html->link('return', "/companies/index"); ?>
</p>
</form>

edit.thtml：

<h1>Edit Company</h1>
<form method="post" action="<?php echo $html->url('/companies/edit')?>">
<?php echo $html->hidden('Company/id'); ?>
<p>
Company:
<?php echo $html->input('Company/company', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/company', 'Company is required.') ?>
</p>
<p>
Price:
<?php echo $html->input('Company/price', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/company', 'Price is required.') ?>
</p>
<p>
Change:
<?php echo $html->input('Company/change', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/change', 'Change is required.') ?>
</p>
<p>
Last Update:
<?php echo $html->input('Company/lastupd', array('size' => '40'))?>
<?php echo $html->tagErrorMsg('Company/lastupd', 'Last Update is required.') ?>
</p>
<p>
<?php echo $html->submit('Save') ?> <?php echo $html->link('return', "/companies/index"); ?>
</p>
</form>