LuaSQL v0.1 - Lua database for the PSP

Posted Nov 30, 2007 at 2:24AM by QJ Staff Listed in: Homebrew Development Tags: Lua, Lua Player, shaolan
Ó


LuaSQL v0.1 for the PSP - Image 1Need to access a database with your PSP? Why not try shaolan's LuaSQL v0.1? This library allows homebrew developers to access SQL through PHP. Users can now create web-based applications with lots of data entries as well as access various security features that are inherent with SQL.

To use this program, you will need a server that supports PHP and has an SQL Database. The library uses the first WiFi connection by default and works on Lua Player v0.16. Since this is the first release of the program, the developer intends on optimizing the code of the homebrew and increasing the functions available via SQL queries.

If you plan on using the program, shaolan included some basic code blocks that you will need to access the database.

Starting a session:
French:

--// appelle de la librairie
dofile("SQLRequest.lua")
--// Initialisation de la connexion
SQL.init(serveur,database,login,password)
--// Connexion à la base de données
SQL.connect()


English:

Calls to the bookstore
Dofile ( "SQLRequest.lua")
Initializing connection
SQL.init (server, database, login, password)
Connect to the database
SQL.connect ()


Queries:
French:

--// Requete SELECT
variable = SQL.select(table,champ,parametre)
--// Requete UPDATE
SQL.update(table,champ,valeur,parametre)


English:

--//SELECT Request
Variable = SQL.select (table, field, parameter)
--//UPDATE Request
SQL.update (table, field value parameter)


Ending a session:
French:

--// Ferme la connexion SQL
SQL.close()

English:

--//Closing connection SQL
SQL.close ()

Download: LuaSQL v0.1

Via XtremeLUA

 
 
 

Comments

No Comments, be the first to Comment

Add New Comment




You must be logged in to post comments




Add QJ.NET
Add to My Yahoo!
Google Reader Subscribe with Bloglines
Add  to your Kinja digest Subscribe in NewsGator Online
Subscribe with Pluck RSS reader Add 'www.qj.net' to Newsburst from CNET News.com
Subscribe with SearchFox RSS del.icio.us www.qj.net
Add to Technorati Favorite! Add to My AOL
furl! it Stumble for Treehugger!