include("includes/connect.php"); if(checklogin(false) == false){ header("location:http://".$domein."login.php?e=1&url=".getCurrentPageUrl()); } /*Bovenaan*/ if(isset($_GET['id'])&& $_GET['actie']=='delete'){ $data_id = mysql_escape_string($_GET['id']); $data_sql = mysql_query("SELECT *, huizen.id AS huizenid FROM `".SQL_PF."huizen` AS `huizen`, `".SQL_PF."cityname` AS `city` WHERE huizen.id = '".$data_id."' AND city.city_id = huizen.woonplaats AND huizen.user_id = ".$_COOKIE['id']); $data_check = mysql_num_rows($data_sql); if($data_check != 0 ){ $sql = "DELETE FROM `".SQL_PF."huizen` WHERE id=".$data_id; $delete_sql = "DELETE FROM `".SQL_PF."ov-huizen-zoek` WHERE `soort` = 1 AND `ander`=".$data_id; $delete2_sql = "DELETE FROM `".SQL_PF."afbeeldingen` WHERE `huizen_id`=".$data_id; $delete3_sql = "DELETE FROM `".SQL_PF."matches` WHERE `huizen_id`=".$data_id; if (!mysql_query($delete_sql)) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $delete_sql; die($message); }// ov is verwijderd if (!mysql_query($delete2_sql)) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $delete2_sql; die($message); }// ov is verwijderd if (!mysql_query($delete3_sql)) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $delete3_sql; die($message); }// ov is verwijderd if (!mysql_query($sql)) { $message = 'Invalid query: ' . mysql_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message); }// ov is verwijderd logToDB('huis verwijderd', 'huizen:verwijderd', $data_id); }} $menu = 5; $submenu = 2; $paginakeywords = ''; $style="huizenindex"; include "layout/header.php"; ?>
class="active" onclick="javascript:(window.location='?vo=1&vor=1');">Postcode | class="active" onclick="javascript:(window.location='?vo=2&vor=1');">Straat | class="active" onclick="javascript:(window.location='?vo=3&vor=1');">Plaats | class="active" onclick="javascript:(window.location='?vo=4&vor=1');">Provincie | class="active" onclick="javascript:(window.location='?vo=5&vor=1');">Vraag prijs | Matches | Opties |
---|---|---|---|---|---|---|
=$verkoop['postcode']?> | =$verkoop['straatnaam']?> =$verkoop['huisnummer']?> | =$plaatsnaam['name']?> | =$provincie['name']?> | € =$prijs?>,- | =$hits?> |