Like and Dislike php

Table of Contents

Mana Jempolya kaka👍👎
Siapa yang suka baper kalo ada yang suka dan memberikan jempal distatus postnya
kamu...... ya..😁
langsung saja ayo kita membuat code scrip
Like dan Dislike
Untuk teman-teman yang baru membaca artikel
Membaca dari awal post
Bahan-bahan Membuat Dalam Papan Percobaan server Localhost
Sistem Pedaftaran php
Login Proces php
Public Post php
Membuat Pondasi sebagai landasan table database
               forum_like.sql

                <br />CREATE TABLE IF NOT EXISTS `forum_like` (<br />`forum_like_id` int(11) NOT NULL AUTO_INCREMENT,<br />`forum_like_by_id` varchar(300) NOT NULL,<br />`forum_like_name` varchar(300) NOT NULL,<br />`forum_like_times` date NOT NULL,<br />`forum_like_body` text NOT NULL,<br />PRIMARY KEY (`forum_like_id`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<br />

---

              forum_disclike.sql

                <br /><br /><br />CREATE TABLE IF NOT EXISTS `forum_diclike` (<br />`forum_diclike_id` int(11) NOT NULL AUTO_INCREMENT,<br />`forum_diclike_by_id` varchar(300) NOT NULL,<br />`forum_diclike_name` varchar(300) NOT NULL,<br />`forum_diclike_times` date NOT NULL,<br />`forum_diclike_body` varchar(5999) NOT NULL,<br />PRIMARY KEY (`forum_diclike_id`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;<br /><br />

---

        Membuat Jebakan didalam  didalam

"button" seperti ini

arah jalur tautan  input data table forum_like 

---

👍

 Menulis dan mengikat nilai asli dari id dan username

---

  arah jalur tautan  input data table forum_dislike

---

👎

 Menulis dan mengikat nilai asli dari id dan username

klik ibu jari yang mengadung tipun form/tautan
menjebak mereka untuk menulis table dari forum_like👍
forum_diclike👎 

---

    Contoh code lengkap

       form-like-and-diclike.php

                <br /><br /><//___button type="submit" class="primary" name="submit_button" id="submit"/><br /><br />👍<br /><br /><?php $servername = "localhost"; $username = "root"; $password = "";//sesuikan dengan database $dbname = "";//sesuikan dengan database $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error)<br /><br />{ die("Connection failed: " . $conn->connect_error); <br /><br />} <br /><br />$sql = "SELECT count(*) as count from forum_like where forum_like_by_id= '$forum_topic_id'";<br /><br />$result = $conn->query($sql); <br /><br />if ($result->num_rows > 0) { <br /><br />$row = $result->fetch_assoc(); <br /><br />echo" <i class=',' style='font-size:19px;'> ".$row['count']."</i>";<br /><br /><br /><br />}<br /><br />else { echo "results";<br /><br />}<br /><br />$conn->close()<br /><br />?><br /><br /><//___button><br /><br /></form><br /><form action="forum_diclike.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"><br /><br /><input type="hidden" name="forum_diclike_by_id" value="<?php echo $rws['forum_topic_id']?>"><br /><br /><input type="hidden"name="forum_diclike_name" value="<?php echo $rws['forum_topic_created_by']?>"><br /><br /><input type="hidden" name="forum_diclike_body" value="<?php echo $rws['forum_topic_body']?>"><br /><br /><//__button type="submit" class="primary" name="submit_button" id="submit"><br /><br />👎<br /><br /><?php $servername = "localhost"; $username = "root"; $password = "";//sesuikan dengan database $dbname = "";//sesuikan dengan database $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error)<br /><br />{ die("Connection failed: " . $conn->connect_error); <br /><br />} <br /><br />$sql = "SELECT count(*) as count from forum_diclike where forum_diclike_by_id= '$forum_topic_id'";<br /><br />$result = $conn->query($sql); <br /><br />if ($result->num_rows > 0) { <br /><br />$row = $result->fetch_assoc(); <br /><br />echo" <i class=',' style='font-size:19px;'> ".$row['count']."</i>";<br /><br /><br /><br />}<br /><br />else { echo "results";<br /><br />}<br /><br />$conn->close()<br /><br />?><br /><br /><//___button><br /><br /></form><br /></i><br /><br /><br />
Meletakan merka didalam akhir post artikel

---

             Contoh code lengkap

              









                forum_topic.php

                <br /><?php include 'components/authentication.php' ?> <br /><?php include 'controllers/base/head.php' ?><br /><?php require '_database/database.php'; if($_SESSION['user_username']){ ?><br /><?php include 'controllers/navigation/first-navigation.php' ?><br /><?php } else{ ?><br /><?php include 'controllers/navigation/index-before-login-navigation.php' ?><br /><?php } ?><br /><?php $current_user = $_SESSION['user_username']; $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); ?><br /><body style=" box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; " ><br /><div class="container"> <div class="panel panel-default"> <div class="panel-body"style=" box-shadow:1px 3px 2px 1px #00FFFF; border: 1px solid; " > <br /><div class="panel-body"> <div class="row clearfix"> <div class="col-md-12 column"style=" box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF; " ><img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_usernamr'];?> <br /><?php echo $rws_search_username['user_lastname'];?>alt="Generic placeholder image" style="<br />width: 37px;<br />height: 37px<br />box-shadow:3px 3px 3px 3px #00FFFF; <br />left: calc(50% - 7px);<br />top: calc(50% - 6px);<br />border: 2px solid;<br />background: #C0C0C0;<br />" ><br /><a href="profile.php?user_username=<?php echo $rws_search_username['user_username'];?> " style="font-size: 20px;"/><?php echo $rws_search_username['user_username'];?><br /></a><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /></div></i><i class="" style="font-size: 1.0em;"><br /><br /></i><br /></div><br /><hr/><?php echo $rws['forum_topic_body'];?><br /><div class="forum-attachment"> <?php if($rws['forum_topic_image']){ ?><br /><br /><div class="col-md-3 column"> <img src="userfiles/uploads/<?php echo $rws['forum_topic_image'];?>" alt="Generic placeholder image" style="<br />width: 200px;<br />height: 200px;<br />box-shadow:3px 3px 3px 3px #ADC2B3; <br />left: calc(50% - 7px);<br />top: calc(50% - 6px);<br />border: 2px solid;<br />background: #00FFFF;<br />" ><br /></div><?php } ?><br /></div><br /><?php if($rws['forum_topic_longtext']){ ?><br /><br /><br /><?php } ?><br /><div/><?php if($rws['forum_topic_file_name']){ ?><br /><br /><br /><a href="user_download_minutes.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>"><br /><?php echo $rws['forum_topic_file_name'];?><br /></a><div/><?php } ?><br /><div/><form action="forum_like.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"><br /><input type="hidden" name="forum_like_by_id" value="<?php echo $rws['forum_topic_id']?>"/><br /><input type="hidden"name="forum_like_name" value="<?php echo $rws['forum_topic_created_by']?>"/><br /><input type="hidden" name="forum_like_body" value="<?php echo $rws['forum_topic_body']?>"/><br /><?php $servername = "localhost"; $username = "root"; $password = "kangdeny11";//sesuikan dengan database $dbname = "userprofile";//sesuikan dengan database $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error)<br />{ die("Connection failed: " . $conn->connect_error); <br />} <br />$sql = "SELECT count(*) as count from user_eye where user_eye_by_id = '$forum_topic_id'";<br />$result = $conn->query($sql); <br />if ($result->num_rows > 0) { <br />$row = $result->fetch_assoc(); <br />?><br /></div></div><?php echo" 👁️<i class='' style='font-size:19px;'> ".$row['count']."</i>";<br />}<br />else { echo "results";<br />}<br />$conn->close()<br />?><br /><?php $servername = "localhost"; $username = "root"; $password = "kangdeny11";//sesuikan dengan database $dbname = "userprofile";//sesuikan dengan database $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error)<br />{ die("Connection failed: " . $conn->connect_error); <br />} <br />$sql = "SELECT count(*) as count from forum_topic_reply where forum_topic_reply_topic_id = '$forum_topic_id'";<br />$result = $conn->query($sql); <br />if ($result->num_rows > 0) { <br />$row = $result->fetch_assoc(); <br />echo"🗨️ <i class='' style='font-size:19px;'><br />".$row['count']."<br />️</i>";<br />}<br />else { echo "results";<br />}<br />$conn->close()<br />?><br /></i><div/><//__button type="submit" class="primary" name="submit_button" id="submit"/><br />👍<br /><?php $servername = "localhost"; $username = "root"; $password = "";//sesuikan dengan database $dbname = "";//sesuikan dengan database $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error)<br />{ die("Connection failed: " . $conn->connect_error); <br />} <br />$sql = "SELECT count(*) as count from forum_like where forum_like_by_id= '$forum_topic_id'";<br />$result = $conn->query($sql); <br />if ($result->num_rows > 0) { <br />$row = $result->fetch_assoc(); <br />echo" <i class=',' style='font-size:19px;'> ".$row['count']."</i>";<br /><br />}<br />else { echo "results";<br />}<br />$conn->close()<br />?><br /><//___button><br /></form><form action="forum_diclike.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>" method="post" enctype="multipart/form-data" id="UploadForm"><br /><input type="hidden" name="forum_diclike_by_id" value="<?php echo $rws['forum_topic_id']?>"><br /><input type="hidden"name="forum_diclike_name" value="<?php echo $rws['forum_topic_created_by']?>"><br /><input type="hidden" name="forum_diclike_body" value="<?php echo $rws['forum_topic_body']?>"><br /></___button type="submit" class="primary" name="submit_button" id="submit"><br />👎<br /><?php $servername = "localhost"; $username = "root"; $password = "";//sesuikan dengan database $dbname = "";//sesuikan dengan database $conn = new mysqli($servername, $username, $password, $dbname); if ($conn->connect_error)<br />{ die("Connection failed: " . $conn->connect_error); <br />} <br />$sql = "SELECT count(*) as count from forum_diclike where forum_diclike_by_id= '$forum_topic_id'";<br />$result = $conn->query($sql); <br />if ($result->num_rows > 0) { <br />$row = $result->fetch_assoc(); <br />echo" <i class=',' style='font-size:19px;'> ".$row['count']."</i>";<br /><br />}<br />else { echo "results";<br />}<br />$conn->close()<br />?><br /><//___button><br /></form></i><br /><br /><br /><div class="container"> <div class="row_e clearfix"><?php require '_database/database.php'; $sql_1 = "SELECT * FROM user WHERE user_username='$user_username'"; $result_1 = mysqli_query($database,$sql_1); while($row_e = mysqli_fetch_array($result_1,MYSQLI_BOTH)) { if($row_e['user_username']){ ?><br /><br /><br /><br /><?php include'controllers/form/forum-topic-reply-form.php' ?> <br /><?php } else{ ?><br /><div class="well"> <div class="row_e 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 } ?><br /></div></li><br /><br /><br /></ul></div></div></li><br /><br /><br /></ul></div><br /><?php } ?><br /><?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); ?><br /><br /><?php if($rws_reply_count > 0){<br />?><br /><div class="container" style=" background-image:!important; "> <div class="row clearfix"> <div class="panel-body"style=" box-shadow:1px 3px 2px 1px #00FFFF; border: 1px solid; " ><img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply['user_usernamr'];?> <br /><?php echo $rws_search_username_reply['user_lastname'];?>alt="Generic placeholder image" style="<br />width: 37px;<br />height: 37px;<br />" ><br /><?php echo " <img src='../assets/img/ajax-loader.gif'alt='Generic placeholder image'style=' width: 3px; height: 3px; '/>";<br />?> <br /><br /><a href="profile.php?user_username=<?php echo $rws_reply['forum_topic_reply_created_by'];?> "><i style="font-size: 18px;"><br /><?php echo $rws_reply['forum_topic_reply_created_by'];?><br /></a> <br /><?php echo $rws_reply['forum_topic_reply_body'];?></i><br /><i style="font-size: 8px;"><br /><?php echo $rws_reply['forum_topic_reply_time'];?></i><br /><?php if($rws_reply['forum_topic_reply_image']){ ?><br /><img src="userfiles/uploads/<?php echo $rws_reply['forum_topic_reply_image'];?>" class="img-responsive thumbnail"><br /><br /><br /><?php } ?><br /><br /></div><?php } ?> <br /></div></div><?php } ?> <br /><br /></body><br /><br /></html><br />

---

             Menyampaikan data kedalam table forum_like dan forum_diclike

contoh 

    💻Root folder

            forum_like.php

                <?php ini_set("display_errors",1); session_start(); $user_username=$_SESSION['user_username']; 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_like_by_id=$_REQUEST['forum_like_by_id']; $forum_like_name=$_REQUEST['forum_like_name']; $forum_like_body=$_REQUEST['forum_like_body']; $sql="INSERT INTO forum_like(forum_like_by_id, forum_like_name, forum_like_times, forum_like_body) VALUES ( '$forum_like_by_id', '$user_username', CURRENT_TIMESTAMP, '$forum_like_body')"; mysqli_query($database,$sql)or die(mysqli_error($database)); header('Location: forum-topic.php?forum_topic_id='.$forum_topic_id); } ?><br />

                forum_diclike.php

                <?php ini_set("display_errors",1); session_start(); $user_username=$_SESSION['user_username']; 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_diclike_by_id=$_REQUEST['forum_diclike_by_id']; $forum_diclike_name=$_REQUEST['forum_diclike_name']; $forum_diclike_body=$_REQUEST['forum_diclike_body']; $sql="INSERT INTO forum_diclike(forum_diclike_by_id, forum_diclike_name, forum_diclike_times, forum_diclike_body) VALUES ( '$forum_diclike_by_id', '$user_username', CURRENT_TIMESTAMP, '$forum_diclike_body')"; mysqli_query($database,$sql)or die(mysqli_error($database)); header('Location: forum-topic.php?forum_topic_id='.$forum_topic_id); } ?><br />

---

Meletakan semua file diluar folder 
Ahh terimaksi