10-21-2009, 12:14 AM
|
#2 (permalink)
|
|
The Addict
Join Date: May 2009
Posts: 287
Thanks: 5
|
PHP Code:
<?php require_once('Connections/wilkins.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$type_lettings = "-1";
if (isset($_REQUEST["type"])) {
$type_lettings = $_REQUEST["type"];
}
$bedrooms_lettings = "-1";
if (isset($_REQUEST["beds"])) {
$bedrooms_lettings = $_REQUEST["beds"];
}
$rentamount_lettings = "-1";
if (isset($_REQUEST["rent"])) {
$rentamount_lettings = $_REQUEST["rent"];
}
mysql_select_db($database_wilkins, $wilkins);
$query_lettings = sprintf("SELECT * FROM lett_property, teaser, instructions WHERE teaser.property_ID = lett_property.lett_ID AND lett_property.property_type = %s AND lett_property.beds = %s AND lett_property.rent < %s AND teaser.property_ID = instructions.property_ID GROUP BY lett_property.lett_ID ORDER BY lett_property.rent ", GetSQLValueString($type_lettings, "text"),GetSQLValueString($bedrooms_lettings, "int"),GetSQLValueString($rentamount_lettings, "int"));
$lettings = mysql_query($query_lettings, $wilkins) or die(mysql_error());
$row_lettings = mysql_fetch_assoc($lettings);
$totalRows_lettings = mysql_num_rows($lettings);
mysql_select_db($database_wilkins, $wilkins);
$query_all_lett = "SELECT * FROM lett_property, teaser, instructions WHERE teaser.property_ID = lett_property.lett_ID AND teaser.property_ID = instructions.property_ID GROUP BY lett_property.lett_ID ORDER BY lett_property.rent ASC";
$all_lett = mysql_query($query_all_lett, $wilkins) or die(mysql_error());
$row_all_lett = mysql_fetch_assoc($all_lett);
$totalRows_all_lett = mysql_num_rows($all_lett);
$queryString_lettings = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
if (stristr($param, "pageNum_lettings") == false &&
stristr($param, "totalRows_lettings") == false) {
array_push($newParams, $param);
}
}
if (count($newParams) != 0) {
$queryString_lettings = "&" . htmlentities(implode("&", $newParams));
}
}
$queryString_lettings = sprintf("&totalRows_lettings=%d%s", $totalRows_lettings, $queryString_lettings);
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!-- Website design and hosting by Greenfrog Computing Ltd -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Wilkins Hammond Lettings & Management, Commercial & Land Services</title>
<link href="css/layout.css" rel="stylesheet" type="text/css" />
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body>
<!-- Header -->
<div id="header">
<div id="top_nav">
<ul id="navigation">
<li><a href="meet_us.html">meet us</a></li>
<li><a href="find_us.html">find us</a></li>
<li><a href="contact_us.html">contact us</a></li>
<li><a href="about_us.html">about us</a></li>
<li><a href="index.html">home</a></li>
</ul>
</div>
<div id="header_data">
<div id="logo">
<a href="index.html"><img src="images/logo.gif" alt="Wilkins Hammond Logo" border="0" /></a>
</div>
<div id="address_phone">
<span id="phone_number"> 01246 232853</span>
<div id="address_bar">
Devon House, 28 Gluman Gate, Chesterfield, S40 1TX<br />
<img src="images/Marketing_headerImage.jpg" alt="Header Bar" width="770" height="19" />
</div>
</div>
</div>
</div>
<!-- Content -->
<div id="container">
<div id="left">
<div id="top_buttons"><a href="landlords.html"><img src="images/landlordbutton.jpg" alt="Landlords" width="170" height="30" /></a><a href="tenants.html"><img src="images/tennantbutton.jpg" alt="Tenants" width="170" height="30" /></a></div>
<div id="middle_buttons">
<form action="show_lettings.php" method="get" enctype="multipart/form-data">
<table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td colspan="2" bgcolor="#FE0000"><strong>Quick Property Search</strong></td>
</tr>
<tr>
<td>Type</td>
<td><label>
<select name="type" id="type">
<option value="Apartment">Apartment</option>
<option value="House">House</option>
<option value="Bungalow">Bungalow</option>
<option value="">Any</option>
</select>
</label></td>
</tr>
<tr>
<td> Beds</td>
<td><label>
<select name="beds" id="beds">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
</select>
</label></td>
</tr>
<tr>
<td>Rent pcm</td>
<td><label>
<select name="rent" id="rent">
<option value="400">up to £400</option>
<option value="500">up to £500</option>
<option value="600">up to £600</option>
<option value="700">up to £700</option>
<option value="1000">up to £1000</option>
</select>
</label></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="search" id="search" value="Search" /></td>
</tr>
<tr>
<td colspan="2" bgcolor="#ECE9D8"><a href="show_all_lettings.php">Show all property</a></td>
</tr>
</table>
</form>
</div>
<div id="middle_buttons">
<table width="100%" border="0" cellspacing="2" cellpadding="0" class="myForm">
<tr>
<td bgcolor="#FE0000"><strong>Information for Tenants</strong></td>
</tr>
<tr>
<td><a href="tenants_why_us.html">Why Choose Us?</a></td>
</tr>
<tr>
<td><a href="tenants_tdc.html">Tenancy Deposit Scheme</a></td>
</tr>
<tr>
<td><a href="tenants_application.html">Making an application</a></td>
</tr>
</table>
</div>
<div id="master_buttons"><a href="commercial.html"><img src="images/commbutton.jpg" alt="Commercial" width="170" height="50" /></a><a href="lettings.html"><img src="images/lettbutton.jpg" alt="Lettings" width="170" height="50" /></a><a href="land.html"><img src="images/landbutton.jpg" alt="Land" width="170" height="50" /></a> </div>
</div>
<div id="right">
<h1>Search result</h1>
<h4><?php echo $totalRows_lettings ?> properties match your search .</h4>
<?php if ($totalRows_lettings > 0) { // Show if recordset not empty ?>
<div id="search_matches">
<?php do { ?>
<table width="100%" border="0" cellspacing="2" cellpadding="3">
<tr>
<td width="205" bgcolor="#999999"><h4><?php echo $row_lettings['property_type']; ?>, <?php echo $row_lettings['property_status']; ?></h4></td>
<td colspan="2" bgcolor="#999999"><h4><?php echo $row_lettings['number_name']; ?>, <?php echo $row_lettings['address_1']; ?> <?php echo $row_lettings['address_2']; ?>, <?php echo $row_lettings['area']; ?>, <?php echo $row_lettings['town_city']; ?></h4></td>
</tr>
<tr>
<td><div align="center"><img src="<?php echo $row_lettings['image_path']; ?>" /></div></td>
<td colspan="2" valign="top"><label><?php echo $row_lettings['detail']; ?></label>
<p> </p></td>
</tr>
<tr>
<td bgcolor="#FE0000"><h4><a href="gallery.php?lett_ID=<?php echo $row_lettings['lett_ID']; ?>">Image gallery</a></h4></td>
<td bgcolor="#FE0000"><h4><a href="<?php echo $row_lettings['file_path']; ?>" target="_blank">Find out more</a>| <a href="arrange_viewing.php?lett_ID=<?php echo $row_lettings['lett_ID']; ?>">Arrange a viewing</a> </h4></td>
<td bgcolor="#FE0000"><h4 align="right">Rent £<?php echo $row_lettings['rent']; ?> pcm Bond £<?php echo $row_lettings['bond']; ?></h4></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<?php } while ($row_lettings = mysql_fetch_assoc($lettings)); ?>
</div>
<?php } // Show if recordset not empty ?>
<?php if ($totalRows_lettings == 0) { // Show if recordset empty ?>
<div id="search_matches">
<h2>No matches for your search? Here are some other properties you may be interested in, or alternatively, <a href="contact_us.html">let us know what you're looking for.</a> </h2>
<?php do { ?>
<br />
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr bgcolor="#999999">
<td width="205"><h4><?php echo $row_all_lett['property_type']; ?>, <?php echo $row_all_lett['property_status']; ?></h4></td>
<td colspan="2"><h4><?php echo $row_all_lett['number_name']; ?>, <?php echo $row_all_lett['address_1']; ?> <?php echo $row_all_lett['address_2']; ?>, <?php echo $row_all_lett['area']; ?>, <?php echo $row_all_lett['town_city']; ?></h4></td>
</tr>
<tr>
<td><div align="center"><img src="<?php echo $row_all_lett['image_path']; ?>" alt="Image" /></div></td>
<td colspan="2" valign="top"><p><?php echo $row_all_lett['detail']; ?></p>
<p> </p></td>
</tr>
<tr bgcolor="#FE0000">
<td><h4><a href="gallery.php?lett_ID=<?php echo $row_all_lett['lett_ID']; ?>">Image gallery</a></h4></td>
<td><h4><a href="<?php echo $row_all_lett['file_path']; ?>">Find out more</a> | <a href="arrange_viewing.php?lett_ID=<?php echo $row_all_lett['lett_ID']; ?>">Arrange a viewing</a></h4></td>
<td><h4>Rent £<?php echo $row_all_lett['rent']; ?> Bond £<?php echo $row_all_lett['bond']; ?></h4></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<?php } while ($row_all_lett = mysql_fetch_assoc($all_lett)); ?>
</div>
<?php } // Show if recordset empty ?>
</div>
</div>
<!-- Footer -->
<div id="footer">
<div id="footer_data"><a href="http://www.rics.org"><img src="images/RICS logo.gif" alt="RICS Logo" width="68" height="77" border="0" align="right" /></a>© <strong><span id="wilkins_hammond">Wilkins Hammond</span> 2009</strong><br />
<span id="wilkins_hammond">Wilkins Hammond</span>, 'Devon House', 28 Gluman Gate, Chesterfield, S40 1TX<br />
Commercial & Land Tel: 01246 555511 | Lettings & Management Tel: 01246 232853<br />
<br />
<a href="legal.html">Legal</a> | Website by <a href="http://www.greenfrogcomputing.co.uk">Greenfrog Computing Ltd</a></div>
</div>
<!-- Google Tracking Code -->
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var pageTracker = _gat._getTracker("UA-10622354-1");
pageTracker._trackPageview();
} catch(err) {}</script>
</body>
</html>
<?php
mysql_free_result($lettings);
mysql_free_result($all_lett);
?>
(Simple Fix!) You could link in JavaScript to just select all of the boxes.
- Won't work, you're using an option tag.
Fix #2 -
Why not set the value of the "Any" to something similar to this?
PHP Code:
// Might need quotes, I'm not positive.
Apartment OR House OR Bungalow
I would just check to see that when that value is submitted that it matches EXACTLY with what it's supposed to be. |
|
|
|