Can't poll SQL in Angular

Question

I checked several posts but I couldn't make it work. Here where I came so far:

myApp.controller('customersCtrl', function($scope, $http, $timeout) {
  var polling = function() {
    var value = $http({
      method: 'GET',
      url: 'poll.php'
    });

    value.success(function(data, status, headers, config) {
      $scope.records = data;
    });

    $timeout(function() {
      polling();
    }, 3000);
  };
  polling();
});

poll.php:

<?php 
$db = new mysqli('fdb4.freehostingeu.com', '1584066_users', '*******', '1584066_users');

if($db->connect_errno > 0){
    die('Unable to connect to database [' . $db->connect_error . ']');
}
$db->set_charset("utf8");
if(!$result = $db->query("SELECT * FROM mtp ORDER BY date DESC")){
    die('There was an error running the query [' . $db->error . ']');
} 

while($row = mysqli_fetch_assoc($result)){
    $row["date"] = strtotime($row["date"]) * 1000;
    $records[] = $row;
}
print( json_encode($records));
$result->free();
$db->close();
?>

It works on the first poll(); call but doesn't refresh if the SQL table updated from outside.

EDIT: I tried it by chance and somehow POST method worked in my case.

Will you please tell what exactly you want to do and what is error? — Laxmikant Dange, Jul 07 '15 at 05:59
@LaxmikantDange Sorry, I also realized that I gave insufficient information. and edited the question. The probem is it works on the first `poll();` call but doesn't refresh if the SQL table updated from outside. — Litestone, Jul 07 '15 at 06:00

Laxmikant Dange · Accepted Answer · 2015-07-07T06:55:04.207

0

When you use $interval or $timeout, then sometime you need to use $apply, try using $apply, it will work.

Here is your answer

myApp.controller('customersCtrl', function($scope, $http, $timeout) {
  var polling = function() {
    var value = $http({
      method: 'GET',
      url: 'poll.php'
    });

    value.success(function(data, status, headers, config) {
      $scope.records = data;
      $scope.$apply(); //Use $apply to start digest process manually.
       $timeout(function() {
         polling();
       }, 3000);
    });

  };
});

edited Jul 07 '15 at 06:55

answered Jul 07 '15 at 06:05

Laxmikant Dange

7,606
6
40
65

Yes, it looks like it should work. First poll(); works as usual, interval works, too... But no effect on the table. Maybe I should let the live update thing go. – Litestone Jul 07 '15 at 06:33
use $scope.$apply(); this is problem with digest. – Laxmikant Dange Jul 07 '15 at 06:36
I did, I did. I think it is jQuery mobile render problem. I have no other idea after all. EDIT: I removed jquery mobile js and css but no effect. – Litestone Jul 07 '15 at 06:42
Ok, I marked as answer because I believe it should work this way. I'll spend some time on it. – Litestone Jul 07 '15 at 06:50
I know this is against rules but may I request personal assist on this, please? – Litestone Jul 07 '15 at 08:18

score -1 · Answer 2 · answered Jul 07 '15 at 06:03

-1

You need $intervalinstead $timeout.

$timeout only wait 3 seconds and make a call then stops. With $interval you can instead wait 3 seconds, call the poll, wait 3 seconds, call the poll, etc...

myApp.controller('customersCtrl', function($scope, $http, $interval) {
  var polling = function() {
    var value = $http({
      method: 'GET',
      url: 'poll.php'
    });

    value.success(function(data, status, headers, config) {
      $scope.records = data;
    });

    $interval(function() {
      polling();
    }, 3000);
  };
  polling();
});

answered Jul 07 '15 at 06:03

michelem

14,430
5
50
66

It loads on the first poll(), but doesn't refresh the html table even I update the SQL table from outside. Can it be because of jQuery mobile? May be scope data is updating but table isn't being refreshed? Am I missing $scope.$apply or a similar thing? – Litestone Jul 07 '15 at 06:13
Calling interval inside function which calls that function will cause memory leak – Laxmikant Dange Jul 07 '15 at 06:53

Can't poll SQL in Angular

2 Answers2