攻克CakePHP系列三表单数据增删改_PHP教程-tutorial php-php.cn

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

WBOY

Lepaskan： 2016-07-21 15:49:11

asal

914 orang telah melayarinya

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

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

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

代码依次为：

database.php：与上例一致。

companies_controller.php：

 
class CompaniesController extends AppController 

{ 

    var $name = 'Companies'; 

    function index() 

    { 

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

    } 

    function view($id = null) 

    { 

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

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

    } 

    function add() 

    { 

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

        { 

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

            { 

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

            } 

        } 

    } 

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

            } 

        } 

    } 

    function delete($id) 

    { 

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

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

    } 

} 
?>

company.php：

 
class Company extends AppModel 

{ 

    var $name = 'Company'; 

    var $validate = array( 

        'company' => VALID_NOT_EMPTY, 

        'price'   => VALID_NOT_EMPTY, 

        'change'  => VALID_NOT_EMPTY, 

        'lastupd' => VALID_NOT_EMPTY 

    ); 

} 
?>

index.thtml：

Test companies

foreach ($companies as $company): ?>

endforeach; ?>

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

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

view.thtml：

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

add.thtml：

Add Company
"post" action="url('/companies/add')?>">

Company:

echo $html->input('Company/company', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/company', 'Company is required.') ?>

Price:

echo $html->input('Company/price', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/company', 'Price is required.') ?>

Change:

echo $html->input('Company/change', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/change', 'Change is required.') ?>

Last Update:

echo $html->input('Company/lastupd', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/lastupd', 'Last Update is required.') ?>

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

edit.thtml：

Edit Company
"post" action="url('/companies/edit')?>">
echo $html->hidden('Company/id'); ?>

Company:

echo $html->input('Company/company', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/company', 'Company is required.') ?>

Price:

echo $html->input('Company/price', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/company', 'Price is required.') ?>

Change:

echo $html->input('Company/change', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/change', 'Change is required.') ?>

Last Update:

echo $html->input('Company/lastupd', array('size' => '40'))?>
echo $html->tagErrorMsg('Company/lastupd', 'Last Update is required.') ?>

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