SQL querys
Hi,
I've used SQL alot, but both SQLx and DBI modules seem too confusing. Can someone write me some code:
|
Re: SQL querys
A great tut for sqlx - https://forums.alliedmods.net/showthread.php?t=46779
|
Re: SQL querys
Yeah, I've read that. It's too confusing. What's with those SQL drivers anyway, they have so many variables and functions etc.
|
Re: SQL querys
Forgot to say: I'd prefer a DBI solutions as it seems more light-weight.
|
Re: SQL querys
Forget about dbi, dbi is old and unsuported, use sqlx.
So, first of all you need to define the sql data like db user host pass in your plugin_init(for example) - g_SqlTuple = SQL_MakeDbTuple(SQL_HOST,SQL_USER,SQL_PASS,SQ L_DB); where g_SqlTuple is .. you get'it from that tut. PHP Code:
|
Re: SQL querys
Yeah, but why do I need this QueryHandle? And how can I convert a SELECT query result into array?
|
Re: SQL querys
Quote:
Quote:
|
Re: SQL querys
I have. Maybe I should refrase it: how can DBI and also PHP do SQL querys without using queryhandles?
|
Re: SQL querys
sqlx without threaded query's
PHP Code:
PHP Code:
|
| All times are GMT -4. The time now is 23:34. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.