โค้ด: เลือกทั้งหมด
photoApp.controller('AccountCtrl', function ($scope, $cordovaDevice, $ionicPlatform, $cordovaSQLite) {
$scope.Save = function (username, useGps, urlname) {
if ($scope.id_row > 0) {
alert($scope.id_row);
// update
var id = $scope.id_row;
var query = "UPDATE usersetting SET username = ? ,useGps = ? , urlname = ? WHERE id = ? ";
$cordovaSQLite.execute(db, query, [username, useGps, urlname,id]).then(function (result) {
$scope.insert = "บันทึกสำเร็จ";
console.log($scope.insert + '-------------------------------------');
}, function (error) {
$scope.insert = "ไม่สามารถบันทึกข้อมูลได้" + error;
});
}
};
});