Like and Dislike php

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

forum_disclike.sql

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

<//___button type="submit" class="primary" name="submit_button" id="submit"/> 
 
👍 
 
<?php

$servername = "localhost";

$username = "root";

$password = "";//sesuikan dengan database

$dbname = "";//sesuikan dengan database

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) 
 
{ die("Connection failed: " . $conn->connect_error); 
 
} 
 
$sql = "SELECT count(*) as count from forum_like where forum_like_by_id= '$forum_topic_id'"; 
 
$result = $conn->query($sql); 
 
if ($result->num_rows > 0) { 
 
$row = $result->fetch_assoc(); 
 
echo" ".$row['count'].""; 
 
 
 
} 
 
else { echo "results"; 
 
} 
 
$conn->close() 
 
?> 
 
<//___button> 
 
</form>
 
<form action="forum_diclike.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"> 
 
<input type="hidden" name="forum_diclike_by_id" value="<?php echo $rws['forum_topic_id']?>"> 
 
<input type="hidden"name="forum_diclike_name" value="<?php echo $rws['forum_topic_created_by']?>"> 
 
<input type="hidden" name="forum_diclike_body" value="<?php echo $rws['forum_topic_body']?>"> 
 
<//__button type="submit" class="primary" name="submit_button" id="submit"> 
 
👎 
 
<?php

$servername = "localhost";

$username = "root";

$password = "";//sesuikan dengan database

$dbname = "";//sesuikan dengan database

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) 
 
{ die("Connection failed: " . $conn->connect_error); 
 
} 
 
$sql = "SELECT count(*) as count from forum_diclike where forum_diclike_by_id= '$forum_topic_id'"; 
 
$result = $conn->query($sql); 
 
if ($result->num_rows > 0) { 
 
$row = $result->fetch_assoc(); 
 
echo" ".$row['count'].""; 
 
 
 
} 
 
else { echo "results"; 
 
} 
 
$conn->close() 
 
?> 
 
<//___button> 
 
</form>

Meletakan merka didalam akhir post artikel

Contoh code lengkap

forum_topic.php

<?php include 'components/authentication.php' ?> 
<?php include 'controllers/base/head.php' ?> 
<?php

require '_database/database.php';
 if($_SESSION['user_username']){
?> 
<?php include 'controllers/navigation/first-navigation.php' ?> 
<?php
 }
 else{
?> 
<?php include 'controllers/navigation/index-before-login-navigation.php' ?> 
<?php
 }
?> 
<?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);
?> 
<body style="
 box-shadow:1px 3px 2px 1px #C0C0C0;
 border: 1px solid;
" > 
<div class="container">
 <div class="panel panel-default">
 <div class="panel-body"style="
 box-shadow:1px 3px 2px 1px #00FFFF;

border: 1px solid;

" >
 
<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'];?> 
<?php echo $rws_search_username['user_lastname'];?>alt="Generic placeholder image" style=" 
width: 37px; 
height: 37px 
box-shadow:3px 3px 3px 3px #00FFFF; 
left: calc(50% - 7px); 
top: calc(50% - 6px); 
border: 2px solid; 
background: #C0C0C0; 
" > 
<a href="profile.php?user_username=<?php echo $rws_search_username['user_username'];?> " style="font-size: 20px;"/><?php echo $rws_search_username['user_username'];?> 
</a> 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
</div>
 
 
 
</div>
 
<hr/><?php echo $rws['forum_topic_body'];?> 
<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'];?>" alt="Generic placeholder image" style=" 
width: 200px; 
height: 200px; 
box-shadow:3px 3px 3px 3px #ADC2B3; 
left: calc(50% - 7px); 
top: calc(50% - 6px); 
border: 2px solid; 
background: #00FFFF; 
" > 
</div>
<?php
 }
 ?> 
</div>
 
<?php
 if($rws['forum_topic_longtext']){
 ?> 
 
 
<?php
 }
 ?> 
<div/><?php
 if($rws['forum_topic_file_name']){
 ?> 
 
 
<a href="user_download_minutes.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>"> 
<?php echo $rws['forum_topic_file_name'];?> 
</a><div/><?php
 }
 ?> 
<div/><form action="forum_like.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"> 
<input type="hidden" name="forum_like_by_id" value="<?php echo $rws['forum_topic_id']?>"/> 
<input type="hidden"name="forum_like_name" value="<?php echo $rws['forum_topic_created_by']?>"/> 
<input type="hidden" name="forum_like_body" value="<?php echo $rws['forum_topic_body']?>"/> 
<?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) 
{ die("Connection failed: " . $conn->connect_error); 
} 
$sql = "SELECT count(*) as count from user_eye where user_eye_by_id = '$forum_topic_id'"; 
$result = $conn->query($sql); 
if ($result->num_rows > 0) { 
$row = $result->fetch_assoc(); 
?> 
</div>
</div>
<?php
echo" 👁️ ".$row['count'].""; 
} 
else { echo "results"; 
} 
$conn->close() 
?> 
<?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) 
{ 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"🗨️ 
".$row['count']." 
️"; 
} 
else { echo "results"; 
} 
$conn->close() 
?> 
<div/><//__button type="submit" class="primary" name="submit_button" id="submit"/> 
👍 
<?php 
$servername = "localhost"; 
$username = "root"; 
$password = "";//sesuikan dengan database
$dbname = "";//sesuikan dengan database
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) 
{ die("Connection failed: " . $conn->connect_error); 
} 
$sql = "SELECT count(*) as count from forum_like where forum_like_by_id= '$forum_topic_id'"; 
$result = $conn->query($sql); 
if ($result->num_rows > 0) { 
$row = $result->fetch_assoc(); 
echo" ".$row['count'].""; 
 
} 
else { echo "results"; 
} 
$conn->close() 
?> 
<//___button> 
</form>
<form action="forum_diclike.php?forum_topic_id=<?php echo $rws['forum_topic_id'];?>
" method="post" enctype="multipart/form-data" id="UploadForm"> 
<input type="hidden" name="forum_diclike_by_id" value="<?php echo $rws['forum_topic_id']?>"> 
<input type="hidden"name="forum_diclike_name" value="<?php echo $rws['forum_topic_created_by']?>"> 
<input type="hidden" name="forum_diclike_body" value="<?php echo $rws['forum_topic_body']?>"> 
</___button type="submit" class="primary" name="submit_button" id="submit"> 
👎 
<?php
$servername = "localhost"; 
$username = "root"; 
$password = "";//sesuikan dengan database
$dbname = "";//sesuikan dengan database
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) 
{ die("Connection failed: " . $conn->connect_error); 
} 
$sql = "SELECT count(*) as count from forum_diclike where forum_diclike_by_id= '$forum_topic_id'"; 
$result = $conn->query($sql); 
if ($result->num_rows > 0) { 
$row = $result->fetch_assoc(); 
echo" ".$row['count'].""; 
 
} 
else { echo "results"; 
} 
$conn->close() 
?> 
<//___button> 
</form>
 
 
 
<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']){
?> 
 
 
 
<?php include'controllers/form/forum-topic-reply-form.php'
?> 
<?php
 }
 else{
?> 
<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 
}
?> 
</div>
</li>
 
 
 
</ul>
</div>
</div>
</li>
 
 
 
</ul>
</div>
 
<?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="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'];?> 
<?php echo $rws_search_username_reply['user_lastname'];?>alt="Generic placeholder image" style=" 
width: 37px; 
height: 37px; 
" > 
<?php
echo "
<img src='../assets/img/ajax-loader.gif'alt='Generic placeholder image'style='
 width: 3px;
 height: 3px;
'/>"; 
?> 
 
<a href="profile.php?user_username=<?php echo $rws_reply['forum_topic_reply_created_by'];?> "> 
<?php echo $rws_reply['forum_topic_reply_created_by'];?> 
</a> 
<?php echo $rws_reply['forum_topic_reply_body'];?> 
 
<?php echo $rws_reply['forum_topic_reply_time'];?> 
<?php if($rws_reply['forum_topic_reply_image']){
 ?> 
<img src="userfiles/uploads/<?php echo $rws_reply['forum_topic_reply_image'];?>" class="img-responsive thumbnail"> 
 
 
<?php
}
?> 
 
</div>
<?php
}
?> 
</div>
</div>
<?php
}
?> 
 
</body> 
 
</html>

Menyampaikan data kedalam table forum_like dan forum_diclike

contoh

💻Root folder

forum_like.php

forum_diclike.php

Meletakan semua file diluar folder
Ahh terimaksi