MySQL Pager class





ranking Sort Sort   |   date Sort Sort   |   member Sort Sort
Syndication

8
Date Submitted Tue. Feb. 21st, 2006 9:50 PM
Revision 2
Coder mattrmiller
Tags PHP | Ping | PingOMatic
Comments 0 comments
Ping, PingOMatic service for an updated. Requires: The Inutio XML-RPC Library.
9
Date Submitted Thu. Apr. 13th, 2006 10:46 AM
Revision 1
Coder mattrmiller
Tags Array | Case | PHP
Comments 0 comments
Change the case of an array.
11
Date Submitted Tue. May. 23rd, 2006 8:48 AM
Revision 1
Coder mattrmiller
Tags CURL | PHP
Comments 2 comments
Example of how to use CURL with PHP.
4
Date Submitted Fri. Jun. 9th, 2006 11:40 AM
Revision 1
Coder mattrmiller
Tags Array | find | PHP | search
Comments 0 comments
A simple search array example.
16
Date Submitted Tue. Jun. 13th, 2006 12:24 AM
Revision 1
Coder mattrmiller
Tags "Phone Number" | Format | PHP
Comments 3 comments
Format a phone number with php.
13
Date Submitted Fri. Jun. 23rd, 2006 10:19 AM
Revision 1
Coder mattrmiller
Tags Authentication | Email | PHP | SMTP
Comments 0 comments
I needed to send an email through an authenticated SMTP server. I found the snippet on the PHP website to do the trick.
13
Date Submitted Tue. Jul. 11th, 2006 10:34 PM
Revision 1
Coder mattrmiller
Tags Generator | Number | PHP | Random | String
Comments 2 comments
Generate a random number or string in PHP.
15
Date Submitted Sun. Aug. 27th, 2006 10:44 AM
Revision 1
Helper mceppi
Tags filesize | PHP
Comments 2 comments
A small recursive php function to determine the size of a directory by adding all it's contents together and returning them as an integer.
-7
Date Submitted Fri. Feb. 17th, 2006 4:52 AM
Revision 3
Helper mercutio
Tags mysql
Comments 0 comments
I use this method for keeping my sql templates away from my code.

You can extend upon the idea, as I have done in the past, by placing SQL handing classes between your scripts and the template library.

Things to note here:

The lesser userd heredoc string method. The reason this is used is to keep the SQL clear and well laid out, and not as messy as using quotes.

vsprintf() is a very handy function if you don't want to hard code the number of parameters to interpolate your string with.

The use of sprintf templates offers you additional security. For example, only allowing numbers to be placed where a %d falls. This, of course, shouldn't be the only security on user supplied variables, but comes in extra handy for debugging purposes.

Regarding the TODO in there, it would take a check of the number of % placeholders there are in the template. One caveat is remembering to remove the count of %%'s that appear (the literal percentage).
7
Date Submitted Mon. Nov. 28th, 2005 4:35 PM
Revision 1
Beginner Michael
Tags Extract | PHP
Comments 3 comments
Using the extract() Functio