$db_addr = 'mysql.gvpn.biz'; // address of MySQL server.
$db_user = 'usvi'; // Username to access server.
$db_name = 'USVI'; // Name of database to connect to.
$connect = @mysql_connect("$db_addr", "$db_user");
if (!($connect)) // If no connect, error and exit().
{
echo("
Unable to connect to the database server.
");
exit();
}
if (!(@mysql_select_db($db_name))) // If can't connect to database, error and exit().
{
echo("
Unable to locate the $db_name database.
");
exit();
}
if (!($limit)){
$limit = 5;} // Default results per-page.
if (!($page)){
$page = 0;} // Default page value.
$numresults = mysql_query("SELECT * FROM beach WHERE a_island = 3"); // the query.
$numrows = mysql_num_rows($numresults); // Number of rows returned from above query.
if ($numrows == 0){
echo("No results found matching your query"); // bah, modify the "Not Found" error for your needs.
exit();}
$pages = intval($numrows/$limit); // Number of results pages.
// $pages now contains int of pages, unless there is a remainder from division.
if ($numrows%$limit) {
$pages++;} // has remainder so add one page
$current = ($page/$limit) + 1; // Current page number.
if (($pages < 1) || ($pages == 0)) {
$total = 1;} // If $pages is less than one or equal to 0, total pages is 1.
else {
$total = $pages;} // Else total pages is $pages value.
$first = $page + 1; // The first result.
if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) {
$last = $page + $limit;} //If not last results page, last result equals $page plus $limit.
else{
$last = $numrows;} // If last results page, last result equals total number of results.
//escape from PHP mode.
?>
St Croix Beaches
//Go back into PHP mode.
// Now we can display results.
$results = mysql_query("SELECT * FROM beach WHERE a_island = 3 ORDER BY a_name ASC LIMIT $page, $limit");
while ($data = mysql_fetch_array($results))
{
?>
$id = $data['a_id'];
?>
if ($page != 0) { // Don't show back link if current page is first page.
$back_page = $page - $limit;
echo("back \n");}
for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it.
{
$ppage = $limit*($i - 1);
if ($ppage == $page){
echo("$i \n");} // If current page don't give link, just text.
else{
echo("$i \n");}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link.
$next_page = $page + $limit;
echo(" next\n");}
?>