I am loking for a concept to geting started is there a way of creating a notification like on user end any one updates his post update or upload an image then on admin panel it notifies the admin like on menu bar it shows 1 and when the admin click on it it becomes 0 i know it is a tricky part i will get started but i want to get a guidline from experts here. I was thinking to create a count query and put a table of pending or something so when ever a user uploads an image and it will be approved by the admin
so how about this
$count = mysqli_query($connection, "SELECT * FROM table_name WHERE status='pending'" AND WHERE userid='1'); $result = mysqli_num_rows($count); echo $result;
How is this approch is it user friendly??