โค้ด: เลือกทั้งหมด
photoApp.controller('AccountCtrl', function ($scope, $cordovaDevice, $ionicPlatform, $cordovaSQLite) {
// $scope.settings = {
$scope.enableGps = true;
$scope.id_row = 0;
//$scope.select = function () {
var query = "SELECT id,username, useGps,urlname FROM usersetting";
$cordovaSQLite.execute(db, query).then(function (result) {
alert(result.rows.item(0).id);
$scope.id_row = result.rows.item(0).id;
if (result.rows.length > 0) {
for (var i = 0; i < result.rows.length; i++)
{
console.log("username : " + result.rows.item(i).username + " urlname : " + result.rows.item(i).urlname);
alert("username : " + result.rows.item(i).username + " urlname : " + result.rows.item(i).urlname);
}
$scope.username = result.rows.item(0).username;
if ($scope.username == '') {
$scope.username = $cordovaDevice.getModel();
}
$scope.useGps = result.rows.item(0).useGps;
$scope.urlname = result.rows.item(0).urlname;
$scope.id = result.rows.item(0).id;
} else {
console.log("NO ROWS EXIST");
}
}, function (error) {
console.error(error);
});
});