Codice PHP:
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Due Effe Immobiliare</title>
<link rel="stylesheet" href="stile.css" />
</head>
<?php
error_reporting(E_ALL);
ini_set('display_errors','1');
require_once("config.php");
?>
<body>
<div align="center">
<div style="width: 880px; margin-top: -15px; background-image: url(images/sfondo.jpg); background-repeat: repeat-y;">
<div style="width: 850px; height: 190px; background-repeat: no-repeat; margin-top: 10px; background-image: url(images/logo.jpg);">
<div id="navcontainer" class="navigate">
<ul id="navlist">
<li id="active">[url="index.php"]Home[/url][*][url="chi.html"]Chi Siamo[/url][*][url="map.htm"]Dove Siamo[/url][*][url="vendita.php"]Vendite[/url][*][url="affitto.php"]Affitti[/url][*][url="contattaci.html"]Contattaci[/url][*][url="form_ricerca.html"]Ricerca[/url][*][url="sbarra.html"]Amministra[/url][/list]
</div>
</div>
<div class="divalto">
<form action="ricerca.php" method="POST">
Contratto<select name="contratto" default="">
<option value="vendita">Vendita</option>
<option value="affitto">Affitto</option>
</select>
Prezzo <input type="text" name="prezzo" default="" />
Tipologia <select name="tipo">
<option value="appartamento">Appartamento</option>
<option value="villetta">Villetta</option>
<option value="monolocale">Monolocale</option>
<option value="ufficio">Ufficio</option>
<option value="bifamiliare">Bifamiliare</option>
<option value="rustico">Rustico</option>
<option value="f_commerciale">Fondo commerciale</option>
<option value="terreno">Terreno</option>
<option value="capannone">Capannone</option>
</select>
Zona <select name="zona">
<option value="massa">Massa</option>
<option value="marina di massa">Marina di Massa</option>
<option value="carrara">Carrara</option>
<option value="marina di carrara">Marina di Carrara</option>
<option value="forte">Forte dei Marmi</option>
<option value="montignoso">Montignoso</option>
<option value="cinquale">cinquale</option>
<option value="ronchi">ronchi</option>
</select>
<input type="submit" value="Invia" />
<input type="reset" value="Cancella" />
</form>
</div>
<div class="style1" style="height: 20px; width: 880px; background-image: url(images/finesito.jpg);"></div>
</div>
</div>
</body>
</html>
Codice PHP:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Pagina di ricerca</title>
</head>
<body>
<?php
error_reporting(E_ALL);
ini_set('display_errors','1');
require_once("config.php");
// ****** ricevo i dati dalla form e controllo lunghezza vettore ******
$contratto=$_POST['contratto'];
$prezzo=$_POST['prezzo'];
$tipo=$_POST['tipo'];
$zona=$_POST['zona'];
$query="";
foreach($_POST as $key=>$value)
{
if($value!="")
{
if($key!="Invia Ricerca") $query .= "$key='$value' ";
}
}
if($query !="")
{
$query="select * from immobili WHERE ".$query."AND 0=0";
echo $query."
";
$ris=mysql_query($query) or die(mysql_error());
}
while ($riga= mysql_fetch_array($ris,MYSQL_ASSOC))
{
$cod_rif=$riga['cod_rif'];
$contratto=$riga['contratto'];
$tipo=$riga['tipologia'];
$prezzo=$riga['prezzo'];
$zona=$riga['zona'];
$desc=$riga['descrizione'];
echo "
[b]Codice [/b] $cod_rif</p>";
echo "
[b]Contratto [/b] $contratto</p>";
echo "
[b]Tipo [/b] $tipo</p>";
echo "
[b]Prezzo [/b] $prezzo</p>";
echo "
[b]Zona [/b] $zona</p>";
echo "
[b]Descrizione [/b] $desc</p>";
echo "
";
$queryfoto="select * from image where cod_rif='$cod_rif'";
$resultfoto=mysql_query($queryfoto) or die (mysql_error());
$num= mysql_num_rows($resultfoto);
while ($foto=mysql_fetch_array($resultfoto))
{
$urlgrande=$foto['url'];
$urlpiccolo=$foto['urlthumb'];
echo"[url='$urlgrande'][img]$urlpiccolo[/img][/url]";
echo " ";
}
echo "<hr />";
}
}
echo"</div>";
?>
<div class="style1" style="height: 20px; width: 880px; background-image: url(images/finesito.jpg);"></div>
</div>
</div>
</body>
</html>
questo e' quello che mi viene stampato a video
select * from immobili WHERE contratto='vendita' tipo='appartamento' zona='massa' AND 0=0
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tipo='appartamento' zona='massa' AND 0=0' at line 1.
qualcuno potrebbe aiutarmi?
Rispondi quotando