fork download 
  1. <?php
  2.  
  3.   public function search_article($name_trening, $name_country, $name_city, $name_date){
  4.  
  5.             if($name_trening != null && $name_country != null && $name_city !=null &&  $name_date != null){
  6.  
  7.                 $query = $this->db->placehold("
  8. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  9.                 WHERE name=? AND country=?  AND city=?  AND date=? ", $name_trening, $name_country, $name_city, $name_date);
  10.             } 
  11.         elseif($name_trening == null && $name_city !=null && $name_date !=null && $name_country != null){
  12.                 $query = $this->db->placehold("SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  13.                 WHERE country=? AND city=? AND date=?", $name_country, $name_city, $name_date);         
  14.         }
  15.         elseif($name_country == null && $name_trening != null && $name_city != null && $name_date != null){
  16.                $query = $this->db->placehold("
  17. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  18.                 WHERE name=?  AND city=?  AND date=? ", $name_trening, $name_city, $name_date);
  19.         }
  20.         elseif($name_city == null && $name_country != null && $name_date != null && $name_trening != null){
  21.                $query = $this->db->placehold("
  22. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  23.                 WHERE name=? AND country=? AND date=? ", $name_trening, $name_country, $name_date);
  24.         }
  25.         elseif($name_date == null && $name_city != null && $name_country!= null && $name_trening != null){
  26.                $query = $this->db->placehold("
  27. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  28.                 WHERE name=? AND country=?  AND city=?", $name_trening, $name_country, $name_city);
  29.         }
  30.       elseif($name_trening == null && $name_country == null && $name_date == null && $name_city != null){
  31.                          $query = $this->db->placehold("
  32. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  33.                 WHERE city=?", $name_city);
  34.       }
  35.       elseif($name_trening == null && $name_country == null && $name_city == null && $name_date != null){
  36.                          $query = $this->db->placehold("
  37. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  38.                 WHERE date=?", $name_date);
  39.       }
  40.       elseif($name_date == null && $name_country == null && $name_city == null && $name_trening !=null){
  41.           $query = $this->db->placehold("
  42. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  43.                 WHERE name=?", $name_trening);
  44.       }
  45.       elseif($name_date == null && $name_trening == null && $name_city == null && $name_country != null){
  46.            $query = $this->db->placehold("
  47. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  48.                 WHERE country=?", $name_country);
  49.       }
  50.  
  51.  
  52.       elseif($name_date == null && $name_trening == null && $name_country!= null && $name_city !=null){
  53.           $query = $this->db->placehold("
  54. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  55.                 WHERE country=? AND city = ?", $name_country, $name_city);
  56.       }
  57.       elseif($name_date == null && $name_city == null && $name_country != null && $name_trening != null){
  58.           $query = $this->db->placehold("
  59. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  60.                 WHERE country=? AND name = ?", $name_country, $name_trening);
  61.       }
  62.       elseif($name_date == null && $name_country == null && $name_city != null && $name_trening != null){
  63.           $query = $this->db->placehold("
  64. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  65.                 WHERE city=? AND name = ?", $name_city, $name_trening);
  66.       }
  67.  
  68.       elseif($name_city == null && $name_trening == null && $name_country != null && $name_date != null){
  69.           $query = $this->db->placehold("
  70. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  71.                 WHERE country=? AND date = ?", $name_country, $name_date);
  72.       }
  73.  
  74.       elseif($name_country == null && $name_trening == null && $name_city != null && $name_date != null){
  75.           $query = $this->db->placehold("
  76. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  77.                 WHERE city=? AND date = ?", $name_city, $name_date);
  78.       }
  79.       elseif($name_country == null && $name_city == null && $name_trening != null && $name_date != null){
  80.           $query = $this->db->placehold("
  81. SELECT id_trening, new, online, time, discount, instr_name, price, name, url, date, country, city, mesto FROM __timetable 
  82.                 WHERE name=? AND date = ?", $name_trening, $name_date);
  83.       }
  84.  
  85.         $this->db->query($query);
  86.                 if($this->db->query($query))
  87. 			return $this->db->results(); 
  88. 		else
  89. 			return false;
  90.  
  91.         }
Runtime error #stdin #stdout #stderr 0.02s 52488KB
comments (?)
stdin 
Standard input is empty
stdout 
Standard output is empty
stderr 
PHP Parse error:  syntax error, unexpected 'public' (T_PUBLIC) in /home/HpyExa/prog.php on line 3
https://ideone.com/kEdhTe
language:
PHP (php 7.3.5)
created:
8 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!