Create JSON object in Ionic SQLite

Question

I am a beginner in Ionic. So, I want to convert JSON string to JSON object in ionic and to access JSON in html page.

controller.js

app.controller('OilTrackerListingCntrl', function($scope, $ionicPlatform, $cordovaSQLite) 
{
$scope.pTrackerData = '';
$cordovaSQLite.execute(dbApp, "SELECT TOTAL_KM, SERVICE_DATE, AMOUNT_PAID, NEXT_SERVICE_DATE FROM OIL_TRACKER")
                .then(
                    function(res) {
                        $ionicLoading.hide();
                        if (res.rows.length > 0) {


                            for (var i = 0; i < res.rows.length; i++) {

                                var varTrackerData = new TrackerData(res.rows.item(i).TOTAL_KM, res.rows.item(i).SERVICE_DATE, res.rows.item(i).AMOUNT_PAID, res.rows.item(i).NEXT_SERVICE_DATE);
                                SelectedTracker.push(varTrackerData);   
                            }
                            var d = JSON.stringify(SelectedTracker);
                            alert(d);
                            $scope.pTrackerData = d;
                            alert($scope.pTrackerData);
                        } else {
                            alert('Not getting');
                        }
                    },
                    function(error) {
                        alert("Error on loading: " + error.message);
                    }
                );
}

eli-k · Accepted Answer · 2016-12-05 12:44:26Z

1

Try this

  var d = JSON.stringify(SelectedTracker);    

   alert(d);  

    $scope.pTrackerData = JSON.parse(d);  

   $scope.pTrackerData = JSON.parse(d);   

 alert($scope.pTrackerData);

edited Dec 5, 2016 at 12:44

eli-k

11.5k12 gold badges46 silver badges48 bronze badges

answered Dec 5, 2016 at 11:20

Jyothish

1611 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create JSON object in Ionic SQLite

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related