Breaking News: Grepper is joining You.com. Read the official announcement!

how to build jquery messages notification with php and mysq

OSP PRO answered on May 18, 2020 Popularity 6/10 Helpfulness 1/10

answer how to build jquery messages notification with php and mysq

related how to build jquery messages notification with php and mysq

how to build jquery messages notification with php and mysq

Comment

<?php

include('connect.php');

if(isset($_POST['view'])){

// $con = mysqli_connect("localhost", "root", "", "notif");

if($_POST["view"] != '')

{
   $update_query = "UPDATE comments SET comment_status = 1 WHERE comment_status=0";
   mysqli_query($con, $update_query);
}

$query = "SELECT * FROM comments ORDER BY comment_id DESC LIMIT 5";
$result = mysqli_query($con, $query);
$output = '';

if(mysqli_num_rows($result) > 0)
{

while($row = mysqli_fetch_array($result))

{

  $output .= '
  <li>
  <a href="#">
  <strong>'.$row["comment_subject"].'</strong><br />
  <small><em>'.$row["comment_text"].'</em></small>
  </a>
  </li>

  ';
}
}

else{
    $output .= '<li><a href="#" class="text-bold text-italic">No Noti Found</a></li>';
}

$status_query = "SELECT * FROM comments WHERE comment_status=0";
$result_query = mysqli_query($con, $status_query);
$count = mysqli_num_rows($result_query);

$data = array(
   'notification' => $output,
   'unseen_notification'  => $count
);

echo json_encode($data);
}
?>

Popularity 6/10 Helpfulness 1/10 Language php

Source: stackoverflow.com

Tags: build jquery messages php

Link to this answer
Share Copy Link

Contributed on May 18 2020

OSP PRO

0 Answers Avg Quality 2/10

Closely Related Answers

how to build jquery messages notification with php and mysq

Comment

$sql = "update tbl_noti set status = 'read'";
       $result = $conn->query($sql);
       $row = $result->fetch_assoc();
       $count = $result->num_rows;
       echo $count;
       $conn->close();

Popularity 8/10 Helpfulness 5/10 Language php

Source: www.sitepoint.com

Tags: build jquery j

Link to this answer
Share Copy Link

Contributed on May 18 2020

OSP PRO

0 Answers Avg Quality 2/10

how to build jquery messages notification with php and mysq

Comment

<script>

$(document).ready(function(){

// updating the view with notifications using ajax

function load_unseen_notification(view = '')

{

 $.ajax({

  url:"fetch.php",
  method:"POST",
  data:{view:view},
  dataType:"json",
  success:function(data)

  {

   $('.dropdown-menu').html(data.notification);

   if(data.unseen_notification > 0)
   {
    $('.count').html(data.unseen_notification);
   }

  }

 });

}

load_unseen_notification();

// submit form and get new records

$('#comment_form').on('submit', function(event){
 event.preventDefault();

 if($('#subject').val() != '' && $('#comment').val() != '')

 {

  var form_data = $(this).serialize();

  $.ajax({

   url:"insert.php",
   method:"POST",
   data:form_data,
   success:function(data)

   {

    $('#comment_form')[0].reset();
    load_unseen_notification();

   }

  });

 }

 else

 {
  alert("Both Fields are Required");
 }

});

// load new notifications

$(document).on('click', '.dropdown-toggle', function(){

 $('.count').html('');

 load_unseen_notification('yes');

});

setInterval(function(){

 load_unseen_notification();;

}, 5000);

});

</script>

Popularity 6/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: build jquery messages messa

Link to this answer
Share Copy Link

Contributed on May 18 2020

OSP PRO

0 Answers Avg Quality 2/10

how to build jquery messages notification with php and mysq

Comment

<script type="text/javascript">

$(document).ready(function(){
$("#datacount").load("select.php");
setInterval(function(){
$("#datacount").load('select.php')
}, 20000);
 });

</script>

Popularity 7/10 Helpfulness 2/10 Language php

Source: www.sitepoint.com

Tags: build jquery messages

Link to this answer
Share Copy Link

Contributed on May 18 2020

OSP PRO

0 Answers Avg Quality 2/10

how to build jquery messages notification with php and mysq

Contents

More Related Answers

how to build jquery messages notification with php and mysq

Closely Related Answers

how to build jquery messages notification with php and mysq

how to build jquery messages notification with php and mysq

how to build jquery messages notification with php and mysq

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.