Show user comments dan reply comments

Updated: 02 Sep, 2021 • 0 • min read

Table of Contents

sepertinya saya hanya membuat code buat kamu jika kamu hanya melakukan copy paste
tidak adil...😭

jadi ayo sama-sama kita pusing 😓😓
➖➖➖➖➖➖➖➖➖➖➖➖➖➖

ini artikel yang akan dibentangkan

1.forum_topic/ public post

2.forum_topic_reply

ini dia contoh forum_topic_reply.sql

forum_topic_reply_by_id`
forum_topic_reply_name
forum_topic_reply_created_by
berkut ini table yang akan bekerja beberapa mereka bertugas sebagai pengenal seperti _reply_by_id';
yang akan mengenalkan kepada table forum_topic
forum_topic reply_name
index $username by user view user comments letakan di forum_topic.php
seperti ini contoh:
dan untuk imput _reply gunakan pagilan includ magic call
letakan disana agar sesuia

<?php   session_start(); include '_database/database.php';     $user_username = $_SESSION['user_username'];     $sql = "SELECT * FROM user where user_username='$user_username'";     $result = mysqli_query($database,$sql) or die(mysqli_error($database));      $row = mysqli_fetch_array($result);     $forum_topic_id = mysqli_real_escape_string($database,$_REQUEST['forum_topic_id']);     $sql = "SELECT * FROM forum_topic where forum_topic_id = '$forum_topic_id'";     $result = mysqli_query($database,$sql);     $rws = mysqli_fetch_array($result);     $temp_user_username = $rws['forum_topic_created_by'];     $sql_search_username = "SELECT * FROM user WHERE user_username = '$temp_user_username'";     $result_search_username = mysqli_query($database,$sql_search_username) or die(mysqli_error($database));     $rws_search_username = mysqli_fetch_array($result_search_username);     $user_eye_id = $_POST['user_eye_id']; $user_eye_name = $_POST['user_eye_name']; $user_eye_body = $_POST['user_eye_body'] = $rws ['forum_topic_body']; $user_eye_pic = $_POST['user_eye_pic'] = $row ['user_avatar']; $query = "INSERT INTO user_eye VALUES('".$user_eye_id."', '".$user_eye_name."', '".$user_eye_body."' ,CURRENT_TIMESTAMP ,'".$user_eye_pic."')"; $sql = mysqli_query($database, $query); ?><body>        <div class="container">            <div class="panel panel-default">                <div class="panel-body">                    <h1></h1><br>                    <div class="well">                        <div class="row clearfix">                            <div class="col-md-1 column">                                <img src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>"style="  width: 90px;  height: 75px;  border: none;  box-shadow:3px 3px 3px 3px #ADC2B3;"/><span  style="font-size: 37px;co or: black;"> <?php echo $rws_search_username['user_firstname'];?> <?php echo $rws_search_username['user_lastname'];?>                                <hr/></div><i class=""style="font-size: 32px;co or: black;"> <?php echo $rws['forum_topic_name']; ?>                                                                <div class="topic-body"></i><i class=""  style="font-size: 29px;co or: black;">                                    <?php echo $rws['forum_topic_body'];?></i>                                </div><div class="forum-attachment">                                    <?php                                         if($rws['forum_topic_image']){                                     ?>                                                                        <div class="col-md-3 column">                                        <img src="userfiles/uploads/<?php echo $rws['forum_topic_image'];?>"  class="img-responsive thumbnail">                                    </div><?php                                    }                                     ?>                                </div><?php  $servername = "localhost";  $username = "root";  $password = "kangdeny11";  $dbname = "userprofile"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);  }  $sql = "SELECT count(*) as count from user_eye where user_eye_body='$user_eye_body'";  $result = $conn->query($sql);  if ($result->num_rows > 0) {  $row = $result->fetch_assoc();  ?>                            </div></div><?php echo" <i class='fa fa-eye' style='font-size:19px;color:black;'> ".$row['count']."</i>"; } else { echo "0 results"; } $conn->close() ?>          <?php  $servername = "localhost";  $username = "root";  $password = "kangdeny11";  $dbname = "userprofile"; $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);  }  $sql = "SELECT count(*) as count from forum_topic_reply where forum_topic_reply_topic_id = '$forum_topic_id'"; $result = $conn->query($sql);  if ($result->num_rows > 0) {  $row = $result->fetch_assoc();  echo" <i class='fa fa-comments' style='font-size:19px;color:black;'> ".$row['count']."</i>";  } else { echo "0 results"; } $conn->close() ?>  </i>  <?php include 'controllers/form/forum-topic-reply-form.php' ;?><?php      $sql_reply = "SELECT * FROM forum_topic_reply where forum_topic_reply_topic_id = '$forum_topic_id'";     $result_reply = mysqli_query($database,$sql_reply);     $rws_reply_count = mysqli_num_rows($result_reply);     while($rws_reply = mysqli_fetch_array($result_reply)){                  $temp_user_username_reply = $rws_reply['forum_topic_reply_created_by'];         $sql_search_username_reply = "SELECT * FROM user WHERE user_username = '$temp_user_username_reply'";         $result_search_username_reply = mysqli_query($database,$sql_search_username_reply);          $rws_search_username_reply = mysqli_fetch_array($result_search_username_reply);  ?> <?php         if($rws_reply_count > 0){ ?>                    <div class="well">                        <div class="row clearfix">                            <div class="col-md-1 column">  <img src="userfiles/avatars/<?php echo $rws_reply['forum_topic_reply_topic'];?>" alt="<?php echo $rws_reply['forum_topic_reply_created_to'];?>"width="50px" right="50px">  <a href="profile.php?user_username=<?php echo $rws_reply['forum_topic_reply_created_to'];?> "><span  style="font-size: 29px;co or: black;"><?php echo $rws_reply['forum_topic_reply_created_to'];?></a> <span style="font-size: 32px;co or: black;"> :<?php echo $rws_reply['forum_topic_reply_body'];?>                                </div></div><div class="forum-attachment">                                    <?php                                         if($rws_reply['forum_topic_reply_image']){                                     ?>                                    <hr/>                                    <div class="col-md-3 column">                                        <img src="userfiles/uploads/<?php echo $rws_reply['forum_topic_reply_image'];?>"  class="img-responsive thumbnail">                                    </div><?php                                         }                                     ?>                                </div></div></div></li></ul></div>       </div></div>                    </div><?php             }     } ?>                  <?php     session_start();     require '_database/database.php';     if($_SESSION['user_username']){ ?>                    <br>                    <div class="container">                        <div class="row clearfix">                        </div></div></div></div></div><?php     }     else{ ?>                    <div class="well">                        <div class="row clearfix">                            <div class="col-md-12 column">                                <h3 class="text-center">You need to <a href="login.php">Log In</a> or <a href="register.php">Register</a> to post comments.</h3></div></div></div><?php     } ?>

input magic call
include 'forum_topic_reply.php

guery myrow view user comment berdasarkan forum_id
$sql_reply = "SELECT * FROM forum_topic_reply where forum_topic_reply_topic_id = '$forum_topic_id'";

letakan file pada folder root server
jangan lupa untuk penulisan input dalam jangkauan guery myrow
dan guery myrws
karena input juga memainkan tipuan guery myrow
seperti username
dan forum_topic_created_by

<?php     $current_user = $_SESSION['user_username'];     $sql = "SELECT * FROM user WHERE user_username='$current_user'";     $result = mysqli_query($database,$sql);     while($row = mysqli_fetch_array($result,MYSQLI_BOTH)) { ?> <form action="components/forum-topic-reply.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm">        <label for="forum_topic_reply_created_created_to"></label><input type="hidden"  value="<?php echo $row['user_username'];?>" name="forum_topic_reply_created_to"/> <input type="hidden"  value="<?php echo $row['user_avatar'];?>" name="forum_topic_reply_topic"/>       <***textarea id="forum-topic-reply-body" rows="4" class="form-control" placeholder="Komentar" name="forum_topic_reply_body" style=" float: left;  width: 160px;  height: 32px;" required /><***/textarea> <input name="BackgroundImageFile" type="file" id="uploadBackgroundFile" class="btn btn-default" name="forum-topic-attachment" style=" float: left;   width: 80px;  height: 32px;" />    <button type="submit" class="btn btn-primary" name="submit_button" id="submit_button" style=" float: left;   width: 80px;  height: 32px;"/>Post</button></form><?php } ?>

perintah menulis untuk data base
form action="forum-topic-reply.php?forum_topic_id="method="post" enctype="multipart/form-data" id="UploadForm">
bahasa yang mudah dimengerti mungkin seperti:
perintah dari id table forum_topic
tulis dengan created_by/$username
dan isi komentar.
contoh

<?php     ini_set("display_errors",1);     session_start();     if($_SERVER['REQUEST_METHOD'] == 'POST'){         require '../_database/database.php';         $forum_topic_id = mysqli_real_escape_string($database,$_REQUEST['forum_topic_id']);         $forum_topic_id_temp = $forum_topic_id;         $forum_topic_reply_created_to=$_REQUEST['forum_topic_reply_created_to'];         $forum_topic_reply_topic=$_REQUEST['forum_topic_reply_topic'];         $forum_topic_reply_body=$_REQUEST['forum_topic_reply_body'];                 $Destination = '../userfiles/uploads';         if(!isset($_FILES['BackgroundImageFile']) || !is_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'])){             $BackgroundNewImageName= '';             move_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'], "$Destination/$BackgroundNewImageName");         }         else{             $RandomNum = rand(0, 9999999999);             $ImageName = str_replace(' ','-',strtolower($_FILES['BackgroundImageFile']['name']));             $ImageType = $_FILES['BackgroundImageFile']['type'];             $ImageExt = substr($ImageName, strrpos($ImageName, '.'));             $ImageExt = str_replace('.','',$ImageExt);             $ImageName      = preg_replace("/\.[^.\s]{3,4}$/", "", $ImageName);             $BackgroundNewImageName = $ImageName.'-'.$RandomNum.'.'.$ImageExt;             move_uploaded_file($_FILES['BackgroundImageFile']['tmp_name'], "$Destination/$BackgroundNewImageName");         }                  $sql="INSERT INTO forum_topic_reply(forum_topic_reply_created_by, forum_topic_reply_topic_id, forum_topic_reply_body, forum_topic_reply_notice,forum_topic_reply_created_to, forum_topic_reply_topic, forum_topic_reply_time, forum_topic_reply_image) VALUES ( '$user_username', '$forum_topic_id', '$forum_topic_reply_body', '$forum_topic_reply_notice', '$forum_topic_reply_created_to', '$forum_topic_reply_topic', CURRENT_TIMESTAMP, '$BackgroundNewImageName')";         mysqli_query($database,$sql)or die(mysqli_error($database));         header("location:../forum-topic.php?forum_topic_id=".$forum_topic_id."request=add-new-forum-post&status=success");     }     ?>

sambut pada file furum-topic-reply.php
baris ini
$forum_topic_id = mysqli_real_escape_string($database,$_REQUEST['forum_topic_id']);
forum_topic_id dari table forum_topic
melakukan penulisan berguna nanti pada menampilkan table forum_topic_reply pada file forum_topic
letaknya bisa dibawah input bisa juga diatas input
pengenal berdasarkan id
untuk reply comment
bukan pada forum_topic_reply_id mereka menunjukan kolum 0
tetapi
di forum_topic_reply_by_id
ini yang akan mengenal antara
table user
table forum_topic
table forum_topic_reply

UNTUK MELIHAT MEREKA BEKERJA
untuk melihat hasil
tautan yang akan melempar kedalam forum-topic-reply
bisa kita lihat Home.php
persis dibawah judul forum mereka mengandung tautan yang mengarahkan kepada forum-topic-reply atau forum_topic_body
didalam file furum-topic.php
jangan lupa untuk membaca
post saya lain waktu
disana saya akan menghamparkan
view user eyes
dan
count jumlah komentar

Gelora

Show user comments dan reply comments

Posting Komentar