Hi, Arhnuld. Thanks for your tutorial of Web SQL and Onsen. I want to make tutorial from this and for the next part (SELECT, UPDATE) in Bahasa. I write this video link, i will. Thanks so much
I finally resolved this problem ;) , but I have question can do it the same application without using database, just like in many websites using clean javascript or jquery ?
That's extremely easy. On all platforms local storage can be accessed using the Window.localStorage object (or just localStorage) The drawback of this is that you can only store strings and not more complex objects. You can work around this by converting objects to strings by using JSON.stringify before storing and JSON.parse after reading. Here's good documentation: developer.mozilla.org/nl/docs/Web/API/Window/localStorage
Hi Arhnuld I see webSQL and its functions are no longer supported at least in Firefox. So openDatabase etc no longer work. What is the best alternative? And have you perhaps updated the code accordingly?
Hello Arhnuld, can you tell me if WebSQL is still a proper source for back database? I don't see any syntax errors in my code but i'm getting a message saying "Something went wrong:could not prepare statement (1 no such table: item)". Thanks for the awesome video! I really like Onsen because I can create apps using vanilla javascript, as a beginner programmer I have found it to be the best starting point. I will look into Vue, Ionic(angular) and the other after getting some coding experience.
Awesome! Thanks for uploading! I can see two typos that mess up the script: CREATE TABLE IF NOT EXIST should be CREATE TABLE IF NOT EXISTS document.getElementByID should be document.getElementById CSS looks okay here. Maybe you can try switching to device view in Chrome? (F12 and then ctrl+shift+m) and refresh with F5?
Yes i'm glad GitHub is available lol. Thanks for finding the typos(noob mistakes :-). I have posed the updates to GitHub -CSS: I"m currently loading those via CDN, when I try to use customized CSS created by the CSS tool you used and I point my import to the local copy, all styling is lost. I will try and sort it. Thanks again!
![[#2024MAMA] BIGBANG (빅뱅) - 뱅뱅뱅 (BANG BANG BANG) + FANTASTIC BABY | Mnet 241123 방송](http://i.ytimg.com/vi/EQsYfiPR9uM/mqdefault.jpg)
This is simply great and simple for me to understand.
nice tutorial really enjoying it, can i ask with create CRUD app.Can you create some tutorial bcs i stuck with UPDATE function.
Hi, Arhnuld. Thanks for your tutorial of Web SQL and Onsen. I want to make tutorial from this and for the next part (SELECT, UPDATE) in Bahasa. I write this video link, i will. Thanks so much
I finally resolved this problem ;) , but I have question can do it the same application without using database, just like in many websites using clean javascript or jquery ?
how can i connect onsen ui to a remote database or mysql
my error is openDatabase is not defined. Why?
nice tutorial. so i was wondering can you store data to android/ios local storage using hybrid app? if yes, how?
That's extremely easy. On all platforms local storage can be accessed using the Window.localStorage object (or just localStorage)
The drawback of this is that you can only store strings and not more complex objects. You can work around this by converting objects to strings by using JSON.stringify before storing and JSON.parse after reading.
Here's good documentation: developer.mozilla.org/nl/docs/Web/API/Window/localStorage
Arhnuld oh so do you mean i can do that with just a simple html and js without frameworks? Cool. Thank you for replying so fast by the way :)
Rockin' Paladin Yes, it's a standard feature. No problemo.
Looking for third part! :)
Uploaded it right after you posted this, hope you found it!
The add button just doesn't work for me, what am I doing wrong??? please assist.
Waarom staat er bij errors: openDatabase is not defined????
your voice is like arnold
Hi Arhnuld I see webSQL and its functions are no longer supported at least in Firefox. So openDatabase etc no longer work. What is the best alternative? And have you perhaps updated the code accordingly?
I think localstorage is the alternative
@@its.arjun.s I'm getting "Something went wrong: undefined". Is that why because of webSQL is no longer supported?
Hello Arhnuld, can you tell me if WebSQL is still a proper source for back database? I don't see any syntax errors in my code but i'm getting a message saying "Something went wrong:could not prepare statement (1 no such table: item)". Thanks for the awesome video! I really like Onsen because I can create apps using vanilla javascript, as a beginner programmer I have found it to be the best starting point. I will look into Vue, Ionic(angular) and the other after getting some coding experience.
Sure! It's supported in Chrome (caniuse.com/#search=storage). In the example code, the table is called 'items', maybe you missed an 's' somewhere?
Awesome! Thanks for uploading!
I can see two typos that mess up the script:
CREATE TABLE IF NOT EXIST should be CREATE TABLE IF NOT EXISTS
document.getElementByID should be document.getElementById
CSS looks okay here. Maybe you can try switching to device view in Chrome? (F12 and then ctrl+shift+m) and refresh with F5?
Yes i'm glad GitHub is available lol. Thanks for finding the typos(noob mistakes :-). I have posed the updates to GitHub
-CSS: I"m currently loading those via CDN, when I try to use customized CSS created by the CSS tool you used and I point my import to the local copy, all styling is lost. I will try and sort it. Thanks again!
What did i do wrong..... everything is working except the part to click on the bin and delete item.... it doesn't delete.
"you need to add" getItems(); "just below function" onSuccess(tx, r){
please perhaps you could post a link to the sourcecode?
I don't mind sharing my code with you, if you don't mind helping me troubleshoot the one error i'm getting?
hello guys this is arnuldddd :-))))))