Guys I followed a tutorial about how to implement a rest api with node+express+mysql and here is a route from inside my code REST.js file:
router.get("/companies",function(req,res){
var query = "SELECT * FROM ??";
var table = ["company"];
query = mysql.format(query,table);
connection.query(query,function(err,rows){
if(err) {
res.json({"Error" : true});
} else {
res.json({"Companies" : rows});
}
});
});
and this is how I call them using angular:
sampleApp.controller('InstallController', function($scope, $http) {
$http.get('http://localhost:3000/api/companies').
success(function (data) {
$scope.clients = data;
});
}
and html
<option ng-repeat="client in clients">{{client}}</option>
this is what I get as a response:
{
"Companies": [
{
"id": 1,
"name": "GOLF"
},
{
"id": 2,
"name": "RENAULT"
},
{
"id": 3,
"name": "AUDI"
},
{
"id": 4,
"name": "MAZDA"
}
]
}
My goal is to iterate on the result to populate a select tag with names. Bear with me please, I'm starting. Thank you :)