LuaSQL Developer Tool Released (neat!)
PSP News Reports:
News/release from shaolan
is something for those who know how SQL and databases work so for the
majority of us this wont be good for us, but heres the translated
newspost: (note from Auri - this is actually a good thing, if we can access a SQL database there's a lot we can do from the PSP from an application standpoint)
All of abors veiled all the necessary file:
LuaSQLv0.1.rar
Then you must have a server supporting PHP, with many on SQL database
Server side:
If you have an archive file PHP, metté its contents at the root of your server (or is generally your "index.php")
You: votre_serveur / LUA / SQLRequest.php
Cote PSP:
Code:
-- / / Calls to the bookstore
Dofile ( "SQLRequest.lua")
-- / / Initializing connection
SQL.init (server, database, login, password)
-- / / Connect to the database
SQL.connect ()
Code:
-- / / SELECT Request
Variable = SQL.select (table, field, parameter)
-- / / UPDATE Request
SQL.update (table, field value parameter)
Code:
-- / / Closing connection SQL
SQL.close ()
Note:
- When you make the UPDATE query, the query if it is well spent, the
variable SQL.error is false if there was a mistake it true worth
- The library uses by default the first WiFi connection, and operates under the LUA PLAYER 0.16
- DAns the parameter you can save as much as you want, but the spaces
doivents be replaced by% 20 and evité quotes singles or doubles for the
moment
It was only the first version, I intend to optimize shortly and metttre
available throughout the SQL query, this is a "preview" rendering final
^ ^
CODE GOOD!
Download here.