<?php
include "./././ayar.php"; 
include "./././baglan.php"; 

$tip = $_GET['tip'];

	if ($tip == 'ekle'){
	
		$urun_isim 	= 	$_GET['urun_isim'];
		$urun_ad	=	$_GET['urun_ad'];
		$urun_soyad	=	$_GET['urun_soyad'];
		$urun_tel	=	$_GET['urun_tel'];
		$urun_no	=	$_GET['urun_no'];
		$urun_durum	=	$_GET['urun_durum'];
		
		if( ($urun_isim != '') && ($urun_ad != '') && ($urun_soyad != '') && ($urun_tel != '') ) {
		
		$db->query("INSERT INTO urunler (urun_isim, urun_ad, urun_soyad, urun_tel, urun_no, urun_durum) VALUES ('$urun_isim', '$urun_ad', '$urun_soyad', '$urun_tel', '$urun_no', '$urun_durum')");
		}
	}
	
	
	if ($tip == 'duzenle'){
	
		$urun_isim 	= 	$_GET['urun_isim'];
		$urun_ad	=	$_GET['urun_ad'];
		$urun_soyad	=	$_GET['urun_soyad'];
		$urun_tel	=	$_GET['urun_tel'];
		$urun_no	=	$_GET['urun_no'];
		$urun_durum	=	$_GET['urun_durum'];
		$urun_id	=	$_GET['urun_id'];
		
		if( ($urun_isim != '') && ($urun_ad != '') && ($urun_soyad != '') && ($urun_tel != '') ) {
		
		$db->query("UPDATE urunler SET urun_isim = '$urun_isim', urun_ad = '$urun_ad', urun_soyad = '$urun_soyad', urun_tel = '$urun_tel', urun_no = '$urun_no', urun_durum = '$urun_durum'  WHERE urun_id = '$urun_id'");
		}
	}
	
	if ($tip == 'sil'){
		
		$urun_id	=	$_GET['id'];		
		$db->query("DELETE FROM urunler WHERE urun_id = '$urun_id'");
	}
	
	if ($tip == 'pb'){
		$urun_id		=	$_GET['id'];
		$urun_durum 	=	$_GET['kod'];		
		$db->query("UPDATE urunler SET urun_durum =$urun_durum where urun_id = $urun_id");	
	}
?>

<?php
	include_once "ayar.php";
	include_once "shared/ez_sql_core.php";
	include_once "mysql/ez_sql_mysql.php";
	$db = new ezSQL_mysql($kuadi,$sifre,$dbadi,$dbyol);
?>

<?php
/**************************************************************/
/***************VERİTABANI BİLGİLERİ BAŞLANGIÇ*****************/
/**************************************************************/
$kuadi = "asd"; // DATABASE KULLANICI ADI
$sifre = "sad"; // DATABASE ŞİFRESİ
$dbadi = "sda"; // DATABASE ADI
$dbyol = "localhost"; // DATABASE SUNUCUSU %99 localhost tur
/**************************************************************/
/*****************VERİTABANI BİLGİLERİ BİTİŞ*******************/
/**************************************************************/
if (!function_exists("ayaral"))
{
function ayaral($b) {
$ayar = mysql_query("SELECT * FROM ayarlar where ayar='$b'");
$ayarya = mysql_fetch_array($ayar);
return $ayarya['goster'];
}
}
if (!function_exists("metaal"))
{
function metaal($c) {
$meta = mysql_query("SELECT * FROM metalar where meta='$c'");
$metaya = mysql_fetch_array($meta);
return $metaya['goster'];
}
}
$baglanti = mysql_connect($dbyol,$kuadi,$sifre) or die("Mysql Baglanti Hatasi");
    //Veritabani baglantisi
    mysql_select_db($dbadi) or die("Veritabani baglanti hatasi");
    @mysql_query("SET NAMES 'latin5'");
$siteadi = ayaral("SiteAdi");
$fradi = ayaral("FirmaAdi");
$siteadresi = ayaral("SiteAdresi");
$adres = ayaral("Adres");
$telefon = ayaral("Telefon");
$faks = ayaral("Faks");
$iletisimmail = ayaral("IletisimMail");
$arizatakip = ayaral("ArizaTakip");
$googlemap = ayaral("GoogleMapFrame");
$googlemapbuyuk = ayaral("GoogleMapLink");
$hakkimizda = ayaral("Hakkimizda");
$muzikplayer = ayaral("MuzikPlayer");
$anasayfadesc = metaal("AnasayfaDesc");
$iletisimdesc = metaal("IletisimDesc");
$hakkimizdadesc = metaal("HakkimizdaDesc");
$haberlerdesc = metaal("HaberlerDesc");
$urunlerimizdesc = metaal("UrunlerimizDesc");
$referanslarimizdesc = metaal("ReferanslarimizDesc");
$servisdesc = metaal("ArizaTakipDesc");

$anasayfakeyw = metaal("AnasayfaKeyw");
$iletisimkeyw = metaal("IletisimKeyw");
$hakkimizdakeyw = metaal("HakkimizdaKeyw");
$haberlerkeyw = metaal("HaberlerKeyw");
$urunlerimizkeyw = metaal("UrunlerimizKeyw");
$referanslarimizkeyw = metaal("ReferanslarimizKeyw");
$serviskeyw = metaal("ArizaTakipKeyw");
?>