wraggster
November 30th, 2007, 15:29
News/release from shaolan (http://xtreamlua.com/modules.php?name=Forums&file=viewtopic&t=2537) 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:
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 and Give Feedback Via Comments
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 and Give Feedback Via Comments