How to notify when new record inserted in sql database in php?

Today, We want to share with you php notification alert when new record is inserted.In this post we will show you php notification popup, hear for notification in php demo we will give you demo and example for implement.In this post, we will learn about
Build Push Notification System with PHP & MySQL with an example.

notification alert in php mysql

how to build jquery messages notification with php and mysql?

update Query

$sql = "update alerting_list set is_active = 'read'";
       $response = $conn->query($sql);
       $row = $response->fetch_assoc();
       $count = $response->num_rows;
       echo $count;
       $conn->close();

php form insert to database and give notification

index.php

Database

--
-- Database: `all_brands`
--

-- --------------------------------------------------------

--
-- Table structure for table `discusstions`
--

CREATE TABLE IF NOT EXISTS `discusstions` (
  `discusstion_id` int(11) NOT NULL,
  `discusstion_head_title` varchar(250) NOT NULL,
  `discusstion_text` text NOT NULL,
  `discusstion_is_active` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `discusstions`
--
ALTER TABLE `discusstions`
  ADD PRIMARY KEY (`discusstion_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `discusstions`
--
ALTER TABLE `discusstions`
  MODIFY `discusstion_id` int(11) NOT NULL AUTO_INCREMENT;

final code

index.php

 
  
  
  
  
 
 
  


  

   
   

   
Simple Facebook Style Header Notification using PHP Ajax Bootstrap
   

   

    

     Give Any Subject
     
    
    

     Give Any Comment
     
    
    

     
    
   
   
  
 

I hope you get an idea about real time notification in php.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.