Notification Run Aktifity User

Dengan menambahkan table kedalam database

berikut ini

user_notif.sql

Table user_notif akan kita gunakan sebagai notifikation aktifitas user.
mengikat data sebagai berikut
notif 🔗like
notif 🔗diclike
notif 🔗eye
notif 🔗comments reply
Yang perlu dilakukan adalah menambahkan baris perintah berikut pada masing- masing INSERT kedalam table database
Tambah code berikut kedalam code
INSERT for table forum_like

hapus beberapa code tak

memangil data
Megunakan Bostrap Dropdown
letakan pada bagian sisi yang mudah terlihat seperti ini misalnya

jika seseorang merespon post dengan menekan 👍 yang didalamnya sudah disertakan button input
dan melempar kedalam insert
contoh code lengkap
🗒️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));
$sql_ntf="INSERT INTO user_notif_forum(user_notif_forum_topic_like_by_id,user_notif_forum_topic_like_name,user_notif_forum_topic_like_body,
user_notif_forum_topic_like_time) VALUES('$forum_topic_id','$user_username','$forum_topic_body',CURRENT_TIMESTAMP)";mysqli_query($database,$sql_ntf)or die(mysqli_error($database));
header('Location: forum-topic.php?forum_topic_id='.$forum_topic_id);} 
?>

Dengan cara berikut ini dua table
forum_like,
user_notif_forum,
secara otomatis menerima dan mengisi data masing-masing username untuk pengikat mereka harus menjaga nilai asli dari user_id
Selengkapnya untuk input data code
baca
forum_like dan forum_diclike

Untuk Memangil data selipkan diantara Boostrap Dropdown
Contoh Code 1

<a href="#" class="dropdown-toggle" data-toggle="dropdown"style="font-size: 15px"style="box-shadow:1px 3px 2px 1px #C0C0C0;
 border: 1px solid;
 background: #00FFFF;"/> 
 
<?php
 $current_user = $_SESSION['user_username'];
$sql_search_user_notif_like_id_reply= "SELECT count(*) as count from user_notif_forum where user_notif_forum_topic_like_name = '$current_user'";
 $result_search_user_notif_like_id_reply= mysqli_query($database,$sql_search_user_notif_like_id_reply) or die(mysqli_error($database)); $rws_search_user_notif_like_id_reply = mysqli_fetch_array($result_search_user_notif_like_id_reply);

?> 
📣 
<?php echo $rws_search_user_notif_like_id_reply['count'];?> 
</a> 
 
 
<?php
 $current_user = $_SESSION['user_username'];
 $sql = "SELECT * FROM user_notif_forum WHERE user_notif_forum_topic_like_created_by='$current_user' order by user_notif_forum_topic_like_time LIMIT 25";
 $result = mysqli_query($database,$sql);
 while($rws = mysqli_fetch_array($result)){
 $temp_user_username= $rws['user_notif_forum_topic_like_name'];
$sql_search_username = "SELECT * FROM user WHERE user_username = '$current_user'";
 $result_search_username = mysqli_query($database,$sql_search_username); 
 $rws_search_username= mysqli_fetch_array($result_search_username);
?> 
 
<?php
 $temp_user_username_reply = $rws['user_notif_forum_topic_like_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);
?> 
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class="" 
alt="Generic placeholder image" style=" 
width: 23px; 
height: 23px 
box-shadow:3px 3px 3px 3px #ADC2B3; 
left: calc(50% - 7px); 
top: calc(50% - 6px); 
border: 2px solid; 
background: none; 
" > 
<a href="dellet_notif.php?user_notif_like_id=
<?php echo $rws['user_notif_like_id'];?>"> 
<?php echo $rws['user_notif_forum_topic_like_created_by'];?> 
<?php
?> 
<?php if($rws['user_notif_forum_topic_like_body']){
 ?>💬 
<?php echo
$rws['user_notif_forum_topic_like_body']
?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_eye']){
 ?>👀 
<?php echo
$rws['user_notif_forum_topic_like_eye']
?> 
<?php
}
?> 
</a> 
 
 
 
 
</a> 
 
 
 
</a> 
 
<?php
}
?> 
 
</ul>

Contoh code lengkap
jumlah user_notif_forum count
berdasrakan user_notif_forum_topic_like_by_id
termasuk didalamnya
notif
image/forum_topic_image
video/video_body
reply/forum_topic_reply
eye/user_eye

<a href="#" class="dropdown-toggle-addon" data-toggle="dropdown"style="font-size: 15px"style="
 background: #00FFFF;"/> 
<?php
$sql_search_user_notif_like_id_reply = "SELECT count(*) as count from user_notif_forum where user_notif_forum_topic_like_created_by= '$user_username'";
 $result_search_user_notif_like_id_reply= mysqli_query($database,$sql_search_user_notif_like_id_reply) or die(mysqli_error($database)); $rws_search_user_notif_like_id_reply = mysqli_fetch_array($result_search_user_notif_like_id_reply);
?> 
🔔</a> 
<?php echo $rws_search_user_notif_like_id_reply['count'];?> 
 
 
<?php
$current_user = $_SESSION['user_username'];
 $sql = "SELECT * FROM user_notif_forum WHERE user_notif_forum_topic_like_created_by ='$current_user' order by user_notif_forum_topic_like_time";
 $result = mysqli_query($database,$sql);
 while($rws = mysqli_fetch_array($result)){
 $temp_user_username= $rws['user_notif_forum_topic_like_name'];
$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);
?> 
<?php
 $temp_user_username_reply = $rws_search_username['user_username'];
 $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_like= mysqli_fetch_array($result_search_username_reply);
?> 
<a href="dellet_notif.php?user_notif_like_id=<?php echo $rws['user_notif_like_id'];?>"> 
<?php
?> 
<?php 
if($rws['user_notif_forum_topic_like_body']){?> 
💬<?php echo
$rws['user_notif_forum_topic_like_body'];?> 
<?php
}
?> 
<?php if($rws_search_username_reply_like['user_avatar']){?> 
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply_like['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply_like['user_username'];?> 
<?php echo $rws_search_username_reply_like['user_lastname'];?> 
" 
alt="Generic placeholder image" style=" 
width: 20px; 
height: 20px; 
background: none; 
" > 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_name']){
if($rws['user_notif_forum_topic_like_body']){
?> 
<?php echo
$rws['user_notif_forum_topic_like_name'];?> 
<?php
}
?> 
<?php echo
$rws['user_notif_forum_topic_like_body'];?> 
 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_eye']){?> 
<?php echo
$rws['user_notif_forum_topic_like_eye'];?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_like']){?> 
<?php echo
$rws['user_notif_forum_topic_like_like'];?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_image']){?> 
👍<img src="userfiles/uploads/<?php echo
$rws['user_notif_forum_topic_like_image'];?>"class="img-responsive thumbnail" 
style=" 
width: 80px; 
height: 80px;"> 
<?php
}
?> 
 
<?php if($rws['user_notif_forum_topic_like_video']){?>👍📽️ 
<?php echo
$rws['user_notif_forum_topic_like_video'];?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_diclike']){?>👎📽️ 
<?php echo
$rws['user_notif_forum_topic_like_diclike'];?> 
<?php
}
?> 
 
 
<?php
}
?> 
 
 
</a> 
 
 
 
 
</a> 
 
 
</ul>
 
 
</div>
</div>
<?php
?> 
 
 
</div>
 
</form>
</div>
<div class="navbar-collapse collapse">
 <ul class="nav navbar-nav navbar-right"style="background: #00FFFF;">
<li> 
<a href="logout.php?user_username"style="font-size:19px;"> 
🛑Keluar(current)</a> 
</li>
<li><a href="edit-profile.php?user_username"style="font-size:19px;"> 
👷 Edit Profile </a></li>
<li><a href="forum.php?user_username"style="font-size:19px;"> 
📓 Forum </a></li>
<li><a href="deiform-495417976/index.php"style="font-size:19px;"> 
🏠 Home </a></li>
<li> 
<php
?> 
️ Messages 
<?php 
$sql_user_messages_count= "SELECT count(*) as count from user_messages where user_messages_created = '$user_username'";
 $result_search_user_messages_count= mysqli_query($database,$sql_user_messages_count) or die(mysqli_error($database)); $rws_search_user_messages_count = mysqli_fetch_array($result_search_user_messages_count);
?><?php echo $rws_search_user_messages_count['count'];?> 
 
 
<li class="dropdown"style="background: #00FFFF;"> 
<a href="#" class="dropdown-toggle" data-toggle="dropdown"style="background: #00FFFF;">📩 
</a> 
<ul class="dropdown-menu"style="background: #00FFFF;"><?php 
 include '_database/database.php';
 $current_user = $_SESSION['user_username'];
 $sql = "SELECT * FROM user_messages WHERE user_messages_created = '$user_username' ORDER BY user_messages_data DESC";
 $result = mysqli_query($database,$sql);
 while($rws_user_messages_name= mysqli_fetch_array($result,MYSQLI_BOTH)) {
 $temp_user_username= $rws_user_messages_name['user_messages_name'];
 $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);
?> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_username'];?>"alt="Generic placeholder image" style="width: 30px; height: 30px; font-size: 18px; background: none; " > <a href="user_view_messages.php?user_messages_id=<?php echo $rws_user_messages_name['user_messages_id'];?>" style="font-size: 18px;"> <?php echo $rws_search_username ['user_username'];?> </a> <?php
}
?>
<li> 
</a> 
</li>
</ul>
</li>
 
 
 
 
</li>
<li> 
</li>
</ul>
</div>
 
</div>
</div>

Yang perlu diingat adalah
pada penulisan table user_notif_forum
menitipkan INSERT user_notif_forum
kedalam input data eskusi INSERT tautan button to table forum_like
dan yang menunjukan aktifiti user
apa pun itu respon comment,like ,diclike
wajib menambahkan baris berikut untuk semua INSERT
New Update table data base

Contoh kode lengkap pangil rws/row
Notification v 1.1

<div id="navigation" class="navbar navbar-default navbar-fixed-top"style="
 background: #00FFFF;">
 <div class="container"style="
 background: #00FFFF;">
 <div class="navbar-header"style="
 background: #00FFFF;">
 
<?php
 $user_username = $_SESSION['user_username'];
 $sql = "SELECT * FROM user WHERE user_username='$user_username'";
 $result = mysqli_query($database,$sql);
 while($row = mysqli_fetch_array($result,MYSQLI_BOTH)) {
?> 
<img class="img-circle" src="userfiles/avatars/<?php echo $row['user_avatar'];?>" class="" alt="<?php echo $row['user_username'];?> 
<?php echo $row['user_lastname'];?> 
" 
alt="Generic placeholder image" style=" 
width: 37px; 
height: 37px 
background: none; 
" > 
 
<a href="my-profile.php?user_username=<?php echo $row['user_username'];?>"> 
<?php echo $row['user_username'];?> 
</a> 
<?php
}
?> 
 
 
 
 
 
<a href="#" class="dropdown-toggle-addon" data-toggle="dropdown"style="font-size: 15px"style="
 background: #00FFFF;"/> 
<?php
$sql_search_user_notif_like_id_reply = "SELECT count(*) as count from user_notif_forum where user_notif_forum_topic_like_created_by= '$user_username'";
 $result_search_user_notif_like_id_reply= mysqli_query($database,$sql_search_user_notif_like_id_reply) or die(mysqli_error($database)); $rws_search_user_notif_like_id_reply = mysqli_fetch_array($result_search_user_notif_like_id_reply);
?> 
🔔</a> 
<?php echo $rws_search_user_notif_like_id_reply['count'];?> 
 
 
<?php
$current_user = $_SESSION['user_username'];
 $sql = "SELECT * FROM user_notif_forum WHERE user_notif_forum_topic_like_created_by ='$current_user' order by user_notif_forum_topic_like_time";
 $result = mysqli_query($database,$sql);
 while($rws = mysqli_fetch_array($result)){
 $temp_user_username= $rws['user_notif_forum_topic_like_name'];
$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);
?> 
<?php
 $temp_user_username_reply = $rws_search_username['user_username'];
 $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_like= mysqli_fetch_array($result_search_username_reply);
?> 
<a href="dellet_notif.php?user_notif_like_id=<?php echo $rws['user_notif_like_id'];?>"> 
<?php
?> 
<?php 
if($rws['user_notif_forum_topic_like_body']){?> 
💬<?php echo
$rws['user_notif_forum_topic_like_body'];?> 
<?php
}
?> 
<?php if($rws_search_username_reply_like['user_avatar']){?> 
<img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply_like['user_avatar'];?>" class="" alt="<?php echo $rws_search_username_reply_like['user_username'];?> 
<?php echo $rws_search_username_reply_like['user_lastname'];?> 
" 
alt="Generic placeholder image" style=" 
width: 20px; 
height: 20px; 
background: none; 
" > 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_name']){
if($rws['user_notif_forum_topic_like_body']){
?> 
<?php echo
$rws['user_notif_forum_topic_like_name'];?> 
<?php
}
?> 
<?php echo
$rws['user_notif_forum_topic_like_body'];?> 
 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_eye']){?> 
<?php echo
$rws['user_notif_forum_topic_like_eye'];?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_like']){?> 
<?php echo
$rws['user_notif_forum_topic_like_like'];?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_image']){?> 
👍<img src="userfiles/uploads/<?php echo
$rws['user_notif_forum_topic_like_image'];?>"class="img-responsive thumbnail" 
style=" 
width: 80px; 
height: 80px;"> 
<?php
}
?> 
 
<?php if($rws['user_notif_forum_topic_like_video']){?>👍📽️ 
<?php echo
$rws['user_notif_forum_topic_like_video'];?> 
<?php
}
?> 
<?php if($rws['user_notif_forum_topic_like_diclike']){?>👎📽️ 
<?php echo
$rws['user_notif_forum_topic_like_diclike'];?> 
<?php
}
?> 
 
 
<?php
}
?> 
 
 
</a> 
 
 
 
 
</a> 
 
 
</ul>
 
 
</div>
</div>
<?php
?> 
 
 
</div>
 
</form>
</div>
<div class="navbar-collapse collapse">
 <ul class="nav navbar-nav navbar-right"style="background: #00FFFF;">
<li> 
<a href="logout.php?user_username"style="font-size:19px;"> 
🛑Keluar(current)</a> 
</li>
<li><a href="edit-profile.php?user_username"style="font-size:19px;"> 
👷 Edit Profile </a></li>
<li><a href="forum.php?user_username"style="font-size:19px;"> 
📓 Forum </a></li>
<li><a href="deiform-495417976/index.php"style="font-size:19px;"> 
🏠 Home </a></li>
<li> 
<php
?> 
️ Messages 
<?php 
$sql_user_messages_count= "SELECT count(*) as count from user_messages where user_messages_created = '$user_username'";
 $result_search_user_messages_count= mysqli_query($database,$sql_user_messages_count) or die(mysqli_error($database)); $rws_search_user_messages_count = mysqli_fetch_array($result_search_user_messages_count);
?><?php echo $rws_search_user_messages_count['count'];?> 
 
 
<li class="dropdown"style="background: #00FFFF;"> 
<a href="#" class="dropdown-toggle" data-toggle="dropdown"style="background: #00FFFF;">📩 
</a> 
<ul class="dropdown-menu"style="background: #00FFFF;"><?php 
 include '_database/database.php';
 $current_user = $_SESSION['user_username'];
 $sql = "SELECT * FROM user_messages WHERE user_messages_created = '$user_username' ORDER BY user_messages_data DESC";
 $result = mysqli_query($database,$sql);
 while($rws_user_messages_name= mysqli_fetch_array($result,MYSQLI_BOTH)) {
 $temp_user_username= $rws_user_messages_name['user_messages_name'];
 $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);
?> <img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username['user_avatar'];?>" class="" alt="<?php echo $rws_search_username['user_username'];?>"alt="Generic placeholder image" style="width: 30px; height: 30px; font-size: 18px; background: none; " > <a href="user_view_messages.php?user_messages_id=<?php echo $rws_user_messages_name['user_messages_id'];?>" style="font-size: 18px;"> <?php echo $rws_search_username ['user_username'];?> 
</a> <?php
}
?>
<li> 
</a> 
</li>
</ul>
</li>
 
 
</li>
<li> 
</li>
</ul>
</div>
 
</div>
</div>

hapus beberapa code tak

penting untuk menjaga nilai keaslian $forum_topic_created_by
dan $username