官术网_书友最值得收藏!

首頁 >

CakePHP 2 Application Cookbook

Deleting records

Just as we can list and view records, as well as edit and create new ones, you'll also want to be familiar with how to delete records using CakePHP.

In this recipe, we'll create an action that allows us to delete records from our table.

Getting ready

As with the previous recipe, we'll continue using the products table and also extend the ProductsController that we created.

How to do it...

Perform the following steps:

  1. Add the following delete() method to the ProductsController class: 
    public function delete($id) {
  if (!$this->request->is('post')) {
    throw new MethodNotAllowedException();
  }
  if ($this->Product->delete($id)) {
    $this->Session->setFlash(__('Product removed: %s', $id));
    return $this->redirect(array('action' => 'index'));
  }
  $this->Session->setFlash(__('Could not remove product'));
  return $this->redirect($this->referer());
}
  2. Change the content of the index.ctp file to the following: 
    <h2><?php echo __('Products'); ?></h2>
<div>
  <?php echo $this->Html->link(__('Add new product'), array('action' => 'add')); ?>
</div>
<table>
  <tr>
    <th><?php echo $this->Paginator->sort('id'); ?></th>
    <th><?php echo $this->Paginator->sort('name'); ?></th>
    <th><?php echo $this->Paginator->sort('created'); ?></th>
    <th><?php echo __('Actions'); ?></th>
  </tr>
  <?php foreach ($products as $product): ?>
    <tr>
      <td><?php echo $product['Product']['id']; ?></td>
      <td><?php echo $this->Html->link($product['Product']['name'], array('action' => 'view', $product['Product']['id'])); ?></td>
      <td><?php echo $this->Time->nice($product['Product']['created']); ?></td>
      <td>
        <?php
        echo $this->Html->link(__('Edit'), array('action' => 'edit', $product['Product']['id']));
        echo $this->Form->postLink(__('Delete'), array('action' => 'delete', $product['Product']['id']), array('confirm' => 'Delete this product?'));
        ?>
      </td>
    </tr>
  <?php endforeach; ?>
</table>
<div>
  <?php echo $this->Paginator->counter(array('format' => __('Page {:page} of {:pages}, showing {:current} records out of {:count} total, starting on record {:start}, ending on {:end}'))); ?>
</div>
<div>
  <?php
  echo $this->Paginator->prev(__('< previous'), array(), null, array('class' => 'prev disabled'));
  echo $this->Paginator->numbers(array('separator' => ''));
echo $this->Paginator->next(__('next >'), array(), null, array('class' => 'next disabled'));
  ?>
</div>

How it works...

In this recipe, we added a delete() method to our ProductsController class. This first checks whether the HTTP method used to call the action was POST. In the event it wasn't, we throw a MethodNotAllowedException exception, which is presented as an error page when it is thrown from an action. This is to protect our application against attempts to delete data via a simple URL. If the HTTP method is correct, we proceed to call the delete() method on the Product model, passing to it the ID of the record to delete. If it is successful, we call the setFlash() method on our Session component with a message confirming the removal or with a failure message if the delete() method fails. Finally, we redirect the request to the index() action if the record was deleted successfully—if not, then we are redirecting the user back to the URL where the delete() method was called from. It may also be worth mentioning that the delete() action itself doesn't have a view associated with it, as nothing is displayed to the user as part of the request.

We then returned to the index.ctp view to add an option to delete a product using the postLink() method of the Form helper. This creates a form with a link that allows us to use POST when clicking on the link which submits the form. You will notice that this takes a third argument, which is an array with a confirm key. This prompts the user to confirm the action before submitting the request to delete the record. This is always recommended when dealing with actions that delete records, in case of a mistake on the user's behalf.

See also

主站蜘蛛池模板： 民权县| 宕昌县| 信宜市| 黄骅市| 靖西县| 白河县| 金湖县| 阳谷县| 博乐市| 靖安县| 古蔺县| 东乡| 鄱阳县| 延安市| 九龙坡区| 金阳县| 屏东县| 南宫市| 额尔古纳市| 万源市| 永福县| 钦州市| 明溪县| 普格县| 蓝田县| 武鸣县| 丹棱县| 乾安县| 富蕴县| 乐业县| 许昌县| 鲜城| 凯里市| 漳浦县| 乌鲁木齐市| 高州市| 福海县| 昌邑市| 夏津县| 岐山县| 土默特右旗|