CODEWITHSUNDEEP
jquery
Nodemon
Nodemon

Reputation: 1046

Notification Message using PHP and Jquery

In the header of my application I have notification message icon.

For example, when a new record is inserted into the table, there must appear the notification message to admin, like this:

image1

If I toggle the button it looks like this:

enter image description here

But the problem is that when I click the notification button, it shows the data, but the count of notofications does not reset to zero.

What I need is when I click the notification link, the quantity of notifications should be reset to zero.

it should look like below image

image3

This is my code:

<!-- Messages: style can be found in dropdown.less-->
                <li class="dropdown messages-menu">
                    <a href="#" class="dropdown-toggle" data-toggle="dropdown" id="notify-comet">
                        <i class="fa fa-envelope-o"></i>
                        <span class="label label-success" id="not-count">
                            <?php
                                $count = Delay::find()
                                        ->where(('id') !== 0)
                                        ->orderBy('id')
                                        ->count();  
                                echo "$count";
                            ?>
                        </span>
                    </a>
                    <ul class="dropdown-menu">
                        <li class="header">You have <?php echo "$count" ?> messages</li>
                        <?php
                            $qry = Delay::find()->all();
                            foreach ($qry as $key => $value) 
                            { 
                        ?>
                            <div class="delay-notification">
                            <ul class="menu">
                                <li><a href="index.php?r=delay"><?php echo $value->claimer_name; ?> &nbsp <?php echo $value->company_name; ?></a></li>
                            </ul>
                            </div>
                        <?php  
                            $i = 1;
                            if ($i++ == 4) break;
                            }
                        ?>

                        <li class="footer"><a href="index.php?r=delay">See All Messages</a></li>
                    </ul>
                </li>

                <?php
                    }
                ?>

Upvotes: 1

Views: 7059

Answers (3)

Sukanya Suku
Sukanya Suku

Reputation: 57

<?php
session_start();
include("../connect.php");
$user=$_SESSION['user'];
if(empty($user))
{
    header("location:index.php");
}
else{
$query_not="SELECT count(status) AS sum FROM `user_leave_details` where status='1' Or status='4' or status='5'";
$result=mysqli_query($bd,$query_not);
while($arr=mysqli_fetch_array($result))
{   
$sum=$arr['sum'];
}   
?>
<html>
<head>
<li class="dropdown messages-menu">
<a href="" class="dropdown-toggle"><span style="color:white"><i class='fa fa-comment-o'  title="Notification"></i></span>
<span class="badge" style="color:#FF0000">
<?php if(empty($_POST['hide']))
{ 
echo $sum;
}
else
{
echo $sum=0;
}?>
</span></a>                                 
<ul style="display: none;" class="dropdown-menu bold">
<?php
$query="SELECT * FROM user_leave_details WHERE status='1' Or status='4' or status='5'";
$sl_no=1;
$result=mysqli_query($bd,$query);
if(mysqli_num_rows($result)>0)
{                                                       while($row=mysqli_fetch_array($result))
                                                 { 
                                                 $user_id=$row['leave_id'];
                                                 $user_name=$row['user_name'];
                                                 $no_days=$row['no_leave'];
                                                 $leave_from=$row['leave_from'];
                                                 $leave_to=$row['leave_to'];
                                                 $status=$row['status'];
                                            ?>
                                         <li name='hlo'><?php echo "<a href='admin_approved.php?reg_id=$user_id' id='hide'' name='hide'>";?><?php if($status==1){echo $user_name." request permission for ".$no_days. " day/days leave from ".$leave_from ." to ".$leave_to;}else if($status==4){echo $user_name." leave reduced from ".$leave_from." to".$leave_to ;}else if($status==5){echo $user_name." cancel for the leave from ".$leave_from." to ".$leave_to;}echo " </a>"; ?> </li>
                                          <?php
                                          if(isset($_POST['hlo']))
                                            {
                                                echo $sum=0;
                                            }
                                            }

                                            }
                                        ?>

                                </ul>
                            </li> 
</head>
</html>
connect.php
<?php
$mysql_hostname = "localhost";
$mysql_user = "root";
$mysql_password = "";$mysql_database = "";        $bd=mysqli_connect($mysql_hostname,$mysql_user,$mysql_password,$mysql_database);
?>

Upvotes: 0

Touqeer Shafi
Touqeer Shafi

Reputation: 5284

Using jQuery bind an event on .messages-menu class

jQuery(document).ready(function($){
   $('#notify-comet').on('click', function(e){
        $("#not-count").html("0");
   })
})

It will reset counter to 0 every time when you open your dropdown.

Upvotes: 1

Amit Guleria
Amit Guleria

Reputation: 231

Do one simple thing when you click on the link or on Button (which shows you the count) call the ajax function which will reset the count to zero or simple j query can do it for you by resting the value of that span .

Upvotes: 0

Related Questions