MySQL Pager class





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

33
Date Submitted Thu. Nov. 9th, 2006 2:11 AM
Revision 1
Helper Nico
Tags Class | PHP | transload | upload
Comments 6 comments
Simple upload class with features such as

- Upload of multiple files at the same time.
- Filtering uploads by size and extension.
- Uploads to configurable subdirs based on date.
- Automatic file renaming if a file with the same name exists.
- Transloading. Copying files from a different host to the local host. (Like Imageshack does)
- And more...
8
Date Submitted Tue. Nov. 14th, 2006 1:24 PM
Revision 1
Scripter shachi
Tags File | PHP | splitter
Comments 0 comments
This function simply splits a file based on the splitter supplied and returns an array with the values. It's pretty much like the file() function. This script could be helpful in section editings.
9
Date Submitted Thu. Nov. 16th, 2006 5:30 AM
Revision 1
Helper Celebhir
Tags characters | PHP | split | String
Comments 0 comments
Function that splits a given string into sections based on the allowed length for a section. Does not split words up. Splits string on Space character (can be set to another character)
9
Date Submitted Sun. Nov. 19th, 2006 12:30 PM
Revision 1
Beginner pcolella
Tags PHP
Comments 2 comments
This is a rewrite of a basic ADODB / PHP Database pager. This pager has some very slick search, sort, and display configuration options. Modifications and improvements are very welcome. Thus I am sharing this code.

A basic example for using this pager would be as follows:

// Check class code for CSS styles used
require_once ('class.init.php');

// SQL Statement
$sql = 'SELECT table1.field1, table1.field2, table1.field3 FROM table1';

// Field Labels
$label_arr = array (
'field1' => 'Field 1 Heading',
'field2' => 'Field 2 Heading',
'field3' => 'Field 3 Heading'
);

// Hidden Fields
$vsel_arr = array (
'field3' => 0 // don't display field3 unless requested by the user
);

$sort_arr = array (
'field1' => 'asc' // sort by field1 ascending order (asc) or (desc)
);

// Config array
$config = array (
'db' => &$dbconn, // open ADODB connection
'sql' => $sql, // String of sql
'id' => 'table1_pager', // pager id for session variables
'label_arr' => $label_arr, // field heading array
'vsel_arr' => $vsel_arr, // fields to hide
'extra_param' => '', // extra paramaters to pass with edit, delete, add anchors
'form_width' => '100%', // table with
'form_title' => 'Table 1', // table title
'edit_anchor' => 'Edit', // link to edit
'del_anchor' => 'Del', // link to delete
'add_anchor' => 'Add', // link to add
'print_anchor' => 'Print', // link to print
'header_view' => true, // no function at this time
'search_view' => true, // no function at this time
'pk' => array ('field1' => true), // primary key field
'sort_arr' => $sort_arr, // sort field array
);

// create object then render it ...
$_pager = new pager($config); // create instance
echo $_pager->render(25); // render output
10
Date Submitted Mon. Dec. 4th, 2006 11:03 PM
Revision 1
Helper jdenton
Tags "date convert" | PHP
Comments 0 comments
Give this little function a start date and number of days and it will calculate the end date.
16
Date Submitted Tue. Dec. 12th, 2006 9:14 PM
Revision 1
Beginner adorkable81
Tags PHP | Thumbnail
Comments 0 comments
Ok, another thumbnail PHP function. This function support resize of JPEG and GIF, and resize with aspect ratio (set $THUMBX=0 if you wish it is resized with the Height, $THUMBY=0 if blah blah blah, you get the point)
9
Date Submitted Tue. Dec. 19th, 2006 3:47 PM
Revision 1
Helper RaX
Tags PHP
Comments 2 comments
This routine checks a client's IP address against a few open lists of blacklisted IP addresses, returns TRUE if the ip is a known proxy.
24
Date Submitted Sun. Dec. 24th, 2006 7:10 PM
Revision 1
Beginner bhmahler
Tags HTML | JavaScript | PHP
Comments 4 comments
This is a PHP and JavaScript Image gallery that I created. There are 2 uses for this.
1.) You can save it as index.php and place in a folder containing images and it will display the images in that folder.
Example:
place index.php in images/folder
http://yoursite.com/images/folder/
This will display all images in that folder

2.) Pass in the path to the folder to display in the url
Example:
Save as imagegallery.php
http://yoursite.com/imagegallery.php?path=images/folde
14
Date Submitted Mon. Jan. 15th, 2007 5:30 PM
Revision 1
Helper Idlemind
Tags Authentication | mysql | PHP | Security
Comments 8 comments
MySQL 5.x Stored Routines, PHP Session Values, a little CSS oh my! Complex to set up but easy to impliment. Geared toward security, simplicity (of use) and convenience.
14
Date Submitted Fri. Jan. 19th, 2007 2:37 PM
Revision 1
Helper inxilpro
Tags "word list" | Generator | Password | PHP | Random
Comments 0 comments
This is a random password generator that produces understandable passwords based on word lists. I've only included a 3 entry world list because you should chose a list based on your password requirements and your users. If you need to generate passwords that are 14 characters in length, you will want a different list than if you're generating 8 character passwords. And depending on your users, you may want to use certain lists. The list I use is about 4000 words that are 5-7 characters long, all well-known words that have had potentially objectionable content removed. For security reasons I don't want to include this list.

A note on security: though this generates relatively strong passwords for the average user, they are particularly susceptible to brute-force attacks. This is even more an issue if somehow your word list gets compromised. I would not recommend using this function for anything where a highly secure password is needed.

A note on choosing your list: You'll also see that I've built the system to avoid generating passwords with zeros and ones in them. This is because zero and upper-case "o" can be confused as can one, lower-case "L" and upper-case "i." When choosing my word list I was also sure to strip out all words that start with the letter "o" or "i" (to prevent the optional ucfirst() from creating 0/O and I/1 confusion) and words that contain the letter "L" (to prevent l/1 confusion). I find that this greatly helps with preventing confusion, but again weakens the security of the passwords some. It's your choice.