\n"; $t = "       "; $KDV = .17; $eksik = 0; $dir = "/opt2/iiplaza/httpd/htdocs/siparis/"; $para_siniri = 100; $sevkiyat_ucreti = 10; $red = ""; $precision = "%01.3f"; include($dir."mesajlar.php3"); include($dir."hata.php3"); function printResult($result){ echo "\n\nNumber of Rows Affected: "; echo mysql_affected_rows($result); echo "
\n\n"; echo "\n"; $sayi = mysql_num_fields($result); print "\t\n"; for($i=0;$i<$sayi;$i++){ $baslik = mysql_fetch_field($result,$i); print "\t\t\n"; } print "\t\n"; while($row = mysql_fetch_array($result)){ echo "\t\n"; for($i=0;$i<$sayi;$i++){ print "\t\t\n"; } echo "\t\n"; } echo "
$baslik->name ($baslik->type)
$row[$i]
\n\n\n"; echo mysql_num_rows($result); echo " rows in total
\n"; } // Hemen aşağıdaki fonksiyon artık kullanılmıyor. function ParcaBilgisi($SEkod){ $query = "SELECT ayrintilibilgi FROM urun WHERE SE_partno = '$SEkod';"; $result = mysql_query($query); list($kod) = mysql_fetch_row($result); $query = "SELECT aciklama FROM aciklama WHERE kod = $kod;"; $result = mysql_query($query); list($aciklama) = mysql_fetch_row($result); return($aciklama); } function MiktarFiyatlar($SEkod){ $query = "SELECT birimfiyat1, birimfiyat2, birimfiyat3, birimfiyat4, birimfiyat5, birimfiyat6, birimfiyat7 FROM urun WHERE SE_partno = '$SEkod';"; $result = mysql_query($query); $deger = mysql_fetch_array($result); $query = "SELECT miktarfiyattipi FROM urun WHERE SE_partno = '$SEkod';"; $result = mysql_query($query); list($miktarfiyattipi) = mysql_fetch_row($result); $query = "SELECT * FROM fiyat WHERE tip = $miktarfiyattipi;"; $result = mysql_query($query); $boundary = mysql_fetch_array($result); print "\n"; print "\n\n\n"; for($i=1;$i<=sizeof($boundary);$i++){ print "\n"; if($i==1){ $boundary1="1"; } else{ $boundary1=$boundary[$i-1]; } $boundary2 = $boundary[$i]-1; if($boundary1!=0){ if($boundary2<$boundary1 ){ print ""; } else{ print ""; } $yaz = $i-1; print ""; } print "\n"; } print "\n
Miktar (Adet)Fiyat (USD)
>$boundary1$boundary1-$boundary2$deger[$yaz]
\n"; } function Protect($str){ $str = str_replace("<","<",$str); $str = str_replace(">",">",$str); return($str); } function AutoFormat($str){ $str = str_replace("\n","
\n",$str); $str = str_replace("\t","     ",$str); return($str); } function ReverseFormat($str){ $str = str_replace("
\n","\n",$str); $str = str_replace("     ","\t",$str); return($str); } function Baglan(){ $db = 'iiplaza'; $server = 'localhost'; $username = 'iiplaza'; $password = 'pan-6539'; $mydb = mysql_connect($server,$username,$password); $selectResult = mysql_select_db($db,$mydb); } function FTP_Upload($file){ $host = 'www.iiplaza.com'; $username = 'spektrum'; $password = ''; $datadir = '/opt2/spektrum/httpd/htdocs/siparis/maintain/'; $localdir = "d:\\data\\www\\spektrum\\siparis\\data\\"; $site = ftp_connect($host); Bocek($site); ftp_login($site,$username,$password); ftp_chdir($site,$datadir); $gittimi = ftp_put($site,"$localdir$file","$datadir$file",FTP_ASCII); Bocek($gittimi); ftp_quit($site); } function Listele($kategori,$uretici,$keyword,$parcano){ Baglan(); if($kategori){ $query = "SELECT * FROM urun WHERE kategori = '$kategori' ORDER BY aciklama;"; $result = mysql_query($query); } elseif($parcano){ $query = "SELECT * FROM urun WHERE parcano = '$parcano' ORDER BY aciklama;"; $result = mysql_query($query); } elseif($uretici){ $query = "SELECT * FROM urun WHERE uretici = '$uretici' ORDER BY aciklama;"; $result = mysql_query($query); } elseif($keyword){ $query = "SELECT * FROM urun WHERE ( INSTR(LCASE(aciklama),LCASE('$keyword')) ) || ( INSTR(LCASE(ayrintilibilgi),LCASE('$keyword')) ) || ( INSTR(LCASE(uretici_kodu),LCASE('$keyword')) ) ORDER BY aciklama;"; $result = mysql_query($query); } else{ #error } if(!$result){ #error: Ürün bulunamadı. include("urunyok.php3"); } else{ echo "\n

"; if(!$keyword){ echo "$kategori$uretici"; if($kategori){ $resim = strtolower($kategori); $resim = str_replace(" ","",$resim); $resim = str_replace(".","",$resim); $resim = str_replace("/","",$resim); if(!( file_exists($ikondir.$resim.".gif") )){ $resim = 'spektrum'; } echo "\n"; } } else{ echo "Arama Sonuçları"; } echo "

\n"; if($keyword){ echo "
($keyword)
"; } $sayi = mysql_num_rows($result); if($sayi<1){ #error: Ürün bulunamadı. include("urunyok.php3"); } else{ Mesaj('miktargir'); print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n\n"; while($row = mysql_fetch_array($result)){ if($tek==1){ $tek = 0; } else{ $tek = 1; } $vendor = $row["uretici"]; $SE = $row["SE_partno"]; $aciklama = $row["aciklama"]; $uretici = $row["uretici"]; $kod = $row["uretici_kodu"]; $fiyat = $row["birimfiyat1"]; $miktar = $row["miktar"]; $sipariskodu = ""; $fiyat = Yuvarla($fiyat); if($tek==1){ print "\n"; } else{ print "\n"; } $SEkodlu = str_replace(" ","%20",$SE); print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; include("herurunelazim.php3"); print "\n"; } print "
AçıklamaÜreticiÜretici koduBirim FiyatStok MiktarıSipariş Miktarınız
"; print "$aciklama  $uretici  $kod  $fiyat  $miktar
\n"; print "\n"; print "\n"; print "
\n"; print "\n\n"; } } } function Kaydet($sessionid,$mallar,$fiyatlar){ Baglan(); $simdi = time(); $query = "REPLACE INTO siparis\n"; $query.= "VALUES (\n"; $query.= "$sessionid,\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "'$mallar',\n"; $query.= "'$fiyatlar',\n"; $query.= "0,\n"; $query.= "$simdi,\n"; $query.= "'',\n"; $query.= "'',\n"; $query.= "0,\n"; $query.= "0,\n"; $query.= "''\n"; $query.= ");"; $result = mysql_query($query); mysql_close(); } function Desifre($stuff){ $stuffs = explode("&",$stuff); for($i=0;$i<=sizeof($stuffs);$i++){ list ($name,$value) = explode(":",$stuffs[$i]); $cevap[$name] = $value; } return $cevap; } function Sifre($ass_array){ while( list($name, $value)=each($ass_array) ){ if($value!=0){ $strng.= "$name:$value&"; } } return $strng; } function SiparisGoster($sessionid){ global $KDV,$para_siniri,$sevkiyat_ucreti; Baglan(); $query = "SELECT mallar,fiyatlar FROM siparis WHERE sessionid = $sessionid;"; $result = mysql_query($query); $row = mysql_fetch_array($result); $fiyatlar = $row["fiyatlar"]; $fiyat = Desifre($fiyatlar); $mallar = $row["mallar"]; $mal = Desifre($mallar); while( list($SE,$quantity) = each($mal) ){ $whereclause.= "(SE_partno = '$SE') || "; } $whereclause = substr($whereclause,0,strlen($whereclause)-4); $query = "SELECT * FROM urun WHERE ".$whereclause.";"; $result = mysql_query($query); if($result){ $noofrows = 5; $SEkodlu = str_replace(" ","%20",$SE); print "

Sipariş Listeniz

\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n\n"; while($row = mysql_fetch_array($result)){ if($tek==1){ $tek = 0; } else{ $tek = 1; } $vendor = $row["uretici"]; $SE = $row["SE_partno"]; $aciklama = $row["aciklama"]; $uretici = $row["uretici"]; $kod = $row["uretici_kodu"]; $miktar = $row["miktar"]; $sipariskodu = ""; $toplam = $fiyat[$SE] * $mal[$SE]; $SEkodlu = str_replace(" ","%20",$SE); if($tek==1){ print "\n"; } else{ print "\n"; } $fiyat_preci = Yuvarla($fiyat[$SE]); print "\n"; print "\n"; print "\n"; print "\n"; include("herurunelazim.php3"); $toplam = Yuvarla($toplam); print "\n"; print "\n"; print "\n"; $ult_toplam += $toplam; } if($ult_toplam < $para_siniri){ $sevkiyat = Yuvarla($sevkiyat_ucreti); } print "\n\n"; print "\n\n"; $ult_toplam += $sevkiyat; $add = Yuvarla($KDV * $ult_toplam); $ult_toplam += $add; $yuzde_KDV = $KDV * 100; print "\n\n"; print "\n\n"; print "
"; print "AçıklamaÜreticiÜretici KoduStok MiktarıSipariş MiktarıFiyatToplam Fiyat
"; print "$aciklama  $uretici  $kod  $miktar  $fiyat_preci  $toplam
Toplam$ult_toplam
Sevkiyat+$sevkiyat
%$yuzde_KDV KDV+$add
Net$ult_toplam
\n"; print "
"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n\n"; } // Mesaj('devamet'); mysql_close(); return $result; } function AdresKaydet($bilgi){ global $eksik; if($bilgi[12]){ $VDno = $bilgi[12]; } else{ # Kullanıcı hatası # Burada Vergi Dairesi No girilmesinin gerekliliği anlatılacak. } $bilgi = TirnakYok($bilgi); $ok = $VDno; $eksik = 0; if($bilgi[1]){ $sirket = $bilgi[1]; } else{ $eksik = 1; } if($bilgi[2]){ $kontak = $bilgi[2]; } else{ $eksik = 2; } if(($bilgi[3])||($bilgi[4])){ $adres1 = $bilgi[3]; $adres2 = $bilgi[4]; } else{ #error: Adreslerden biri girilmeli $eksik = 3; } $semt = $bilgi[5]; if($bilgi[6]){ $sehir = $bilgi[6]; } else{ $eksik = 6; } $pk = $bilgi[7]; if($bilgi[8]){ $tel = $bilgi[8]; } else{ #Telefon girilmeli $eksik = 8; } $faks = $bilgi[9]; if($bilgi[10]){ # Eposta girilmeli $eposta = $bilgi[10]; } else{ $eksik = 10; } if($bilgi[11]){ $VD = $bilgi[11]; } else{ #VD girilmeli $eksik = 11; } if($bilgi[12]){ $VDno = $bilgi[12]; } else{ #VDno girilmeli $eksik = 12; } $talimat = $bilgi[13]; if($bilgi[14]){ $shipop = $bilgi[14]; } else{ #Shipping options girilmeli $eksik = 14; } if($bilgi[15]){ $payop = $bilgi[15]; } else{ #Payment options girilmeli $eksik = 15; } if($eksik){ $ok = 0; } $cari = ''; $query = "REPLACE INTO musteri VALUES\n"; $query.= "('$VDno',\n"; $query.= "'$sirket',\n"; $query.= "'$kontak',\n"; $query.= "'$adres1',\n"; $query.= "'$adres2',\n"; $query.= "'$semt',\n"; $query.= "'$sehir',\n"; $query.= "'$pk',\n"; $query.= "'$tel',\n"; $query.= "'$faks',\n"; $query.= "'$eposta',\n"; $query.= "'$VD',\n"; $query.= "'$VDno',\n"; $query.= "'$talimat',\n"; $query.= "$shipop,\n"; $query.= "$payop,\n"; $query.= "'$cari');"; if($ok){ $result = mysql_query($query); $sayi = mysql_affected_rows($result); } if(!$sayi){ $ok = 0; } return $ok; } function AdresYenile($bilgi){ global $eksik; $ok = $bilgi[12]; $bilgi = TirnakYok($bilgi); if($bilgi[1]){ $sirket = $bilgi[1]; } else{ $eksik = 1; } if($bilgi[2]){ $kontak = $bilgi[2]; } else{ $eksik = 2; } if(($bilgi[3])||($bilgi[4])){ $adres1 = $bilgi[3]; $adres2 = $bilgi[4]; } else{ #error: Adreslerden biri girilmeli $eksik = 3; } $semt = $bilgi[5]; if($bilgi[6]){ $sehir = $bilgi[6]; } else{ $eksik = 6; } $pk = $bilgi[7]; if($bilgi[8]){ $tel = $bilgi[8]; } else{ #Telefon girilmeli $eksik = 8; } $faks = $bilgi[9]; if($bilgi[10]){ $eposta = $bilgi[10]; } else{ $eksik = 10; } if($bilgi[11]){ $VD = $bilgi[11]; } else{ #VD girilmeli $eksik = 11; } if($bilgi[12]){ $VDno = $bilgi[12]; } else{ #VDno girilmeli $eksik = 12; } $talimat = $bilgi[13]; if($bilgi[14]){ $shipop = $bilgi[14]; } else{ #Shipping options girilmeli $eksik = 14; } if($bilgi[15]){ $payop = $bilgi[15]; } else{ #Payment options girilmeli $eksik = 15; } if($eksik>0){ $ok = 0; } $cari = $bilgi[16]; $query = "REPLACE INTO musteri VALUES\n"; $query.= "('$VDno',\n"; $query.= "'$sirket',\n"; $query.= "'$kontak',\n"; $query.= "'$adres1',\n"; $query.= "'$adres2',\n"; $query.= "'$semt',\n"; $query.= "'$sehir',\n"; $query.= "'$pk',\n"; $query.= "'$tel',\n"; $query.= "'$faks',\n"; $query.= "'$eposta',\n"; $query.= "'$VD',\n"; $query.= "'$VDno',\n"; $query.= "'$talimat',\n"; $query.= "$shipop,\n"; $query.= "$payop,\n"; $query.= "'$cari');"; if($ok){ $result = mysql_query($query); $sayi = mysql_affected_rows($result); } if(!$sayi){ $ok = 0; } return $ok; } function SiparisiGonder($sessionid,$cari,$firmabilgisi,$talimat,$shipop,$payop,$ccno){ $talimat = Protect($talimat); $talimat = AutoFormat($talimat); $kod = $firmabilgisi[0]; $query = "UPDATE siparis SET firmakod = '$kod', verildi = 1,\n"; $query.= "sirket = '$firmabilgisi[1]',\n"; $query.= "kontak = '$firmabilgisi[2]',\n"; $query.= "adres1 = '$firmabilgisi[3]',\n"; $query.= "adres2 = '$firmabilgisi[4]',\n"; $query.= "semt = '$firmabilgisi[5]',\n"; $query.= "sehir = '$firmabilgisi[6]',\n"; $query.= "pk = '$firmabilgisi[7]',\n"; $query.= "tel = '$firmabilgisi[8]',\n"; $query.= "faks = '$firmabilgisi[9]',\n"; $query.= "eposta = '$firmabilgisi[10]',\n"; $query.= "VD = '$firmabilgisi[11]',\n"; $query.= "VDno = '$firmabilgisi[12]',\n"; $query.= "talimatlar = '$talimat', shipop = $shipop, payop = $payop WHERE sessionid = $sessionid;"; $result = mysql_query($query); # Bocek($query);Bocek($result); return $result; } function SiparisSonHali($sessionid){ global $KDV,$red,$para_siniri,$sevkiyat_ucreti; Baglan(); $query = "SELECT mallar,fiyatlar FROM siparis WHERE sessionid = $sessionid;"; $result = mysql_query($query); $row = mysql_fetch_array($result); $mallar = $row["mallar"]; $mal = Desifre($mallar); $fiyatlar = $row["fiyatlar"]; $fiyat = Desifre($fiyatlar); while( list($SE,$quantity) = each($mal) ){ $whereclause.= "(SE_partno = '$SE') || "; } $whereclause = substr($whereclause,0,strlen($whereclause)-4); $query = "SELECT * FROM urun WHERE ".$whereclause.";"; $result = mysql_query($query); print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $noofrows = 5; while($row = mysql_fetch_array($result)){ if($tek==1){ $tek = 0; } else{ $tek = 1; } $vendor = $row["uretici"]; $SE = $row["SE_partno"]; $aciklama = $row["aciklama"]; $uretici = $row["uretici"]; $kod = $row["uretici_kodu"]; $mevcut = $row["miktar"]; $quantity = $mal[$SE]; $toplam = $fiyat[$SE] * $quantity; if($tek==1){ print "\n"; } else{ print "\n"; } $fiyat_preci = Yuvarla($fiyat[$SE]); print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; $toplam = Yuvarla($toplam); print "\n"; print "\n"; $ult_toplam += $toplam; } if($ult_toplam < $para_siniri){ $sevkiyat = Yuvarla($sevkiyat_ucreti); } print "\n\n"; print "\n\n"; $ult_toplam += $sevkiyat; $add = Yuvarla($KDV * $ult_toplam); $ult_toplam += $add; $yuzde_KDV = $KDV * 100; print "\n\n"; print "\n\n"; print "
AçıklamaÜreticiÜretici koduSipariş miktarıMevcut miktarBirim fiyatToplam Fiyat
 $aciklama $uretici $kod $quantity \n"; if($mevcut < $quantity){ echo $red; } print "$mevcut$fiyat_preci$toplam
Toplam$ult_toplam
Sevkiyat+$sevkiyat
%$yuzde_KDV KDV+$add
Net$ult_toplam
\n"; mysql_close(); return($ult_toplam); } function FiyatBelirle($SEno,$miktar){ $query = "SELECT miktarfiyattipi FROM urun WHERE SE_partno = '$SEno';"; $result = mysql_query($query); $data = mysql_fetch_array($result); $fiyattipi = $data["miktarfiyattipi"]; $query = "SELECT * FROM fiyat WHERE tip = $fiyattipi;"; $result = mysql_query($query); list($tip,$miktar1,$miktar2,$miktar3,$miktar4,$miktar5,$miktar6,$miktar7)=mysql_fetch_row($result); $getrow = 1; if(($miktar>=$miktar1)&&($miktar2!=0)){ $getrow = 2; } if(($miktar>=$miktar2)&&($miktar3!=0)){ $getrow = 3; } if(($miktar>=$miktar3)&&($miktar4!=0)){ $getrow = 4; } if(($miktar>=$miktar4)&&($miktar5!=0)){ $getrow = 5; } if(($miktar>=$miktar5)&&($miktar6!=0)){ $getrow = 6; } if(($miktar>=$miktar6)&&($miktar7!=0)){ $getrow = 7; } $row = "birimfiyat".$getrow; $query = "SELECT $row FROM urun WHERE SE_partno = '$SEno';"; $result = mysql_query($query); $row = mysql_fetch_row($result); $sonuc = $row[0]; return $sonuc; } function ConfirmationMail($email,$sirket,$sessionid){ Baglan(); $order_query = "SELECT * FROM siparis WHERE sessionid = $sessionid;"; $order = mysql_query($order_query); $order_data = mysql_fetch_object($order); $to = $email; $header = "Content-Type: text/plain; charset=windows-1254\r\n"; $header.= "From: siparis@spektrumelektronik.com\r\n"; $header.= "Bcc: siparis@spektrumelektronik.com, fatih@spektrumelektronik.com, sinan@turksanayi.com\r\n"; $header.= "Reply-To: siparis@spektrumelektronik.com\r\n"; $subject = "Siparisiniz Alindi ($sirket)"; $body = "$n$n"; $sourcefile = "posta.txt"; if($fd = fopen($sourcefile, "r")){ $body.= fread($fd, filesize($sourcefile)); if(fclose($fd)){ #nice } else{ #still ok. } } else{ # error: Dosya hatası!! Hata('mailgitmedidosyayok'); } $body.= "\n\nFirma İsmi: $sirket\n"; # $body.= "Cari Kodu: (varsa) $cari\n"; $body.= "İlgili Kişi: $order_data->kontak\n"; $body.= "Adres: $order_data->adres1 $order_data->adres2\n"; $body.= "$order_data->semt\t$order_data->sehir\t$order_data->pk\n"; $body.= "Tel: $order_data->tel\n"; $body.= "Faks: $order_data->faks\n"; $body.= "Vergi Dairesi: $order_data->VD\n"; $body.= "Vergi Dairesi No: $order_data->VDno\n"; $body.= "Talimatlar: $order_data->talimat\n"; $shipment = ShipmentBelirle($order_data->shipop); $payment = PaymentBelirle($order_data->payop); $body.= "Sevkiyat: $shipment\n"; $body.= "Ödeme: $payment\n"; // Siparis bilgilerini alma rutini.... global $KDV,$red,$para_siniri,$sevkiyat_ucreti; Baglan(); $query = "SELECT mallar,fiyatlar FROM siparis WHERE sessionid = $sessionid;"; $result = mysql_query($query); $row = mysql_fetch_array($result); $mallar = $row["mallar"]; $mal = Desifre($mallar); $fiyatlar = $row["fiyatlar"]; $fiyat = Desifre($fiyatlar); while( list($SE,$quantity) = each($mal) ){ $whereclause.= "(SE_partno = '$SE') || "; } $whereclause = substr($whereclause,0,strlen($whereclause)-4); $query = "SELECT * FROM urun WHERE ".$whereclause.";"; $result = mysql_query($query); $body.= "Açıklama\t"; $body.= "Üretici\t"; $body.= "Üretici kodu\t"; $body.= "Sipariş miktarı\t"; $body.= "Mevcut miktar\t"; $body.= "Birim fiyat\t"; $body.= "Toplam Fiyat\t\n"; $noofrows = 5; while($row = mysql_fetch_array($result)){ $vendor = $row["uretici"]; $SE = $row["SE_partno"]; $aciklama = $row["aciklama"]; $uretici = $row["uretici"]; $kod = $row["uretici_kodu"]; $mevcut = $row["miktar"]; $quantity = $mal[$SE]; $toplam = $fiyat[$SE] * $quantity; $fiyat_preci = Yuvarla($fiyat[$SE]); $body.= "$aciklama\t"; $body.= "$uretici\t"; $body.= "$kod\t"; $body.= "$quantity\t"; $body.= "$mevcut\t"; $body.= "$fiyat_preci\t"; $toplam = Yuvarla($toplam); $body.= "$toplam\t"; $body.= "\n"; $ult_toplam += $toplam; } if($ult_toplam < $para_siniri){ $sevkiyat = Yuvarla($sevkiyat_ucreti); } $body.= "\n\nToplam: $ult_toplam\n\n"; $body.= "Sevkiyat: +$sevkiyat\n\n"; $ult_toplam += $sevkiyat; $add = Yuvarla($KDV * $ult_toplam); $ult_toplam += $add; $yuzde_KDV = $KDV * 100; $body.= "%$yuzde_KDV KDV: +$add\n"; $body.= "Net: $ult_toplam\n"; mysql_close(); if( mail($to,$subject,$body,$header) ){ Hata('mailgitmedi'); } } function SEMail($siparisno,$eposta,$sirket){ $to = "siparis@spektrumelektronik.com,gulbin@spektrumelektronik.com,sinan@turksanayi.com"; $header = "Content-Type: text/html; charset=windows-1254\r\n"; $header.= "From: siparis@spektrumelektronik.com\r\n"; $header.= "Reply-To: $eposta\r\n"; $subject = "Yeni Siparis: $sirket"; $body = "$n$n"; $body.= "Firma İsmi: $sirket$n$n"; $body.= "
$n"; mail($to,$subject,$body,$header); } function ShipmentBelirle($kod){ $query = "SELECT shipment FROM shipment WHERE kod = $kod;"; $result = mysql_query($query); $bilgi = mysql_fetch_row($result); return $bilgi[0]; } function PaymentBelirle($kod){ $query = "SELECT payment FROM payment WHERE kod = $kod;"; $result = mysql_query($query); $bilgi = mysql_fetch_row($result); return $bilgi[0]; } function TirnakYok($dizi){ while( list($no,$strng) = each($dizi) ){ $strng = str_replace("'","`",$strng); $dizi[$no] = str_replace("'","`",$dizi[$no]); } return $dizi; } function Yuvarla($num){ global $precision; return sprintf($precision,$num); } function Bocek($strng){ print "*** $strng ***

\n"; } // DB functions function DropTable($name){ $query = "DROP TABLE IF EXISTS $name;"; $result = mysql_query($query); return array("result"=>$result,"query"=>$query,"error"=>mysql_error(),"rows_affected"=>mysql_affected_rows($result)); } function ExportQuery($filename,$name){ global $dir,$field_term,$line_term; $filename = $dir."data/".$filename; $exportquery = "SELECT * FROM $name INTO OUTFILE '$filename'\n"; $exportquery .= $field_term.$line_term.";"; $result = mysql_query($exportquery); return array("result"=>$result,"query"=>$exportquery,"error"=>mysql_error()); } function ImportDataFromFile($filename,$table){ global $dir,$field_term,$line_term; $query = "SHOW COLUMNS FROM $table;"; $result = mysql_query($query); $fieldlist = "("; while($field_data = mysql_fetch_object($result)){ $fieldlist.= $field_data->Field.","; } $fieldlist = substr($fieldlist,0,strlen($fieldlist)-1).")"; $filename = $dir."data/".$filename; $importquery = "LOAD DATA LOCAL INFILE '$filename' REPLACE\n"; $importquery .= "INTO TABLE $table\n"; $importquery .= $field_term.$line_term."\n".$fieldlist.";"; $result = mysql_query($importquery); return array("result"=>$result,"query"=>$query,"error"=>mysql_error(),"rows_affected"=>mysql_affected_rows($result)); } function AddDataToTable($table,$data,$replace){ global $n,$close_query; $insert_query = "INSERT INTO $table VALUES(\n"; $replace_query = "REPLACE INTO $table VALUES(\n"; $query = "SHOW COLUMNS FROM $table;"; $result = mysql_query($query); while( $column_data = mysql_fetch_object($result) ){ if( stristr($column_data->Type,"char") || stristr($column_data->Type,"text") ){ $add[$column_data->Field] = "''"; } else{ $add[$column_data->Field] = "0"; } if($data[$column_data->Field] ){ $add[$column_data->Field] = $data[$column_data->Field]; } } if($replace){ $query = $replace_query; } else{ $query = $insert_query; } $query.= join(",", array_values($add) ); $query.= ");"; $result = mysql_query($query); return array("result"=>$result,"query"=>$query,"error"=>mysql_error(),"rows_affected"=>mysql_affected_rows($result)); } function UpdateTable($table,$data){ global $n,$close_query; $replace_query = "UPDATE $table SET\n"; $query = "SHOW COLUMNS FROM $table;"; $result = mysql_query($query); $query = "SHOW INDEX FROM $table;"; $otherresult = mysql_query($query); $kosul = ""; while($index_data = mysql_fetch_object($otherresult) ){ $kosul.= "($index_data->Column_name = ".$data[$index_data->Column_name].") || "; } $kosul = substr($kosul,0,strlen($kosul)-4); $query = $replace_query; while( list($key,$value) = each($data) ){ $query.= $key."=".$value.",\n"; } $query = substr($query, 0, strlen($query)-2); $query.= "\nWHERE ($kosul);"; $result = mysql_query($query); return array("result"=>$result,"query"=>$query,"error"=>mysql_error(),"rows_affected"=>mysql_affected_rows($result)); } function EditDataIn($table,$data){ // returns html code to edit data in table if($data){ $query = "SELECT * FROM $table WHERE ("; while( list($key,$value) = each($data) ){ $query.= "($key=$value) && "; } $query = substr($query,0,strlen($query)-4).");"; Bocek($query); } else{ $query = "SHOW FIELDS FROM $table;"; } $result = mysql_query($query); $return_body = " "; if($data){ $return_body.= " "; } else{ $return_body.= " "; } if($data){ $row = mysql_fetch_array($result); while( list($field,$value) = each($row) ){ if(!is_int($field) ){ $return_body.= "\n"; } } } else{ while( $row = mysql_fetch_object( $result ) ){ $return_body.= "\n"; } } $return_body.= "\n"; $return_body.= "\n
$field
$row->FieldField]\" size=40>
\n"; return $return_body; } function AddQuotes($tablename,$data){ // Adds single-quotes to string in an array if they are char or text in the table $query = "SHOW FIELDS FROM $tablename;"; $result = mysql_query($query); while( $row = mysql_fetch_object($result) ){ $fieldtype[$row->Field] = $row->Type; } while( list($key,$value) = each($data) ){ if( stristr($fieldtype[$key],"char") || stristr($fieldtype[$key],"text") ){ if(strcmp($value,"")==0){ $data[$key] = "''"; } else{ if(strcmp(substr($value,0,1),"'")!=0){ $value = "'$value"; } if(strcmp(substr($value,-1),"'")!=0){ $value = "$value'"; } $data[$key] =$value; } } } return $data; } function AlwaysAddQuotes($tablename,$data){ // Just as above exc. always adds quotes and does RFC1738 encoding $query = "SHOW FIELDS FROM $tablename;"; $result = mysql_query($query); while( $row = mysql_fetch_object($result) ){ $fieldtype[$row->Field] = $row->Type; } while( list($key,$value) = each($data) ){ if( stristr($fieldtype[$key],"char") || stristr($fieldtype[$key],"text") ){ $data[$key] = "'".strtr($value,"'","`")."'"; // Change existing quotes to ` and add quotes. } } return $data; } function SelectToArray($table,$fields,$kosul){ // returns 2d array containing values of the recordset if(is_array($fields)){ $fields = implode(",",$fields); } $query = "SELECT $fields FROM $table"; if($kosul){ $query.= " WHERE ($kosul);"; } else{ $query.= ";"; } $result = mysql_query($query); $i=0; while( $currentrow = mysql_fetch_array( $result ) ){ $row[$i] = $currentrow; $i++; } return $row; } function SelectFrom($table,$fields,$kosul){ // Select query if(is_array($fields)){ $fields = implode(",",$fields); } $query = "SELECT $fields FROM $table"; if($kosul){ $query.= " WHERE ($kosul);"; } else{ $query.= ";"; } $result = mysql_query($query); return array("result"=>$result,"query"=>$query,"error"=>mysql_error()); } function SelectRowFrom($table,$fields,$kosul){ // returns one row, array if(is_array($fields)){ $fields = implode(",",$fields); } $query = "SELECT $fields FROM $table"; if($kosul){ $query.= " WHERE ($kosul);"; } else{ $query.= ";"; } $result = mysql_query($query); return mysql_fetch_array($result); } function SelectObjectFrom($table,$fields,$kosul){ // returns one row, object if(is_array($fields)){ $fields = implode(",",$fields); } $query = "SELECT $fields FROM $table"; if($kosul){ $query.= " WHERE ($kosul);"; } else{ $query.= ";"; } $result = mysql_query($query); return mysql_fetch_object($result); } function GetLastNumber($table,$key){ $query = "SELECT MAX($key) AS $key FROM $table"; $result = mysql_query($query); list($lastno) = mysql_fetch_array($result); return $lastno; } ?>