| 導購 | 订阅 | 在线投稿
分享
 
 
 

攻克CakePHP系列三 表單數據增刪改

來源:互聯網  2008-12-18 07:52:19  評論

下面的代碼是CakePHP下對表單數據的增加,刪除,修改實現代碼

這裏聲明一點,上例中不小心把數據庫表中lastupd字段錯打成lastudp,本例子予以更正。

除上訴字段數據庫與上例一致。

工程仍沿用上例,如下圖:

代碼依次爲:

database.php:與上例一致。

companies_controller.php:

<?php

classCompaniesControllerextendsAppController

{

var$name='Companies';

functionindex()

{

$this->set('companies',$this->Company->findAll());

}

functionview($id= null)

{

$this->Company->id =$id;

$this->set('company',$this->Company->read());

}

functionadd()

{

if(!emptyempty($this->data))

{

if($this->Company->save($this->data))

{

$this->flash('Your post has been saved.','/companies');

}

}

}

functionedit($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');

}

}

}

functiondelete($id)

{

$this->Company->del($id);

$this->flash('The post with id: '.$id.' has been deleted.','/companies');

}

}

?>

company.php:

<?php

classCompanyextendsAppModel

{

var$name='Company';

var$validate=array(

'company'=> VALID_NOT_EMPTY,

'price'=> VALID_NOT_EMPTY,

'change'=> VALID_NOT_EMPTY,

'lastupd'=> VALID_NOT_EMPTY

);

}

?>

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>

<?phpforeach($companiesas$company): ?>

<tr>

<td><?phpecho$company['Company']['id']; ?></td>

<td>

<?phpecho$html->link($company['Company']['company'],"/companies/view/".$company['Company']['id']); ?>

<?phpecho$html->link('Delete',"/companies/delete/{$company['Company']['id']}", null,'Are you sure?')?>

</td>

<td><?phpecho$company['Company']['price']; ?></td>

<td><?phpecho$company['Company']['change']; ?></td>

<td><?phpecho$company['Company']['lastupd']; ?></td>

</tr>

<?phpendforeach; ?>

</table>

<p>

<?phpecho$html->link('add',"/companies/add"); ?>

</p>

view.thtml:

<h1>Company: <?phpecho$company['Company']['company']?></h1>

<p><small>Id: <?phpecho$company['Company']['id']?></small></p>

<p>Price: <?phpecho$company['Company']['price']?></p>

<p>Change: <?phpecho$company['Company']['change']?></p>

<p>LastUpdate: <?phpecho$company['Company']['lastupd']?></p>

<br/>

<p>

<?phpecho$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:

<?phpecho$html->input('Company/company',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/company','Company is required.') ?>

</p>

<p>

Price:

<?phpecho$html->input('Company/price',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/company','Price is required.') ?>

</p>

<p>

Change:

<?phpecho$html->input('Company/change',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/change','Change is required.') ?>

</p>

<p>

Last Update:

<?phpecho$html->input('Company/lastupd',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/lastupd','Last Update is required.') ?>

</p>

<p>

<?phpecho$html->submit('Save') ?> <?phpecho$html->link('return',"/companies/index"); ?>

</p>

</form>

edit.thtml:

<h1>Edit Company</h1>

<form method="post"action="<?php echo $html->url('/companies/edit')?>">

<?phpecho$html->hidden('Company/id'); ?>

<p>

Company:

<?phpecho$html->input('Company/company',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/company','Company is required.') ?>

</p>

<p>

Price:

<?phpecho$html->input('Company/price',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/company','Price is required.') ?>

</p>

<p>

Change:

<?phpecho$html->input('Company/change',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/change','Change is required.') ?>

</p>

<p>

Last Update:

<?phpecho$html->input('Company/lastupd',array('size'=>'40'))?>

<?phpecho$html->tagErrorMsg('Company/lastupd','Last Update is required.') ?>

</p>

<p>

<?phpecho$html->submit('Save') ?> <?phpecho$html->link('return',"/companies/index"); ?>

</p>

</form>

如此訪問http://localhost/cakephp/companies即可測試代碼。

下面的代碼是CakePHP下對表單數據的增加,刪除,修改實現代碼 這裏聲明一點,上例中不小心把數據庫表中lastupd字段錯打成lastudp,本例子予以更正。 除上訴字段數據庫與上例一致。 工程仍沿用上例,如下圖: 代碼依次爲: database.php:與上例一致。 companies_controller.php: <?php classCompaniesControllerextendsAppController { var$name='Companies'; functionindex() { $this->set('companies',$this->Company->findAll()); } functionview($id= null) { $this->Company->id =$id; $this->set('company',$this->Company->read()); } functionadd() { if(!emptyempty($this->data)) { if($this->Company->save($this->data)) { $this->flash('Your post has been saved.','/companies'); } } } functionedit($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'); } } } functiondelete($id) { $this->Company->del($id); $this->flash('The post with id: '.$id.' has been deleted.','/companies'); } } ?> company.php: <?php classCompanyextendsAppModel { var$name='Company'; var$validate=array( 'company'=> VALID_NOT_EMPTY, 'price'=> VALID_NOT_EMPTY, 'change'=> VALID_NOT_EMPTY, 'lastupd'=> VALID_NOT_EMPTY ); } ?> 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> <?phpforeach($companiesas$company): ?> <tr> <td><?phpecho$company['Company']['id']; ?></td> <td> <?phpecho$html->link($company['Company']['company'],"/companies/view/".$company['Company']['id']); ?> <?phpecho$html->link('Delete',"/companies/delete/{$company['Company']['id']}", null,'Are you sure?')?> </td> <td><?phpecho$company['Company']['price']; ?></td> <td><?phpecho$company['Company']['change']; ?></td> <td><?phpecho$company['Company']['lastupd']; ?></td> </tr> <?phpendforeach; ?> </table> <p> <?phpecho$html->link('add',"/companies/add"); ?> </p> view.thtml: <h1>Company: <?phpecho$company['Company']['company']?></h1> <p><small>Id: <?phpecho$company['Company']['id']?></small></p> <p>Price: <?phpecho$company['Company']['price']?></p> <p>Change: <?phpecho$company['Company']['change']?></p> <p>LastUpdate: <?phpecho$company['Company']['lastupd']?></p> <br/> <p> <?phpecho$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: <?phpecho$html->input('Company/company',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/company','Company is required.') ?> </p> <p> Price: <?phpecho$html->input('Company/price',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/company','Price is required.') ?> </p> <p> Change: <?phpecho$html->input('Company/change',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/change','Change is required.') ?> </p> <p> Last Update: <?phpecho$html->input('Company/lastupd',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/lastupd','Last Update is required.') ?> </p> <p> <?phpecho$html->submit('Save') ?> <?phpecho$html->link('return',"/companies/index"); ?> </p> </form> edit.thtml: <h1>Edit Company</h1> <form method="post"action="<?php echo $html->url('/companies/edit')?>"> <?phpecho$html->hidden('Company/id'); ?> <p> Company: <?phpecho$html->input('Company/company',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/company','Company is required.') ?> </p> <p> Price: <?phpecho$html->input('Company/price',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/company','Price is required.') ?> </p> <p> Change: <?phpecho$html->input('Company/change',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/change','Change is required.') ?> </p> <p> Last Update: <?phpecho$html->input('Company/lastupd',array('size'=>'40'))?> <?phpecho$html->tagErrorMsg('Company/lastupd','Last Update is required.') ?> </p> <p> <?phpecho$html->submit('Save') ?> <?phpecho$html->link('return',"/companies/index"); ?> </p> </form> 如此訪問[url=http://localhost/cakephp/companies]http://localhost/cakephp/companies[/url]即可測試代碼。
󰈣󰈤
王朝萬家燈火計劃
期待原創作者加盟
 
 
 
>>返回首頁<<
 
 
 
 
 熱帖排行
 
王朝網路微信公眾號
微信掃碼關註本站公眾號 wangchaonetcn
 
 
靜靜地坐在廢墟上,四周的荒凉一望無際,忽然覺得,淒涼也很美
© 2005- 王朝網路 版權所有