bedroom £pm
Property description
Property features
Property photos
Map Location
Map locations are approximate.
'; $per30_status_sign= ''; $per31_status_sign= ''; $per32_status_sign= ''; $per33_status_sign= ''; $category_link =""; $sqlprop = "SELECT * FROM properties_affrnt WHERE id ='$id' AND propstatus = 'live' LIMIT 1"; $prop_query = mysqli_query($db_conx, $sqlprop); ///////////////// END ADDED SQLPROP BELOW TO DISPLAY THE DATA FETCHED BELOW AND CREATED THE MTCS //////////////////////////////// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// ///// Fetch the prop row from the query above while ($row = mysqli_fetch_array($prop_query, MYSQLI_ASSOC)) { $id = $row["id"]; $per1 = $row["ptntproptype"]; $per2 = $row["ptntbednumber"]; $per3 = $row["ptntcountry"]; $per4 = $row["ptntcity"]; $per5 = $row["pmonthlybudget"]; $per18 = $row["ppropinfo"]; $per19 = $row["pemail"]; $per21 = $row["pstreet"]; $per22 = $row["ptnttown"]; $per23 = $row["ptntpostcode"]; $per24 = $row["nearbystation1"]; $per25 = $row["nearbystation2"]; $per26 = $row["nearbystation3"]; $per27 = $row["minimumstayperiod"]; $per28 = $row["billsincluded"]; $per29 = $row["availablefrom"]; $per30 = $row["furnished"]; $per31 = $row["garden"]; $per32 = $row["parking"]; $per33 = $row["centralheating"]; $per35 = $row["availableday"]; $per36 = $row["availablemonth"]; $per37 = $row["availableyear"]; $per38 = $row["propcode"]; $avatar = $row["avatar"]; $avatar1 = $row["avatar1"]; $avatar2 = $row["avatar2"]; $avatar3 = $row["avatar3"]; $avatar4 = $row["avatar4"]; } // BEDROOM DISPLAY $per2display = ''.$per2.' bedroom'; if ($per2 == 'studio' || $per2 == 'Studio' || $per2 == 'shared' || $per2 == 'Shared'){ $per2display = $per2; } /// OTHER MTC POSTCODE REDUCE $per23postcodereduceddisplay = $per23; $per23postcodereduceamount = '0'; if (strlen($per23) == '5'){ $per23postcodereduceamount = '-3'; $per23postcodereduceddisplay = substr($per23,0,$per23postcodereduceamount); } else if (strlen($per23) == '6'){ $per23postcodereduceamount = '-3'; $per23postcodereduceddisplay = substr($per23,0,$per23postcodereduceamount); } else if (strlen($per23) == '7'){ $per23postcodereduceamount = '-3'; $per23postcodereduceddisplay = substr($per23,0,$per23postcodereduceamount); } ////// Images to display to tnts and on edit profile $property_pic_cover = ''; if($avatar == NULL){ $property_pic_cover = ''; } $property_pic_cover1 = ''; if($avatar1 == NULL){ $property_pic_cover1 = ''; } $property_pic_cover2 = ''; if($avatar2 == NULL){ $property_pic_cover2 = ''; } $property_pic_cover3 = ''; if($avatar3 == NULL){ $property_pic_cover3 = ''; } $property_pic_cover4 = ''; if($avatar4 == NULL){ $property_pic_cover4 = ''; } ///////////////////////////////////////////////////////// //// Images to show to uploader only in the form section $property_pic_cover_inform = '
'; if($avatar == NULL){ $property_pic_cover_inform = ''; } $property_pic_cover1_inform = ''; if($avatar1 == NULL){ $property_pic_cover1_inform = ''; } $property_pic_cover2_inform = ''; if($avatar2 == NULL){ $property_pic_cover2_inform = ''; } $property_pic_cover3_inform = ''; if($avatar3 == NULL){ $property_pic_cover3_inform = ''; } $property_pic_cover4_inform = ''; if($avatar4 == NULL){ $property_pic_cover4_inform = ''; } /// PROP RNT DISPLAY if (empty($per5)) { $per5_display_prop_rnt = 'Amount not set'; } else if (!empty($per5)) { $per5_display_prop_rnt = number_format($per5); $pound_per5_display_prop_rnt = '£'; $permonth_per5_display_prop_rnt = 'per month'; } // RNT DISPLAY if (empty($per5)) { $numformatpmonthlybudgetdisplay = '£ TBC'; } else if (!empty($per5)) { $numformatpmonthlybudgetdisplay = number_format($per5); $numformatpmonthlybudgetpounddisplay = '£'; } // LOCATION DISPLAY if (empty($per21)) { $locationper21display = ''; } else if (!empty($per21)) { $locationper21display = 'in '.$per21.','; } if (empty($per22)) { $locationper22display = ''; } else if (!empty($per22)) { $locationper22display = ''.$per22.','; } if (empty($per23)) { $locationper23display = ''; } else if (!empty($per23)) { $locationper23display = ''.$per23postcodereduceddisplay.''; } /// FEEATURES STATUS DISPLAY if($per28 == 'No'){ $per28_status_sign= ''; } if($per30 == 'No'){ $per30_status_sign= ''; } if($per31 == 'No'){ $per31_status_sign= ''; } if($per32 == 'No'){ $per32_status_sign= ''; } if($per33 == 'No'){ $per33_status_sign= ''; } /// if ($per4 == 'West London'){ $category_link = 'http://www.cheaprentuk.com/Cheap-flats-west-london'; } if ($per4 == 'North West London'){ $category_link = 'http://www.cheaprentuk.com/Cheap-flats-north-west-london'; } if ($per4 == 'East London'){ $category_link = 'http://www.cheaprentuk.com/Cheap-flats-east-london'; } if ($per4 == 'North London'){ $category_link = 'http://www.cheaprentuk.com/Cheap-flats-north-london'; } if ($per4 == 'South London'){ $category_link = 'http://www.cheaprentuk.com/Cheap-flats-south-london'; } if ($per4 == 'Central London'){ $category_link = 'http://www.cheaprentuk.com/Cheap-flats-central-london'; } ?> array( 'text' => 'Name', 'val' => $_POST['name'] ), 1 => array( 'text' => 'Email address', 'val' => $_POST['email'] ), 2 => array( 'text' => 'Message', 'val' => $_POST['message'] ), 3 => array( 'text' => 'Checkboxes', 'val' => implode($_POST['checkboxes'], ", ") ), 4 => array( 'text' => 'Radios', 'val' => $_POST['radios'] ) ); $message = ""; foreach($fields as $field) { $message .= $field['text'].": " . htmlspecialchars($field['val'], ENT_QUOTES) . "Map locations are approximate.