Az oldal használata:

1. 1.

   Írd be az irányítószámod.
   

2. 2.

   Kattints a Keresésre.
   

3. 3.

   Mentsd el a könyvjelzőid közé.
   

Tipp: Állítsd be a mobilodon a településed könyvjelzőként, hogy bármikor meg tudd nézni mikor viszik el tőletek a szemetet.

Legfrissebb adatok

callback=$callback; if($this->handler=mysqli_connect(SQL_SERVER,SQL_LOGIN,SQL_PASS,TRUE)){ if(mysqli_select_db(SQL_DBNAME,$this->handler)){ mysqli_set_charset("UTF8",$this->handler); }else{ if($callback) call_user_func($callback,mysqli_error(),""); else $this->error(mysqli_error()); } if($template!="") $this->installTemplate($template); if($table!="") $this->table=$table; }else{ if($callback) call_user_func($callback,mysqli_error(),""); else $this->error(mysqli_error()); } } public function fetch($query=""){ $r=Array(); $this->query=($query!=""?$query:$this->query); $this->query=str_replace("&table",$this->table,$this->query); if($q=mysqli_query($this->query,$this->handler)){ while($rr=mysqli_fetch_assoc($q)){ $r[]=$rr; } return $r; } if($this->callback) call_user_func($this->callback,mysqli_error(),$this->query); else $this->error(mysqli_error()); return false; } public function get($fields,$filter="",$order=""){ $r=Array(); if($fields!='*') $fields=$this->getParams($fields,'`'); $this->query="SELECT ".preg_replace('/\s+/',"",$fields)." FROM `".$this->table."`"; if($filter!="") $this->query.=" WHERE ".$filter; $this->query.=" ".$order; if($q=mysqli_query($this->query,$this->handler)){ while($rr=mysqli_fetch_assoc($q)){ $r[]=$rr; } return $r; } if($this->callback) call_user_func($this->callback,mysqli_error(),$this->query); else $this->error(mysqli_error()); return false; } public function put($fields,$values,$sub=""){ $this->query="INSERT INTO `".$this->table."` (".$this->getParams($fields,"`").") VALUES(".$this->getParams($values).") ".$sub; if(mysqli_query($this->query,$this->handler)) return true; if($this->callback) call_user_func($this->callback,mysqli_error(),$this->query); else $this->error(mysqli_error()); return false; } public function get_auto_increment(){ $this->query="SHOW TABLE STATUS LIKE '".$this->table."'"; $tmp=mysqli_query($this->query,$this->handler) or $this->error(mysqli_error()); $row=mysqli_fetch_assoc($tmp); return $row["Auto_increment"]; } //todo public function update($query,$filter){ $this->query="UPDATE `".$this->table."` SET ".$query." WHERE ".$filter; if($q=mysqli_query($this->query,$this->handler)){ return $q; }else{ if($this->callback) call_user_func($this->callback,mysqli_error(),$this->query); else $this->error(mysqli_error()); } } public function delete($filter){ $this->query="DELETE FROM `".$this->table."`"; if($filter!="all") $this->query.=" WHERE ".$filter; if($q=mysqli_query($this->query,$this->handler)){ return $q; }else{ if($this->callback) $this->callback(mysqli_error(),$this->query); else $this->error(mysqli_error()); } } //endtodo public function lastQuery(){ return $this->query; } public function lastError(){ return $this->error; } private function installTemplate($template){ if($q=mysqli_query($template,$this->handler)){ return $q; }else{ if($this->callback) $this->callback(mysqli_error(),$this->query); else $this->error(mysqli_error()); } } private function error($txt){ $this->error=$txt; print $this->error; return false; } private function getParams($str,$qoute="'"){ $str=explode(",",$str); $p=""; foreach($str as $attr){ if($attr!=""){ if($p!="") $p.=','; $p.=$qoute.$attr.$qoute; } } return $p; } } ?>