Show user comments dan reply comments

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

DATA BARU

Show user comments dan reply comments

Posting Komentar untuk "Show user comments dan reply comments"

Menu Halaman Statis