$value) { # code... if(++$i === $numItems){ $concats .= "'".$value."'"; }else{ $concats .= "'".$value."',"; } } $concats .= ")"; //end of keywords based search //location based search $locations = explode(',', $location); $loc = "("; $numItems = count($locations); $i = 0; foreach ($locations as $key => $value) { # code... if(++$i === $numItems){ $loc .= "'".$value."'"; }else{ $loc .= "'".$value."',"; } } $loc .= ")"; //end of location based search try { //foreach ($keyword as $key => $value) { # code... $stmt = $connect->prepare("SELECT * FROM room_rental_registrations_apartment WHERE country IN $concats OR country IN $loc OR state IN $concats OR state IN $loc OR city IN $concats OR city IN $loc OR address IN $concats OR address IN $loc OR rooms IN $concats OR landmark IN $concats OR landmark IN $loc OR rent IN $concats OR deposit IN $concats"); $stmt->execute(); $data2 = $stmt->fetchAll(PDO::FETCH_ASSOC); $stmt = $connect->prepare("SELECT * FROM room_rental_registrations WHERE country IN $concats OR country IN $loc OR state IN $concats OR state IN $loc OR city IN $concats OR city IN $loc OR rooms IN $concats OR address IN $concats OR address IN $loc OR landmark IN $concats OR rent IN $concats OR deposit IN $concats"); $stmt->execute(); $data8 = $stmt->fetchAll(PDO::FETCH_ASSOC); $data = array_merge($data2, $data8); }catch(PDOException $e) { $errMsg = $e->getMessage(); } } ?>

Welcome To Room Rental Registration!

It's Nice To See You

Search

Search rooms or homes for hire.

Search

'.$errMsg.'

'; } if(count($data) !== 0){ echo "

List of Apartment Details

"; }else{ //echo "

Try Some other keywords

"; } ?> $value) { echo '

'; // echo 'Edit'; echo '

Owner Details

'; echo '

Owner Name: '.$value['fullname'].'

'; echo '

Mobile Number: '.$value['mobile'].'

'; echo '

Alternate Number: '.$value['alternat_mobile'].'

'; echo '

Email: '.$value['email'].'

'; echo '

Country: '.$value['country'].'

State: '.$value['state'].'

City: '.$value['city'].'

'; if ($value['image'] !== 'uploads/') { # code... echo ''; } echo '

Room Details

'; // echo '

Country: '.$value['country'].' State: '.$value['state'].' City: '.$value['city'].'

'; echo '

Plot Number: '.$value['plot_number'].'

'; if(isset($value['sale'])){ echo '

Sale: '.$value['sale'].'

'; } if(isset($value['apartment_name'])) echo '

Apartment Name: '.$value['apartment_name'].'

'; if(isset($value['ap_number_of_plats'])) echo '

Plat Number: '.$value['ap_number_of_plats'].'

'; echo '

Available Rooms: '.$value['rooms'].'

'; echo '

Address: '.$value['address'].'

Landmark: '.$value['landmark'].'

'; echo '

Other Details

'; echo '

Accommodation: '.$value['accommodation'].'

'; echo '

Description: '.$value['description'].'

'; if($value['vacant'] == 0){ echo '

Occupied

'; }else{ echo '

Vacant

'; } echo '

'; } ?>