<%
include("../../include/PgLib.php");
function findArea($searchstring) {
$areas = array();
if (strlen($searchstring) >= 3) {
$DB = new PGDB();
$sql = new QUERY($DB);
$query = "SELECT DISTINCT p.area_id
FROM area a, photo p
WHERE p.area_id = a.area_id
AND lower(a.area_name) LIKE lower('%$searchstring%')";
//print($query);
$sql->execute($query);
if ($sql->getntuples() == 0) {
$DB->close ();
return $areas;
}
else {
for ($i = 0; $i < $sql->getntuples(); $i++) {
$record = $sql->readrow();
array_push($areas, $record['area_id']);
$area_select .= $record['area_id'] . " " . $record['area_name'] ."
";
$sql->gonext();
}
$DB->close ();
}
}
return $areas;
}
$q = trim($q);
// Aapo Rista 2002-12-03 13:48:34
// Tää q2 on kai tullut Jarnolta jostain syystä edelliseen formiin?
if (trim($q2))
$q = trim($q2);
if ($q != "") {
$a = findArea($q);
$osa = $a[0]; //$photo_street_pri
if ($osa > 0) {
$q_part = "area_id=$osa";
} else {
$q_part = "photo_street_pri=$q";
}
//$searchstring = "formtype=4&language=fi&$q_part&restype=thumbs&action=Hae";
$searchstring = "language=fi&$q_part&restype=thumbs&action=Hae";
//print ("$searchstring");
//exit;
if (strstr($HTTP_REFERER, "hakutulos")) {
header("Location: hakutulos.html?$searchstring");
}
else {
header("Location: hakukehys.html?$searchstring");
}
//print("Location: tulossivu");
//print("Location: tulossivu");
//header("Location: /search/searchframe.html?formtype=4&language=fi&area_id=$osa&restype=thumbs&action=Hae");
}
else {
print("Tyhjä haku");
}
%>