
Untitled
By: a guest on
May 13th, 2012 | syntax:
None | size: 0.86 KB | hits: 14 | expires: Never
<?php
// model for delete a post
function delete_post($post_id, $user_id) {
$dbh = db_connect();
$stmt_delete = $dbh->prepare('DELETE FROM posts WHERE id = ? AND user_id = ?');
if(!$stmt_delete->execute(array($post_id, $user_id))) {
return false;
} else {
return true;
}
}
// new solution in model
$affected = $dbh->exec('DELETE FROM posts WHERE id = '. $post_id .' AND user_id = '. $user_id .'');
if($affected == 1) {
return true;
} else {
return false;
}
// controller for deleting post
case 'delete':
check_authentication();
if(delete_post($params['id'], $_SESSION['user']['id'])) {
flash_notice('Successfully deleted post');
redirect_to('posts');
} else {
flash_notice('Could not delete post');
}
?>