Forum
Aktif konular
Üyeler
Kurallar
Arama
PHP Installer Yapımı PHP Installer Yapımı
-
merhaba arkadaşlar ilk defa installer yapıyorum ve takıldım kaldım. SQL dosyasını bir türlü import ettiremedim, hata veriyor. Dosyalar sırasıyla;
İndex.php dosyam;
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <style> body{ text-align: center; } #anatasiyici{ width: 430px; margin: 0 auto; } .bg{ background-image:url(bg.png); width:430px; height:510px; } #bilgiler{ padding-top:230px; padding-left:85px; color:#36F; } </style> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>WEB Installer v.1.0</title> </head> <body> <div id="anatasiyici"> <div class="bg"> <form id="bilgiler" method="post" action="?step=kur"> <table width="230" border="0"> <tr> <td width="58" height="37">DB Sunucu</td> <td width="126"><input type="text" name="host" value="localhost"/></td> </tr> <tr> <td height="43">DB adı</td> <td><input type="text" name="dbname" value="<?PHP echo $_POST['dbname']; ?>"/></td> </tr> <tr> <td height="42">DB K.adı</td> <td><input type="text" name="dbuser" value="<?PHP echo $_POST['dbuser']; ?>"/></td> </tr> <tr> <td height="43">DB Şifre</td> <td><input type="text" name="dbsifre" value="<?PHP echo $_POST['dbsifre']; ?>"/></td> </tr> <tr> <td height="43"> </td> <td align="right"><input type="submit" value="KURULUMA BAŞLA" /></td> </tr> </table> </form> </div> <?PHP switch($_GET['step']){ case "kur": $hostname = $_POST['host']; $dbname = $_POST['dbname']; $dbuser = $_POST['dbuser']; $dbsifre = $_POST['dbsifre']; $con = mysql_connect($hostname,$dbuser,$dbsifre); if (!$con) { die('Kullanıcı adı veya şifreniz hatalı.'); } // Create table mysql_select_db($dbname, $con); $path = ""; $sql_filename = "sorgular.sql"; $sql_contents = file_get_contents($path.$sql_filename); $sql_contents = explode("@@", $sql_contents); foreach($sql_contents as $query){ $result = mysql_query($query) or die("Database query failed: ".mysql_error()); } mysql_close($con); break; } ?> </div> </body> </html>sorgular.sql dosyam;
CREATE TABLE IF NOT EXISTS admin ( id int(11) NOT NULL AUTO_INCREMENT, kullanici_adi text NOT NULL, sifre text NOT NULL, yetki text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO admin VALUES(1, 'admin', '11112', '1'); CREATE TABLE IF NOT EXISTS haber_duyuru ( id int(11) NOT NULL AUTO_INCREMENT, baslik text NOT NULL, icerik text NOT NULL, icon text NOT NULL, tarih text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS hosgeldiniz ( id int(11) NOT NULL AUTO_INCREMENT, baslik text NOT NULL, icerik text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO hosgeldiniz VALUES(1, 'Aliquam dapibus tincidunt metus. Praesent justo dolor, lobortis quis, lobortis dignissim', 'YQ=='); CREATE TABLE IF NOT EXISTS markalar ( id int(11) NOT NULL AUTO_INCREMENT, ad text NOT NULL, logo text NOT NULL, link text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS neler_sunuyor ( id int(11) NOT NULL AUTO_INCREMENT, baslik text NOT NULL, icerik text NOT NULL, icon text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; INSERT INTO neler_sunuyor VALUES(1, 'Modern and Clean', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type.', 'dark-mapleleaf'); INSERT INTO neler_sunuyor VALUES(2, 'Powerful Admin Panel', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type.', 'dark-gear'); INSERT INTO neler_sunuyor VALUES(3, 'Custom Widgets', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard dummy text ever since the 1500s, when an unknown printer took a galley of type.', 'dark-recycle'); CREATE TABLE IF NOT EXISTS sayfalar ( id int(11) NOT NULL AUTO_INCREMENT, sayfa text NOT NULL, title text NOT NULL, icerik text NOT NULL, keyword text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; INSERT INTO sayfalar VALUES(1, 'hakkimizda', 'Hakkımızda', 'PHN0cm9uZyBzdHlsZT0ibWFyZ2luOiAwcHg7IHBhZGRpbmc6IDBweDsgY29sb3I6IHJnYigxMDMsIDEwNCwgODgpOyBmb250LWZhbWlseTogQXJpYWwsICdoZWx2ZXRpY2EgbmV1ZScsIEhlbHZldGljYSwgVmVyZGFuYSwgc2Fucy1zZXJpZjsgZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMTlweDsiPlRFTiBLT1pNRVTEsEs8L3N0cm9uZz48c3BhbiBzdHlsZT0iY29sb3I6IHJnYigxMDMsIDEwNCwgODgpOyBmb250LWZhbWlseTogQXJpYWwsICdoZWx2ZXRpY2EgbmV1ZScsIEhlbHZldGljYSwgVmVyZGFuYSwgc2Fucy1zZXJpZjsgZm9udC1zaXplOiAxM3B4OyBsaW5lLWhlaWdodDogMTlweDsiPiZuYnNwOzwvc3Bhbj48ZGl2PjxzcGFuIHN0eWxlPSJjb2xvcjogcmdiKDEwMywgMTA0LCA4OCk7IGZvbnQtZmFtaWx5OiBBcmlhbCwgJ2hlbHZldGljYSBuZXVlJywgSGVsdmV0aWNhLCBWZXJkYW5hLCBzYW5zLXNlcmlmOyBmb250LXNpemU6IDEzcHg7IGxpbmUtaGVpZ2h0OiAxOXB4OyI+UGVyZmVjdCBMYXNoZXMgxLBwZWsgS2lycGlrLCBTaWx2ZXJMaW5lIEthbMSxY8SxIE1ha3lhaiBDaWhhesSxLCBJY3VybCAtRWxsZWViYW5hIEtpcnBpayBQZXJtYXPEsSwgTmFpbCBQZXJmZWN0IFByb3RleiBUxLFybmFrJm5ic3A7IMO8csO8bmxlcmluaW4gaXRoYWxhdMSxbsSxIHYgZSBlxJ9pdGltaW5pIGdlcsOnZWtsZcWfdGlyaXIuIE3DvMWfdGVyaSBtZW1udW5peWV0aW5pbiBkZXZhbWzEsWzEscSfxLFuxLEgaWxrZSBlZGluZW4gZWtpYmltaXogVMO8cmtpeWUgZ2VuZWxpbmRlIG3DvMWfdGVyaWxlcmltaXplIGhpem1ldCB2ZXJtZWt0ZWRpci4gTcO8xZ90ZXJpIG9kYWtsxLEgw6fDtnrDvG1sZXIgc3VuYWJpbG1layB2ZSBQcm9qZW5pemkgaGF5YXRhIGdlw6dpcm1layBpw6dpbiwgdGVrbGlmIGHFn2FtYXPEsW5kYW4gYmHFn2xheWFyYWssIHNpemlubGUgZ2Vyw6dla2xlxZ90aXJlY2XEn2kgdG9wbGFudMSxbGFyxLFuYSB2ZSBwcm9qZW5pemluIGhheWF0YSBnZcOnZWNlxJ9pIGFuYSBrYWRhciwgaGVkZWZsZXJpbml6ZSB1bGHFn21hbsSxesSxIHNhxJ9sYXlhY2FrIHTDvG0gw6dhbMSxxZ9tYWxhcsSxIGthbGl0ZXlpIHZlIGVrb25vbWl5aSBiYXogYWxhcmFrIGLDvHnDvGsgYmlyIHRpdGl6bGlrbGUgZ2Vyw6dla2xlxZ90aXJpci48L3NwYW4+PC9kaXY+', 'a'); INSERT INTO sayfalar VALUES(2, 'urunler', 'Ürünler', 'Ürünlerin olduğu sayfa.', 'ürün sayfası'); INSERT INTO sayfalar VALUES(3, 'sorucevap', 'Soru & Cevap (SSS)', 'Soru cevapların yer aldığı sayfamız', 'a'); INSERT INTO sayfalar VALUES(4, 'diger', 'Diğer Sitelerimiz', 'PHVsPjxsaT48YiBzdHlsZT0ibGluZS1oZWlnaHQ6IDE5cHg7IGNvbG9yOiByZ2IoMTAzLCAxMDQsIDg4KTsgZm9udC1mYW1pbHk6IEFyaWFsLCAnaGVsdmV0aWNhIG5ldWUnLCBIZWx2ZXRpY2EsIFZlcmRhbmEsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogc21hbGw7Ij5EacSfZXIgc2l0ZWxlcjwvYj48L2xpPjxsaT48YiBzdHlsZT0ibGluZS1oZWlnaHQ6IDE5cHg7IGNvbG9yOiByZ2IoMTAzLCAxMDQsIDg4KTsgZm9udC1mYW1pbHk6IEFyaWFsLCAnaGVsdmV0aWNhIG5ldWUnLCBIZWx2ZXRpY2EsIFZlcmRhbmEsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogc21hbGw7Ij5IYWxsbzwvYj48L2xpPjxsaT48YiBzdHlsZT0ibGluZS1oZWlnaHQ6IDE5cHg7IGNvbG9yOiByZ2IoMTAzLCAxMDQsIDg4KTsgZm9udC1mYW1pbHk6IEFyaWFsLCAnaGVsdmV0aWNhIG5ldWUnLCBIZWx2ZXRpY2EsIFZlcmRhbmEsIHNhbnMtc2VyaWY7IGZvbnQtc2l6ZTogc21hbGw7Ij5NZXJoYWJhPC9iPjwvbGk+PC91bD4=', 'sitelerimiz, diğer sitelerimiz, kardeş siteler'); INSERT INTO sayfalar VALUES(5, 'iletisim', 'İletişim', '', ''); CREATE TABLE IF NOT EXISTS site_ayarlari ( logo text NOT NULL, email text NOT NULL, telefon text NOT NULL, facebook text NOT NULL, twitter text NOT NULL, youtube text NOT NULL, title text NOT NULL, keyword text NOT NULL, id int(11) NOT NULL AUTO_INCREMENT, aciklama text NOT NULL, adres text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO site_ayarlari VALUES('uploads/logo.png', 'satis@localhost', '+90(212) 455 55 55', 'a', 'a', 'a', 'a', 'a', 1, 'aaaaaa', '13/2 Elizabeth St, Melbourne VIC 3000, Australia'); CREATE TABLE IF NOT EXISTS site_tanitim ( id int(11) NOT NULL AUTO_INCREMENT, baslik text NOT NULL, icerik text NOT NULL, icon text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; INSERT INTO site_tanitim VALUES(1, 'KOLAY KULLANIM', 'Lorem Ipsum is simply dummy text of the printing and typesetting indus', 'statics'); INSERT INTO site_tanitim VALUES(2, 'UZUN ÖMÜR', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard', 'user'); INSERT INTO site_tanitim VALUES(3, 'SAĞLIKLI MALZEME', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry''s standard', 'sun'); CREATE TABLE IF NOT EXISTS slider ( id int(11) NOT NULL AUTO_INCREMENT, baslik text NOT NULL, altbaslik text NOT NULL, resim text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ; INSERT INTO slider VALUES(1, 'FRESH', 'Solutions', 'images/slider/nivo/slider-1.jpg'); INSERT INTO slider VALUES(7, 'SADECE', 'Bakış', 'uploads/slider-4.jpg'); CREATE TABLE IF NOT EXISTS sloganlar ( id int(11) NOT NULL AUTO_INCREMENT, slogan text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; INSERT INTO sloganlar VALUES(1, 'Süper !'); INSERT INTO sloganlar VALUES(2, 'Güzel !'); INSERT INTO sloganlar VALUES(3, 'Hoş !'); INSERT INTO sloganlar VALUES(4, 'Hmm !'); CREATE TABLE IF NOT EXISTS sorucevap ( id int(11) NOT NULL AUTO_INCREMENT, soru text NOT NULL, cevap text NOT NULL, onay text NOT NULL, tarih text NOT NULL, adsoyad text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; INSERT INTO sorucevap VALUES(1, 'çıkarsa ne olur ?', 'Okey olur', '1', '13 Nis. 2013', 'Tuğba Ekinci'); CREATE TABLE IF NOT EXISTS urunler ( id int(11) NOT NULL AUTO_INCREMENT, resim text NOT NULL, ad text NOT NULL, aciklama text NOT NULL, keyword text NOT NULL, tarih text NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; INSERT INTO urunler VALUES(6, 'uploads/logo.png', 'Frame & Light Box 2', 'RnVzY2UgZXVpc21vZCBjb25zZXF1YXQgYW50ZS4gTG9yZW0gaXBzdW0gZG9sb3Igc2l0IGFtZXQsIGNvbnNlY3RldHVlciBhZGlwaXNjaW5nIGVsaXRlbGxlbnRlc3F1ZSBzZWQgZG9sb3IuIEFsaXF1YW0gY29uZ3VlIGZlcm1lbnR1bSBuaXNsLiBNYXVyaXMgYWNjdW1zYW4gbnVsbGEgdmVsIGRpYW0uIFNlZCBpbiBsYWN1cyB1dCBlbmltIGFkaXBpc2NpbmcgYWxpcXVldC4gTnVsbGEgdmVuZW5hdGlzLiBJbiBwZWRlIG1pLCBhbGlxdWV0IHNpdCBhbWV0ZXVpc21vZCBpbiwgYXVjdG9yIHV0LCBsaWd1bGEuIEFsaXF1YW0gZGFwaWJ1cyB0aW5jaWR1bnQgbWV0dXMuIFByYWVzZW50IGp1c3RvIGRvbG9yLCBsb2JvcnRpcy4=', 'a', '16/04/2013'); INSERT INTO urunler VALUES(7, 'uploads/14075922.png', 'aa', 'YWFh', 'a', ''); INSERT INTO urunler VALUES(8, 'uploads/14075922.png', 'aaaaaaaa', 'YWFhYWE=', 'aaaa', ''); INSERT INTO urunler VALUES(9, 'uploads/IMG_0457.JPG', 'fgfhgfhgf', 'Z2ZoZmdoZ2ZoZ2Zo', 'fghgfhgfhfh', ''); INSERT INTO urunler VALUES(10, 'uploads/807-IMG_0457.JPG', 'qwe23423', 'MjM0MjM0', '234234', ''); -
vermiş olduğu hata
Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO admin VALUES(1, 'admin', '11112', '1'); CREATE TABLE IF NOT EXIST' at line 9
-
INSERT INTO admin VALUES(1, 'admin', '11112', '1');bunu
INSERT INTO admin VALUES('1', 'admin', '11112', '1'); şöyle yazıp dener misin hocam ? Baştaki 1'i tırnak içine al. -
şöyle dene
INSERTINTOadminVALUES('null','admin','11112','1'); -
her ikisinide denedim olmadı arkadaşlar, sanırım sorun şu tam olarak satır atlamıyor. yani mesela ben sadece en baştaki creati bıraktığımda sql dosyasında oluşturuyor. 2. satıra ne yazarsam yazayım hata veriyor
-
hocam "@@" işaretine göre delimiter yapmışın ama o delimiterı nerde kullandın sql dosyasında kullanmış görünmüyorsun ?
-
hocam harikasın :) delimiteri ";" yapınca hallettim :)
-
gamesbug bunu yazdı
hocam harikasın :) delimiteri ";" yapınca hallettim :)
halletmene sevindim hocam :D insanın gözünden kaçabiliyor bazen.
Kısayol
Şikayet
Özel Mesaj
Alıntı yap
Toplam Hit: 903 Toplam Mesaj: 8
Cevapla