PHP Comment::find_by_id方法代码示例

 /**
  * Comments list
  *
  * @param $request
  * @return mixed
  */
 public function comments_list($request)
 {
     // Delete page
     if ($request->get('delete')) {
         $delete = $request->get('delete');
         if ($delete != 'all') {
             $comment = \Comment::find_by_id(intval($delete));
             if ($comment) {
                 // Delete child comments
                 \Comment::table()->delete('parent_id = ' . $comment->id);
                 if ($comment->delete()) {
                     $this->view->assign('message', $this->lang->translate('form.deleted'));
                 }
             }
         } else {
             \Comment::table()->delete('1');
             $this->view->assign('message', $this->lang->translate('form.deleted'));
         }
     }
     // Filter
     $filter = [];
     if ($request->get('author')) {
         $author = \User::find($request->get('author'));
         if ($author) {
             $filter['conditions'] = ['author_id = ?', $author->id];
         }
     }
     $filter['order'] = 'id DESC';
     if ($request->order) {
         $filter['order'] = $request->order;
     }
     /** @var Listing $paginator */
     $paginator = NCService::load('Paginator.Listing', [$request->page, \Comment::count('all')]);
     $filter = array_merge($filter, $paginator->limit());
     // Filter users
     $comments = \Comment::all($filter);
     $comments = \Comment::as_array($comments);
     return $this->view->render('comment/list.twig', ['title' => $this->lang->translate('comment.list'), 'comments_list' => $comments, 'listing' => $paginator->pages(), 'page' => $paginator->cur_page]);
 }

<?php

require_once "../../includes/initialize.php";
if (!$session->is_logged_in()) {
    redirect_to("login.php");
}
// must have an ID
if (empty($_GET['id'])) {
    $session->message("No comment ID was provided.");
    redirect_to('index.php');
}
$comment = Comment::find_by_id($_GET['id']);
if ($comment && $comment->delete()) {
    $session->message("The comment was deleted.");
    redirect_to("comments.php?id={$comment->photograph_id}");
} else {
    $session->message("The comment could not be deleted.");
    redirect_to('list_photos.php');
}
if (isset($database)) {
    $database->close_connection();
}

<?php

require_once "../../includes/initialize.php";
if (!$session->is_logged_in()) {
    redirect_to("login.php");
}
// must have an ID
if (empty($_GET['comment_id'])) {
    $session->message("No comment ID was provied.");
    redirect("index.php");
}
// check if passed comment id exists.
$comment = Comment::find_by_id($_GET["comment_id"]);
if ($comment && $comment->delete()) {
    //$session->message("The comment {$comment->filename} was deleted.");
    redirect_to("comments.php?id={$_GET['photo_id']}");
} else {
    $session->message("The comments could not be deleted.");
    redirect_to("list_photos.php");
}
if (isset($database)) {
    $database->close_connection();
}

<?php

include "includes/header.php";
?>

<?php 
if (!$session->is_signedin() || !isset($_GET['id'])) {
    header("Location: login.php");
} else {
    $id = $_GET['id'];
}
?>

<?php 
if (isset($_POST['submit-yes'])) {
    $comment = Comment::find_by_id($id);
    if (!$comment) {
        header("Location: comments.php");
    }
    $comment->delete("comment");
    header("Location:comments.php");
}
if (isset($_POST['submit-no'])) {
    header("Location: comments.php");
}
?>
        <!-- Navigation -->
        
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
            <!-- Brand and toggle get grouped for better mobile display -->          
    <?php 

    } else {
        //the comment did not save successfully, for whatever reason
        $session->message("Your comment was not added successfully.");
        redirect_head(current_url());
        //redirect back to itself
    }
}
//FLAG NEW COMMENTS HERE
if (isset($_GET['flag_comment_wk'])) {
    //make sure user has access to do this
    if (!$session->is_logged_in) {
        $session->message("You do not have sufficient rights to flag this comment.");
        redirect_head(ROOT_URL . file_name_without_get() . "?pet_wk=" . $_GET['pet_wk']);
    }
    //first, make sure the comment exists
    $comment_to_flag = Comment::find_by_id($_GET['flag_comment_wk']);
    if (!$comment_to_flag) {
        //if the item does not exist in the database
        $session->message("You must've clicked on a bad URL; please try again.");
        redirect_head(ROOT_URL . file_name_without_get() . "?pet_wk=" . $_GET['pet_wk']);
    }
    //now we make sure the comment is not already flagged
    if ($comment_to_flag->is_flagged == '1') {
        $session->message("That comment is already flagged.");
        redirect_head(ROOT_URL . file_name_without_get() . "?pet_wk=" . $_GET['pet_wk']);
    }
    //if we're here, go ahead and flag the comment
    $comment_to_flag->is_flagged = 1;
    if ($comment_to_flag->save()) {
        $session->message("The comment was successfully flagged.");
        redirect_head(ROOT_URL . file_name_without_get() . "?pet_wk=" . $_GET['pet_wk']);

<?php

require_once '../../includes/initialize.php';
if (!$session->is_logged_in()) {
    redirect("login.php");
}
if (!isset($_GET['commentid'])) {
    redirect('index.php');
}
if ($comment = Comment::find_by_id($_GET['commentid'])) {
    if ($comment && $comment->delete()) {
        $session->set_get_message('Comment Was Deleted Successfully');
        redirect("photo_comment.php?commentid={$comment->photograph_id}");
    } else {
        $session->set_get_message('Comment Was Not Deleted');
        redirect('view_photograph.php');
    }
}