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;
}
}
?>
Hulladékszállítási naptárak
Partnereink
A hulladék naptár nem jöhetett volna létre a ti segítségetek nélkül. Köszönjük a visszajelzéseket, észrevételeket. Akik a legtöbbet segítettek: