Php Toplu Seçimleri Alma ve Veritabanına Kayıt Etme

Blogumda daha önceden yayınladığım bir makalede devamını başka bir makale şeklinde anlatacağımı belirtmişim, unuttuğum için yazamadım. Bir arkadasımın hatırlatması üzerine makaleyi bir video şeklinde hazırladım.<br /><br /><a href="http://www.ayazoglu.org/2013/10/jquery-ile-toplu-secme-islemi-toplu.html">http://www.ayazoglu.org/2013/10/jquery-ile-toplu-secme-islemi-toplu.html</a><br /><br />Konusunda jquery ile toplu checked işlemininden elde edilen bir dizinin alınması ve veritabanına kayıt edilmesini anlattık. Olay basittir.<br /><br /><div class="separator" style="clear: both; text-align: center;"><iframe allowfullscreen="allowfullscreen" frameborder="0" height="500" mozallowfullscreen="mozallowfullscreen" src="https://www.youtube.com/embed/_wGhZwUb89I?feature=player_embedded" webkitallowfullscreen="webkitallowfullscreen" width="100%"></iframe></div><br /><br /><br />Video içeriğindeki kaynak kodlar :<br /><br /><br /><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> <?php <br /> ## Ayna.Pro <br /> ## NM <br /> /* <br /> Evet Arkadaslar bir yazımda konu ile ilgili döküma paylaşacağımı yazmışım, arkadasın hatırlatması üzerine konu ile ilgili bir video çekeyim dedim :) <br /> Şimdi jquery ile toplu checkbox işlemini php ve mysql ilişkili yapalım. Konuya özet geçmek gerekirse, <br /> hepsini seç veya bazılarını seçip mysql e kayıt edeceğiz.. <br /> Şimdi bu verileri buraya mysql den nasıl cekeceğinizi anlatmıyorum :) <br /> [] Bu şekilde zaten array olduğunu belirtmiş olduk tekrarında bir kez daha array olarak belirtmemize gerek yok <br /> verileri basitce aldık. <br /> Şimdi mysql bağlantısı yapıp query ile ekleyelim. <br /> Olay basittir :) <br /> Sağlıcakla Esen Kalın. <br /> */ <br /> if($_POST){ <br /> mysql_connect("localhost","root","123654")or die("hata"); <br /> mysql_select_db("ders"); <br /> $kat = $_POST['kategoriler']; <br /> foreach($kat as $kategori){ <br /> $ekle = mysql_query("insert into veri(veri)values('$kategori')"); <br /> if($ekle){ <br /> echo "Eklendi. ".$kategori."<br>"; <br /> } <br /> } <br /> } <br /> ?> <br /> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.5.0/jquery.min.js" type="text/javascript"></script> <br /> <script type="text/javascript"> <br /> $(function () { <br /> $(".tumunu-sec").click(function(){ <br /> $(this).closest('table').find(':checkbox').attr('checked', this.checked); <br /> }); <br /> }); <br /> </script> <br /> <form action="" method="post"> <br /> <table id="tablo"><thead> <br /> <tr><th width="20px"><input type="checkbox" class="tumunu-sec" title="Tümünü Seç"></th> <br /> <th>Kategoriler</th></tr> <br /> </thead> <br /> <tbody> <br /> <tr> <br /> <td><input type="checkbox" name="kategoriler[]" value="PHP"></td> <br /> <td>Php</td> <br /> </tr> <br /> <tr> <br /> <td><input type="checkbox" name="kategoriler[]" value="MYSQL"></td> <br /> <td>Mysql</td> <br /> </tr> <br /> <tr> <br /> <td><input type="checkbox" name="kategoriler[]" value="HTML"></td> <br /> <td>Html</td> <br /> </tr> <br /> <tr> <br /> <td><input type="checkbox" name="kategoriler[]" value="CSS"></td> <br /> <td>Css</td> <br /> </tr> <br /> <tr> <br /> <td><input type="checkbox" name="kategoriler[]" value="JQUERY"></td> <br /> <td>Jquery</td> <br /> </tr> <br /> </tbody> <br /> </table> <br /> <input type="submit" value="Kaydet"> <br /> </form> <br /></code></pre>

Php Toplu Seçimleri Alma ve Veritabanına Kayıt Etme

Blogumda daha önceden yayınladığım bir makalede devamını başka bir makale şeklinde anlatacağımı belirtmişim, unuttuğum için yazamadım. Bir a...

Devamı »

zend Gdata ile Blogger,Blogspot Sitenize İçerik Post Edin.

<br /><div>Google nin bu konuda Blogger apisi mevcut fakat api kodunu bir kaç gün içinde vereceğiz uyarısını görünce farkı yollara başvurmam sonucunda, zend Framework ile yaptığım basit içerik posteri sizle paylaşalım..</div><div><br /></div><div>Öncelikle Zend in kendi sitesinden zend_Gdata yı indirin.</div><div><br /></div><div><a href="http://framework.zend.com/downloads/latest">http://framework.zend.com/downloads/latest</a></div><div><br /></div><div><br /></div><div>Örnek Birde Bot vermiş olalım :) Rüya Tabirleri Botu</div><div><br /></div><div>Ama günlük belli bir sayıya kadar içerik eklemenize izin veriyor </div><div><br /></div><div>Ornek.Php</div><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> <?php <br /> ## By NM <br /> ## Ayna.Pro <br /> require_once 'Zend/Loader.php'; <br /> Zend_Loader::loadClass('Zend_Gdata'); <br /> Zend_Loader::loadClass('Zend_Gdata_Query'); <br /> Zend_Loader::loadClass('Zend_Gdata_ClientLogin'); <br /> $user = 'google@mail.com'; <br /> $pass = 'sifreniz'; <br /> $service = 'blogger'; <br /> $client = Zend_Gdata_ClientLogin::getHttpClient($user, $pass, $service, null, <br /> Zend_Gdata_ClientLogin::DEFAULT_SOURCE, null, null, <br /> Zend_Gdata_ClientLogin::CLIENTLOGIN_URI, 'GOOGLE'); <br /> $gdClient = new Zend_Gdata($client); <br /> $kaynak = file_get_contents("http://www.ruya-tabirleri.com/a-sozlugu5.html"); <br /> $say = preg_match_all('#<a href="(.*?)" title="(.*?)" style="text-decoration: none">#s',$kaynak,$url); <br /> for($i=1;$i<$say;$i++){ <br /> $urele = $url[1][$i]; <br /> $baslik = $url[2][$i]; <br /> $baslik = iconv("windows-1254","UTF-8",$baslik); <br /> $asil = file_get_contents($urele); <br /> $r1 = explode('<div id="solyasla">',$asil); <br /> $r2 = explode('</div>',$r1[1]); <br /> $r3 = explode('<center>',$r2[1]); <br /> $icerik = $r3[0]; <br /> $icerik = iconv("windows-1254","UTF-8",$icerik); <br /> $tag = 'A'; <br /> /////////////////////////POST İşlemi <br /> $blogID = '7733994614677648385'; // like 98744313216546562 <br /> $title=$baslik; <br /> $content=$icerik; <br /> $uri = 'http://www.blogger.com/feeds/' . $blogID . '/posts/default'; <br /> $entry = $gdClient->newEntry(); <br /> $entry->title = $gdClient->newTitle($title); <br /> $newLabel = $gdClient->newCategory($tag, 'http://www.blogger.com/atom/ns#'); <br /> $labels[] = $newLabel; // Append the new label to the list of labels. <br /> $entry->setCategory($labels); <br /> $entry->content = $gdClient->newContent($content); <br /> $entry->content->setType('text'); <br /> $createdPost = $gdClient->insertEntry($entry, $uri); <br /> $idText = split('-', $createdPost->id->text); <br /> $newPostID = $idText[2]; <br /> echo $newPostID; <br /> ///////////////// <br /> flush(); <br /> } <br /> ?> <br /></code></pre>

zend Gdata ile Blogger,Blogspot Sitenize İçerik Post Edin.

Google nin bu konuda Blogger apisi mevcut fakat api kodunu bir kaç gün içinde vereceğiz uyarısını görünce farkı yollara başvurmam sonucunda,...

Devamı »

Php ile Resim Boyutlandırma Sınıfı - Php Resim Ebatları

Resim olaylarında kullanabileceğiniz bir resim boyutlandırma yardımcı sınıfıdır. Resimlerde yükseklik veya genişlik hesaplamalarında yada resimlerine genişliklerini ve yüksekliklerini almada kullanabileceğiniz güzel bir sınıftır.<br /><div><br /></div><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> <?php <br /> #################### <br /> ## By NM <br /> ## ImageClass <br /> ## www.ayna.pro <br /> #################### <br /> class Resim{ <br /> public $image; <br /> public function boyut($image){ <br /> $size = getimagesize($image); <br /> return $size[3]; <br /> } <br /> public function genislik($image){ <br /> preg_match('#width="(.*?)"#',$this->boyut($image),$sonuc); <br /> return $sonuc[1]; <br /> } <br /> public function yukseklik($image){ <br /> preg_match('#height="(.*?)"#',$this->boyut($image),$sonuc); <br /> return $sonuc[1]; <br /> } <br /> public function YukseklikHesapla($yenigenislik,$genislik,$yukseklik){ <br /> $islem = $yukseklik*$yenigenislik; <br /> $n = $islem/$genislik; <br /> return ceil($n); <br /> } <br /> public function GenislikHesapla($yeniyukseklik,$genislik,$yukseklik){ <br /> $islem = $genislik*$yeniyukseklik; <br /> $n = $islem/$yukseklik; <br /> return ceil($n); <br /> } <br /> //Class Bitişi <br /> } <br /> $resim = new Resim(); <br /> // Örnek Kullanım <br /> $resimimiz = 'dosya.jpg'; <br /> $genislik = $resim->genislik($resimimiz); <br /> $yukseklik = $yukseklik->genislik($resimimiz); <br /> $genislikhesapla = $resim->GenislikHesapla("500",$genislik,$yukseklik); <br /> $yukseklikhesapla = $resim->GenislikHesapla("300",$genislik,$yukseklik); <br /> ?> <br /></code></pre>

Php ile Resim Boyutlandırma Sınıfı - Php Resim Ebatları

Resim olaylarında kullanabileceğiniz bir resim boyutlandırma yardımcı sınıfıdır. Resimlerde yükseklik veya genişlik hesaplamalarında yada re...

Devamı »

ezSQL Kullanımı, Veritabanı Sınıfı, RainTPL ve ezSQL

Bu yazımda sizlere Kendiminde vazgeçemediğim ve neredeyse bütün projemlerimde kullandığım bir veritabanı snıfını tanıtacağım, ezSQL mutlaka bilenleriniz veya duyanlarınız olmuştur, malumunuz Wordpress in de alt yapısını oluşturan bir veritabanı sınıfıdır. Kullanım kolaylığı hızlılığı açısından çok çekicidir.<br />ezSQL her ne kadar biz mysql için kullanımını anlatacak olsak ta PHP-PDO, Oracle8, InterBase/FireBird, PostgreSQL, SQLite (PHP), SQLite (C++) ve MS-SQL gibi birçok veritabanında da kullanılır.<br /><br />Öncelikle<br /><br /><a href="http://www.ayna.pro/uploads/ezSQL.zip">http://www.ayna.pro/uploads/ezSQL.zip</a><br /><br />Linkten ezSQL içeriğini indirin. Bir dizin oluşturun ve  İndirmiş olduğumuz paketin içinden mysql klasöründeki ez_sql_mysql.php ve shared klasöründeki ez_sql_core.php dosyalarını alıyoruz ve yeni oluşturduğumuz dizine yüklüyoruz. Bununla birlikte aynı dizinde boş bir config.php dosyası oluşturuyoruz.<br /><br /><br /><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> <?php <br /> //ezSQL çekirdegini dahil ediyoruz. <br /> include_once "ez_sql_core.php"; <br /> // ezSQL veritabani bilesenini cagiriyoruz. <br /> include_once "ez_sql_mysql.php"; <br /> // veritabanin ayarlarini yapiyoruz. <br /> $vt_kullanici="root"; <br /> $vt_parola=""; <br /> $vt_isim="bilgiler"; <br /> $vt_sunucu="localhost"; <br /> // ezSQL sinifini cagirarak calistirmaya basliyoruz. <br /> $db = new ezSQL_mysql($vt_kullanici,$vt_parola,$vt_isim,$vt_sunucu); <br /> ?> </code></pre><br />içeriğine bu şekilde oluşturup, ezSQL sınıfını dahil edip veritabanı bağlantısını sağlıyoruz. artık config dosyanız hazır.<br /><br />artık veritabanı query lerinizi ezSQL ile yapabilirsiniz.<br /><br />Örnek Sorgular :<br /><br /><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> $db->query("insert into(sutun)values('deger')"); <br /> $db->query("update tablo set sutun='deger' where ='kosul'"); <br /> $tekil = $db->get_row("select * from tablo where ='kosul'"); <br /> echo $tekil->konubasligi; <br /> $cogul = $db->get_results("select * from tablo"); <br /> foreach($cogul as $coklu){ <br /> echo $coklu->konubasligi; <br /> } <br /> $veri_sayisi = $db->get_var("select count(*) from tablo"); <br /></code></pre><br /><br />Bununla birlikte eğer ezSQL sınıfını kendi yazmış olduğunuz bir fonksiyonda kullanacaksanız fonksiyonun başına global $db; yazmayı unutmayın.<br /><br />Kullanışlı ve pratik :)<br /><br />Ek Olarak Eğer Mysql cache kullanmak isterseniz config.php dosyanız da ek olarak<br /><div><br /></div><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> // Cache süresi ne zaman dolacak? <br /> $db->cache_timeout = 24; // Verilen değer saat cinsinden! <br /> // Cache dizini <br /> $db->cache_dir = 'cache/mysql/'; <br /> $db->use_disk_cache = true; <br /></code></pre><br />Değerlerini kullanabilirsiniz.<br /><br />Diğer bir konu ezSQL RainTPL template manager ilede oldukça uyumludur.<br /><div><br /></div><pre style="background-image: URL(https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHhRotJ-kdDzjGQnC28xEkK6EWiJSFygCQ6hb5uAa5HVp-2LHIlt832MlhIVYTQsc6DCgtuMe_6XPCUby0PB0a1TCcItWWhyD79UQDdNrbH2D1_YC7_dgEXMf7G96wROf7D17SDGpNjBLl/s320/codebg.gif); background: #f0f0f0; border: 1px dashed #CCCCCC; color: black; font-family: arial; font-size: 12px; height: auto; line-height: 20px; overflow: auto; padding: 0px; text-align: left; width: 99%;"><code style="color: black; word-wrap: normal;"> $cogul = $db->get_results("select * from tablo",ARRAY_A); <br /> $tpl->assgin("cogul",$cogul); <br /></code></pre><br />Şeklinde basitçe loop edebilirsiniz.

ezSQL Kullanımı, Veritabanı Sınıfı, RainTPL ve ezSQL

Bu yazımda sizlere Kendiminde vazgeçemediğim ve neredeyse bütün projemlerimde kullandığım bir veritabanı snıfını tanıtacağım, ezSQL mutlaka ...

Devamı »

PHP Tırnak Hatası, Mysql Tırnak Sorunu Hakkında

Bu Yazım da Php ile ilgili bazan yaşadığınız bir problem olan çift tırnak yada tek tırnak sorunu neden kaynaklanır, nasıl giderilir,<br /><br />Mysql veri kaydetme esnasında yaşadığınız bu sorun aslına bakarsanız size bir uyarıdır :) nasıl bir uyarı diyecek olursanız, bu konuya geçmezden evvel sql query hakkında biraz incelemede bulunalım,<br /><br /><blockquote class="tr_bq">"select * from tablo where sutun='deger' order by id desc"</blockquote><br />var olan query  bu şekilde varsayarsak deger değişkeni içersinde bir çift tırnak veya tek tırnak olduğunu varsayalım. degerin "merhaba" olduğunu düşünelim<br /><br />"select * from tablo where sutun='"merhaba" order by id desc"<br /><br />"select * from tablo where sutun='" query sutunu iki operatör arasını kapsar, o nedenle deger içersinde çift tırnak olduğu zaman query bu şekil bir hal alacaktır. Bu aslında bir SQL injection açığıdır. yani query nize dışardan bir müdahale sözkonusudur. mysql_real_escape_string yada addslashes fonksiyonundan geçirerek değişkeni o şekilde query ye dahil etmeniz gerekir,<br /><br /><blockquote class="tr_bq">$deger = addslashes($_POST['deger]);</blockquote><br />gibi yada<br /><br /><blockquote class="tr_bq">$deger = mysql_real_escape_string($_POST['deger]);</blockquote><br />Diğer bir konu tırnak sorunu sunucuda maqic_quotes aktif olmadığı zamanlarda meydana gelir şayet sunucu sahibi iseniz, php.ini editlyerek magic_quotes değerini on yapabilirsiniz.

PHP Tırnak Hatası, Mysql Tırnak Sorunu Hakkında

Bu Yazım da Php ile ilgili bazan yaşadığınız bir problem olan çift tırnak yada tek tırnak sorunu neden kaynaklanır, nasıl giderilir, Mysql v...

Devamı »

Php ile Blogger Blogspot sitelerden Veri Çekme, Blogger Bot [Video]

Bu videoda blogger için php ile bot yapımı anlatılmıştır. blogspot sitelerden veri çekilmesi nasıl yapılır anlatılmıştır. Gerçi blogspot veya başka herhangi bir site içinde bu prosedürler geçerlidir, Aynı zamanda bot yazma olayı hakkında basit bir örnek teşkil edebilir.. Aklınızda takılan soru ve sorunlar için yorum atabilirsiniz.<br /><br /><br /><iframe allowfullscreen="" frameborder="0" height="315" src="//www.youtube.com/embed/aHd5nvjrz_U" width="420"></iframe>

Php ile Blogger Blogspot sitelerden Veri Çekme, Blogger Bot [Video]

Bu videoda blogger için php ile bot yapımı anlatılmıştır. blogspot sitelerden veri çekilmesi nasıl yapılır anlatılmıştır. Gerçi blogspot vey...

Devamı »

Php ile Seo Url Yapımı - Seo Url Sınıfı

Seo Sınıfı ile kolayca seo url oluşturabilirsiniz. seo.link.php dosyasını oluşturarak alttaki kodları yapıştırın. ve kullanacağınız sayfada include edin. Kullanımı altta basitçe anlatılmıştır.<br /><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;"><?php </span><br /><span style="background-color: #e7e9e9; color: #ff8000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">// Seo Class Code By Kerim Yılmaz </span><br /><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">class </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">seo</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">{<br />public </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">;<br />public function </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">sef</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">) </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">{ </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">trim</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"--"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"---"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$turkce</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">=array(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ş"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ş"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ı"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"("</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">")"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"‘"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ü"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ü"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ö"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ö"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ç"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ç"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">" "</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"/"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"*"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"?"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><br /><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ş"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ş"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ı"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ğ"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ğ"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"İ"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ö"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ö"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ç"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ç"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"ü"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Ü"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"A"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"B"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"C"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"D"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"E"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"F"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"G"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><br /><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"H"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"I"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"J"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"K"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"L"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"M"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"N"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"O"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"P"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"R"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"S"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"T"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"U"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"V"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Y"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Z"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"Q"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"X"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"W"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$duzgun</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">=array(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"s"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"s"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"i"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"u"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"u"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"o"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"o"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"c"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"c"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"s"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><br /><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"s"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"i"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"g"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"g"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"I"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"o"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"o"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"c"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"c"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"u"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"u"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"+"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"a"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"b"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"c"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"d"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"e"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"f"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"g"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"h"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><br /><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"i"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"j"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"k"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"l"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"m"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"n"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"o"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"p"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"r"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"s"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"t"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"u"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"v"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"y"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"z"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"q"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"x"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"w"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">=</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$turkce</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$duzgun</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">preg_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"@[^A-Za-z0-9\+_]+@i"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">""</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"--"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"---"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">);</span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"--"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">);</span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1 </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">str_replace</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"+"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #dd0000; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">"-"</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">,</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">);</span><br /><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">return </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$tr1</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">;<br />}<br />} </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$seo </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= new </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">seo</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(); </span><br /><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">?></span><br /><blockquote class="tr_bq"><span style="font-family: monospace; font-size: 12px; white-space: nowrap;">K</span><span style="font-family: monospace; font-size: 12px; white-space: nowrap;">ullanımı : </span></blockquote><span style="font-family: monospace;"><span style="font-size: 12px; white-space: nowrap;"><br /></span></span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$seourl </span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">= </span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$seo</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">-></span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">sef</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">(</span><span style="background-color: #e7e9e9; color: #0000bb; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">$konusbasligi</span><span style="background-color: #e7e9e9; color: #007700; font-family: monospace; font-size: 12px; font-weight: bold; white-space: nowrap;">);  </span>

Php ile Seo Url Yapımı - Seo Url Sınıfı

Seo Sınıfı ile kolayca seo url oluşturabilirsiniz. seo.link.php dosyasını oluşturarak alttaki kodları yapıştırın. ve kullanacağınız sayfada ...

Devamı »

Mysql Join İşlemleri, Join Tablosu

Mysql sorgularında kullandığımız join işlemlerinden bahsedeceğim, join işlemi nedir, mysql veritabanından birden fazla tablo arasında belirli bir kritere bağlı olarak bir eşleme, sanal bir tablo oluşturma işlemidir.<br /><br /><div class="separator" style="clear: both; text-align: center;"><a href="http://1.bp.blogspot.com/-Yydj5rzpC8g/UlXHAzSPepI/AAAAAAAAABI/WPfVPQCEZb0/s1600/10.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="472" src="http://1.bp.blogspot.com/-Yydj5rzpC8g/UlXHAzSPepI/AAAAAAAAABI/WPfVPQCEZb0/s640/10.jpg" width="640" /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;">Join Sorgu tablosunda gayet net bir şekilde açıklanmıştır.</div><br />

Mysql Join İşlemleri, Join Tablosu

Mysql sorgularında kullandığımız join işlemlerinden bahsedeceğim, join işlemi nedir, mysql veritabanından birden fazla tablo arasında belirl...

Devamı »

Php ile RSS oluşturmak, Mysql Dinamik Rss Yapmak, Php Rss, Mysql Rss

Bu yazımda php ile dinamik rss oluşturmayı anlatacağım. mysql den veri çekerek dinamik bir şekilde rss oluşturmak php ile basit bir olaydır. Verdiğim kodu kendinize göre değiştirip kullanabilirsiniz. örnek demo olarak blogumun rss sine bakabilirsiniz. adres satırında rss.php yazmanız yeterli.<br /><br />örnek php rss kodu :<br /><br /><blockquote class="tr_bq"><?php<br />include "config.php";<br />header('Content-Type: text/xml');<br />echo '<?xml version="1.0" encoding="UTF-8"?><br /><rss version="2.0"><br /><channel><br /><title>/*/Ayazoglu Other Name Of Security/*/</title><br /><description>Php ve mysql webtasarımı üzerine özgün makale ve eğitim dökümanları barındırır. </description><br /><link>http://www.ayazoglu.org/ayazoglu.org/</link>';<br />$sorgu = mysql_query("SELECT id, baslik, icerik, tarih FROM yazilar ORDER BY mid DESC LIMIT 15");<br />while($icerik=mysql_fetch_array($sorgu)){<br />echo '<br /><item><br /><title>'.$icerik['baslik'].'</title><br /><description><![CDATA[<br />'.$icerik['icerik'].'<br />]]></description><br /><link>http://www.ayazoglu.org/ayazoglu.org/comments.php?entry=entry'.$icerik['id'].'</link><br /><pubDate>'.$icerik['tarih'].' GMT</pubDate><br /></item>';<br />}<br />echo '</channel><br /></rss>';<br />?></blockquote><br />Eğer türkçe karakter hatası alıyorsanız. dosyanızı notepad++ ile açıp kodlamayı UTF-8 yapınız. Hala türkçe karakter hatası alıyorsanız. Veritabanı karakter setinizi kontrol ediniz. Hala daha çözemedim ben Türkçe karakter sorunu alıyorum. veya Mozilla da çalışıyor, internet explorer de çalışmıyor diyorsanız. Yorum yazınız bizzat yardımcı olayım..

Php ile RSS oluşturmak, Mysql Dinamik Rss Yapmak, Php Rss, Mysql Rss

Bu yazımda php ile dinamik rss oluşturmayı anlatacağım. mysql den veri çekerek dinamik bir şekilde rss oluşturmak php ile basit bir olaydır....

Devamı »

Curl ile url ye Post gönderme, Kaynak okuma

<span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">Bir url ye get methoduyla gönderilmiş kısmını file_get_contetns</span><br /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">ile okumak kolay ama birde url ye post yöntemiyle veri gönderip çekmekkonusu var.</span><br /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">bununn için curl fonksiyonumuzun post özelliğinden faydalanacağız.</span><br /><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">passcracking.com sitesinde md5 crack işlemi ni nasıl yapacağız onuda öğrenmiş olacağız.</span><br /><br /><blockquote class="tr_bq"><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">// Passcracking.Com ///</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">$hash = "MD5 BURADA OLACAK";</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">$gonder = curl_init();</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">curl_setopt($gonder, CURLOPT_URL, "http://passcracking.com/index.php");</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">curl_setopt($gonder, CURLOPT_POST, 1);</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">curl_setopt($gonder, CURLOPT_RETURNTRANSFER, 1);</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">curl_setopt($gonder, CURLOPT_POSTFIELDS,"datafromuser=$hash");</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">$sonuc = curl_exec ($gonder);</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">curl_close ($gonder);</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">$kaynak = explode('</td><td bgcolor=#FF0000>', $sonuc);</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">$kaynak = explode('</td><td>', $kaynak[1]);</span></span><br /><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;">// Passcracking.comm..///</span></span></blockquote><span style="color: #767676; font-family: Trebuchet MS; font-size: x-small;"><span style="line-height: 18px;"><br /></span></span> <span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">bu url de md5 crack işlemi yapılıyor ancak md5 post edilerek gönderiliyor bu işlemi curl postfields ile datayı post ediyoruz ve post eilmiş kaynağı okuyoruz.</span><br /><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">sonrası standart explode işlemleri veriyi bölüp gerekli kısmnı alıyoruz. vede ekrana yazdırıyoruz</span>

Curl ile url ye Post gönderme, Kaynak okuma

Bir url ye get methoduyla gönderilmiş kısmını file_get_contetns ile okumak kolay ama birde url ye post yöntemiyle veri gönderip çekmekkonusu...

Devamı »

Wordpress İçerik Ekleme [PHP]

<span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">son istekleriniz üzere wordpress te dışardan bir kaynaktan</span><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">yazı ekleme işlemini anlatacğım.</span><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">herhangi bir bot un wordpress e konu açmasını sağlayabilir</span><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">veya istediğiniz şekilde bir yazılımda konu açtırabilirsiniz</span><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">bunun için kodumuzu veriyorum...</span><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><br /><blockquote class="tr_bq"><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">include "wp-load.php";</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">$my_post = array();</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">$my_post['post_title'] = "KONU BAŞLIĞI";</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">$my_post['post_content'] = "YAZI İÇERİĞİ";</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">$my_post['post_status'] = 'publish';</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">$my_post['post_author'] = 1;</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">$my_post['post_category'] = array(8); //Kategori id.</span><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">wp_insert_post( $my_post );</span><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">echo "eklendi";</span></blockquote><br style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;" /><span style="color: #767676; font-family: 'Trebuchet MS'; font-size: 13px; line-height: 18px;">bu kod sayesinde wordpress e dışardan yazı ekleme işlemi yapabilirsiniz..</span>

Wordpress İçerik Ekleme [PHP]

son istekleriniz üzere wordpress te dışardan bir kaynaktan yazı ekleme işlemini anlatacğım. herhangi bir bot un wordpress e konu açmasını sa...

Devamı »