I'm new to AngularJS and I need help writing a function that can populate a select element with data from a database table. While I am able to fill the select element, I am struggling to set the default value for it.
Here is my code:
HTML :
<div id="super-regional-modal" ng-controller="RegionalController">
<form name="regionalform" id="regionalform">
<div class="form-group">
<div class="row">
<div class="input-field col s12">
<span style="color:#DA1022;">* </span><label for="regionalInfoTipoRegional">Label Test</label>
<select class="form-control" id="regionalInfoTipoRegional" name="regionalInfoTipoRegional" ng-model="regionalInfo.tipoRegional" ng-init="regionalInfo.tipoRegional = populateSelect('select * from wrk_tests')" ng-options="tiporegional as tiporegional.cidade for tiporegional in populate_select_output track by tiporegional.id" ng-required="true"></select>
</div>
</div>
</div>
</form>
</div>
Javascript :
'use strict';
angular.module("acsApp").controller("RegionalController", ["$scope", "$http", "$state", "$stateParams", "$timeout", "$sce", "toaster", function ($scope, $http, $state, $stateParams, $timeout, $sce, toaster){
$scope.populateSelect = function(sqlselect){
$http.post("modulos/sistema/php/sys/fillDB.php", {"sqlselect" : sqlselect}
).success(function(data, status, headers, config){
$scope.populate_select_output = data.records;
}).error(function(data, status, headers, config){
console.error(data);
});
}
PHP :
<?php
header("Access-Control-Allow-Origin: *");
include($_SERVER["DOCUMENT_ROOT"]."/".explode("/",$_SERVER["PHP_SELF"])[1]."/functions.php");
include($_SERVER["DOCUMENT_ROOT"]."/".explode("/",$_SERVER["PHP_SELF"])[1]."/clsConnection.php");
$cls_database = new Database();
$db = $cls_database->getConnection();
$data = json_decode(file_get_contents("php://input"));
$sqlselect = $data->sqlselect;
$stmt = $db->prepare($sqlselect);
$stmt->execute();
$num = $stmt->rowCount();
$arr = array();
if($num>0){
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)){
extract($row);
$arr[] = $row;
}
}
header("Content-Type: application/json; charset=UTF-8");
echo json_encode(['records' => $arr]);
?>
Any assistance would be greatly appreciated. Thank you!