Harmony Database Runs In One Page Part 1

Table of Contents

Sedikit Berbeda dari Harmony Database For Post Video in One Page
Didalam publis post/home page mengumpulkan data dari database
1.user.sql
2.forum_topic.sql
3.video_file.sql And Jumlah Pasang Mata/video_eye.sql
4.forum_like.sql And forum_diclike.sql
5.forum_eye.sql
Dikesempatan kali ini materi pembahasan adalah
Menampilkan semua data lengkap dengan jumlah pasang mata dan like,diclike menbahkan Jumla komentar lengkap dengan dropdown comments dari comment reply
Contoh

Gambar berikut mendapat
👁️5 pasang mata
👍6 Like
👎2 Diclike
Yang menarik disini adalah Menambahkan Bootstrap Drobdown pada bagian
💬 9 Comment
Contoh Bootstrap Drobdown

Menpilkan jumlah comment dan semu data dari forum_reply .
melunakan data tersebut dengan perintah berikut
$temp_user_username_reply
=$rws['forum_topic_reply_creted'].
 membuat data dapat memasuki tempat mereka masing-masing gunakan perintah berikut:
$temp_video_id_reply=
$rws['video_id']//mengabil data video_id dari table video_file ,supaya mereka dapat tetap patu untuk berjalan dan selaras dengan data video_reply_id dari table video_reply.
Contoh code lengkap
home.php

---

<br /><?php include 'components/authentication.php'; include 'controllers/base/head.php'; ?><br /><?php include 'controllers/base/style.php' ?><br /><?php require '_database/database.php'; if($_SESSION['user_username']){ include 'controllers/navigation/first-navigation.php'; ?><br /><br><br /><?php } else{ ?><br /><?php } ?><br />

<br /><?php $sql = "SELECT * FROM forum_topic WHERE forum_topic_id order by forum_topic_time LIMIT 25"; $result = mysqli_query($database,$sql); while($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); $rws_search_username= mysqli_fetch_array($result_search_username); $temp_forum_topic_by_id_reply= $rws['forum_topic_id']; $sql_search_forum_topic_by_id_reply = "SELECT count(*) as count from forum_topic_reply where forum_topic_reply_topic_id = '$temp_forum_topic_by_id_reply'"; $result_search_forum_topic_by_id_reply= mysqli_query($database,$sql_search_forum_topic_by_id_reply) or die(mysqli_error($database)); $rws_search_forum_topic_by_id_reply = mysqli_fetch_array($result_search_forum_topic_by_id_reply); $temp_user_eye_id_reply= $rws['forum_topic_id']; $sql_search_user_eye_id_reply= "SELECT count(*) as count from user_eye where user_eye_by_id = '$temp_forum_topic_by_id_reply'"; $result_search_user_eye_id_reply= mysqli_query($database,$sql_search_user_eye_id_reply) or die(mysqli_error($database)); $rws_search_user_eye_id_reply = mysqli_fetch_array($result_search_user_eye_id_reply); $temp_forum_like_id_reply= $rws['forum_topic_id']; $sql_search_forum_like_id_reply= "SELECT count(*) as count from forum_like where forum_like_by_id = '$temp_forum_topic_by_id_reply'"; $result_search_forum_like_id_reply= mysqli_query($database,$sql_search_forum_like_id_reply) or die(mysqli_error($database)); $rws_search_forum_like_id_reply = mysqli_fetch_array($result_search_forum_like_id_reply); $temp_forum_diclike_id_reply= $rws['forum_topic_id']; $sql_search_forum_diclike_id_reply= "SELECT count(*) as count from forum_diclike where forum_diclike_by_id = '$temp_forum_topic_by_id_reply'"; $result_search_forum_diclike_id_reply= mysqli_query($database,$sql_search_forum_diclike_id_reply) or die(mysqli_error($database)); $rws_search_forum_diclike_id_reply = mysqli_fetch_array($result_search_forum_diclike_id_reply); ?><div class="panel-body"> <div class="row clearfix"><div class="col-md-12 column"style=" border: 1px solid; background: #00FFFF; " ><a href="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>"><i style="font-size: 18px;"><br /><img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_username'];?> <br /><?php echo $rws_search_username['user_lastname'];?>"alt="Generic placeholder image" style="<br />width: 37px;<br />height: 37px;"><br /></a><br /><i style="font-size: 18px;color:black;"><br /><a href="profile.php?user_username= <?php echo $rws_search_username['user_username'];?><br />"><?php echo $rws_search_username['user_username'];?></a><br /><i class=""style="font-size: 8px;color:black;"><br /><?php echo $rws['forum_topic_time']; ?> </i><form action="user_eye.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"><br /><input type="hidden" name="user_eye_by_id" value="<?php echo $rws['forum_topic_id']?>"/><br /><input type="hidden"name="user_eye_name" value="<?php echo $rws['forum_topic_created_by']?>"/><br /><input type="hidden" name="user_eye_body" value="<?php echo $rws['forum_topic_body']?>"/><div><?php echo $rws['forum_topic_body'];?></div><//----button type="hidden" name="submit-button"class="group-addon" id="submit" style=" background: #00FFFF;"><br /><?php if($rws ['forum_topic_image']){?> <br /><a href="userfiles/uploads/<?php echo $rws ['forum_topic_image']?>"> <br /><img src="userfiles/uploads/<?php echo $rws ['forum_topic_image']?>"class="img-responsive thumbnail"<br />style="<br />width: 330px;<br />height: 330px;"<br />><?php } ?></i></a><br /><//----button><br /></form><div/><i style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"><?php echo "👁️<i class='' style='font-size:15px;'><br />".$rws_search_user_eye_id_reply['count']."<br />️</i>";<br />?></i><i style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"><?php echo "👍<i class='' style='font-size:15px;'><br />".$rws_search_forum_like_id_reply['count']."<br />️</i>";<br />?></i><i style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"><br /><?php echo "👎<i class='' style='font-size:15px;'><br />".$rws_search_forum_diclike_id_reply['count']."<br />️</i>";<br />?><br /></i><br /><?php ?><br /><span class="dropdown-group-addon"><br /><a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"/><br />💬<br /><?php echo $rws_search_forum_topic_by_id_reply['count']; ?> <br /></a><br /><span class="dropdown-menu" style="font-size: 15px; box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"><?php $temp_forum_topic_id_reply= $rws['forum_topic_id']; $sql_search_forum_topic_id_reply= "SELECT * FROM forum_topic_reply where forum_topic_reply_topic_id = '$temp_forum_topic_id_reply' order by forum_topic_reply_time LIMIT 25"; $result_search_forum_topic_id_reply = mysqli_query($database,$sql_search_forum_topic_id_reply); $rws_search_forum_topic_id_reply = mysqli_num_rows($result_search_forum_topic_id_reply); while($rws_search_forum_topic_id_reply= mysqli_fetch_array($result_search_forum_topic_id_reply)){ $temp_user_username_reply = $rws_search_forum_topic_id_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); ?><br /><span><br /><a href="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>"><i style="font-size: 18px;"><br /><img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply['user_username'];?><?php echo $rws_search_username_reply['user_lastname'];?>"alt="Generic placeholder image" style="<br />width: 28px;<br />height: 28px;"><br /></a><br /><a href="profile.php?user_username=<?php echo $rws_search_username_reply['user_username'];?>"><br /><?php echo $rws_search_username_reply['user_username'];?><br /></a> <br /><?php echo $rws_search_forum_topic_id_reply['forum_topic_reply_body'];?><br /><?php if($rws_search_forum_topic_id_reply['forum_topic_reply_image']){ ?><br /><img src="userfiles/uploads/<?php echo $rws_search_forum_topic_id_reply['forum_topic_reply_image'];?>" class="img-responsive thumbnail"><br /><?php } ?><br /><i class=""><br /></i><br /></a><br /><span><br /><i class=""><br /></i><br /></a><br /></span><br /><?php } ?></span><br /></ul></span><br /></div></div><?php ?></div></div></div></div></div></div></div></div><?php } ?><br /></body><br /></html><br />
Pada code forum_reply versi awal
lengkap dengan comment reply picture
untuk code reply terbaru
Unduh Code Lengkap home.php
jika kesulitan dalam memahami code
Contoh
Websit Sosial Media
hubungi saya
Email

---