LuaSQL PSP

LuaSQL
General
Author	shaolan
Type	Demos
Version	0.1
License	Mixed
Last Updated	2007/11/19
Links
Download
Website
Source

A library to access SQL through PHP.

User guide

You will need a server that supports PHP and SQL databases.

In the archive, you will find a "PHP" folder. Place its contents at the root of your server (typically where your "index.php" file is located).

You should have: your_server/LUA/SQLRequest.php

PSP Side:

--// Calling the library
dofile("SQLRequest.lua")
--// Initializing the connection
SQL.init(server, database, login, password)
--// Connecting to the database
SQL.connect()

--// SELECT query
variable = SQL.select(table, field, parameter)

--// UPDATE query
SQL.update(table, field, value, parameter)

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

Notes:

• When performing the UPDATE query, if it succeeds, the variable SQL.error will be false; if there’s an error, it will be true.
• The library uses the first available Wi-Fi connection by default and works with LUA PLAYER 0.16.
• In the parameters, you can include as many as you want, but spaces should be replaced with %20, and avoid using single or double quotes for now.

External links

• XtreamLua - http://xtreamlua.com/modules.php?name=Forums&file=viewtopic&t=2537 (archived)