My new PHP database class

Begby

If you have a chance check it out and let me know what you think and if its worth me spending more time to develop.

Thanks

http://www1.pways.com/LawnGnome

sarahk

If it works and doesn't run slowly it looks great. I don't know if I will transfer my site to it but I may use for new work. In particular I have a class to create just the sql insert string which I then pass to my current db class. This makes that step unnecessary.

I think managing inserts well is one of the most difficult things in any database language. Once you get to 15 fields the code becomes sooo hard to read and maintain.

One suggestion: allow the user to pass a hash of values.

thanks for making it available

merkinmuffley

It's worth the time if you'll be satisfied later that you produced a useful piece of software. From the looks of it, it's certainly useful. But, I can't see under the hood- the link to the .zip file is broken (404).

If you're not making the source available can I ask a question- when you insert a record for example, do you rely on the inherited class to tell what the column names should be? or, do you ask the database what the column names are, and then find corresponding members of the inherited class?

Begby

Whoops, the link was broken. Fixed now. Sorry about that.

As for how inserts work, I ask the database for the field names and type when the object is created, then using those fieldnames and types I construct the query from the corresponding member variables.

jmcneese

what's wrong with PEAR:😃B?

Begby

There is nothing wrong with Pear DB, as a matter of fact this class makes use of Pear DB (although I need to make it a bit quicker). However, this class will make it so you don't need to write any SQL at all for most simple queries or even open a connection.

jmcneese

aaahhhh, gotcha. sorta class n00b extents PEAR class, right?

Begby

Well sorta, but it doesn't really extend pear, just uses it. Check out the source/documentation and you can see what I am talking about.