i wish to display data from mysql dataBase using angularJS but all in vain. Pls review myu code and suggest me where am i going wrong:
<?php
$host = "localhost";
$user = "";
$pass = "";
$database = "abc";
$con = mysql_connect($host,$user,$pass);
if (!$con) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_select_db($database,$con);
//select
$query = "SELECT * FROM `product`";
$result = mysql_query($query) OR die(mysql_error());
$arr = array();
//now we turn the results into an array and loop through them.
while ($row = mysql_fetch_array($result)) {
$name = $row['name'];
$description = $row['description'];
//echo 'This is: ' . $name . ' ' . $description . "<br/>\n"
$arr[] = $row;
}
echo json_encode($arr);
?>
controllers.js
function ProductListCtrl($scope,$http) {
$http.get('php/connect.php').success(function(data) {
$scope.products = data;
});
//$scope.orderProp = 'name';
}
index.html
<html ng-app>
<head>
<script src="../angular-1.0.1.min.js"></script>
<script src="js/controllers.js"></script>
</head>
<body>
<ul ng:controller="ProductListCtrl">
<li ng:repeat="product in products">
{{product.name}}
</li>
</ul>
</body>
</html>
when i run index.html, i get infinite list of bullets with no result displayed. Where am i going wrong?
