\n"; //NewLine
if($urunimport){
$dbname = '/opt2/iiplaza/html/siparis/data/urun.txt';
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
$query = "DROP TABLE IF EXISTS urun;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE urun(\n";
$query.= "SE_partno CHAR(50) NOT NULL,\n";
$query.= "uretici_kodu CHAR(30),\n";
$query.= "aciklama CHAR(100),\n";
$query.= "uretici CHAR(40),\n";
$query.= "miktar INT(7) UNSIGNED,\n";
$query.= "birimfiyat1 FLOAT(10,4) UNSIGNED,\n";
$query.= "birimfiyat2 FLOAT(10,4) UNSIGNED,\n";
$query.= "birimfiyat3 FLOAT(10,4) UNSIGNED,\n";
$query.= "birimfiyat4 FLOAT(10,4) UNSIGNED,\n";
$query.= "birimfiyat5 FLOAT(10,4) UNSIGNED,\n";
$query.= "birimfiyat6 FLOAT(10,4) UNSIGNED,\n";
$query.= "birimfiyat7 FLOAT(10,4) UNSIGNED,\n";
$query.= "ayrintilibilgi INT(10),\n";
$query.= "resim INT(10),\n";
$query.= "kategori CHAR(20),\n";
$query.= "miktarfiyattipi TINYINT(1),\n";
$query.= "PRIMARY KEY (SE_partno));";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$importquery = "LOAD DATA LOCAL INFILE '$dbname' REPLACE\n";
$importquery .= "INTO TABLE urun\n";
$importquery .= "FIELDS TERMINATED BY '\\t'\n";
$importquery .= "LINES TERMINATED BY '\\n'\n";
$importquery .= "(SE_partno,uretici_kodu,aciklama,uretici,miktar,birimfiyat1,birimfiyat2,birimfiyat3,birimfiyat4,birimfiyat5,birimfiyat6,birimfiyat7,ayrintilibilgi,resim,kategori,miktarfiyattipi);";
$result = mysql_query($importquery);
print "$importquery";
print "$n*** $result ***$n$n$n";
}
elseif($musteriimport){
$dbname = '/opt2/iiplaza/html/siparis/data/musteri.txt';
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
$query = "DROP TABLE IF EXISTS musteri;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE musteri(\n";
$query.= "kod INT(10) UNSIGNED NOT NULL,\n";
$query.= "sirket CHAR(50),\n";
$query.= "kontak CHAR(50),\n";
$query.= "adres1 CHAR(255),\n";
$query.= "adres2 CHAR(255),\n";
$query.= "semt CHAR(50),\n";
$query.= "sehir CHAR(50),\n";
$query.= "pk CHAR(10),\n";
$query.= "tel CHAR(20),\n";
$query.= "faks CHAR(20),\n";
$query.= "eposta CHAR(100),\n";
$query.= "VD CHAR(50),\n";
$query.= "VDno CHAR(15),\n";
$query.= "talimat TEXT,\n";
$query.= "shipop TINYINT(2) UNSIGNED,\n";
$query.= "payop TINYINT(1) UNSIGNED,\n";
$query.= "cari CHAR(10),\n";
$query.= "PRIMARY KEY (kod));";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$importquery = "LOAD DATA LOCAL INFILE '$dbname' REPLACE\n";
$importquery .= "INTO TABLE musteri\n";
$importquery .= "FIELDS TERMINATED BY '\\t'\n";
$importquery .= "LINES TERMINATED BY '\\n'\n";
$importquery .= "(kod,sirket,kontak,adres1,adres2,semt,sehir,pk,tel,faks,eposta,VD,VDno,talimat,shipop,payop,cari);";
$result = mysql_query($importquery);
print "$importquery";
print "$n*** $result ***$n$n$n";
}
elseif($createorderdb){
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
if($arsiv){
$name = "arsiv";
}
else{
$name = "siparis";
}
$query = "DROP TABLE IF EXISTS $name;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE $name(\n";
if($arsiv){$query.="orderno INT(10) UNSIGNED NOT NULL,\n";}
$query.= "sessionid INT(10) UNSIGNED NOT NULL,\n";
$query.= "firmakod INT(10),\n";
$query.= "sirket CHAR(50),\n";
$query.= "kontak CHAR(50),\n";
$query.= "adres1 CHAR(255),\n";
$query.= "adres2 CHAR(255),\n";
$query.= "semt CHAR(50),\n";
$query.= "sehir CHAR(50),\n";
$query.= "pk CHAR(10),\n";
$query.= "tel CHAR(20),\n";
$query.= "faks CHAR(20),\n";
$query.= "eposta CHAR(100),\n";
$query.= "VD CHAR(50),\n";
$query.= "VDno CHAR(15),\n";
$query.= "mallar TEXT,\n";
$query.= "fiyatlar TEXT,\n";
if(!$arsiv){$query.= "verildi TINYINT(1),\n";}
$query.= "tarih INT(10),\n";
$query.= "notlar TEXT,\n";
$query.= "talimatlar TEXT,\n";
$query.= "shipop TINYINT(1),\n";
$query.= "payop TINYINT(1),\n";
if(!$arsiv){$query.= "ccno CHAR(25),\n";}
if($arsiv){
$query.= "PRIMARY KEY (orderno));";
}
else{
$query.= "PRIMARY KEY (sessionid));";
}
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
}
elseif($fiyatimport){
$dbname = '/opt2/iiplaza/html/siparis/data/fiyat.txt';
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
$query = "DROP TABLE IF EXISTS fiyat;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE fiyat(\n";
$query.= "tip TINYINT(1) UNSIGNED NOT NULL,\n";
$query.= "miktar1 INT(10),\n";
$query.= "miktar2 INT(10),\n";
$query.= "miktar3 INT(10),\n";
$query.= "miktar4 INT(10),\n";
$query.= "miktar5 INT(10),\n";
$query.= "miktar6 INT(10),\n";
$query.= "miktar7 INT(10),\n";
$query.= "PRIMARY KEY (tip));";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$importquery = "LOAD DATA LOCAL INFILE '$dbname' REPLACE\n";
$importquery .= "INTO TABLE fiyat\n";
$importquery .= "FIELDS TERMINATED BY '\\t'\n";
$importquery .= "LINES TERMINATED BY '\\n'\n";
$importquery .= "(tip,miktar1,miktar2,miktar3,miktar4,miktar5,miktar6,miktar7);";
$result = mysql_query($importquery);
print "$importquery";
print "$n*** $result ***$n$n$n";
}
elseif($shipmentimport){
$dbname = '/opt2/iiplaza/html/siparis/data/shipment.txt';
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
$query = "DROP TABLE IF EXISTS shipment;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE shipment(\n";
$query.= "kod TINYINT(1) UNSIGNED NOT NULL,\n";
$query.= "shipment CHAR(255),\n";
$query.= "PRIMARY KEY (kod));";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$importquery = "LOAD DATA LOCAL INFILE '$dbname' REPLACE\n";
$importquery .= "INTO TABLE shipment\n";
$importquery .= "FIELDS TERMINATED BY '\\t'\n";
$importquery .= "LINES TERMINATED BY '\\n'\n";
$importquery .= "(kod,shipment);";
$result = mysql_query($importquery);
print "$importquery";
print "$n*** $result ***$n$n$n";
}
elseif($paymentimport){
$dbname = '/opt2/iiplaza/html/siparis/data/payment.txt';
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
$query = "DROP TABLE IF EXISTS payment;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE payment(\n";
$query.= "kod TINYINT(1) UNSIGNED NOT NULL,\n";
$query.= "payment CHAR(255),\n";
$query.= "PRIMARY KEY (kod));";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$importquery = "LOAD DATA LOCAL INFILE '$dbname' REPLACE\n";
$importquery .= "INTO TABLE payment\n";
$importquery .= "FIELDS TERMINATED BY '\\t'\n";
$importquery .= "LINES TERMINATED BY '\\n'\n";
$importquery .= "(kod,payment);";
$result = mysql_query($importquery);
print "$importquery";
print "$n*** $result ***$n$n$n";
}
elseif($aciklamaimport){
$dbname = '/opt2/iiplaza/html/siparis/data/aciklama.txt';
$db = 'iiplaza';
$server = 'localhost';
$username = 'iiplaza';
$password = 'pan-6539';
$mydb = mysql_connect($server,$username,$password);
$selectResult = mysql_select_db($db,$mydb);
$query = "DROP TABLE IF EXISTS aciklama;";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$query = "CREATE TABLE aciklama(\n";
$query.= "kod INT(10) UNSIGNED NOT NULL,\n";
$query.= "aciklama TEXT,\n";
$query.= "PRIMARY KEY (kod));";
$result = mysql_query($query);
print "$query";
print "$n*** $result ***$n$n$n";
$importquery = "LOAD DATA LOCAL INFILE '$dbname' REPLACE\n";
$importquery .= "INTO TABLE aciklama\n";
$importquery .= "FIELDS TERMINATED BY '\\t'\n";
$importquery .= "LINES TERMINATED BY '\\n'\n";
$importquery .= "(kod,aciklama);";
$result = mysql_query($importquery);
print "$importquery";
print "$n*** $result ***$n$n$n";
}
else{
?>