Advertisement
michaelyuen

Untitled

Feb 20th, 2017
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.72 KB | None | 0 0
  1. <?php
  2.     class someClass {
  3.         private $data;
  4.        
  5.         public function __construct() {
  6.             global $con;
  7.             $this->con = $con;
  8.         }
  9.    
  10.         public function getSearch($search_array);
  11.             foreach ($search_array as $k => $v) {
  12.                 $likes[] = "$k LIKE '%$v%'";
  13.             }
  14.             $where = implode(' AND ',$likes);
  15.             $query = "SELECT title,cat_name,country_name,state_name,city_name
  16.                              FROM classified
  17.                              LEFT JOIN user on classified.user_id=user.id
  18.                              LEFT JOIN category on classified.category_id=category.id
  19.                              LEFT JOIN countries on user.country=countries.id
  20.                              LEFT JOIN states on user.state=states.id
  21.                              LEFT JOIN cities on user.city=cities.id
  22.                              WHERE $where";
  23.             if (!$result = $this->con->query($query)) {
  24.                 $this->getSearch->error = 'Error - Connection, Search : ' . $this->con->error;
  25.                 return false;
  26.             }
  27.             if ($result->num_rows == 0) {
  28.                 $this->getSearch->error = 'Warning - Search: No Record Found';
  29.                 return false;
  30.             }
  31.             WHILE ($row = $result->fetch_assoc()) {
  32.                 $data[] = $row;
  33.             }
  34.             return $data;
  35.     }
  36.    
  37.     $someClass = new someClass;
  38.    
  39.     if (ISSET($_POST['search'])) {
  40.         $search_array = $_POST;
  41.         unset($search_array['search']);
  42.         $result = $someClass->getSearch($search_array);
  43.         echo $result = (is_array($result)) ? print_r($result) : $someClass->getSearch->error;
  44.     }
  45. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement