Report, edit, etc...Posted by Pyro-Fire on 2006-12-20 at 11:06:54
i am working on a module which fully induces the sql language to manage a database that is stored locally in a folder.
Current SQL Statements Available:
SELECT
UPDATE
Both are completely functional, works exactly like it does on a website.... wildcards are not supported yet.. and when using commas to breakup data (such as select username,password ect ect), use a space instead with no comma. its just not implemented yet.
Anyway, im quite proud of this module, which is completely self-sufficient, all you must provide is the database, and the mysql statement, and it returns all data/makes changes as neccessery.
i'll post the preview of the module.
Please note: dont mind that lil msgbox that pops at the start... its not the only table you can use... its just the only table that exists in the database by default.
So.. where is the database you ask? its kept in the folder called "Database". you can change anything inside it.. but you must keep this syntax:
Database
--Table
----entry_NUMBER.ini
----entry_NUMBER.ini
----entry_NUMBER.ini
--Table
----entry_NUMBER.ini
and so on..
please keep all data inside the ini files the same across the board... so if 1 of them has username, all others should too...
also with updating, please ensure there is no spaces between the 2 key variables (variable=value)
Why all these precautions before running a statement? because i havent added error controls yet
the sql statements are the highest priority.. only built-in errors have been done..
note: doesnt support limit or orderby...yet
Have fun and be sure to check for updates!
[attachmentid=22162]
Note: this is the preview, not the module. preview coded in vb2005 too.
Current SQL Statements Available:
SELECT
UPDATE
Both are completely functional, works exactly like it does on a website.... wildcards are not supported yet.. and when using commas to breakup data (such as select username,password ect ect), use a space instead with no comma. its just not implemented yet.
Anyway, im quite proud of this module, which is completely self-sufficient, all you must provide is the database, and the mysql statement, and it returns all data/makes changes as neccessery.
i'll post the preview of the module.
Please note: dont mind that lil msgbox that pops at the start... its not the only table you can use... its just the only table that exists in the database by default.
So.. where is the database you ask? its kept in the folder called "Database". you can change anything inside it.. but you must keep this syntax:
Database
--Table
----entry_NUMBER.ini
----entry_NUMBER.ini
----entry_NUMBER.ini
--Table
----entry_NUMBER.ini
and so on..
please keep all data inside the ini files the same across the board... so if 1 of them has username, all others should too...
also with updating, please ensure there is no spaces between the 2 key variables (variable=value)
Why all these precautions before running a statement? because i havent added error controls yet
the sql statements are the highest priority.. only built-in errors have been done..note: doesnt support limit or orderby...yet
Have fun and be sure to check for updates!
[attachmentid=22162]
Note: this is the preview, not the module. preview coded in vb2005 too.
Report, edit, etc...Posted by Doodle77(MM) on 2006-12-20 at 19:11:21
Only one entry per text file?
Report, edit, etc...Posted by Pyro-Fire on 2006-12-21 at 03:04:58
each entry file is a new row.
Report, edit, etc...Posted by Pie_Sniper on 2006-12-27 at 16:14:02
Why not just put all the entries in one file named after the database?
Report, edit, etc...Posted by Pyro-Fire on 2006-12-28 at 05:03:03
because its a lot easier if multiple files are used. i dont use a proper function to read the INI files.