|
|
|
|
|
|
| |
//A sample function that I made that will limit the number of
//rows from mysql to be display each page where $start is
//the starting row, $trows is the total number of rows and $rown
//is the number of rows to be display each page.
| <?php
$host=""; //hostname
$user=""; //user
$password="";//password
$db="dbname"; //database name
$tbl="table"; //table name
$rown="5"; //number of rows to be display each page
//The functions
function first($start,$trows,$rown)
{
if ($start == $trows-intval($trows%$rown)&&$trows>$rown ||$start<>intval(0))
{
$first="<a href=$SCRIPT_NAME?start=0>First</a>";}
else
{
$first="First";
}
return $first;
}
function previous($start,$trows,$rown)
{
if ($start >= $trows-intval($trows%$rown)&&$trows>$rown||$start<>intval(0))
{
$prev=$start-$rown;
$previous="<a href=$SCRIPT_NAME?start=$prev>Previous</a>";
}
else
{
$previous="Previous";
}
return $previous;
}
function next1($start,$trows,$rown)
{
if ($start < ($trows-intval($trows%$rown))&&(($start+$rown)-$trows<>"0"))
{
$next=$start+$rown;
$next="<a href=$SCRIPT_NAME?start=$next>Next</a>";
}
else
{
$next="Next";
}
return $next;
}
function last($start,$trows,$rown)
{
if ($start < $trows-intval($trows%$rown)&&(($start+$rown)-$trows<>"0"))
{
if (($rem=$trows%$rown)==0){$rem=$rown;}
$last=intval($trows-$rem);
$last="<a href=$SCRIPT_NAME?start=$last>Last</a>";
}
else
{
$last="Last";
}
return $last;
}
//end of the functions
mysql_connect($host,$user,$password);
mysql_select_db($db);
$query="select * from $tbl";
$result=mysql_query($query);
$numrows=mysql_num_rows($result);//total number of rows equal to $trows;
if ($start=="")
{$start=0;}
$query="$query limit $start,$rown"; //limit output $rown=5 rows starting $start
$result=mysql_query($query);
print"<table border=1>
<tr>
<td>Field1</td>
<td>Field2</td>
<td>Field3</td>
<td>Field4</td>
<td>Field5</td>
</tr>";
while ($row=mysql_fetch_array($result))
{
print"<tr>
<td>$row[0]</td>
<td>$row[1]</td>
<td>$row[2]</td>
<td>$row[3]</td>
<td>$row[4]</td>
</tr>";
}
print"</table>";
print"<table><tr>
<td>".first($start,$numrows,$rown)."</td>
<td>".previous($start,$numrows,$rown)."</td>
<td>".next1($start,$numrows,$rown)."</td>
<td>".last($start,$numrows,$rown)."</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 | | | email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | 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 | | | Linked comboboxes with php-mysql & javascript
Categories : PHP, Java Script, Databases, MySQL | | | 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 | | | usercounter class
Categories : PHP, PHP Classes, Databases, MySQL, Environment Variables | |
|
|
|
