MySQL database wrapper class

[Gpower2]

A class that contains all the functionality for interacting with MySQL database. It should contain functions that:

• allow execution for INSERT, UPDATE, DELETE operations, returning the number of rows affected
• allow execution for scalar queries returning DataTables
• allow execution for scalar queries returning single data values
• allow execution for scalar queries returning an enumerable object

[LelouchVII]

Really? Doesn't php implement any libraries for that? We got to write our own?

I could do this in C#. If php is as strong in some departments I could for sure do this. I haven't much experience with php so any comments will be appreciated. Else..the usual way. We ain't mechanics for nothing!

[Gpower2]

I guess you're referring to an Entity Framework style of library, an ORM stack. I'd prefer to avoid such an implementation, since though it's really useful for small and medium sized applications. it can really bring down performance at large databases. In our case, we have ~17000 users and hundreds of thousands posts and private messages.

In any case, I'd prefer to write this one if you don't mind.