Data not showing with angular $http service by using php?

Question

im building a project with angular,i have a html form that sends data to "customers" table in MYSQL. now i want to show the data of "customers" table. this is my code that i tried to get that data but its not working. can anyone help?

php code:

<?php
  $con = mysqli_connect('localhost','root','','hamatkin');
  if(!$con){
    die("couldnt connect".mysqli_error);
  }
  $query = "SELECT * FROM customers";
  $result = $con->query($query);
  $r = array();
  if( $result->num_rows>0){
    while($row = $result->fetch_assoc()){
      $r[] = $row;
    }
  }
  $res = json_encode($r);
  echo $res;
  echo $sql_statement;
  ?>

controller:

"use strict";
var app = angular.module('dataSystem',[]);
app.controller('customerCardsCtrl',function($scope,$route,$location,$http){
    $http({method:'GET', url:'api/get-allCustomers.php'}).success(function(response){
        $scope.customers = response.data;
      });
    });
});

html code:

<!DOCTYPE html>
<html >
<head>
    <title></title>
</head>
<body>


    <div>
      <table ng-controller="customerCardsCtrl" >
        <tr ng-repeat="x in customers">
        <td> {{ x.customer_id}} </td>
        <td>{{ x.first_name }}</td>
        <td>{{ x.last_name }}</td>
        <td> {{ x.id}} </td>
        <td> {{ x.city}} </td>
        <td> {{ x.adress}} </td>
        <td> {{ x.phone}} </td>
        <td> {{ x.email}} </td>
        <td> {{ x.fax}} </td>
        <td> {{ x.referrer}} </td>
        <td> {{ x.comments}} </td>

        </tr>
        </table>
    </div>
</body>
</html>

you print 2 json in php side. please remove 1 which is not correct. — Paresh Gami
– Paresh Gami, Commented May 20, 2016 at 9:47

Chukwuemeka Ihedoro · Accepted Answer · 2016-05-20 11:03:50Z

0

use this code instead

"use strict";
var app = angular.module('dataSystem',[]);
app.controller('customerCardsCtrl',function($scope,$route,$location,$http){
  $http({method:'GET', url:'api/get-allCustomers.php'})
    .then(function(response){
           $scope.customers = response.data;
       }, function(response){
           console.log(response)
       });
});

edited May 20, 2016 at 11:03

answered May 20, 2016 at 10:38

Chukwuemeka Ihedoro

6051 gold badge6 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Dennis Kapitankin Over a year ago

the console showing me: warning tried to load angular more than once, and: script1002: syntax error customerCardsCtrl.js(8,1), and: error: [ng:areq] argument 'customerCardsCtrl' is not a function got undefined

Chukwuemeka Ihedoro Over a year ago

did you remove that extra }); you added?

Dennis Kapitankin Over a year ago

i have to leave the extra }): because without it the page isn't working

Chukwuemeka Ihedoro Over a year ago

the rest of your code is ok except that you must remove echo $sql_statement; in your php code. please try the edited controller code

Dennis Kapitankin Over a year ago

i removed echo_$sql statement, and i tried the edited code but the code makes the pages not to work , thats why i have to do an extra }); and then the page working great except not showing details from table "customers". but thanks for trying to help ! can u try to help in another program?(skype,teamviewer, chrome remote desktop)

|

Collectives™ on Stack Overflow

Data not showing with angular $http service by using php?

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related