tag:blogger.com,1999:blog-55532626458990352202024-03-19T06:05:17.400-07:00Sümeyye TopçuAnonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-5553262645899035220.post-17830375381902319602015-07-10T00:12:00.001-07:002015-07-10T01:12:46.534-07:00phpMyAdmin,MySql ve Veritabanı Oluşturma<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;">PhpMyadmin,Php dilinde yazılmış Mysql veritabanında ki işlemlerimizi görsel olarak yapmamızı sağlayan bir sistemdir.PhpMyadmin ile;</span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;"><br /></span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;">-Veritabanı açılabilir.</span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;"><br /></span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;">-Kullanıcılar tanımlanabilir.</span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;"><br /></span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;">-Tablolar oluşturulabilir.Ve tablolara veri eklenip silinebilir.</span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;"><br /></span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;">Ve buna benzer birçok işlem yapılabilir</span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;"><br /></span></span></div>
<div style="color: #222222; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px;">
<span style="font-family: Tahoma, sans-serif;"><span style="background-color: white; font-size: x-small;"><br /></span></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-family: Tahoma, sans-serif;">Daha önce <a href="http://elifnurispirli.blogspot.com.tr/2015/07/wampserver-kurulumu.html" style="color: #888888; text-decoration: none;">Wampserver</a> kurulumunu anlatmıştım.Şimdi wampsever'e tıklayarak aktif hale getiriyoruz.Görev çubuğunda simge oluşacak simgeye tıklayın çıkan seçeneklerden phpMyAdmin'i seçin.Aşağıdaki pencere açılıyor.</span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-family: Tahoma, sans-serif;"><br /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-family: Tahoma, sans-serif;"><br /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white;"> <img height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZy54hhjfzysMo9SRbsLlpHsURXxQL4sMmw5EcZnFk-IHawDY-WFBF-F_hKIAiNPUZvc2sapkNghtQ-OpIrE8_0AHgk-gF15LqMH047P8bTUQ9XJKy-VhQKOhO0KKUo8zyxDTI7KuA1Ag/s400/Ads%25C4%25B1z.png" width="400" /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white;"><br /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-size: 15.3999996185303px; line-height: 21.5599994659424px; text-align: center;"> Daha sonra veritabanlarına tıklayarak yeni bir veni bir veri tabanı oluşturun.</span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white;"> <img height="112" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi_74Mg5uSKr49Vqlj_LZ462d1OYTy8yk4xpj0TK1NWHRYvKixH-eL6Bd61S-M8RbfeBD6Wep_bkLKX2RHN_OPKFkARS48qeWY9dRKhqe66oTVxiJK8rOZmdROBObsZGliVufuCfke12ow/s400/ads%25C4%25B1z2.png" width="400" /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white;"><br /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-family: 'Times New Roman', serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">Veritabanımız oluştuktan sonra sol taraftaki menüde gözükecektir.Tablo işlemlerini yapmak için üzerine tıklıyoruz.</span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white;"> <img height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhc0DQvDHXPQy49KoSC3722Vb-mXGyO5uM_sx7RIMzDef_OheLNsgdBXkoKzopkckvpoqdePMAQGfoVSrrCiT0Wrx5QJwHR-E560cNXVC5UokAFguSenLfFTbAMhcxBg867KI5oCgCuoYk/s400/Ads%25C4%25B1z3.png" width="400" /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-size: 15.3999996185303px; line-height: 21.5599994659424px; text-align: center;"> Tablomuzun adını ve sütun sayısını belirledikten sonra devam ediyoruz</span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white;"> <img height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo06H-CB1KuOKeDalCL1VTXPyt6w92fxsAIsazSfctdzgvvzGV66qi_p-2VE7ff6ZZgWfHEh7YH4hO0crauvR6AIGZRJaeALPTEo8Eek_wPOUKIuB5soWhzyWv6wmwUjCe0434yyPiNAs/s400/Ads%25C4%25B1z4.png" width="400" /></span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 18.2000007629395px;">
<span style="background-color: white; font-size: 15.3999996185303px; line-height: 21.5599994659424px; text-align: center;"> Şekildeki gibi sutünları size uygun biçimde doldurun.Veri tabanınız kullanıma hazır ..</span></div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-25999510992932518952015-07-09T03:48:00.000-07:002015-07-09T04:00:37.918-07:00PHP ile MySQL bağlantısı kurmak<h3 class="post-title entry-title" itemprop="name" style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 24px; font-stretch: normal; font-weight: normal; margin: 0.75em 0px 0px; position: relative;">
<span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;">Veritabanı sunucusuna bağlandıktan sonra hangi veritabanını kullanılmak isteniyorsa o veritabanı seçilir. Bundan sonra da veritabanı kullanılabilir.</span></h3>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
<span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;"><br /></span><span style="background-color: white; color: #373737; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;">İl</span><span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;">k önce MySQL veritabanı sunucusu bağlantısı yapılır:</span><br />
<span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;">MySQL veritabanı sunucusuna bağlanmak için </span><strong style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">mysql_connect()</strong><span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;"> fonksiyonu kullanılabilir.</span><strong style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">mysql_connect()</strong><span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;"> fonksiyonu MySQL sunucusuna yeni bir bağlantı kurar veya var olan bağlantıyı tekrar kullanır.</span><br />
<br />
<span style="background-color: white; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px;">Kullanımı </span><strong style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #666666;">mysql_connect(SunucuAdi, KullaniciAdi, Sifre, YeniBaglanti);</span></strong><br />
<strong style="background-color: white; border: 0px; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 24.375px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: #666666;"><br /></span></strong><span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b>Aşağıdaki kod yazıp kaydettikten sonra bağlantı kurlmuş oluyor.</b></span></span></div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
<span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b><br /></b></span></span></div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
<span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b></b></span></span><br />
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
<span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b><?php</b></span></span></div>
<span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b>
</b></span></span>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
<span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b>$host="127.0.0.1";//host değişkenimize attığımız ip adresi</b></span></span></div>
<span style="font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 24.375px;"><b>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
$user = "root";//Kullanıcı adını root ismini verdik</div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
$pass = "";//Şifre kısmını boş(null) bırakıyoruz</div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
$vt=mysql_connect($host,$user,$pass,"Bağlantı");</div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
if($vt)</div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
echo "Bağlantı Kuruldu (1)";</div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
else </div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
echo "Bağlantı Kurulamadı (0)";</div>
<div class="post-body entry-content" id="post-body-7869936002614251189" itemprop="description articleBody" style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 1.4; position: relative; width: 570px;">
?></div>
</b></span></span></div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-9079620050203989172015-07-08T04:05:00.003-07:002015-07-08T04:05:48.830-07:00MYSQL GİRİŞ<h2 style="background-color: white; color: #990000; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 13px; font-stretch: normal; margin: 0.5em 0px; position: relative; text-transform: uppercase;">
<br /></h2>
<span style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;">MySQL, altı milyondan fazla sistemde yüklü bulunan çoklu iş parçacıklı (multi-threaded), çok kullanıcılı (multi-user), hızlı ve sağlam (robust) bir veritabanı yönetim sistemidir.</span><br style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;" /><br style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;" /><span style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;">UNIX, OS/2 ve Windows platformları için ücretsiz dağıtılmakla birlikte ticari lisans kullanmak isteyenler için de ücretli bir lisans seçeneği de mevcuttur. Kaynak kodu açık olan MySQL'in pek çok platform için çalıştırılabilir ikilik kod halindeki indirilebilir sürümleri de mevcuttur. Ayrıca ODBC sürücüleri de bulunduğu için birçok geliştirme platformunda rahatlıkla kullanılabilir. Geliştiricileri, 500'den fazlası 100 milyon üzeri kayıt içeren 10.000 tablodan oluşan kendi veritabanlarını (200 terabyte civarında veri) MySQL'de tuttuklarını söylüyorlar.</span><br style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;" /><br style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;" /><span style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;">MySQL, tuttuğu tablolarla çok kullanıcılı sistemlerde söz konusu olan erişim hakları sorununu başarılı bir şekilde çözmektedir. MySQL'in 4.0 sürümü ile birlikte "transaction" desteği, 4.1 sürümüyle birlikte de alt sorgu desteği eklenmiştir. Bugün ise MySQL 5.0 ve 6.0 sürümlerinin isimlerini çok daha sık duymaktayız.</span><br style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;" /><br style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;" /><span style="background-color: white; color: #990000; font-family: 'Times New Roman', Times, FreeSerif, serif; font-size: 15.8400001525879px; line-height: 22.1760005950928px;">Ayrıca "veri tutarlılığını (referential integrity)" sağlama işinin programcıya bırakılması tercih edilmiştir, ancak bu bir dezavantaj olarak görülmeyebilir. Çünkü pek çok veritabanı programcısı VTYS'lerdeki veri tutarlılığı'nın esnek olmayan, zorlayıcı bir özellik olduğunu düşünmektedir.</span>Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-85260112178224473972015-07-08T01:15:00.000-07:002015-07-10T01:20:51.459-07:00MYSQL'de CASE, IF, IFNULL, NULLIF KULLANIMI<span style="color: #cc0000;">CASE</span><br />
<span style="color: #cc0000;"><br /></span>
MYSQL 'de bazı yerlerde (örneğin select işleminde seçilecek değer için )koşul kullanılabilir. CASE deyimi bu işlem için kullanabiliriz.<br />
<br />
KULLANIM ŞEKLİ:<br />
<br />
<div style="background: #EDF7FF; border: solid #CCE5EA 1.5pt; mso-element: para-border-div; padding: 8.0pt 0cm 8.0pt 8.0pt;">
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #993333; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">SELECT</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"> alan1</span></b><b><span style="color: #66cc66; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">,</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"> alan2</span></b><b><span style="color: #66cc66; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">,</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">CASE alan3<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">WHEN </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'deger1'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"> THEN </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'deger1a'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">WHEN </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'deger2'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"> THEN </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'deger2a'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">WHEN </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'deger3'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"> THEN </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'deger3a'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">ELSE </span></b><b><span style="color: red; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">'ön tanımlı değer'</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"><o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">END<o:p></o:p></span></b></div>
<div class="MsoNormal" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; margin-bottom: 0.0001pt; padding: 0cm;">
<b><span style="color: #993333; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;">FROM</span></b><b><span style="color: #6e6e6e; font-family: "Courier New"; font-size: 10.5pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: TR;"> tablo<o:p></o:p></span></b></div>
</div>
<br />
<div class="MsoNormal">
<o:p> örnekle açıklayalım:</o:p></div>
<div class="MsoNormal">
<o:p><br /></o:p></div>
<div class="MsoNormal">
<o:p><b>ÖĞRENCİ TABLOSU</b></o:p></div>
<div class="MsoNormal">
<o:p><b><br /></b></o:p></div>
<div>
<br /></div>
<div>
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="background-color: #fff9ee; border-collapse: collapse; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 21.5599994659424px; width: 630px;"><tbody>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">ad<o:p></o:p></span></b></div>
</td><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">soyad<o:p></o:p></span></b></div>
</td><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">bolumId<o:p></o:p></span></b></div>
</td><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">bolumAdi<o:p></o:p></span></b></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Mehmet<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Durmaz<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">1<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Bilgisayar Öğretmenliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ahmet<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Yıkılmaz<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">1<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Bilgisayar Öğretmenliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ayşe<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<i><span style="border: 1pt none windowtext; font-family: Arial, sans-serif; font-size: 7.5pt; padding: 0cm;">NULL</span></i><span style="font-family: Arial, sans-serif; font-size: 7.5pt;"><o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">2<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Fizik Öğretmenliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Melek<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Tunc<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">2<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Fizik Öğretmenliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Seher<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ay<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">5<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Biyokimya Mühendisliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Şakir<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Yok<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">4<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Kimya Öğretmenliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Abbas<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Kırmızı<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">3<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Fizik Bölümü<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ayşe<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Pekmez<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">2<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Fizik Öğretmenliği<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Mert<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Günaydın<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">5<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="font-size: 15.3999996185303px; line-height: 21.5599994659424px; margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Biyokimya Mühendisliği</span></div>
<div>
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;"><br /></span></div>
</td></tr>
</tbody></table>
</div>
Bu örneğimizde bölüm değerlerine göre bölüm adlarını yazdıracağız.<br />
<br />
<b><br /></b>
<b><br /></b>
<b><br /></b>
<br />
<div style="background-color: #fff9ee; font-size: 15.3999996185303px;">
<div class="line number1 index0 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php comments" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; clear: both; color: rgb(0, 130, 0) !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">//Ekrana gelecek sutunlerı belirledik</code></div>
<div class="line number2 index1 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">SELECT ad,soyad,bolumId,</code><code class="php keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">case</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">bolumId</code></div>
<div class="line number3 index2 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
</div>
<div class="line number4 index3 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
</div>
<div class="line number5 index4 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php comments" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; clear: both; color: rgb(0, 130, 0) !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">//bolumId si değerine göre gelecek yeni değerleri belirledik</code></div>
<div class="line number6 index5 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">When </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'1'</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">then </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'Bilgisayar Öğretmenliği'</code></div>
<div class="line number7 index6 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">When </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'2'</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">then </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'Fizik Öğretmenliği'</code></div>
<div class="line number8 index7 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">When </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'3'</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">then </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'Fizik Bölümü'</code></div>
<div class="line number9 index8 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">When </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'4'</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">then </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'Kimya Öğretmenliği'</code></div>
<div class="line number10 index9 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">When </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'5'</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">then </code><code class="php string" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: blue !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">'Biyokimya Mühendisliği'</code></div>
<div class="line number11 index10 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
</div>
<div class="line number12 index11 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
</div>
<div class="line number13 index12 alt2" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php comments" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; clear: both; color: rgb(0, 130, 0) !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">//yeni değerlerin sütun ismini bolumAdi olarak değiştirdik</code></div>
<div class="line number14 index13 alt1" style="background-attachment: initial !important; background-clip: initial !important; background-color: white !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: #b9b9b9; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.3999996185303px; height: auto !important; left: auto !important; letter-spacing: 0.200000002980232px; line-height: 15.8399991989136px; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px 1em !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; white-space: pre !important; width: auto !important;">
<code class="php functions" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: rgb(255, 20, 147) !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">end</code> <code class="php keyword" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: rgb(0, 102, 153) !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; font-weight: bold !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">as</code> <code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;">bolumAdi from ogrenci</code></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; line-height: 21.5599994659424px;">
<code class="php plain" style="background: none !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; color: black !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><br /></code></div>
<div style="font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; line-height: 21.5599994659424px;">
<code class="php plain" style="background-attachment: initial !important; background-clip: initial !important; background-color: initial !important; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-image-outset: initial !important; border-image-repeat: initial !important; border-image-slice: initial !important; border-image-source: initial !important; border-image-width: initial !important; border-radius: 0px !important; border: 0px !important; bottom: auto !important; box-sizing: content-box !important; float: none !important; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; font-size: 1em !important; height: auto !important; left: auto !important; line-height: 1.1em !important; margin: 0px !important; min-height: inherit !important; outline: 0px !important; overflow: visible !important; padding: 0px !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important;"><span style="color: red;">IF_ ELSE</span></code></div>
<div>
<span style="font-family: Consolas, Bitstream Vera Sans Mono, Courier New, Courier, monospace;"><span style="line-height: 16.939998626709px;">IF kullanımı basit bir koşul ifadesidir.</span></span></div>
<div>
<span style="font-family: Consolas, Bitstream Vera Sans Mono, Courier New, Courier, monospace;"><span style="line-height: 16.939998626709px;"><br /></span></span></div>
<div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Verdana, sans-serif;">Kullanım Şekli:</span></div>
<div style="color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<div style="background: rgb(237, 247, 255); border: 1.5pt solid rgb(204, 229, 234); padding: 8pt 0cm 8pt 8pt;">
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #993333; font-size: 10.5pt;">SELECT</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"> <o:p></o:p></span></b></pre>
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #6e6e6e; font-size: 10.5pt;">IF </span></b><b><span style="color: red; font-size: 10.5pt;">'kosul_ifadesi'</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"> THEN </span></b><b><span style="color: red; font-size: 10.5pt;">'komutlar1'</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"><o:p></o:p></span></b></pre>
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #6e6e6e; font-size: 10.5pt;">ELSEIF </span></b><b><span style="color: red; font-size: 10.5pt;">'kosul_ifadesi'</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"> THEN </span></b><b><span style="color: red; font-size: 10.5pt;">'komutlar2'</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"><o:p></o:p></span></b></pre>
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #6e6e6e; font-size: 10.5pt;">ELSE </span></b><b><span style="color: red; font-size: 10.5pt;">'komutlar3'</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"><o:p></o:p></span></b></pre>
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #6e6e6e; font-size: 10.5pt;">END IF<o:p></o:p></span></b></pre>
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #993333; font-size: 10.5pt;">FROM</span></b><b><span style="color: #6e6e6e; font-size: 10.5pt;"> tablo</span></b></pre>
<pre style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: none; line-height: 15pt; padding: 0cm;"><b><span style="color: #6e6e6e; font-size: 10.5pt;">
</span></b></pre>
</div>
</div>
</div>
</div>
<div style="background-color: #fff9ee; color: #222222; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Örnekle açıklayalım;</span></div>
<div style="background-color: #fff9ee; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Arial, Helvetica, sans-serif;">Örnekle açıklayalım;</span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<table border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="border-collapse: collapse; width: 442px;"><tbody>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">ad<o:p></o:p></span></b></div>
</td><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">soyad<o:p></o:p></span></b></div>
</td><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div align="center" class="MsoNormal" style="margin-bottom: 0.0001pt; text-align: center;">
<b><span style="font-family: Arial, sans-serif; font-size: 10.5pt;">notu<o:p></o:p></span></b></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Mehmet<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Durmaz<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">45<o:p></o:p></span></div>
</td></tr>
<tr style="height: 10.05pt;"><td style="background: rgb(229, 229, 229); border: 1pt solid black; height: 10.05pt; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ahmet<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; height: 10.05pt; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Yıkılmaz<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; height: 10.05pt; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">58<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ayşe<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<i><span style="border: 1pt none windowtext; font-family: Arial, sans-serif; font-size: 7.5pt; padding: 0cm;">NULL</span></i><span style="font-family: Arial, sans-serif; font-size: 7.5pt;"><o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<i><span style="border: 1pt none windowtext; font-family: Arial, sans-serif; font-size: 7.5pt; padding: 0cm;">65<o:p></o:p></span></i></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Melek<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Tunc<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">18<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Seher<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ay<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">92<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Şakir<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Yok<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">85<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Abbas<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Kırmızı<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">62<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: rgb(229, 229, 229); border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Ayşe<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Pekmez<o:p></o:p></span></div>
</td><td style="background: rgb(229, 229, 229); border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">55<o:p></o:p></span></div>
</td></tr>
<tr><td style="background: white; border: 1pt solid black; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Mert<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 5.25pt;"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">Günaydın<o:p></o:p></span></div>
</td><td style="background: white; border-bottom-color: black; border-bottom-width: 1pt; border-right-color: black; border-right-width: 1pt; border-style: none solid solid none; padding: 0cm; width: 69.6pt;" valign="top" width="93"><div class="MsoNormal" style="margin-bottom: 0.0001pt;">
<span style="font-family: Arial, sans-serif; font-size: 7.5pt;">38</span></div>
</td></tr>
</tbody></table>
Bu örneğimizde notu 60 dan yüksek olan öğrencilere geçti düşüklere kaldı yazıyoruz.</div>
<div style="font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
SELECT AD , SOYAD</div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
IF(NOTU>=60,"GEÇTİ","KALDI")</div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
AS SONUÇ</div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
FROM ÖĞRENCİ</div>
<div style="font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="color: red;">IF NULL</span></div>
<div style="font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
ıfnull kullanımı içinde verilen iki değer için eğer ilk değer(boş)null değilse sonuca ilk değeri, boş ise sonuca ikinci değeri döndürür. ıfnull sonuca bir string yada integer değerleri döndürür.</div>
<div style="font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;">Kullanım Şekli:</span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<br /></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<table class="crayon-table" style="background-attachment: initial !important; background-clip: initial !important; background-color: ghostwhite; background-image: none !important; background-origin: initial !important; background-position: initial !important; background-repeat: initial !important; background-size: initial !important; border-collapse: collapse !important; border-spacing: 0px !important; border: none !important; color: #1e1e1e; font-family: Consolas, ConsolasRegular, 'Courier New', monospace; font-size: 12px; line-height: 15px; margin-bottom: 0px !important; margin-left: 0px; margin-right: 0px !important; margin-top: 0px !important; padding: 0px !important; table-layout: auto !important; vertical-align: baseline; width: auto !important;"><tbody style="border: 0px; margin: 0px; padding: 0px; vertical-align: baseline;">
<tr class="crayon-row" style="background: 0px 50%; border: none !important; margin: 0px !important; padding: 0px !important; vertical-align: top !important;"><td class="crayon-nums " data-settings="show" style="background-attachment: initial; background-clip: initial; background-color: rgb(238, 238, 238) !important; background-image: initial; background-origin: initial; background-position: 0px 50%; background-repeat: initial; background-size: initial; border: 0px; margin: 0px !important; padding: 0px !important; vertical-align: top !important;"><div class="crayon-nums-content" style="background: 0px 50%; border: 0px; margin: 0px; padding-bottom: 3px !important; padding-left: 0px; padding-right: 0px; padding-top: 5px !important; vertical-align: baseline; white-space: nowrap;">
<div class="crayon-num" data-line="crayon-55962eb05ef9b097394148-1" style="background: 0px 50%; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(222, 222, 222) !important; border-right-style: solid !important; border-right-width: 1px !important; border-top-width: 0px; color: rgb(170, 170, 170) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; min-width: 1.2em !important; padding: 0px 5px; text-align: right !important; vertical-align: baseline;">
1</div>
<div class="crayon-num crayon-striped-num" data-line="crayon-55962eb05ef9b097394148-2" style="background: 0px 50%; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(222, 222, 222) !important; border-right-style: solid !important; border-right-width: 1px !important; border-top-width: 0px; color: rgb(170, 170, 170) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; min-width: 1.2em !important; padding: 0px 5px; text-align: right !important; vertical-align: baseline;">
2</div>
<div class="crayon-num" data-line="crayon-55962eb05ef9b097394148-3" style="background: 0px 50%; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(222, 222, 222) !important; border-right-style: solid !important; border-right-width: 1px !important; border-top-width: 0px; color: rgb(170, 170, 170) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; min-width: 1.2em !important; padding: 0px 5px; text-align: right !important; vertical-align: baseline;">
3</div>
<div class="crayon-num crayon-striped-num" data-line="crayon-55962eb05ef9b097394148-4" style="background: 0px 50%; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(222, 222, 222) !important; border-right-style: solid !important; border-right-width: 1px !important; border-top-width: 0px; color: rgb(170, 170, 170) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; min-width: 1.2em !important; padding: 0px 5px; text-align: right !important; vertical-align: baseline;">
4</div>
<div class="crayon-num" data-line="crayon-55962eb05ef9b097394148-5" style="background: 0px 50%; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(222, 222, 222) !important; border-right-style: solid !important; border-right-width: 1px !important; border-top-width: 0px; color: rgb(170, 170, 170) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; min-width: 1.2em !important; padding: 0px 5px; text-align: right !important; vertical-align: baseline;">
5</div>
</div>
</td><td class="crayon-code" style="background: 0px 50%; border: 0px; margin: 0px !important; padding: 0px !important; vertical-align: top !important; width: 651px;"><div class="crayon-pre" style="background: none !important; border: none !important; color: black; margin: 0px; overflow: visible; padding-bottom: 3px !important; padding-left: 0px; padding-right: 0px; padding-top: 5px !important; tab-size: 4; vertical-align: baseline; white-space: pre;">
<div class="crayon-line" id="crayon-55962eb05ef9b097394148-1" style="background: 0px 50%; border: 0px; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;">
<span class="crayon-k" style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span class="crayon-h" style="border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">IFNULL</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-cn" style="border: 0px; color: rgb(0, 153, 153) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-cn" style="border: 0px; color: rgb(0, 153, 153) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">0</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="crayon-h" style="border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-c" style="border: 0px; color: rgb(153, 153, 153) !important; font-family: inherit; font-size: inherit !important; font-style: italic !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">-- returns 1</span></div>
<div class="crayon-line crayon-striped-line" id="crayon-55962eb05ef9b097394148-2" style="background: 0px 50%; border: 0px; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;">
</div>
<div class="crayon-line" id="crayon-55962eb05ef9b097394148-3" style="background: 0px 50%; border: 0px; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;">
<span class="crayon-k" style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span class="crayon-h" style="border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">IFNULL</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-s" style="border: 0px; color: rgb(221, 17, 68) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">''</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-cn" style="border: 0px; color: rgb(0, 153, 153) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">1</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="crayon-h" style="border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-c" style="border: 0px; color: rgb(153, 153, 153) !important; font-family: inherit; font-size: inherit !important; font-style: italic !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">-- returns ''</span></div>
<div class="crayon-line crayon-striped-line" id="crayon-55962eb05ef9b097394148-4" style="background: 0px 50%; border: 0px; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;">
</div>
<div class="crayon-line" id="crayon-55962eb05ef9b097394148-5" style="background: 0px 50%; border: 0px; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px 5px; vertical-align: baseline;">
<span class="crayon-k" style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">SELECT</span><span class="crayon-h" style="border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-e" style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">IFNULL</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">(</span><span class="crayon-k " style="border: 0px; color: teal !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">NULL</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">,</span><span class="crayon-s" style="border: 0px; color: rgb(221, 17, 68) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">'IFNULL function'</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">)</span><span class="crayon-sy" style="border: 0px; color: rgb(51, 51, 51) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">;</span><span class="crayon-h" style="border: 0px; color: rgb(0, 111, 224) !important; font-family: inherit; font-size: inherit !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;"> </span><span class="crayon-c" style="border: 0px; color: rgb(153, 153, 153) !important; font-family: inherit; font-size: inherit !important; font-style: italic !important; font-weight: inherit !important; height: inherit; line-height: inherit !important; margin: 0px; padding: 0px; vertical-align: baseline;">--</span></div>
</div>
</td></tr>
</tbody></table>
</div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white; font-size: 14.8500003814697px; line-height: 20.7900009155273px;">Örnekler;</span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span class="keyword" style="background-color: white; border: none; color: #006699; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; font-weight: 700; line-height: 18px; margin: 0px; padding: 0px;">SELECT</span><span style="background-color: white; border: none; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px;"> IFNULL(1,2); </span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; border: none; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px;"><br /></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Consolas, 'Courier New', Courier, mono, serif;"><span style="background-color: white; font-size: 14px; line-height: 18px;">SONUÇ:1</span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Consolas, 'Courier New', Courier, mono, serif;"><span style="background-color: white; font-size: 14px; line-height: 18px;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<ol class="dp-sql" style="background-color: white; border: none; color: #5c5c5c; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px 0px 1px 45px !important; padding: 0px;">
<li class="alt" style="border-left-color: rgb(0, 63, 127); border-left-width: 3px; border-style: none none none solid; color: inherit; list-style: decimal-leading-zero outside; margin: 0px !important; padding: 0px 3px 0px 10px !important;"><span style="background-color: inherit; border: none; color: black; margin: 0px; padding: 0px;"><span class="keyword" style="background-color: inherit; border: none; color: #006699; font-weight: 700; margin: 0px; padding: 0px;">SELECT</span><span style="background-color: inherit; border: none; margin: 0px; padding: 0px;"> IFNULL(</span><span class="op" style="background-color: inherit; border: none; color: grey; margin: 0px; padding: 0px;">NULL</span><span style="background-color: inherit; border: none; margin: 0px; padding: 0px;">,2); </span></span><span style="background-color: inherit; color: black;"> </span></li>
</ol>
</div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<br /></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Verdana, sans-serif; font-size: xx-small;">SONUÇ:2</span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
<h3 style="color: #222222; margin: 0px; position: relative;">
<span style="color: red; font-family: Arial, Helvetica, sans-serif; font-size: x-small;"><span style="background-color: white; line-height: 20.7900009155273px;">NULLIF</span></span></h3>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;">Nullif koşul ifadesinde eğer içinde verilen iki değer eşit ise boş(null) değerini değil ise ilk değeri değer sütunumuza döndürecektir.</span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="background-color: white; color: #333333; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="color: #333333; font-family: Verdana, sans-serif;"><span style="background-color: white; font-size: 14.8500003814697px; line-height: 20.7900009155273px;">Kullanım Şekli:</span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="color: #333333; font-family: Verdana, sans-serif;"><span style="background-color: white; font-size: 14.8500003814697px; line-height: 20.7900009155273px;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<div class="MsoNormal" style="background: rgb(244, 247, 249); line-height: 18pt; margin-bottom: 15pt; word-break: break-all;">
<span style="color: #298ae5; font-family: Helvetica, sans-serif; font-size: 12pt;">NULLIF(ifade1, ifade2);</span></div>
</div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white; line-height: 20.7900009155273px;">Örnekler:</span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<span style="font-family: Verdana, sans-serif;"><span style="background-color: white; line-height: 20.7900009155273px;"><br /></span></span></div>
<div style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;">
<ol class="dp-sql" style="background-color: white; border: none; color: #5c5c5c; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px 0px 1px 45px !important; padding: 0px;">
<li class="alt" style="border-left-color: rgb(0, 63, 127); border-left-width: 3px; border-style: none none none solid; color: inherit; list-style: decimal-leading-zero outside; margin: 0px !important; padding: 0px 3px 0px 10px !important;"><span style="background-color: inherit; border: none; color: black; margin: 0px; padding: 0px;"><span class="keyword" style="background-color: inherit; border: none; color: #006699; font-weight: 700; margin: 0px; padding: 0px;">SELECT</span><span style="background-color: inherit; border: none; margin: 0px; padding: 0px;"> </span><span class="func" style="background-color: inherit; border: none; color: deeppink; margin: 0px; padding: 0px;">NULLIF</span><span style="background-color: inherit; border: none; margin: 0px; padding: 0px;">(2,2);</span></span><span style="background-color: inherit; color: black;"> </span></li>
</ol>
</div>
<br style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;" />
<span style="color: #222222; font-family: Verdana, sans-serif; font-size: xx-small;">SONUÇ:NULL</span><br />
<span style="color: #222222; font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span><span style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;"></span><span style="color: #222222; font-family: Verdana, sans-serif; font-size: xx-small;"><br /></span><span style="color: #222222; font-size: 15.3999996185303px; line-height: 21.5599994659424px;"></span><span class="keyword" style="background-color: white; border: none; color: #006699; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; font-weight: 700; line-height: 18px; margin: 0px; padding: 0px;">SELECT</span><span style="background-color: white; border: none; color: #222222; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px;"> </span><span class="func" style="background-color: white; border: none; color: deeppink; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px;">NULLIF</span><span style="background-color: white; border: none; color: #222222; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 14px; line-height: 18px; margin: 0px; padding: 0px;">(2,3); </span></div>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-76794577218104815892015-07-03T00:44:00.000-07:002015-07-10T01:26:49.992-07:00Php MY Admin'de Veritabanı KurulumuGeçen yazılımda php my admine bağlandık. şimdi veri tabanı oluşturucaz kırmızı çerçeve içerisine alınan veri tabanları sekmesine tıklıyoruz.<br />
<br />
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<img border="0" height="356" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZy54hhjfzysMo9SRbsLlpHsURXxQL4sMmw5EcZnFk-IHawDY-WFBF-F_hKIAiNPUZvc2sapkNghtQ-OpIrE8_0AHgk-gF15LqMH047P8bTUQ9XJKy-VhQKOhO0KKUo8zyxDTI7KuA1Ag/s640/Ads%25C4%25B1z.png" width="640" /></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;">Aşağıda gördüğünüz gibi bir ekran sizi karşılayacak.Yeni veritabanı oluştur yazan bölüme veritabınımızın ismini yazıyoruz.</span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;"><img border="0" height="143" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4tJpvl5d60QnrzqzTd1SX3A3gdCGrd7xZBI0__BNYocisnxv-AfuOKA3JwLc4uwvZQC0Eakzb3pveMjxz2Woqx9-gc32BBuF2sL8WnJtDWriLFIauLxqnxewXyv5LxPkHECsv4PBoIXNz/s1600/3.png" style="-webkit-border-image: url(data:image/png; border: none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; outline: none; padding: 8px;" width="508" /></span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;">Oluştur butonuna tıkladığımızda aşağıdaki gibi işlemin doğru gerçekleştiğini bildiren bir uyarı göreceksiniz.</span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<img border="0" height="73" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFDU3lvPKs-Yjs70KbVA0nWFLa58Lg4YeYbSuSahwI9XC-mYTRC7waRU1h3BI8OM8ik-i9Bvo6Ke5vqdd-2rva83QZhlNrlH23PvPhzm8v9_3H7sSOc6uDh2u1CDC9I3DRIRd1-glDWils/s1600/4.png" style="-webkit-border-image: url(data:image/png; border: none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; outline: none; padding: 8px;" width="361" /></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;">Veritabanımız oluştuktan sonra sol taraftaki menüde gözükecektir.Tablo işlemlerini yapmak için üzerine tıklıyoruz.</span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe7d666twxOebk7aaD70zgcwZrXqjBvpEVA8HuHyICDik-hFbdfnmBLFIHUssdrA41AyDS6R-5siAY0jyVgm-OwQG9QBBgAfTOILX0CAVC2ODHk2hUWu745iRCTJGav-QETkdG020xGfsV/s1600/5.png" style="-webkit-transition: color 0.3s; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; outline: none; text-decoration: none; transition: color 0.3s;"><span style="font-family: 'Times New Roman', serif;"><span style="color: black;"><img border="0" height="467" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhe7d666twxOebk7aaD70zgcwZrXqjBvpEVA8HuHyICDik-hFbdfnmBLFIHUssdrA41AyDS6R-5siAY0jyVgm-OwQG9QBBgAfTOILX0CAVC2ODHk2hUWu745iRCTJGav-QETkdG020xGfsV/s1600/5.png" style="-webkit-border-image: url(data:image/png; border: none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; outline: none; padding: 8px; position: relative;" width="421" /></span></span></a></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;">Açılan sayfada adı yazan bölüme veritabanında oluşturacağımız tablonun adını ve sütün sayısını giriyoruz.Daha sonraki uygulamalarda bu veritabanını kullanacağımız için resimdeki gibi doldurmanızı tavsiye ederim.Daha sonraki bireysel çalışmalarınızda isteğinize göre düzenleyebilirsiniz.</span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;"><img border="0" height="309" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiBAiMzYMbnZWtfD7OphzhklBf_g5aYRxiRZqdUzVNDwSISwSlvjoj9yiMFITSasbK-8b3NWS5tHD3cfc7nGhpi_bu8a8OnM9-rKrKPOXI9s-DutR84q6CXsGP5G9KGBvX1KEPEh16_llel/s1600/7.png" style="-webkit-border-image: url(data:image/png; border: none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; outline: none; padding: 8px;" width="452" /></span></div>
<div style="background-color: white; color: #333333; font-family: Arial, Helvetica, sans-serif; font-size: 14px; line-height: 18.2000007629395px; margin: 0px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: 'Times New Roman', serif;">Son olarak yukarıdaki gibi bir sayfa bizi karşılayacak.Kırmızı çerçeveli alandaki bölümlerin herbiri tablonun sutunlarını ifade etmektedir.Basit olarak veritabanı oluşturmayı anlattım.</span></div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-31530370227915397582015-07-03T00:31:00.000-07:002015-07-03T00:31:00.933-07:00Php'de Mysql ile Veritabanından Veri Çekme<br /><div class="article-content entry-content" itemprop="articleBody" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 1.4; margin: 10px auto 5px; outline: none; padding: 0px; text-align: justify;">
<span style="font-family: Arial; font-size: 13px; line-height: 18.2000007629395px;">PHP ile MySQL bağlantısı kurma ve veri ekleme işlemlerini anlatmıştım. Bu yazıda MySQL veritabanından veri çekmeyi anlatıyorum.</span><br /><span style="font-family: Arial; font-size: 13px; line-height: 18.2000007629395px;">İçinde dersler bulunan ders adında bir tablomuz olsun. Tablomuzun içeriği aşağıdaki gibidir.</span><br /><div class="separator" style="clear: both; margin: 0px; outline: none; padding: 0px; text-align: center;">
<span style="margin-left: 1em; margin-right: 1em;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic8RwRKnpw49MXs1zbknG8NDLthSA-Vj1y0tB5UkTKWlHVcnVxgzNYsBm6Aw1SUGk5Nh4k7tcAifwEemLJK9yaolzMbdomuusPjP3fvJSQMwtA4qOFdVranbpvtyMEbVX7bK_v5EOvjfep/s1600/tablo.jpg" imageanchor="1" style="-webkit-transition: color 0.3s; color: #b38f00; display: inline; margin-left: 1em; margin-right: 1em; outline: none; text-decoration: none; transition: color 0.3s;"><img border="0" height="286" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic8RwRKnpw49MXs1zbknG8NDLthSA-Vj1y0tB5UkTKWlHVcnVxgzNYsBm6Aw1SUGk5Nh4k7tcAifwEemLJK9yaolzMbdomuusPjP3fvJSQMwtA4qOFdVranbpvtyMEbVX7bK_v5EOvjfep/s400/tablo.jpg" style="-webkit-border-image: url(data:image/png; border-image-repeat: stretch; border-image-slice: 9; border-image-source: url(data:image/png; border-image-width: 9px; border: 9px none; box-sizing: border-box; display: inline-block; height: auto; margin: 10px auto; max-width: 100%; padding: 8px; position: relative;" width="400" /></a></span></div>
<div class="separator" style="clear: both; margin: 0px; outline: none; padding: 0px; text-align: center;">
<br /></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
Aşağıdaki kod ile verileri çekiyorum.<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<?php<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
error_reporting(0);<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
$host = "127.0.0.1";<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
$user = "root";<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
$sifre = "";<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
$db = @mysql_connect( $host, $user, $sifre, "kullanicilar") or die ("HATA : " . mysql_error()); @mysql_select_db("kullanicilar",$db);<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
if($db)<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
echo 1;<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
else<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
echo 2;<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
$sorgu = mysql_query("select * from kullanici ");<o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
while($yazdir=mysql_fetch_array($sorgu))<o:p></o:p></div>
<div class="separator" style="clear: both; margin: 0px; outline: none; padding: 0px;">
</div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
{ echo "Bilgi".$yazdir[0].$yazdir[1].$yazdir[2].$yazdir[3]."<br>"; } ?></div>
</div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-39279263067634953952015-07-03T00:26:00.003-07:002015-07-03T00:26:49.635-07:00Kontrol Akış fonksiyonları<br /><div class="article-content entry-content" itemprop="articleBody" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 1.4; margin: 10px auto 5px; outline: none; padding: 0px; text-align: justify;">
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<b><u><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;">Case Operatörü</span><o:p></o:p></u></b></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<b><u><span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;"><br /></span></u></b></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<span style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;">Sql cümlelerimiz içinde belirli durumlara göre farklı işlemler yapmak istiyorsak Case-When yapısını kullanabiliriz.</span><o:p></o:p></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<br /><ul style="margin: 0.5em 0px; outline: none; padding: 0px 0px 0px 2em;">
<li style="margin: 0px; outline: none; padding: 0px;"><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;"><b>Select ders.kredi, ders.dadi, case kredi when '3' then "dersin kredisi" end as kredi_no from ders</b></span></li>
</ul>
</div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;">Bu Sql kodunda kredi sütununda değeri 3 olanlara kredi_no adında yeni bir sütun oluşturup dersin kredisi yazdıracaktır.</span></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<b><u><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;"><br /></span></u></b></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<b><u><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;">If Operatörü<o:p></o:p></span></u></b></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<b><u><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;"><br /></span></u></b></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;">If-Else koşul ifadelerimiz çoğu yazılım dilinde kullanıldığı gibi burada da aynı mantıkta çalışır. Case ile aynı mantığa sahiptir.<o:p></o:p></span></div>
<div class="MsoNormal" style="margin: 0px; outline: none; padding: 0px;">
<br /><ul style="margin: 0.5em 0px; outline: none; padding: 0px 0px 0px 2em;">
<li style="margin: 0px; outline: none; padding: 0px;"><span style="font-family: 'Times New Roman', serif; font-size: 12pt; line-height: 18.3999996185303px;"><b>SELECT ders.kredi,ders.dadi, IF(kredi='3',"kredili ders","dersin kredisi") AS ders_kredisi FROM ders</b></span></li>
</ul>
</div>
</div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-22513612276679950832015-07-03T00:25:00.002-07:002015-07-09T01:46:44.430-07:00MYSQL Operatörler<br />
<br />
<div class="article-content entry-content" itemprop="articleBody" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 14px; line-height: 1.4; margin: 10px auto 5px; outline: none; padding: 0px; text-align: justify;">
<table align="left" border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-collapse: collapse; border: none; color: #444444; font-family: Georgia, Utopia, 'Palatino Linotype', Palatino, serif; font-size: 13px; line-height: 18.2000007629395px; margin-left: 4.8pt; margin-right: 4.8pt; width: 500px;"><tbody>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div align="center" class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px; text-align: center;">
<b><span style="font-size: 14pt;">İSİM<o:p></o:p></span></b></div>
</td><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div align="center" class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px; text-align: center;">
<b><span style="font-size: 14pt;">TANIM<o:p></o:p></span></b></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
AND,&&<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Mantıksal VE<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
=<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Bir değer atamada (UPDATE işlemleri gibi.)<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
: =<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Bir değer atamada karşılaştırma işlemlerinde.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
BETWEEN x AND y<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
X ve Y arasındaki değerleri belirler.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
BINARY<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Sayıların ikilik sayı sistemine göre işlem yapılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
&<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
İki bit bloğundaki tüm bitleri sırasıyla VE bağlacı ile işleme sokmak için kullanılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
~<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Sayının binary değerinin tersini alır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
|<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
İki bit bloğundaki tüm bitleri sırasıyla VEYA bağlacı ile işleme sokmak için kullanılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
^<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen karakterlerden olmayacak şekilde bir tek harf yerine kullanılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
CASE<br />
<ul style="line-height: 1.4; margin: 0.5em 0px; outline: none; padding: 0px 2.5em;"></ul>
</div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Kosula göre işlem yapma<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
DIV<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Tamsayı bölme.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
/<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Bölme operatörü<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
< = ><o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Eşitlik karşılaştırma yapar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
=<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen değere eşit olanlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
>=<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen değerden büyük veya eşit olanlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
><o:p> </o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen değerden büyük olanlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
IS NOT NULL<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Null değerine sahip olmayanları tanımlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
IS NOT<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Doğru, yanlış veya bilinmeyen değerlerin değiline karşı mantıksal değer sunar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
IS NULL<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen alanların NULL olanlarını seçmek için kullanılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
IS<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Doğru, yanlış veya bilinmeyen değere karşı mantıksal değer sunar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
<<<o:p> </o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Bir bit bloğu üzerinde sola kaydırma işlemi o blok üzerindeki tüm bitler sol pozisyona geçer.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
<=<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen değerden küçük veya eşit olanlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
<<o:p> </o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen değerden küçük olanlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
LIKE<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirli bir kalıba uygun olan bilgileri seçmek için kullanılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
-<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Çıkarma operatörü<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
% or MOD<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Herhangi bir yazı yerine geçer.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
NOT BETWEEN x AND y<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
X ve Y arasında olmayan değerleri belirler.Yani X’ten küçük Y’den büyük değerler.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
! =,<><o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirtilen değere eşit olmayanlar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
NOT LIKE<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Belirli bir kalıba uygun ifade olan bilgileri seçmek için kullanılır.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
NOT REGEXP<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Komples sözdizimine sahip olmayan ifadeleri bulmak için kullanılan bir tekniktir.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
NOT, !<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Mantıksal DEĞİL<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
||,OR<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Mantıksal VEYA<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
+<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Toplama operatörü<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
REGEXP<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Komples sözdizimine sahip ifadeleri bulmak için kullanılan bir tekniktir.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
>><o:p> </o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Bir bit bloğu üzerinde sağa kaydırma işlemi o blok üzerindeki tüm bitler bir sağ pozisyona geçer.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
RLIKE<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
REGEXP ile aynı işleve sahip.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
SOUNDS LIKE<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Sese göre arama yapar.<o:p></o:p></div>
</td></tr>
<tr style="height: 14.9pt;"><td style="border: 1pt solid windowtext; height: 14.9pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
*<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.9pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Çarpma opera<o:p></o:p></div>
</td></tr>
<tr style="height: 14.05pt;"><td style="border: 1pt solid windowtext; height: 14.05pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
_<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 14.05pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Bir tek karakter yerine geçer.<o:p></o:p></div>
</td></tr>
<tr style="height: 15.75pt;"><td style="border: 1pt solid windowtext; height: 15.75pt; padding: 0cm 5.4pt; width: 98.5pt;" valign="top" width="131"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
XOR<o:p></o:p></div>
</td><td style="border-bottom-color: windowtext; border-bottom-width: 1pt; border-right-color: windowtext; border-right-width: 1pt; border-style: none solid solid none; height: 15.75pt; padding: 0cm 5.4pt; width: 368.3pt;" valign="top" width="491"><div class="MsoNormal" style="margin: 0px 0px 0.0001pt; outline: none; padding: 0px;">
Özel VEYA DEĞİL</div>
</td></tr>
</tbody></table>
</div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-25911619136503902412015-07-02T05:30:00.002-07:002015-07-02T05:30:37.677-07:00PDO veri tabanına bağlanma<span style="color: #444444; font-family: Georgia, Utopia, Palatino Linotype, Palatino, serif;"><span style="background-color: white; font-size: 13px; line-height: 18.2000007629395px;">Bağlantılar temel sınıfının örneklenmesiyle kurulur. hangi sürücüyü kulanacağınızın bir önemi yoktur;daimapdo sınıf ismini kullanmamız gerekir.</span></span><div>
<span style="color: #444444; font-family: Georgia, Utopia, Palatino Linotype, Palatino, serif;"><span style="background-color: white; font-size: 13px; line-height: 18.2000007629395px;">veri tabanı kaynağını ve isteğe bağlı olarak kullanıcı ismini ve parolasını belirtmek için kurucuyu kullanabiliriz.</span></span></div>
<div>
<span style="color: #444444; font-family: Georgia, Utopia, Palatino Linotype, Palatino, serif;"><span style="background-color: white; font-size: 13px; line-height: 18.2000007629395px;">şimdi veri tabanımıza bağlanıp ekrana mesaj yazdıralım.</span></span></div>
<div>
<span style="color: #444444; font-family: Georgia, Utopia, Palatino Linotype, Palatino, serif;"><span style="background-color: white; font-size: 13px; line-height: 18.2000007629395px;"><br /></span></span></div>
<div>
<span style="color: #444444; font-family: Georgia, Utopia, Palatino Linotype, Palatino, serif;"><span style="background-color: white; font-size: 13px; line-height: 18.2000007629395px;"><br /></span></span></div>
<div>
<span style="background-color: white; font-size: 13px; line-height: 18.2000007629395px;"><span style="color: #444444; font-family: Georgia, Utopia, Palatino Linotype, Palatino, serif;"><div>
<?php</div>
<div>
echo"selam dünya!";</div>
<div>
$user="root";</div>
<div>
$pass="";</div>
<div>
$db=new PDO('mysql:host=127.0.0.1;dbname=atauni',$user,$pass);</div>
<div>
?></div>
<div>
echo:ekrana yazdırılacak mesaj</div>
<div>
$user:veri tabanı kullanıcı adı</div>
<div>
$pass:veri tabanı şifresi</div>
<div>
120.0.0.1:yerel sunucu ıp adresi(standartdır.)</div>
<div>
dbname:veri tabanı ismi</div>
</span></span></div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-9776245050462828452015-07-02T04:47:00.003-07:002015-07-02T04:47:42.168-07:00MYSQL ‘DE BAZI FONKSİYONLARmysql_connect():PHP ile MYSQL veri tabanına bir kullanıcı adı ve parola ile bağlanmamızı sağlar.<br />
mysql_select_db():Bir veri tabanı sunucusunda bize ait birden fazla veri tabanı kaydı olacağından hangisi ile bağlanıp çalışacağımızı seçmemiz gerekir. Bu fonksiyonu kullandığımızda istediğimiz veri tabanını seçiyoruz.<br />
mysql_error():Veri tabanına bağlantı yaptıktan sonra biz istediğimiz sürece hata yerlerini göstermez.<br />
kısacası hata varsa görüntüler.<br />
mysql_query():Veri tabanı ve veri tabanına bağlı bütün tablolar üzerinde SQL sorgularını çalıştırır.<br />
Bu fonksiyonunu kullanabilmek için ilk önce mysql_connect()fonksiyonu ile mysql sunucusuna bağlantı kurulmuş olması gerekir.mysql_query() sunucusu başarılı olup olmamasına göre true veya false olarak döndürür.<br />
mysql_affected_rows():select(insert,delete,update) işlemleri için,mysql_query()sorgusunda dönem toplam sonuç sayısı bu fonksiyon ile yönetilir.<br />
mysql_fetch_array():sorgudan dönen sonuçları dizi değişkeni olarak alır.<br />
mysql_fetch_object():sorgudan dönen sonuç satırını nesne olarak alır.<br />
mysql _close:Bağlantı kapatmak için kullanılır.<br />
create:Bilgisayarda tutulan verilerin, kontrol edilmesi,erişilmesi,kullanılması.<br />
İF:Koşul koşmak.<br />
ELSE:Eğer.<br />
Echo:PHP de ekrana yazdırma komutudur.<br />
İnsert İnto:sql de veri tabanına kayıt eklemek için kullanılır.<br />
Up date.Tablodaki veriyi güncelleme.<br />
DELETE:Tablodaki veriyi silme.<br />
SELECT:Tablo seçmek.<br />
Primary*key:Bir tabloda bir sütunu eşsiz değer yapmaya yarar.<br />
<br />Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-29694662615525435632015-07-02T00:45:00.001-07:002015-07-02T00:45:47.780-07:00SQL Kodları ile veritabanı oluşturma,tablo oluşturma,veri ekleme,veri güncelleme,veri silme işlemleri<b><u>VERİ TABANI OLUŞTURMA</u></b><br /><div>
<u><br /></u></div>
<div>
Sql kodu ile veri tabanı oluşturmak için create database komutu kullanılmaktadır.</div>
<div>
Kullanımı:</div>
<div>
create database deneme</div>
<div>
Yukarıdaki sql kod ile deneme isimli sir veri tabanı oluşturduk.</div>
<div>
<br /></div>
<div>
<b><u>TABLO OLUŞTURMA</u></b></div>
<div>
<u><br /></u></div>
<div>
Aşağıdaki SQL kodları sql ekranına yazdırıp çalıştırıldığı zaman öğrenci adında bir tablo oluşturulur ve bu tablonun sütunları ogr_no, Adı, Soy adı olarak tanımlanmış olur.</div>
<div>
<br /></div>
<div>
CREATE TABLE ogrenci (</div>
<div>
ogr_no INT,</div>
<div>
Adi VARCHAR(15),</div>
<div>
Soy adi VARCHAR(15))</div>
<div>
<br /></div>
<div>
<b><u>VERİ EKLEME</u></b></div>
<div>
<u><br /></u></div>
<div>
Bir tabloya yeni veri eklemek için INSERT deyimi kullanılır.INSERT deyimi, INTO ve VALUES ifadeleriyle birlikte kullanılır ve tabloya yeni veri eklemesi sağlanır.</div>
<div>
Tablodaki tüm alanlara değer girilecekse, tablo isminden sonra sütun isimlerinin belirtilmesine gerek yoktur. Çünkü bu tür durumda tablodaki tüm alanlara veri girişi sağlanmış olacaktır.</div>
<div>
<br /></div>
<div>
Az önce oluşturduğumuz tabloya şu şekilde veri ekleyebiliriz:</div>
<div>
INSERT INTO ogrenci(ogr_no,adi, soyadi) values ('134415000','unal','kaplan')</div>
<div>
<br /></div>
<div>
<b><u>VERİ GÜNCELLEME</u></b></div>
<div>
Belirtilen tablodaki alanların değerlerini belirtiren ölçütlere göre değişmek için bir güncelleme sorgusu oluşturmak gerekir.Bunun için UPDATE DEYİMİ KULLANILIR.</div>
<div>
Az önce oluşturduğumuz verinin ismini değiştirelim:</div>
<div>
<br /></div>
<div>
UPDATE ogrenci SET adi ='sümeyye' WHERE ogr_ no =134415000</div>
<div>
<b><u>VERİ SİLME</u></b></div>
<div>
Bir tabloda bulunan kayıt veya kayıtların istenildiği zaman silinmesi mümkündür.</div>
<div>
tablolarda silme işlemi gerçekleştirmek için DELETE komutu kullanılır.DELETE komutu kullanırken FROM eki ile birlikte tablo ismi yazılarak hangi tablodan veri silinmesi istenildiği belirtilebilir.WHERE deyimi ile de verilerin silinme koşulu belirlenir.</div>
<div>
Eğer WHERE ifadesi ile bir koşul belirlenmezse tablodaki tüm kayıtlar silineceğinden WHERE kullanmaya dikkat edilmesi gerekmektedir.</div>
<div>
<br /></div>
<div>
DELETE FROM ogrenci WHERE ogr_no='134415000'</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<br /></div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-18571244574679940332015-07-01T01:13:00.001-07:002015-07-09T04:00:30.969-07:00JOİNLERİN KULLANIMI<div style="text-align: justify;">
İlk önce iki tane tablomuz olsun bunlar:</div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<img height="195" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVQddDpyj4IULpwer3FBHNFQNVxv7TY-A2voFn0yla4G26I8pr3MzYAFFMyz3kp7N2wxdGi7v9OY5Oz9bej8mS7zhmjTAuYac3vt-1V2Nr-zIGqPgGSn-CNtf8WZgAk62MQqW_sTzZ0yk/s400/1.JPG" width="400" /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: center;">
1.tablo(tablo adi:öğrenci)</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<img height="70" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSRyR33I4M7CYIB_66OJzBhwEySdfQ_lA2h4me7pAp-wMi-0sTnv4p_A9Ar8zXk4D22YWIql2AzfnsG3fNldgWuB_hdZs3Zhe6uCmVArXpL7rWj44zXxn1vGMbOnch89qKW8zNJaAIlGU/s400/2.JPG" width="400" /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
<br /></div>
<div style="text-align: center;">
2.tablo(tablo adi :bölüm)</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
INNER JOIN:iki tablonun kesişimini döndürür.</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
SELECT *FROM bölüm INNER JOIN öğrenci ön bölüm.bid=öğrenci.bid</div>
<div style="text-align: left;">
<img height="132" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7dYRGnOPR3RWAZSJZLPig4u-K9SwTgJiZ7R3seZ_PgV3eroNOyQY-cwYnyCZj0EteuFTNdAOZVd-jr8ULjgUR4i0ux0O7DJ0iTPpuhbZbjYO-RUVE5nLHME24XUl3OQptjQtFYdN_PLc/s400/3+innerjoin.JPG" width="400" /></div>
<div style="text-align: center;">
INNER JOIN EKRAN ÇIKTISI</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
(Tabloda bidler eşit olanları yazdırdı.Eğer hiç bölüme kayıtlı öğrenci olsaydı onu tablomuda görüntülemeyekti.)</div>
<div style="text-align: left;">
LEFT JOIN:Bir tablodaki tüm kayıtlar ile tablodaki birleştirme koşulunu sağlayan kayıtları döndürmek istersek left join kullanırız.</div>
<div style="text-align: left;">
SELECT* FROM Bölüm LEFT JOIN öğrenci Ön bölüm.eyili=öğrenci.o_yılı</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<img height="186" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCHLX_dOLeqDPmO4Z18kVGRFe2mKdVzxV1DBn73Ch7Rh_w6LcBOqncRhB7LVY4SdzKIzWBSrCdsd5BLzYhbZuJwbVb5VCIlxSyzb1iVxv9rkQBW4vC6dfEc3IwWqli7sKEgMiSkfzQkYU/s400/4+lefjoin.JPG" width="400" /></div>
<div style="text-align: center;">
LEFT JOIN EKRAN ÇIKTISI</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: center;">
(Tabloda eyili ve o_yili sütunlarını karıştırıp eşit olanları ekrana yazdırdı.eşit olmayanlara "NULL"(boş) yazdırdı.)</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
RIGHT JOIN:left ve right arasındaki fark tüm kayıtların seçileceğini tablonun sağdaki mi yoksa soldaki mi olacağını belirtiyor.</div>
<div style="text-align: left;">
SELECT * FROM BÖLÜM RIGHT JOIN öğrenci ön bölüm eyili =öğrenci.o_ yili</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<img height="191" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGbjDtWQVXlK3YU4PmZoackVXarQPXAm8kLyKzIqMdid3CPwHl3hDnHqtuaiRu3og4sqzfwdRE9nk_C6hLpQalJ82eI2NIxlBQJJkf28DKUJVDAfjM3f1Avw_rcVRyzwe26tGr0LUWHoY/s400/5rightjoin.JPG" width="400" /></div>
<div style="text-align: center;">
Righ Joın Ekran Çıktısı</div>
<div style="text-align: left;">
(tabloda o_yili ve eyili sütunlarını karşılaştırıp eşit olanları ekrana yazdırdı. eşit olmayanlara "NULL"(BOŞ)yazdırıdı.)</div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
<div style="text-align: justify;">
<br /></div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0tag:blogger.com,1999:blog-5553262645899035220.post-77343324446961616112015-06-24T00:43:00.000-07:002015-07-09T23:54:05.441-07:00WampServer Kurulumu<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Bilindiği üzere php dosyalarını çalıştırabilmek için yerel sunucuya ihtiyacımız var.Wampserver programı ile kendi bilgisayarınızı yerel sunucu olarak ayarlayabilirsiniz.</div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Program adresi: http://www.wampserver.com/en/</div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Program ücretsiz olup herhangi bir key – crack veya serial istememektedir.</div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Kurulum ve Kullanım:</div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Öncelikle yukarıdaki adresten dosyamızı indiriyoruz. Ardından kuruluma başlıyoruz.</div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp1.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><span style="color: black;"><img alt="wamp1" class="aligncenter size-full wp-image-320" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp1.png" height="430" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="540" /></span></a></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Next ile ilerliyoruz.<br />
<br />
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp2.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><span style="color: black;"><img alt="wamp2" class="aligncenter size-full wp-image-321" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp2.png" height="428" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="543" /></span></a></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Sözleşmeyi onaylayıp Next ile ilerliyoruz.<br />
<br />
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp3.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><img alt="wamp3" class="aligncenter size-full wp-image-322" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp3.png" height="424" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="544" /></a></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Kurulacak dizini değiştirmemize gerek yok. Devam ediyoruz..<br />
<br />
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp4.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><span style="color: black;"><img alt="wamp4" class="aligncenter size-full wp-image-323" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp4.png" height="418" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="539" /></span></a></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Hızlı başlat ve masaüstü kısayolu isterseniz oluşturabilirsiniz.<br />
<br />
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp5.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><span style="color: black;"><img alt="wamp5" class="aligncenter size-full wp-image-324" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp5.png" height="422" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="540" /></span></a></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
Kurulumu başlatıyoruz.<br />
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp6.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><span style="color: black;"><img alt="wamp6" class="aligncenter size-full wp-image-325" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp6.png" height="424" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="540" /></span></a></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: center; vertical-align: baseline;">
Dosyalar kopyalanıyor..<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="wamp7" border="0" class="aligncenter wp-image-326" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp7.png" height="418" width="534" /></a></div>
<br />
<br />
<br />
<br />
Varsayılan tarayıcımızı göstermemiz gerekiyor.<br />
<br />
<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp8.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><img alt="wamp8" class="aligncenter size-full wp-image-327" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp8.png" height="418" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="534" /></a></div>
<br />
<br />
Burası smtp mail için gerekli mail sunucusu bilgileri..<br />
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
<div class="separator" style="clear: both; text-align: center;">
<a class="fancybox" href="http://www.mylmz.in/wp-content/uploads/2014/03/wamp9.png" rel="fancybox" style="-webkit-transition: color 0.3s; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #b38f00; display: inline; font-family: 'Helvetica Neue Light', HelveticaNeue-Light, 'Helvetica Neue', Helvetica, Arial, sans-serif; margin: 0px; outline: none 0px; padding: 0px; text-decoration: none; transition: color 0.3s; vertical-align: baseline;"><img alt="wamp9" class="aligncenter size-full wp-image-328" src="http://www.mylmz.in/wp-content/uploads/2014/03/wamp9.png" height="420" style="-webkit-border-image: url(data:image/png; background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; box-sizing: border-box; display: block; height: auto; margin: 5px auto; max-width: 100%; outline: none 0px; padding: 0px; position: relative; vertical-align: baseline;" width="536" /></a></div>
<br /></div>
<div style="background-attachment: scroll; background-clip: initial; background-color: white; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border: 0px none; color: #333333; font-family: verdana; font-size: 13px; line-height: 20px; margin: 0px; outline: none 0px; padding: 0px; text-align: justify; vertical-align: baseline;">
</div>
Anonymoushttp://www.blogger.com/profile/13821010353207174501noreply@blogger.com0