MySQL Pager class





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

9
Date Submitted Fri. Oct. 14th, 2005 5:06 PM
Revision 1
Helper lilleman
Tags Files | Folders | List | PHP
Comments 1 comments
Get a List of Folders and/or Files
23
Date Submitted Fri. Oct. 14th, 2005 5:12 PM
Revision 1
Helper lilleman
Tags Folder | PHP | Size
Comments 1 comments
Get the Size of a Folde
8
Date Submitted Mon. Oct. 23rd, 2006 7:59 PM
Revision 1
Helper lgrover
Tags my.cnf | mysql | optimization
Comments 0 comments
When ByteMyCode was crashing because of the traffic load, we started optimizing MySQL. The server had a load of >50 but the processor was all tied up in IOWAIT. We realized that the database was the source of the bottleneck so we increased all of the cache sizes. Now, it is really fast.
5
Date Submitted Sun. Oct. 22nd, 2006 5:21 AM
Revision 1
Beginner kiefpiet
Tags PHP
Comments 1 comments
Open a text file and format it (word wrap).
6
Date Submitted Sun. Oct. 22nd, 2006 5:34 AM
Revision 1
Beginner kiefpiet
Tags PHP | upload
Comments 2 comments
Simple file upload script.
23
Date Submitted Wed. May. 3rd, 2006 4:31 PM
Revision 3
Beginner kaparo
Tags geotarget | geotargetting | PHP
Comments 3 comments
This snippet originally is used for targetting ads banners depended on the geographic location of the visitor, but can be used for other purposes. Also originally is used for US and the rest of the world, but you can add check for other countries too.
15
Date Submitted Sun. Sep. 24th, 2006 5:35 PM
Revision 1
Helper kahotep
Tags Form | HTML | PHP
Comments 1 comments
Generates a tree view within a dropdown select box.
12
Date Submitted Sun. Sep. 24th, 2006 5:43 PM
Revision 1
Helper kahotep
Tags HTML | PHP
Comments 6 comments
Generates select boxes, text boxes, check boxes and radio buttons. Via a handful of functions.
-8
Date Submitted Tue. Nov. 7th, 2006 11:06 AM
Revision 1
Helper kahotep
Tags mysql | PHP
Comments 6 comments
This class is a simple authentication scheme which makes it easy to add authentication to any page by including one class and adding one table to your MySQL database.

The following functions are employed by this authentication class:

auth()
this is the default constructor; it automatically checks for the POST vars "username" and "password", it also checks to see if the user passed the GET variable "logout", which would prompt it to set the authentication status to un-authenticated.

is_authorized()
Checks the SESSION variable "authorized" and returns true or false depending on that variable.

mysql_bind()
This is automatically called by the constructor each time the class is instantiated and $_POST['username'] and $_POST['password'] are present. It queries the db for a valid username and MD5 encoded password.

user_create($username,$email,$password)
Creates a user, if the username is available, and creates an MD5 hash based on username, password and date, to be used in the "activation" of the account.

user_activation_message($username)
Sends the custom activation message to the email address for the username specified

user_activation($activation_hash)
Checks to see if the activation hash is valid, if it is, the activation_hash variable is set to NULL, thus signifying that the account is active.

user_password_change($username,$password_old,$password_new)
Quick and easy way to change the user's password with one function call.

user_logout()
Sets the authorization status in $_SESSION['authorized'] to FALSE

is_username_available( $username )
Returns TRUE or FALSE depending on whether or not the username is free.
0
Date Submitted Mon. Oct. 13th, 2008 11:10 PM
Revision 1
Beginner jmardones
Tags mysql
Comments 0 comments
this snippet show how to set up passwords in a mysql console.