Pulling SQLite data from teh db with HTML5 and JavaScript.

Okay, probably pretty simple for those who know sqlite and html5 already...

I am trying to use javascirpt to pull data back out of my sqlite db, and show the results on the screen. Let me just start there. I can get into formatting later.

i have a db that I can open, and write data into the table I created. I have 5 fields, the 1st being the autonumber 'id' field. The rest I fill in, and submit them into the database.

Now I just want to create a simple SELECT * FROM Mydb, and print the results to the screen.

I have no idea how to do this correctly, particuarly in an html5 page using javascript.

Any help is greatly appreciated.

Brian

JavaScript is a client-side language. For security reasons, client-side languages cannot have direct access to a database (this would imply passwords and other sensitive data to travel insecurely through the net). To pull information from a database (SQlite, MySQL, SQL, etc) you need to use a server-side language like PHP.

Once you have parsed that information from the database on the server, you can then send it to the client (your browser) and do all kinds of crazy stuff with JavaScript.

If you need more clarification on the difference between a client-side language and a server-side language, take a look at this good tutorial:

http://www.scriptingok.com/tutorial/Ser ... lient-side

Let me know if you have any other question.

REGARDS

Okay, should have been more clear. This is a cached webapp for the iphone that I'm working on. I need to simply pull the data from the db with a select statement, and then be able to know where the data is so I can put it on the screen in the html5 code.

No need for security, because it's not going over a network or internet. For any security based parts will definitely use php.

Does that help...I know this can be done, I'm just not familiar with the format for doing it.

Thanks,

Brian

I know GEARS from Google allows you to do that on several desktop and mobile platforms. I'm not sure if the project includes iPhone. Why don't you give it a look?

http://code.google.com/apis/gears/