· 6 years ago · Nov 21, 2019, 07:40 PM
1// Create Database
2var db = openDatabase('Database', '1.0', 'myDB', 100000);
3
4function addNewData(time, date, task) {
5 db.transaction(function(tx) {
6 tx.executeSql('CREATE TABLE IF NOT EXISTS DATA (time, date, task)');
7 tx.executeSql("INSERT INTO DATA (time, date, task) VALUES (" + time + ",'" + date + "','" + task + "')");
8 redirectPage('http://192.168.1.230/create-feeding-schedule');
9 alert("run add");
10 });
11};
12
13function saveData() {
14
15 var getTime = $("#timeValue").val();
16 alert("time " + getTime);
17
18 var date = new Date();
19 var getDate = date.toString();
20 getDate = $("#dateValue").val();
21 alert("date " + getDate);
22
23 var task = "Feeding the fish";
24 addNewData(getTime, getDate, task);
25 alert("Notify: A new timer be added.");
26
27};
28
29function redirectPage(url) {
30 $(location).attr('href', url);
31}
32
33function errorDB(err) {
34 alert("Error processing SQL: " + err.code);
35}