<?php $memcache = new Memcache(); $memcache->connect('localhost', 11211) or die("Could not connect"); $aData = array('name' => 'table', 'color' => 'brown', 'size' => array('x' => 200, 'y' => 120, 'z' => 150), 'strength' => 10); require_once 'memcache.caching.php'; $oCache = new CacheMemcache(); echo 'Initial data: <pre>'; // lets see what we have print_r($aData); echo '</pre>'; if ($oCache->bEnabled) { // if Memcache enabled $oCache->setData('my_object', $aData); // saving data to cache server $oCache->setData('our_class_object', $oCache); // saving object of our class into cache server too echo 'Now we saved all in cache server, click <a href="index2.php">here</a> to check what we have in cache server'; } else { echo 'Seems Memcache not installed, please install it to perform tests'; }
public function showFilteredPetMateList($filterPetMateList) { $this->data = array(); $categories = array(); $breeds = array(); $ages = array(); $genders = array(); $email = $filterPetMateList->getEmail(); $categories = json_decode($filterPetMateList->getFilterSelectedCategories()); $breeds = json_decode($filterPetMateList->getFilterSelectedBreeds()); $ages = json_decode($filterPetMateList->getFilterSelectedAge()); $genders = json_decode($filterPetMateList->getFilterSelectedGender()); $sqlAddress = "SELECT latitude,longitude FROM userDetails WHERE email='" . $filterPetMateList->getEmail() . "' "; $latlong = mysqli_query($this->con, $sqlAddress); $latLongValue = mysqli_fetch_row($latlong); $latitude = $latLongValue[0]; $longitude = $latLongValue[1]; if ((int) $filterPetMateList->getCurrentPage() == 1) { if (empty($categories) && empty($ages)) { foreach ($genders as $gender) { $gender = trim($gender); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_gender='{$gender}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { if (empty($categories) && empty($genders)) { $minAge = $ages[0]; $maxAge = $ages[1]; $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge}\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } else { if (empty($ages) && empty($genders)) { foreach ($categories as $category) { $category = trim($category); if (empty($breeds)) { $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } else { foreach ($breeds as $breed) { $breed = trim($breed); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } else { if (empty($categories)) { $minAge = $ages[0]; $maxAge = $ages[1]; foreach ($genders as $gender) { $gender = trim($gender); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { if (empty($ages)) { foreach ($categories as $category) { $category = trim($category); if (empty($breeds)) { foreach ($genders as $gender) { $gender = trim($gender); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_gender='{$gender}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { foreach ($breeds as $breed) { $breed = trim($breed); foreach ($genders as $gender) { $gender = trim($gender); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_gender='{$gender}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } else { if (empty($genders)) { $minAge = $ages[0]; $maxAge = $ages[1]; foreach ($categories as $category) { $category = trim($category); if (empty($breeds)) { $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge}\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } else { foreach ($breeds as $breed) { $breed = trim($breed); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge}\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } else { $minAge = $ages[0]; $maxAge = $ages[1]; if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($genders as $gender) { $gender = trim($gender); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($genders as $gender) { $gender = trim($gender); $this->con->options(MYSQLI_OPT_CONNECT_TIMEOUT, 500); $sql = "SELECT pm.id, pm.first_image_path, pm.second_image_path, pm.third_image_path, pm.pet_category, pm.pet_breed, pm.pet_age_inMonth, pm.pet_age_inYear, pm.pet_gender, pm.pet_description, pm.post_date,ud.name,ud.email,ud.mobileno,( 3959 * acos( cos( radians('{$latitude}') ) * cos( radians( ud.latitude ) ) * cos( radians( ud.longitude ) - radians('{$longitude}') ) + sin( radians('{$latitude}') ) * sin( radians( ud.latitude ) ) ) ) * 1.609344 AS distance\n FROM petmate pm \n INNER JOIN userDetails ud\n ON pm.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}'\n HAVING distance < 5 ORDER BY distance "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } } } } } } $count = 0; $count += count($this->data); $rowsPerPage = 10; $totalPages = ceil($count / $rowsPerPage); if (is_numeric($filterPetMateList->getCurrentPage())) { $currentPage = (int) $filterPetMateList->getCurrentPage(); } if ($currentPage >= 1 && $currentPage <= $totalPages) { $offset = ($currentPage - 1) * $rowsPerPage; $formattedArray = array(); foreach ($this->data as $key => $row) { $formattedArray[$key] = $row['post_date']; } array_multisort($formattedArray, SORT_DESC, $this->data); $output = array_slice($this->data, $offset, $rowsPerPage); $cache = new CacheMemcache(); if ($cache->memcacheEnabled) { $cache->setData('filter_pet_mate_list_email', $email); $cache->setData('filter_pet_mate_list_array_' + $email, $this->data); // saving data to cache server } } } else { $cache = new CacheMemcache(); $output = null; if ($cache->memcacheEnabled) { if ($email == $cache->getData('filter_pet_mate_list_email')) { $this->data = $cache->getData('filter_pet_mate_list_array_' + $email); $count = 0; $count += count($this->data); $rowsPerPage = 10; $totalPages = ceil($count / $rowsPerPage); if (is_numeric($filterPetMateList->getCurrentPage())) { $currentPage = (int) $filterPetMateList->getCurrentPage(); } if ($currentPage >= 1 && $currentPage <= $totalPages) { $offset = ($currentPage - 1) * $rowsPerPage; $output = array_slice($this->data, $offset, $rowsPerPage); } } } } return $output; }
public function showFilteredPetList($filterPetList) { $this->data = array(); $categories = array(); $breeds = array(); $ages = array(); $genders = array(); $adoptionAndPrices = array(); $email = $filterPetList->getEmail(); $categories = json_decode($filterPetList->getFilterSelectedCategories()); $breeds = json_decode($filterPetList->getFilterSelectedBreeds()); $ages = json_decode($filterPetList->getFilterSelectedAge()); $genders = json_decode($filterPetList->getFilterSelectedGender()); $adoptionAndPrices = json_decode($filterPetList->getFilterSelectedAdoptionAndPrice()); if ((int) $filterPetList->getCurrentPage() == 1) { if (empty($categories) && empty($ages) && empty($genders)) { foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { if (empty($categories) && empty($ages) && empty($adoptionAndPrices)) { foreach ($genders as $gender) { $gender = trim($gender); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_gender='{$gender}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { if (empty($categories) && empty($genders) && empty($adoptionAndPrices)) { $minAge = $ages[0]; $maxAge = $ages[1]; $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } else { if (empty($ages) && empty($genders) && empty($adoptionAndPrices)) { foreach ($categories as $category) { $category = trim($category); if (empty($breeds)) { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } else { foreach ($breeds as $breed) { $breed = trim($breed); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } else { if (empty($categories) && empty($ages)) { foreach ($genders as $gender) { $gender = trim($gender); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_gender='{$gender}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_gender='{$gender}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_gender='{$gender}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { if (empty($categories) && empty($genders)) { $minAge = $ages[0]; $maxAge = $ages[1]; foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { if (empty($categories) && empty($adoptionAndPrices)) { $minAge = $ages[0]; $maxAge = $ages[1]; foreach ($genders as $gender) { $gender = trim($gender); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { if (empty($ages) && empty($genders)) { if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } else { if (empty($ages) && empty($adoptionAndPrices)) { if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($genders as $gender) { $gender = trim($gender); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_gender='{$gender}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($genders as $gender) { $gender = trim($gender); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_gender='{$gender}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } else { if (empty($genders) && empty($adoptionAndPrices)) { $minAge = $ages[0]; $maxAge = $ages[1]; if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } else { if (empty($categories)) { $minAge = $ages[0]; $maxAge = $ages[1]; foreach ($genders as $gender) { $gender = trim($gender); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { if (empty($ages)) { if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($genders as $gender) { $gender = trim($gender); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_gender='{$gender}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_gender='{$gender}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_gender='{$gender}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($genders as $gender) { $gender = trim($gender); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_gender='{$gender}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_gender='{$gender}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_gender='{$gender}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } } else { if (empty($genders)) { $minAge = $ages[0]; $maxAge = $ages[1]; if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } else { if (empty($adoptionAndPrices)) { $minAge = $ages[0]; $maxAge = $ages[1]; if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($genders as $gender) { $gender = trim($gender); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($genders as $gender) { $gender = trim($gender); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' "; try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } else { $minAge = $ages[0]; $maxAge = $ages[1]; if (empty($breeds)) { foreach ($categories as $category) { $category = trim($category); foreach ($genders as $gender) { $gender = trim($gender); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } else { foreach ($categories as $category) { $category = trim($category); foreach ($breeds as $breed) { $breed = trim($breed); foreach ($genders as $gender) { $gender = trim($gender); foreach ($adoptionAndPrices as $adoptionAndPrice) { $adoptionAndPrice = trim($adoptionAndPrice); if ($adoptionAndPrice == "For Adoption") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_adoption='{$adoptionAndPrice}' "; } else { if ($adoptionAndPrice == "50000 Onwards") { $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email \n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_price >= 50000 "; } else { $splitPrice = explode("-", $adoptionAndPrice); $minPrice = trim($splitPrice[0]); $maxPrice = trim($splitPrice[1]); $sql = "SELECT p.first_image_path, p.second_image_path, p.third_image_path, p.pet_category, p.pet_breed, p.pet_age_inMonth, p.pet_age_inYear, p.pet_gender, p.pet_description, p.pet_adoption, p.pet_price, p.post_date, p.email, ud.name, ud.mobileno \n FROM petapp p\n INNER JOIN userDetails ud\n ON p.email = ud.email\n WHERE pet_category='{$category}' AND pet_breed='{$breed}' AND pet_age_inYear BETWEEN {$minAge} AND {$maxAge} AND pet_gender='{$gender}' AND pet_price BETWEEN {$minPrice} AND {$maxPrice} "; } } try { $select = mysqli_query($this->con, $sql); while ($rowdata = mysqli_fetch_assoc($select)) { $this->data[] = $rowdata; } } catch (Exception $e) { echo 'SQL Exception: ' . $e->getMessage(); } } } } } } } } } } } } } } } } } } } } $count = 0; $count += count($this->data); $rowsPerPage = 10; $totalPages = ceil($count / $rowsPerPage); if (is_numeric($filterPetList->getCurrentPage())) { $currentPage = (int) $filterPetList->getCurrentPage(); } if ($currentPage >= 1 && $currentPage <= $totalPages) { $offset = ($currentPage - 1) * $rowsPerPage; $formattedArray = array(); foreach ($this->data as $key => $row) { $formattedArray[$key] = $row['post_date']; } array_multisort($formattedArray, SORT_DESC, $this->data); $output = array_slice($this->data, $offset, $rowsPerPage); $cache = new CacheMemcache(); if ($cache->memcacheEnabled) { $cache->setData('filter_pet_list_email', $email); $cache->setData('filter_pet_list_array_' + $email, $this->data); // saving data to cache server } } } else { $cache = new CacheMemcache(); if ($cache->memcacheEnabled) { if ($email == $cache->getData('filter_pet_list_email')) { $this->data = $cache->getData('filter_pet_list_array_' + $email); $count = 0; $count += count($this->data); $rowsPerPage = 10; $totalPages = ceil($count / $rowsPerPage); if (is_numeric($filterPetList->getCurrentPage())) { $currentPage = (int) $filterPetList->getCurrentPage(); } if ($currentPage >= 1 && $currentPage <= $totalPages) { $offset = ($currentPage - 1) * $rowsPerPage; $output = array_slice($this->data, $offset, $rowsPerPage); } } } } return $output; }