Angular $http.get doesn't return what i expected

Question

I'm trying to do a simple http get request but it doesn't return what i expected.

Here is the code

.js :

$http.get("database.php").success(function(data, status)
{
    alert(data);
    $scope.data = data;
}
).error(function(data, status)
{
    $scope.untruc = "Error";
});

.php :

<?php
header('Content-type: application/json');

$conn = // my connection

// Check connection
if ($conn->connect_error)
    echo "Connection failed";
else
{
    $sql = "SELECT id FROM user";
    $result = $conn->query($sql);
    echo json_encode($result);
}

?>

and the ouput is :

data : <?php header('Content-type: application/json'); $conn = // my connection; // Check connection    if ($conn->connect_error) echo "Connection failed"; else { $sql = "SELECT id FROM user"; $result = $conn->query($sql); echo json_encode($result); } ?>

literaly the code...

I'm expecting it to get the $result. Do you know how i could do that ?

Most likely a misconfigured webserver that does not pass the PHP files through the PHP interpreter — Torben Pi Jensen
– Torben Pi Jensen, Commented Jul 6, 2017 at 8:33
Is PHP installed on your server? For some reason your .php file isn't being handled as it should and returns the PHP code in plain text. — Adrian
– Adrian, Commented Jul 6, 2017 at 8:34
I just realised i wasn't testing it on a server but on local... Thank you — Momo Kebab
– Momo Kebab, Commented Jul 6, 2017 at 8:35

Liyaquet Hussain · Accepted Answer · 2017-07-06 11:22:31Z

1

Please check you php code once. And try to implement this code

<?php
header('Content-type: application/json');

$conn = new mysqli('localhost', 'root', 'password', 'database');

// Check connection
if ($conn->connect_error)
    echo "Connection failed";
else
{
    $sql = "SELECT * FROM users";
    $result = $conn->query($sql);
    $myresult = [];
    $i =0;
    while($row = $result->fetch_array()) {
		$myresult[$i] = $row;
		$i++;
	}
    
    //echo "<pre>";
    echo json_encode($myresult);
}

?>

answered Jul 6, 2017 at 11:22

Liyaquet Hussain

1015 bronze badges

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

Collectives™ on Stack Overflow

Angular $http.get doesn't return what i expected

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related