connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$getid = preg_replace("/[^0-9]/", "", $_GET["id"]);
if (strlen($getid) <= 2) {
$sql = "SELECT * FROM `properties` WHERE `id` = $getid";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
$row = $result->fetch_assoc();
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$status = $row["status"];
$beds = $row["beds"];
$baths = $row["baths"];
$sqft = $row["sqft"];
$rent = $row["rent"];
$petfee = $row["petfee"];
$deposit = $row["deposit"];
$description = $row["description"];
}}
else { die("Nope"); }
?>
"; ?>
";
$addresscut = preg_replace('/\s+/', '', $row["address"]);
$directory = "images/$addresscut/";
$images = glob("$directory*.jpg");
foreach($images as $image) {
echo "";
}
echo "";
$movies = glob("$directory*.mp4");
foreach($movies as $movie) {
/*
echo "";
*/
echo "";
/*
echo "";
*/
/*
echo "";
*/
}
$conn->close();
?>
Beds: $beds Baths: $baths $sqft sqft Rent: $rent
Deposit: $deposit Pet Fee: $petfee
$description
Reserve This Property Today!