|
|
|
|
|
|
| |
This shows how to page thru a resultset in a simple manner. It produces a set of links where-ever its called that looks like:
[ 1 2 3 4 5 6 7 ]
and so on. For extremely large resultsets, this function may not be aproppriate as the list of links could get very long, though you can mitigate that by using a larger display amount value, which is the number of items to show on any one page.
Bastien
| <?
/*
show_pages shows the links to the different pages
it gets passed the current offset and the total number of images to
show on one page ($display_length)
*/
function show_pages($offset, $display_length)
{
//run a query to see how many records there are total.
$total = '';
$total_images = 0;
$pages = 0;
$base_offset = 0;
echo "<table width='100%'><tr><td align='center'><b>[ ";
$sql = "select count(*) from photos";
//query is a custom db connect function
$total = query($sql);
if (mysql_num_rows($total)==1)
{
$row = mysql_fetch_array($total);
$total_images = $row[0];
$pages = ceil($total_images/$display_length); //calc the number of links to show (ceil rounds up to next int)
for ($x = 1 ; $x <= $pages; $x++)
{
//don't show current page as link
if ($base_offset == $offset)
{
echo "$x ";
}else{
echo "<a href=\"".$_SERVER['PHP_SELF']."?offset=$base_offset\">$x</a> ";
}//end if
$base_offset += $display_length;
}//next
}else{
echo "No other images found";
}
echo "]</b></td></tr></table>";
}
?> | |
|
|
| This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | | | Point and Click Interface ala MS Access for creating SQL statements.
Categories : MySQL, Complete Programs, General SQL, PHP, Databases | | | Message of the Day - Random Message (Needs MySQL!)
Categories : Databases, HTML and PHP, PHP, MySQL | | | Alternating background color for HTML table rows
Categories : PHP, Databases, MySQL, HTML and PHP | | | color codes for positive and negative numbers
Categories : PHP, MySQL, Databases, HTML | | | Authorize Me! An authentication script.
Categories : MySQL, Databases, Authentication, PHP | | | A very simple way to build and do a hierarchical html categories browser without javascript , just using html php and mySql
Categories : HTML and PHP, Databases, Algorithms, PHP, MySQL | | | Tropicalm Genetree Family (MySQL based family tree)
Categories : PHP, Interfaces, Databases, MySQL, Complete Programs | | | mysql_escape_string
Categories : PHP, MySQL, Databases, Strings | | | Automatically printing the contents of an sql table in MySQL.
Categories : MySQL, PHP, HTML and PHP, Databases | | | This script is a contact form between users of a
website (kinda like the PM function on the forums)
Categories : PHP, Databases, MySQL, Regexps | | | Finding the day of the week for a specific date.
Categories : PHP, Databases, MySQL, Date Time | |
|
|
|
