Edit Infobox PSP Homebrews: LuaSQL PSP

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in one of the groups: Users, Administrators.

Title:
Image:	Upload file
Description:
Author(s):
Last Updated:
Contributor(s):
Ported by:
Type:
Version:
License:
Language(s):
Format:
Download:
Download Raw:
Website:
Source:
Discussion:
Donation:

Free text:

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: <pre>--// Calling the library dofile("SQLRequest.lua") --// Initializing the connection SQL.init(server, database, login, password) --// Connecting to the database SQL.connect() </pre> <pre>--// SELECT query variable = SQL.select(table, field, parameter) --// UPDATE query SQL.update(table, field, value, parameter) </pre> <pre>--// Closing the SQL connection SQL.close() </pre> 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 - [https://web.archive.org/web/20071202060125/http://xtreamlua.com/modules.php?name=Forums&file=viewtopic&t=2537 http://xtreamlua.com/modules.php?name=Forums&file=viewtopic&t=2537] (archived) [[Category:Lua applications on PSP]]

Summary:

Cancel