Notification Run Aktifity User

Table of Contents

Dengan menambahkan table kedalam database

berikut ini

user_notif.sql

CREATE TABLE IF NOT EXISTS`user_notif_forum`(`user_notif_like_id` int(11) NOT NULL AUTO_INCREMENT,`user_notif_forum_topic_like_by_id` varchar(300) NOT NULL,`user_notif_forum_topic_like_name` varchar(300) NOT NULL,`user_notif_forum_topic_like_created_by`varchar(333) NOT NULL,`user_notif_forum_topic_like_body` varchar(5999) NOT NULL,`user_notif_forum_topic_like_eye` varchar(5999) NOT NULL,`user_notif_forum_topic_like_time` date NOT NULL, PRIMARY KEY(`user_notif_like_id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6;

---

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

$sql_ntf="INSERT INTO user_notif_forum(user_notif_forum_topic_like_by_id,<br />user_notif_forum_topic_like_name,<br />user_notif_forum_topic_like_body,<br />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));
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

<br /><span class="dropdown-group-addon"style="box-shadow:1px 3px 2px 1px #C0C0C0; border: 1px solid; background: #00FFFF;"><br /><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;"/><br /><br /><?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); ?><br />📣<br /><?php echo $rws_search_user_notif_like_id_reply['count'];?> <br /></a><br /><span class="dropdown-menu" style="font-size: 15px; border: 1px solid; background: #00FFFF;"><br /><br /><?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); ?><br /><span><br /><?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); ?><br /><img class="img-circle" src="userfiles/avatars/<?php echo $rws_search_username_reply['user_avatar'];?>" class=""<br />alt="Generic placeholder image" style="<br />width: 23px;<br />height: 23px<br />box-shadow:3px 3px 3px 3px #ADC2B3; <br />left: calc(50% - 7px);<br />top: calc(50% - 6px);<br />border: 2px solid;<br />background: none;<br />" ><br /><a href="dellet_notif.php?user_notif_like_id= <?php echo $rws['user_notif_like_id'];?>"><br /><?php echo $rws['user_notif_forum_topic_like_created_by'];?><br /><?php ?><br /><?php if($rws['user_notif_forum_topic_like_body']){ ?>💬<br /><?php echo $rws['user_notif_forum_topic_like_body'] ?><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_eye']){ ?>👀<br /><?php echo $rws['user_notif_forum_topic_like_eye'] ?><br /><?php } ?><br /></a><br /></span><br /></br><br /><i class=""><br /></i><br /></a><br /><span> <br /><i class=""><br /></i><br /></a><br /></span><br /><?php } ?><br /></span><br /></ul></span><br />
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

<br /><span class="dropdown-group-addon"style=" background: #00FFFF;"><br /><a href="#" class="dropdown-toggle-addon" data-toggle="dropdown"style="font-size: 15px"style=" background: #00FFFF;"/><br /><?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); ?><br />🔔</a><br /><?php echo $rws_search_user_notif_like_id_reply['count'];?><br /><span class="dropdown-menu" style="font-size: 15px; background: #00FFFF;"><br /><br /><?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); ?><br /><?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); ?><br /><a href="dellet_notif.php?user_notif_like_id=<?php echo $rws['user_notif_like_id'];?>"><br /><?php ?><br /><?php if($rws['user_notif_forum_topic_like_body']){?><br />💬<?php echo $rws['user_notif_forum_topic_like_body'];?> <br /><?php } ?><br /><?php if($rws_search_username_reply_like['user_avatar']){?><br /><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'];?> <br /><?php echo $rws_search_username_reply_like['user_lastname'];?><br />"<br />alt="Generic placeholder image" style="<br />width: 20px;<br />height: 20px;<br />background: none;<br />" ><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_name']){ if($rws['user_notif_forum_topic_like_body']){ ?><br /><?php echo $rws['user_notif_forum_topic_like_name'];?><br /><?php } ?> <br /><?php echo $rws['user_notif_forum_topic_like_body'];?><br /><br /><?php } ?> <br /><?php if($rws['user_notif_forum_topic_like_eye']){?><br /><i class="fa fa-eye"></i><?php echo $rws['user_notif_forum_topic_like_eye'];?> <br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_like']){?><br /><?php echo $rws['user_notif_forum_topic_like_like'];?><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_image']){?><br />👍<img src="userfiles/uploads/<?php echo $rws['user_notif_forum_topic_like_image'];?>"class="img-responsive thumbnail"<br />style="<br />width: 80px;<br />height: 80px;"><br /><?php } ?><br /><br /><?php if($rws['user_notif_forum_topic_like_video']){?>👍📽️<br /><?php echo $rws['user_notif_forum_topic_like_video'];?><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_diclike']){?>👎📽️<br /><?php echo $rws['user_notif_forum_topic_like_diclike'];?><br /><?php } ?><br /><br /><br /><?php } ?><br /><i class=""><br /></i><br /></a><br /><span><br /><br /><i class=""><br /></i><br /></a><br /></span><br /></span><br /></ul></span> <br /><br /></div></div><?php ?> <br /><br /><br /></div></span> <br /></form></div><div class="navbar-collapse collapse"> <ul class="nav navbar-nav navbar-right"style="background: #00FFFF;"><li><br /><a href="logout.php?user_username"style="font-size:19px;"><br />🛑Keluar<span class="sr-only">(current)</span></a><br /></li><li><a href="edit-profile.php?user_username"style="font-size:19px;"><br />👷 Edit Profile </a></li><li><a href="forum.php?user_username"style="font-size:19px;"><br />📓 Forum </a></li><li><a href="deiform-495417976/index.php"style="font-size:19px;"><br />🏠 Home </a></li><li><br /><php ?><br />️ Messages<br /><?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'];?> <br /><br /><br /><li class="dropdown"style="background: #00FFFF;"><br /><a href="#" class="dropdown-toggle" data-toggle="dropdown"style="background: #00FFFF;">📩<br /></a><br /><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><br /></a><br /></li></ul></li><br /><br /><br /><br /></li><li><br /></li></ul></div><!--/.nav-collapse --><br /></div></div><!-- ./Before Login Navigation --><br /><br /><br />
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

CREATE TABLE IF NOT EXISTS `user_notif_forum` (<br />`user_notif_like_id` int(11) NOT NULL AUTO_INCREMENT,<br />`user_notif_forum_topic_like_by_id` varchar(300) NOT NULL,<br />`user_notif_forum_topic_like_name` varchar(300) NOT NULL,<br />`user_notif_forum_topic_like_created_by` varchar(333) NOT NULL,<br />`user_notif_forum_topic_like_body` varchar(5999) NOT NULL,<br />`user_notif_forum_topic_like_eye` varchar(5999) NOT NULL,<br />`user_notif_forum_topic_like_like` varchar(5999) NOT NULL,<br />`user_notif_forum_topic_like_image` varchar(333) NOT NULL,<br />`user_notif_forum_topic_like_video` text NOT NULL,<br />`user_notif_forum_topic_like_time` date NOT NULL,<br />`user_notif_forum_topic_like_diclike` text NOT NULL,<br />PRIMARY KEY (`user_notif_like_id`,`user_notif_forum_topic_like_by_id`)<br />) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Contoh kode lengkap pangil rws/row
Notification v 1.1

<br /><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;"> <i type="hidden" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"style=" background: #00FFFF;"><br /><?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)) { ?> <br /><img class="img-circle" src="userfiles/avatars/<?php echo $row['user_avatar'];?>" class="" alt="<?php echo $row['user_username'];?> <br /><?php echo $row['user_lastname'];?><br />"<br />alt="Generic placeholder image" style="<br />width: 37px;<br />height: 37px<br />background: none;<br />" ><br /><span type="hidden" class="navbar-toggle-addon" data-toggle="collapse" data-target=".navbar-collapse"><br /><a href="my-profile.php?user_username=<?php echo $row['user_username'];?>"><br /><?php echo $row['user_username'];?><br /></a> <br /><?php } ?> </span><br /></i><br /><br /><br /><br /><span class="dropdown-group-addon"style=" background: #00FFFF;"><br /><a href="#" class="dropdown-toggle-addon" data-toggle="dropdown"style="font-size: 15px"style=" background: #00FFFF;"/><br /><?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); ?><br />🔔</a><br /><?php echo $rws_search_user_notif_like_id_reply['count'];?><br /><span class="dropdown-menu" style="font-size: 15px; background: #00FFFF;"><br /><br /><?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); ?><br /><?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); ?><br /><a href="dellet_notif.php?user_notif_like_id=<?php echo $rws['user_notif_like_id'];?>"><br /><?php ?><br /><?php if($rws['user_notif_forum_topic_like_body']){?><br />💬<?php echo $rws['user_notif_forum_topic_like_body'];?> <br /><?php } ?><br /><?php if($rws_search_username_reply_like['user_avatar']){?><br /><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'];?> <br /><?php echo $rws_search_username_reply_like['user_lastname'];?><br />"<br />alt="Generic placeholder image" style="<br />width: 20px;<br />height: 20px;<br />background: none;<br />" ><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_name']){ if($rws['user_notif_forum_topic_like_body']){ ?><br /><?php echo $rws['user_notif_forum_topic_like_name'];?><br /><?php } ?> <br /><?php echo $rws['user_notif_forum_topic_like_body'];?><br /><br /><?php } ?> <br /><?php if($rws['user_notif_forum_topic_like_eye']){?><br /><i class="fa fa-eye"></i><?php echo $rws['user_notif_forum_topic_like_eye'];?> <br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_like']){?><br /><?php echo $rws['user_notif_forum_topic_like_like'];?><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_image']){?><br />👍<img src="userfiles/uploads/<?php echo $rws['user_notif_forum_topic_like_image'];?>"class="img-responsive thumbnail"<br />style="<br />width: 80px;<br />height: 80px;"><br /><?php } ?><br /><br /><?php if($rws['user_notif_forum_topic_like_video']){?>👍📽️<br /><?php echo $rws['user_notif_forum_topic_like_video'];?><br /><?php } ?><br /><?php if($rws['user_notif_forum_topic_like_diclike']){?>👎📽️<br /><?php echo $rws['user_notif_forum_topic_like_diclike'];?><br /><?php } ?><br /><br /><br /><?php } ?><br /><i class=""><br /></i><br /></a><br /><span><br /><br /><i class=""><br /></i><br /></a><br /></span><br /></span><br /></ul></span> <br /><br /></div></div><?php ?> <br /><br /><br /></div></span> <br /></form></div><div class="navbar-collapse collapse"> <ul class="nav navbar-nav navbar-right"style="background: #00FFFF;"><li><br /><a href="logout.php?user_username"style="font-size:19px;"><br />🛑Keluar<span class="sr-only">(current)</span></a><br /></li><li><a href="edit-profile.php?user_username"style="font-size:19px;"><br />👷 Edit Profile </a></li><li><a href="forum.php?user_username"style="font-size:19px;"><br />📓 Forum </a></li><li><a href="deiform-495417976/index.php"style="font-size:19px;"><br />🏠 Home </a></li><li><br /><php ?><br />️ Messages<br /><?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'];?> <br /><br /><br /><li class="dropdown"style="background: #00FFFF;"><br /><a href="#" class="dropdown-toggle" data-toggle="dropdown"style="background: #00FFFF;">📩<br /></a><br /><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><br /></a><br /></li></ul></li><br /><br /></li><li><br /></li></ul></div><!--/.nav-collapse --><br /></div></div><!-- ./Before Login Navigation --><br /><br /><br /><br />

hapus beberapa code tak

---

me

penting untuk menjaga nilai keaslian $forum_topic_created_by
 dan $username

Pada masing-masing notification $row['count'] terkandung didalamnya tautan untuk menghapus jejak mereka dan mengembalikan kedalam halam rumah
contoh

dellet_notif.php

<?php require '_database/database.php'; $user_notif_like_id = mysqli_real_escape_string($database,$_REQUEST['user_notif_like_id']); $user_notif_forum_topic_like_by_id = mysqli_real_escape_string($database,$_REQUEST['user_notif_forum_topic_like_by_id']); $current_user = mysqli_real_escape_string($database,$_REQUEST['user_username']); $user_notif_like_id_temp = $user_notif_like_id; $user_notif_forum_topic_like_by_id_temp = $user_notif_forum_topic_like_by_id; $curren_user_temp = $user_username; $sql = "SELECT * FROM user_notif_forum where user_notif_like_id = '$user_notif_like_id'"; $result = mysqli_query($database,$sql); $rws = mysqli_fetch_array($result); $query = "DELETE FROM user_notif_forum WHERE user_notif_like_id='".$user_notif_like_id."'"; $sql= mysqli_query($database, $query); if($sql){ header('Location: forum_topic.php?user_username='.$username); } ?>
sekian terimaksih
Jika masih keaulitan dalam memahami code
Semua file yang dibutuhkan untuk websit webmaster1. 0
contak
Email