Esempio n. 1
0
		<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>
Esempio n. 2
0
			<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 
Esempio n. 3
0
<?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);
}