I tried to insert multiple data in my sqlLite table, but it does not work as intended.
This is my Create function:
function Create() {
console.log("DBITEMS CREATED")
db.transaction(tx => {
tx.executeSql("CREATE TABLE IF NOT EXISTS DBITEMS(ID INTEGER PRIMARY KEY NOT NULL, DATE TEXT, HEURE TEXT, MINUTES TEXT)")
});
}
This is my Insert function:
function Insert(date) {
let d = new Date(date)
console.log('\nDATE:',date)
var dString = d.toISOString().split('T')[0].toString()
let heure = d.getHours().toString()
let minutes = d.getMinutes().toString()
db.transaction(tx => {
tx.executeSql("INSERT INTO DBITEMS(DATE,HEURE,MINUTES) VALUES(?,?,?)", [dString,heure,minutes],(tx,result)=>{
if (result.rows.length > 0) {
console.log('Data Inserted Successfully...',date)
} else console.log('Failed...')
})
})
}
This is the console output:
DATE: 2022-03-15T16:35:36.626Z