Codeigniter Tutorials

Home » Codeigniter »

How to send Notification to User?

Controller

File Name : Notification.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Notification extends CI_Controller {
public function __construct()
{
parent::__construct();
$this->load->model('Auth_model');
}

public function index() {
$this->load->view('notification');
}

public function insert_notification()
{
$subject = $this->input->post('subject');
$comment = $this->input->post('comment');

$data = array(
'comment_subject'=> $subject,
'comment_text'=> $comment
);
$result = $this->Auth_model->save_comment($data);

}

public function fetch()
{

if(isset($_POST['view'])){
if($_POST["view"] != '')
{
$data = array(
'comment_status'=>1
);
$this->db->where('comment_status','0');
$this->db->update('comments',$data);
}

$result = $this->Auth_model->get_notification();
$output = '';
if($result > 0)
{
foreach ($result as $row)
{
$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 = $this->db->query($status_query);
$count = $result_query->num_rows();
$data = array(
'notification' => $output,
'unseen_notification' => $count
);
echo json_encode($data);
}

}

}

View

File Name : notification.php

<!DOCTYPE html>
<html>
<head>
<title>Notification using PHP Ajax Bootstrap</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
</head>
<body>
<br /><br />
<div class="container">
<nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#">PHP Notification Tutorial</a>
</div>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="label label-pill label-danger count" style="border-radius:10px;"></span> <span class="glyphicon glyphicon-bell" style="font-size:18px;"></span></a>

<ul class="dropdown-menu"> </ul>

</li>
</ul>
</div>
</nav>
<br />
<form method="post" id="comment_form" action="<?php echo base_url()?>/notification/insert_notification">
<div class="form-group">
<label>Enter Subject</label>
<input type="text" name="subject" id="subject" class="form-control">
</div>
<div class="form-group">
<label>Enter Comment</label>
<textarea name="comment" id="comment" class="form-control" rows="5"></textarea>
</div>
<div class="form-group">
<input type="submit" name="post" id="post" class="btn btn-info" value="Post" />
</div>
</form>
</div>

<script>
$(document).ready(function(){

// updating the view with notifications using ajax
function load_unseen_notification(view = '')
{
$.ajax({
url:"<?php echo base_url()?>notification/fetch",
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:"<?php echo base_url()?>notification/insert_notification",
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>

</body>
</html>

Model

File Name : Auth_model.php

public function save_comment($data)
{
return $this->db->insert('comments', $data);

}

public function get_notification()
{
// $query = "SELECT * FROM comments ORDER BY comment_id DESC LIMIT 5";
$this->db->select('*');
$this->db->from('comments');
$this->db->order_by('comment_id','desc');
$this->db->limit('5');
$qry = $this->db->get();
return $qry->result();
}

File Name :

Example :- How to send notification in core php

File Name :

CREATE TABLE `comments` (
`comment_id` int(11) NOT NULL,
`comment_subject` varchar(250) NOT NULL,
`comment_text` text NOT NULL,
`comment_status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `comments`
ADD PRIMARY KEY (`comment_id`);
ALTER TABLE `comments`
MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

index page

File Name : index.php

<!DOCTYPE html>

<html>

<head>

<title>Notification using PHP Ajax Bootstrap</title>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>

<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />

<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

</head>

<body>

<br /><br />

<div class="container">

<nav class="navbar navbar-inverse">

<div class="container-fluid">

<div class="navbar-header">

<a class="navbar-brand" href="#">PHP Notification Tutorial</a>

</div>

<ul class="nav navbar-nav navbar-right">

<li class="dropdown">

<a href="#" class="dropdown-toggle" data-toggle="dropdown"><span class="label label-pill label-danger count" style="border-radius:10px;"></span> <span class="glyphicon glyphicon-bell" style="font-size:18px;"></span></a>

<ul class="dropdown-menu"></ul>

</li>

</ul>

</div>

</nav>

<br />

<form method="post" id="comment_form">

<div class="form-group">

<label>Enter Subject</label>

<input type="text" name="subject" id="subject" class="form-control">

</div>

<div class="form-group">

<label>Enter Comment</label>

<textarea name="comment" id="comment" class="form-control" rows="5"></textarea>

</div>

<div class="form-group">

<input type="submit" name="post" id="post" class="btn btn-info" value="Post" />

</div>

</form>

</div>
<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>
</body>

</html>

File Name : connect.php

<?php

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

?>

Insert

File Name : insert.php

<?php

if(isset($_POST["subject"]))

{

include("connect.php");

$subject = mysqli_real_escape_string($con, $_POST["subject"]);

$comment = mysqli_real_escape_string($con, $_POST["comment"]);

$query = "INSERT INTO comments(comment_subject, comment_text)VALUES ('$subject', '$comment')";

mysqli_query($con, $query);

}

?>

File Name : fetch.php

<?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);
}
?>

File Name :

Itechtuto

Codeigniter Tutorials

How to send Notification to User?

File Name : Notification.php

File Name : notification.php

File Name : Auth_model.php

File Name :

File Name :

File Name :

File Name :

File Name : index.php

File Name : connect.php

File Name : insert.php

File Name : fetch.php

File Name :

Connect Us Socially:

Quick Links