Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class someClass {
- private $data;
- public function __construct() {
- global $con;
- $this->con = $con;
- }
- public function getSearch($search_array);
- foreach ($search_array as $k => $v) {
- $likes[] = "$k LIKE '%$v%'";
- }
- $where = implode(' AND ',$likes);
- $query = "SELECT title,cat_name,country_name,state_name,city_name
- FROM classified
- LEFT JOIN user on classified.user_id=user.id
- LEFT JOIN category on classified.category_id=category.id
- LEFT JOIN countries on user.country=countries.id
- LEFT JOIN states on user.state=states.id
- LEFT JOIN cities on user.city=cities.id
- WHERE $where";
- if (!$result = $this->con->query($query)) {
- $this->getSearch->error = 'Error - Connection, Search : ' . $this->con->error;
- return false;
- }
- if ($result->num_rows == 0) {
- $this->getSearch->error = 'Warning - Search: No Record Found';
- return false;
- }
- WHILE ($row = $result->fetch_assoc()) {
- $data[] = $row;
- }
- return $data;
- }
- $someClass = new someClass;
- if (ISSET($_POST['search'])) {
- $search_array = $_POST;
- unset($search_array['search']);
- $result = $someClass->getSearch($search_array);
- echo $result = (is_array($result)) ? print_r($result) : $someClass->getSearch->error;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement