AngularJS with PHP and I want the response in JSON

Question

I want the response in JSON but I get the wrong response. I am learning AngularJS. Please help me.

I am using fetch.php code below:

<?php
    $servername = "localhost";
    $username = "root";
    $password = "admin";
    $dbname = "ghanshyam";
    // Create connection
    $conn = new mysqli($servername, $username, $password,$dbname );

    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 


     $query = "SELECT * FROM `table`"; 
     $result = $conn->query($query);
            if ($result->num_rows > 0) {
        // output data of each row
        while($row = $result->fetch_assoc()) {
           $r[] = $row;
        }
    } else {
        echo "0 results";
    }

    header('Content-Type: application/json');

    echo json_encode(($r));

    $conn->close();
?>

and also using HTML code below

<!DOCTYPE html>
<html>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.6.4/angular.min.js"></script>
<script src="comen.js"></script>
<body>
 <div>
     <p>hello</p>
    <table ng-app="myApp" ng-controller="myCtrl" >
        <tr ng-repeat="x in myWelcome track by $index">
            <td> {{ x.one}} </td>
            <td> {{ x.two }} </td>
            <td> {{ x.three }} </td>

        </tr>
    </table>
</div>
<script>
var app = angular.module('myApp', []);
app.controller('myCtrl', function($scope, $http) {
    $http.get("fetch.php")
    .success(function(response) {
        console.log(response.data);
        $scope.myWelcome = response.data;
    });
});
</script>
    </body>
</html>

I get the response as shown below:

<?php
$servername = "localhost";
$username = "root";
$password = "admin";
$dbname = "ghanshyam";
// Create connection
$conn = new mysqli($servername, $username, $password,$dbname );

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 


 $query = "SELECT * FROM `table`"; 
 $result = $conn->query($query);
        if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
       $r[] = $row;
    }
} else {
    echo "0 results";
}

Sachila Ranawaka · Accepted Answer · 2017-10-09 10:59:45Z

1

.success is deprecated since angular version 1.4.Since you are using version 1.6, use then to catch the response.

 $http.get("fetch.php")
    .then(function(response) {
        console.log(response.data);
        $scope.myWelcome = response.data;
    });

make sure to define the $r as an array also.

 $r = array();
 if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $r[] = $row;
    }
 } else {
        echo "0 results";
 }

edited Oct 9, 2017 at 10:59

answered Oct 9, 2017 at 10:54

Sachila Ranawaka

41.6k8 gold badges62 silver badges87 bronze badges

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

3 Comments

Prajapati Ghanshyam Over a year ago

actually i want json from MySql database. please help me

Prajapati Ghanshyam Over a year ago

i get out in fetch.php is "[{"one":"ghanshyam","two":"prajapati","three":"10","four":"20"},{"one":"qww","two":"cxzc","three":"12","four":"222"},{"one":"xcz","two":"xzcxz","three":"1111","four":"1111"},{"one":"qww","two":"cxzc","three":"12","four":"222"},{"one":"xcz","two":"xzcxz","three":"1111","four":"1111"}]"

Prajapati Ghanshyam Over a year ago

i want use that data in my html

Collectives™ on Stack Overflow

AngularJS with PHP and I want the response in JSON

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related