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"); } ?>
$address $city, $state $zip
"; ?> "; $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: $bedsBaths: $baths$sqft sqft
Rent: $rent Deposit: $depositPet Fee: $petfee

$description

Reserve This Property Today!
"; ?>