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!
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