Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on May 13th, 2012  |  syntax: None  |  size: 0.86 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. <?php
  2.  
  3. // model for delete a post
  4. function delete_post($post_id, $user_id) {
  5.     $dbh = db_connect();
  6.     $stmt_delete = $dbh->prepare('DELETE FROM posts WHERE id = ? AND user_id = ?');
  7.  
  8.     if(!$stmt_delete->execute(array($post_id, $user_id))) {
  9.         return false;
  10.     } else {
  11.         return true;
  12.     }
  13. }
  14.  
  15. // new solution in model
  16.     $affected = $dbh->exec('DELETE FROM posts WHERE id = '. $post_id .' AND user_id = '. $user_id .'');
  17.  
  18.     if($affected == 1) {
  19.         return true;
  20.     } else {
  21.         return false;
  22.     }
  23.  
  24. // controller for deleting post
  25.     case 'delete':
  26.         check_authentication();
  27.         if(delete_post($params['id'], $_SESSION['user']['id'])) {
  28.             flash_notice('Successfully deleted post');
  29.             redirect_to('posts');
  30.         } else {
  31.             flash_notice('Could not delete post');
  32.         }
  33. ?>