Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. function saveFoodToDatabase(dag, typeFood, calories) {
  2. db.transaction(saveFoodDB, errorDB, successDB);
  3. function saveFoodDB(tx) {
  4. getNewDatabaseID(function callback(_newID) {
  5. var newID = _newID;
  6. alert(dag + ' ' + newID);
  7. tx.executeSql('INSERT INTO tabel (_id, datum, food, cal) VALUES ('
  8. + newID + ' , date("now" , "-' + dag + ' days"), "'
  9. + typeFood + '" , ' + calories + ')');
  10. });
  11. }
  12. function errorDB(err) {
  13. alert("Error processing SQLsave: " + err);
  14. }
  15. function successDB() {
  16. $.mobile.changePage("#dayPage");
  17. }
  18. }
  19.  
  20. function getNewDatabaseID(callback) {
  21. db.transaction(getMaxIDDB, errorDB);
  22. function getMaxIDDB(tx) {
  23. tx.executeSql('SELECT _id FROM tabel ORDER BY _id DESC', [], querySuccess, queryError);
  24. }
  25. function errorDB(err) {
  26. alert("Error processing SQLnew: " + err);
  27. }
  28. function queryError(err) {
  29. alert("ERROR reading SQL" + err);
  30. }
  31. function querySuccess(tx, results) {
  32. callback(results.rows.item(0)._id + 1);
  33. }
  34. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement