<?php

  public function search_article($name_trening, $name_country, $name_city, $name_date){
            
            if($name_trening != null && $name_country != null && $name_city !=null &&  $name_date != null){

                $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE name=? AND country=?  AND city=?  AND date=? ", $name_trening, $name_country, $name_city, $name_date);
            } 
        elseif($name_trening == null && $name_city !=null && $name_date !=null && $name_country != null){
                $query = $this->db->placehold("SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE country=? AND city=? AND date=?", $name_country, $name_city, $name_date);         
        }
        elseif($name_country == null && $name_trening != null && $name_city != null && $name_date != null){
               $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE name=?  AND city=?  AND date=? ", $name_trening, $name_city, $name_date);
        }
        elseif($name_city == null && $name_country != null && $name_date != null && $name_trening != null){
               $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE name=? AND country=? AND date=? ", $name_trening, $name_country, $name_date);
        }
        elseif($name_date == null && $name_city != null && $name_country!= null && $name_trening != null){
               $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE name=? AND country=?  AND city=?", $name_trening, $name_country, $name_city);
        }
      elseif($name_trening == null && $name_country == null && $name_date == null && $name_city != null){
                         $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE city=?", $name_city);
      }
      elseif($name_trening == null && $name_country == null && $name_city == null && $name_date != null){
                         $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE date=?", $name_date);
      }
      elseif($name_date == null && $name_country == null && $name_city == null && $name_trening !=null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE name=?", $name_trening);
      }
      elseif($name_date == null && $name_trening == null && $name_city == null && $name_country != null){
           $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE country=?", $name_country);
      }
      
      
      elseif($name_date == null && $name_trening == null && $name_country!= null && $name_city !=null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE country=? AND city = ?", $name_country, $name_city);
      }
      elseif($name_date == null && $name_city == null && $name_country != null && $name_trening != null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE country=? AND name = ?", $name_country, $name_trening);
      }
      elseif($name_date == null && $name_country == null && $name_city != null && $name_trening != null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE city=? AND name = ?", $name_city, $name_trening);
      }
      
      elseif($name_city == null && $name_trening == null && $name_country != null && $name_date != null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE country=? AND date = ?", $name_country, $name_date);
      }
      
      elseif($name_country == null && $name_trening == null && $name_city != null && $name_date != null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE city=? AND date = ?", $name_city, $name_date);
      }
      elseif($name_country == null && $name_city == null && $name_trening != null && $name_date != null){
          $query = $this->db->placehold("
SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
                WHERE name=? AND date = ?", $name_trening, $name_date);
      }
      
        $this->db->query($query);
                if($this->db->query($query))
			return $this->db->results(); 
		else
			return false;
		    
        }