Notify changes in the database

Question

Here is a snippet of the script I am using to fetch record in the database.

   var url = '../waitOrders?restaurant_id=1;

    $(document).ready(function() {
            $.ajaxSetup({ cache: false }); 
            setInterval(function() {$("#displayarea").load(url); }, 400);
        });

It works fine but my question is that is there a way to notify me that the database has a new record or changes?

score 1 · Answer 1 · answered Feb 04 '14 at 10:04

1

1) You can write the triggers for that, which is informed you whenever new entry of data is occure.

OR

2) you can use User Define Functions which helped you when new entry comes to database.

answered Feb 04 '14 at 10:04

Mitul Maheshwari

2,647
4
24
38

do you have any examples of triggers? – user3230425 Feb 04 '14 at 13:41
sorry, buddy i don't have. but you can find on google – Mitul Maheshwari Feb 04 '14 at 13:48

score 0 · Answer 2 · answered Feb 04 '14 at 09:46

I am not sure what database you are using but if you were using php and mysql:

$query = $db->query("SELECT `articles`.`title`  FROM `articles` LIMIT 6");

while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
echo $row['title'], '<br>';
}

echo '<p>Returned ', $query->rowCount(), ' results</p>';

the $query object is using the rowCount() method to return the number of records added to the databases, so not sure if this answers your question.

Notify changes in the database

2 Answers2