Temizlik v3 Versiyonu Sizlerle

<?php require_once 'baglan.php';
function logla($aciklama){
  global $db;
  $satir2 = ['aciklama' => $aciklama ];
  $query = $db->prepare("INSERT INTO log SET aciklama=:aciklama");
  $insert = $query->execute($satir2);
};
function form_security($post){
  if(is_array($post)){
    array_map('form_security',$post);
  }else{
    $post=trim($post);
    $post = htmlspecialchars($post);
    $post = stripslashes($post);
    $post = strip_tags($post); 
  }
  return $post;
}
function password($hsc){
  if(is_array($hsc)){
    array_map('password',$hsc);
  }else{
    $hsc=trim($hsc);
    $hsc = htmlspecialchars($hsc);
    $hsc = stripslashes($hsc);
    $hsc = strip_tags($hsc);
    $hsc=md5($hsc);
  }
  return $hsc;
}
function boskontrol($veri){
  if ($veri == '') {
    echo 'Tüm alanları doldurunuz';
    exit;
  }else{
    return $veri;
  }
}
function yonlendir($saniye, $links){
  echo '<META HTTP-EQUIV="Refresh" CONTENT="'.$saniye.';URL='.$links.'">';
}
function GetIP(){
  if(getenv("HTTP_CLIENT_IP")) {
   $ip = getenv("HTTP_CLIENT_IP");
 } elseif(getenv("HTTP_X_FORWARDED_FOR")) {
   $ip = getenv("HTTP_X_FORWARDED_FOR");
   if (strstr($ip, ',')) {
     $tmp = explode (',', $ip);
     $ip = trim($tmp[0]);
   }
 } else {
   $ip = getenv("REMOTE_ADDR");
 }
 return $ip;
}
function islemkontrol () {
  if (empty($_SESSION['kullanici_ad'])) {
    Header("Location:../?durum=izinsizislem");
    exit;
  }
}
function dbtrim($par){
  return str_replace(array("'", "\""), array("'", "&quot;"), $par);
}

function guvenlik($t){
  $t = str_replace("from", "", $t);
  $t = str_replace("where", "", $t);
  $t = str_replace("concat", "", $t);
  $t = str_replace("limit", "", $t);
  $t = str_replace("'", "", $t);
  $t = str_replace("char", "", $t);
  $t = str_replace("select", "", $t);
  $t = str_replace("insert", "", $t);
  $t = str_replace("delete", "", $t);
  $t = str_replace("update", "", $t);
  $t = str_replace("drop table", "", $t);
  $t = str_replace("union", "", $t);
  $t = str_replace("null", "", $t);
  $t = str_replace("SELECT", "", $t);
  $t = str_replace("INSERT", "", $t);
  $t = str_replace("DELETE", "", $t);
  $t = str_replace("UPDATE", "", $t);
  $t = str_replace("DROP TABLE", "", $t);
  $t = str_replace("UNION", "", $t);
  $t = str_replace("NULL", "", $t);
  $t = str_replace("order by", "", $t);
  $t = str_replace(";", "", $t);
  $t = str_replace("exec", "", $t);
  $t = str_replace("shell", "", $t);
  $t = str_replace("cmd", "", $t);
  $text = dbtrim($t);
  return $text;
}
function get($q){
  if (!empty($_GET[$q])) {
    $data = guvenlik($_GET[$q]);
  } else {
    $data = false;
  }
  return $data;
}

function post($q){
  if (!empty($_POST[$q])) {
    $data = guvenlik($_POST[$q]);
  } else {
    $data = '';
  }
  return $data;
}

function tl_format($deger){
  $tl_formati = number_format($deger, 2, ",", ".");
  return $tl_formati;
}
function kisa($metin, $uzunluk = 50){
  if ($uzunluk < strlen($metin)) {
    $metin = mb_substr($metin, 0, $uzunluk) . "...";
    $metin_son = strrchr($metin, " ");
    $metin = str_replace($metin_son, " ...", $metin);
  }
  return strip_tags($metin);
}
function seo($s){
  $tr = ["ş", "Ş", "ı", "İ", "ğ", "Ğ", "ü", "Ü", "ö", "Ö", "ç", "Ç"];
  $en = ["s", "s", "i", "i", "g", "g", "u", "u", "o", "o", "c", "c"];
  $s = str_replace($tr, $en, $s);
  $s = strtolower($s);
  $s = preg_replace("/&amp;amp;amp;amp;amp;amp;amp;amp;.+?;/", "-", $s);
  $s = preg_replace("/[^%a-z0-9 _-]/", "-", $s);
  $s = preg_replace("/\\s+/", "-", $s);
  $s = preg_replace("|-+|", "-", $s);
  $s = str_replace("--", "-", $s);
  $s = trim($s, "-");
  return $s;
}
function tcevir($tarih){
  $tr = explode("-",$tarih);
  $tarih1 = $tr[2]."-".$tr[1]."-".$tr[0];
  return $tarih1;
}
function zamantr($girdi){
  $cikti = date("d F Y ", $girdi);
  $aylarIng = array(
    "January", "February", "March", "April", "May", "June",
    "July", "August", "September", "October", "November", "December");
  $gunlerIng = array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
  $aylar = array(
    "Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran",
    "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık"
  );
  $gunler = array("Pazartesi", "Salı", "Çarşamba", "Perşembe", "Cuma", "Cumartesi", "Pazar");
  $cikti = str_replace($aylarIng, $aylar, $cikti);
  $cikti = str_replace($gunlerIng, $gunler, $cikti);
  return $cikti;
}
function yzamantr($girdi){
  $cikti = date("d F Y l H:i", $girdi);
  $aylarIng = array(
    "January", "February", "March", "April", "May", "June",
    "July", "August", "September", "October", "November", "December");
  $gunlerIng = array("Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday");
  $aylar = array(
    "Ocak", "Şubat", "Mart", "Nisan", "Mayıs", "Haziran",
    "Temmuz", "Ağustos", "Eylül", "Ekim", "Kasım", "Aralık"
  );
  $gunler = array("Pazartesi", "Salı", "Çarşamba", "Perşembe", "Cuma", "Cumartesi", "Pazar");
  $cikti = str_replace($aylarIng, $aylar, $cikti);
  $cikti = str_replace($gunlerIng, $gunler, $cikti);
  return $cikti;
}
function sorgu($db,$tablo,$wherealan="",$wherearraydeger="",$order="ORDER BY ID ASC",$limit=""){
  $db->query("SET CHARACTER SET utf8");
  $sql="SELECT * FROM ".$tablo;
  if(!empty($wherealan) && !empty($wherearraydeger)){
    $sql.=" ".$wherealan;
    if(!empty($order)){ $sql.=" ".$order;}
    if(!empty($limit)){ $sql.=" LIMIT ".$limit;}
    $execute=$db->prepare($sql);
    $veris=$execute->execute($wherearraydeger);
    $veri=$execute->fetchAll(PDO::FETCH_ASSOC);
  }
  else
  {
    if(!empty($order)){ $sql.=" ".$order;}
    if(!empty($limit)){ $sql.=" LIMIT ".$limit;}
    $veri=$db->query($sql,PDO::FETCH_ASSOC);
  }
  if($veri!=false && !empty($veri))
  {
    $line=array();
    foreach($veri as $deger)
    {
      $line[]=$deger;
    }
    return $line;
  }
  else
  {
    return false;
  }
}
?>