What kind of library have you built yourself? Or even that others have created that you use often in your projects.

I use a couple of classes made by Chroder in almost all of my scripts. A mysql class and a template class.

Are any of yours worth sharing with the community?

very rarely use classes (tsk). Got some useful functions... Why would you need a MySQL class? just outta interest

The way this class is setup it cuts my mysql coding in about half. Here is an example...

PHP Code:

$db = new Database('host','user','pass','db','persistent'); //persistent is normally a true or false value 1 or 0.
$db->query('SELECT * FROM mytable');
while($res = $db->fetch()) {
  echo $res['sample']."<br />";
} 


Each time I call $db->fetch() it will contain the results in an array from the last $db->query().

The ones I find most useful are the fetchAll and fetchAllKey. I love those babies

Cap is using one method, you can also use the other way and handle all your own resource IDs

$myquery = $db->query('sql');
while($res = $db->fetch($myquery))
...

Just makes it easier when the class handles everything on it's own.

I haven't found much use for fetchAllKey in my scripts yet.

If you ever have a table that holds all your script options (say you have like 40 options for various things from Site Title to default skin etc), you can fetch them all in one go.

PHP Code:

$options = $DB->fetchAllKey("SELECT value FROM options", 'name');

// $options['site_title'], $options['default_skin'] etc 


Thats nifty, I will remember that one.

That MySQL class looks extremely familiar. There's a mysql class that uses almost exact code like that, at www.tapinternet.com, where they are using it in some code they call their own - their Data Business Objects (DBO). Check it out.

I use their MySQL class for my Content Management System. I should probalby try writing my own, eventually, but theirs is working great for me.

Jason

It probably looks familiar because these methods are the most efficient aproach, IMHO at least.

One class that I absolutely love, and its generalized but I use it often, is Snoopy.

Snoopy -- that's what I was looking for the other day! I remembered you liked one of those types of scripts, but I forgot the name of it.

That MySQL class looks extremely familiar. There's a mysql class that uses almost exact code like that, at www.tapinternet.com, where they are using it in some code they call their own - their Data Business Objects (DBO). Check it out.

Most DB classes have methods for query, fetch and fetchrow/fetchone. Other then that, they differ. As to DBO -- I can't find it, where do I download it?

I could not find it either.

ADODB (database class) probably the best one out there, Xtemplate (templating), phpMailer. Plus 15 or so other classes that are home built.

As the site I work on at the moment is extensively OO I have numerous classes that are extended depending on all sorts of things.

Been years since I was function based, a bit less since i used to mix html and php in the same script (shudder the though of debugging that stuff now). In fact its that bad a memory I overlook posts that have code mixed with html.

The ones i cannot live without are not mine, they are AdoDB and Xtemplate.

Ibbo

I tend to skip over some of the longer posts with mixed php and html. I used to be so against templates, until I actually used them seriously. Now I could not do any project without templates.