darkscript's Profile
| About Me |
I live in code. Web and Stand Alone App Development.PHP, HTML, XHTML, DHTML, JS, jQuery, MYSQL, T-SQL, T-SQL Lite, C#, ASP.NET
|
| Languages Spoken |
English
|
| Company |
Nitsak
|
| Position |
Senior Software and Web Developer
|
| Interests |
Open Source Matters.
|
| Recent Code |
ADOBE AIR DATABASE EXPRESS OBJECT ( JS HTML )REQUIREMENTS---------------------1. an SQL lite Database with some data in it2. adobe air---------------------------1. Download the db.zip attached---------------------------<script type="text/javascript" src="db.js"></script>2. after you include the file you can use it like so---------------------------/* The dbo namsepaceis automatically added as soon as you include the script file.dbo stands for database objectdbo.init creates the connection and opens itdbo.execute is used for executing SQLdbo.fillData is used for returning the result of your querythis works similar to the PHP mysql_fetch_object*/// connect to the database// one.sqlite is my db namedbo.init('one.sqlite');// execute SQL commands// table name = groupsdbo.execute("SELECT * FROM groups");// return the datavar rows = dbo.fillData();// working with the datafor(var i = 0; i < rows.length; i++) { var row = rows[i]; // row.columnName// name is the name of the column I'm getting data fromalert(row.name);}-----------------------------------
|
|
Stats
Last online 02/25/10
Groups
darkscript is a member of the following Groups:
Adobe User Group - Durban
Group - Africa 49 Members
ExtJS with AIR Development
Group - Virtual 13 Members
|
