<div class="baslik"> <h2><a class="h3" style="color:#337AB7;" href=""><?php echo $yazar; ?> Yazar Profili</a></h2> </div> <div class="entryler"> <div class="entry" id="1"> <div class="entryicerik">Entry Sayısı: <?php echo $row['entry']; ?> <br /><br> Başlık Sayısı: <?php echo $row['baslik']; ?> <br><br> <b>Son Entry Yazdığı Başlıklar:</b><br> <?php foreach ($veri as $satir) { $baslikid = $satir["baslikid"]; $sql = $db->prepare("SELECT * FROM basliklar WHERE id= ?"); $sql->execute(array($baslikid)); $row = $sql->fetch(PDO::FETCH_ASSOC); $link = replace_tr($row['isim']); echo '<a href="' . $adres . '/baslik/' . $link . '--' . $baslikid . '/">' . $row['isim'] . '</a> <br />'; } ?> </div> </div> </div> </div>
<div class="listeyenile"><a id="yenile" class="btn btn-primary" style="cursor:pointer;" onclick="yenile()">Yenile</a><img class="yuklen" height="32px" src="http://www.conax.com.tr/img/loading.gif" id="yenilen"></img></div> <ul> <?php $veri = $db->query("select * from entryler Order By id DESC")->fetchAll(PDO::FETCH_ASSOC); $liste = ""; foreach ($veri as $row) { $baslikid = $row["baslikid"]; preg_match("#_{$baslikid}-#", $liste, $listeara); if (!$listeara == null) { } else { $liste = '_' . $baslikid . '-' . $liste; $sql = $db->prepare("SELECT * FROM basliklar WHERE id= ?"); $sql->execute(array($baslikid)); $roww = $sql->fetch(PDO::FETCH_ASSOC); $isim = htmlspecialchars($roww['isim']); $link = replace_tr($isim); ?> <li> <div ><a class="buton" href="/baslik/<?php echo $link; ?> --<?php echo $roww['id']; ?> /"><?php echo $isim; ?> </a></div> </li> <?php
<?php require "vt.php"; function replace_tr($text) { $text = trim($text); $search = array('Ç', 'ç', 'Ğ', 'ğ', 'ı', 'İ', 'Ö', 'ö', 'Ş', 'ş', 'Ü', 'ü', ' ', '\''); $replace = array('c', 'c', 'g', 'g', 'i', 'i', 'o', 'o', 's', 's', 'u', 'u', '-', '-'); $new_text = str_replace($search, $replace, $text); return $new_text; } $term = $_GET['term']; $query = $db->query('select * from basliklar where isim like "%' . $term . '%"', PDO::FETCH_ASSOC); if ($query->rowCount()) { $data = array(); foreach ($query as $row) { $data[] = array('value' => $row['isim'], 'baslik_id' => $row['id'], 'baslik_isim' => $row['isim'], 'baslik_link' => replace_tr($row['isim']), 'entry_adedi' => $row['entryadedi']); } echo json_encode($data); }