Accessing Databases with Class

How about a nice new name for your search engine: Seekist.com,if you are interested have the name value and make an offer,Cheers
Willjames

There's a small probem with this article - you'll notice that page 3 (Extending Classes) is repeated on page 4 (Queries and query results).
<br>
<br>
If you look down page 4, you'll find the actual start of "Queries and query results" right above Example 7. (Last sentence of paragraph above - should be bold title. :^)
<br>
<br>
Otherwise, great article! Gives me good insight into Kristian's PHPLIB DB_Sql functions as well.

Thanks for pointing that out. It is fixed now.

Wonderful article. This is one of the most useful PHP articles I've read thus far.

Thanks,
-wj

Wonderful article. This is one of the most useful PHP articles I've read thus far.

Thanks,
-wj

Thank you. There will be a sequel.

Thank you for this great tutorial.
<br>
<br>
I have a couple of simple questions:
<br>
<br>
1) I noticed a %s appearing in the code several times. What is it?
<br>
<br>
2) Could you explain a little more what p() and f() do? What do "p" and "f" stand for?
<br>
<br>
3) What does the @ represent? (@mysql_affected_rows)
<br>
<br>
Thank you,
<br>
<br>
riddler

I'm working on retrieving information from the MySQL database and placing a 'LIMIT' function in PHP to return only a selected number of results. For some reason i'm getting all records returned. Any suggestions?
<br>
<br>
Thank you;
<br>
<br>
P. Robie

Hi,
Im needing plans to build a small shed, similar to the Cabanas from Duro-Shed. I need a 7\'w x 10\'l x 6\' height or close to those dimensions.
Thanks,
Ron

Though the class connects to the db and makes a lot of db work easier, the example doesn\'t seem to indicate whether mysql_close() is still required. I am assuming it is. What type of damage can one cause if they forget to close the db?

Agreed. I\'ll be checking devshed out a lot more often if I keep seeing good PHP articles like this.

Thanks!

Please tell me you\'re kidding :) Have you looked around the site much?

Yes and no.. Take a look at the PHP docs for mysql_close:
<br>
<br>
mysql_close() closes the link to a MySQL database that's associated with the specified link identifier. If the link identifier isn't specified, the last opened link is assumed.
<br>
<br>
Note that this isn't usually necessary, as non-persistent open links are automatically closed at the end of the script's execution.
<br>
<br>
mysql_close() will not close persistent links generated by mysql_pconnect().
<br>
<br>

There is no need to call mysql_close() any
time. PHPs resource management will do the
right thing automatically: Depending on
whether you used a *_connect or a *_pconnect
to establish the connection it will close
the link automatically at the end of the
page or reuse the connection on subsequent
pages.

It is the nature of script languages
that they relieve you of such bookkeeping
chores.

The printf() (print formatted) function of
<br>
PHP is directly copies from the C language.
<br>
It takes a format string as the first
<br>
parameter and any number of variables as
<br>
the following parameters. The format string
<br>
must contain placeholders, which consist
<br>
of a percent sign and a type. Thus, %s is a
<br>
placeholder for a string variable.
<br>
<br>
You are using the printf() function like
<br>
this: printf(\