Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function saveFoodToDatabase(dag, typeFood, calories) {
- db.transaction(saveFoodDB, errorDB, successDB);
- function saveFoodDB(tx) {
- getNewDatabaseID(function callback(_newID) {
- var newID = _newID;
- alert(dag + ' ' + newID);
- tx.executeSql('INSERT INTO tabel (_id, datum, food, cal) VALUES ('
- + newID + ' , date("now" , "-' + dag + ' days"), "'
- + typeFood + '" , ' + calories + ')');
- });
- }
- function errorDB(err) {
- alert("Error processing SQLsave: " + err);
- }
- function successDB() {
- $.mobile.changePage("#dayPage");
- }
- }
- function getNewDatabaseID(callback) {
- db.transaction(getMaxIDDB, errorDB);
- function getMaxIDDB(tx) {
- tx.executeSql('SELECT _id FROM tabel ORDER BY _id DESC', [], querySuccess, queryError);
- }
- function errorDB(err) {
- alert("Error processing SQLnew: " + err);
- }
- function queryError(err) {
- alert("ERROR reading SQL" + err);
- }
- function querySuccess(tx, results) {
- callback(results.rows.item(0)._id + 1);
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement