Code: Select all
if ($_POST){
$county = $_POST['county'];
$rooms = $_POST['type'];
$rent = $_POST['rent'];
$rent_min = $rent - 500;
}
$dbase = mysql_connect ( ' ', ' ', ' ' );
mysql_select_db ( ' ', $dbase );
$pagesize = 1;
$recordstart = (int) $_GET['recordstart'];
$recordstart = (isset($_GET['recordstart'])) ? $recordstart : 0;
if($county){
$sql = "SELECT * FROM `apartments` WHERE `county` = '".$county."' AND `rooms` = '".$rooms."' AND `rent` < '".$rent."' AND `rent` > '".$rent_min."' ORDER BY `rent` LIMIT $recordstart, $pagesize";
}else{
$sql = "SELECT * FROM `apartments`";
}
$dbase->tabular_output($sql);
// Retrieve total rows in order to determine whether 'next' link should appear
$result = $dbase->query("SELECT count(rent) AS count FROM `apartments`");
list($totalrows) = $result->fetch_row();
// Create the 'previous' link
if ($recordstart > 0) {
$prev = $recordstart - $pagesize;
$url = $_SERVER['PHP_SELF']."?recordstart=$prev";
printf("<a href='%s'>Previous Page</a>", $url);
}
// Create the 'next' link
if ($totalrows > ($recordstart + $pagesize)) {
$next = $recordstart + $pagesize;
$url = $_SERVER['PHP_SELF']."?recordstart=$next";
printf("<a href='%s'>Next Page</a>", $url);
}
//include the class
require_once("/home/genesis/php/HTML/Table.php");
//set table attributes
$attributes = array("width"=>"600","border"=>"1", "align"=>"center");
//create the table class
$table = new HTML_Table($attributes);
//build our first row
$contents = array("County", "Town", "Phone Number", "Rooms", "Baths", "Rent");
$attributes = array("bgcolor"=>"#336699", "align"=>"center", "id"=>"results");
$table->addRow($contents, $attributes, "TH");
//loop through and add our data
$attributes = array("bgcolor"=>"#COCOCO", "align"=>"center");
$res = mysql_query($sql, $dbase);
while($row = mysql_fetch_assoc($res)) {
$contents = array($row['county'], $row['town'], $row['phone'], $row['rooms'], $row['bath'], $row['rent'],);
$table->addRow($contents, $attributes);
}
$table->altRowAttributes(1, null, array("class"=>"alt"));
$table->display();
?>