<?php
session_start();
ob_start();
include('admin/ayar.php');
?>
<!DOCTYPE html>
<!--[if IE 8 ]><html class="ie ie8" lang="en"> <![endif]-->
<!--[if IE 9 ]><html class="ie ie9" lang="en"> <![endif]-->
<!--[if (gte IE 9)|!(IE)]><!--><html lang="en"> <!--<![endif]-->
<head>
<!-- Basic Page Needs -->
<meta charset="utf-8">
<title>Ask me Responsive Questions and Answers Template</title>
<meta name="description" content="Ask me Responsive Questions and Answers Template">
<meta name="author" content="vbegy">
<!-- Mobile Specific Metas -->
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">
<!-- Main Style -->
<link rel="stylesheet" href="style.css">
<!-- Skins -->
<link rel="stylesheet" href="css/skins/skins.css">
<!-- Responsive Style -->
<link rel="stylesheet" href="css/responsive.css">
<!-- Favicons -->
<link rel="shortcut icon" href="images/favicon.png">
</head>
<body class="boxed_body">
<?php
include('ust.php');
?>
<section class="container main-content">
<div class="row">
<div class="col-md-9">
<?php
if (!empty($_GET['butun'])) {
$konu=$db->prepare("SELECT* FROM konular WHERE id=?");
$konu->bindParam(1,$_GET['butun']);
$konu->execute();
$kon= $konu->fetchAll(PDO::FETCH_ASSOC);
foreach ($kon as $ke) {
?>
<article class="question single-question question-type-normal">
<h2>
<a href="single_question.html"><?php echo $ke['baslik']; ?></a>
</h2>
<a class="question-report" href="#">Report</a>
<div class="question-type-main"><i class="icon-question-sign"></i><?php echo $ke['kimden']; ?></div>
<div class="question-inner">
<div class="clearfix"></div>
<div class="question-desc">
<p><?php echo $ke['yazi']; ?></p>
</div>
<div class="question-details">
<span class="question-answered question-answered-done"><i class="icon-ok"></i>solved</span>
</div>
<span class="question-date"><i class="icon-time"></i><?php echo $ke['tarih']; ?></span>
<!-- kaç cevap var -->
<?php
if (!empty($_GET['butun'])) {
$kactane= $db->prepare("SELECT COUNT(*)FROM konuyorumlari WHERE sayfa_no=?");
$kactane->bindParam(1,$_GET['butun']);
$kactane->execute();
$kac= $kactane->fetchAll();
foreach ($kac as $kedi) {
?>
<span class="question-comment"><a href="#"><i class="icon-comment"></i><?php echo $kedi[0]; ?> Answer</a></span>
<?php
}
}
?>
<!-- kaç cevap var -->
<span class="single-question-vote-result">+22</span>
<ul class="single-question-vote">
<li><a href="#" class="single-question-vote-up" title="Like"><i class="icon-thumbs-up"></i></a></li>
</ul>
<div class="clearfix"></div>
</div>
</article>
<?php
}
}
?>
<div class="share-tags page-content">
<div class="question-tags"><i class="icon-tags"></i>
<a href="#">wordpress</a>, <a href="#">question</a>, <a href="#">developer</a>
</div>
<div class="share-inside-warp">
<ul>
<li>
<a href="#" original-title="Facebook">
<span class="icon_i">
<span class="icon_square" icon_size="20" span_bg="#3b5997" span_hover="#666">
<i i_color="#FFF" class="social_icon-facebook"></i>
</span>
</span>
</a>
<a href="#" target="_blank">Facebook</a>
</li>
<li>
<a href="#" target="_blank">
<span class="icon_i">
<span class="icon_square" icon_size="20" span_bg="#00baf0" span_hover="#666">
<i i_color="#FFF" class="social_icon-twitter"></i>
</span>
</span>
</a>
<a target="_blank" href="#">Twitter</a>
</li>
<li>
<a href="#" target="_blank">
<span class="icon_i">
<span class="icon_square" icon_size="20" span_bg="#ca2c24" span_hover="#666">
<i i_color="#FFF" class="social_icon-gplus"></i>
</span>
</span>
</a>
<a href="#" target="_blank">Google plus</a>
</li>
<li>
<a href="#" target="_blank">
<span class="icon_i">
<span class="icon_square" icon_size="20" span_bg="#e64281" span_hover="#666">
<i i_color="#FFF" class="social_icon-dribbble"></i>
</span>
</span>
</a>
<a href="#" target="_blank">Dribbble</a>
</li>
<li>
<a target="_blank" href="#">
<span class="icon_i">
<span class="icon_square" icon_size="20" span_bg="#c7151a" span_hover="#666">
<i i_color="#FFF" class="icon-pinterest"></i>
</span>
</span>
</a>
<a href="#" target="_blank">Pinterest</a>
</li>
</ul>
<span class="share-inside-f-arrow"></span>
<span class="share-inside-l-arrow"></span>
</div><!-- End share-inside-warp -->
<div class="share-inside"><i class="icon-share-alt"></i>Share</div>
<div class="clearfix"></div>
</div><!-- End share-tags -->
<!-- End about-author -->
<!-- End related-posts -->
<!-- cevaplar burasi -->
<div id="commentlist" class="page-content">
<div class="boxedtitle page-title"><h2>Cevaplar ( <span class="color">5</span> )</h2></div>
<ol class="commentlist clearfix">
<?php
$butun= @$_GET['butun'];
$id = @$_GET['id'] ? $_GET['id']:0;
if(!$id){ $id= 1;
}
$say = $db->query("SELECT * FROM konuyorumlari WHERE sayfa_no='{$butun}' ");
$toplamveri = $say -> rowCount();
$bireksigi = $toplamveri - 1;
$limit =1;
$sayfa_sayisi = ceil($toplamveri / $limit);
if($id > $sayfa_sayisi){
$id =1; }
$goster = $id * $limit - $limit;
$gorunensayfa= 3;
$makale = $db->query("SELECT * FROM konuyorumlari WHERE sayfa_no='{$butun}' ORDER BY id DESC LIMIT $goster,$limit");
$makbule= $makale -> fetchAll(PDO::FETCH_ASSOC);
foreach($makbule as $gob){
?>
<li class="comment">
<div class="comment-body comment-body-answered clearfix">
<div class="avatar"><img alt="" src="http://placehold.it/60x60/FFF/444"></div>
<div class="comment-text">
<div class="author clearfix">
<div class="comment-author"><a href="#"><!-- kimden --><?php echo $gob['kimden']; ?></a></div>
<div class="comment-vote">
<ul class="question-vote">
<li><a href="#" class="question-vote-up" title="Like"></a></li>
<li><a href="#" class="question-vote-down" title="Dislike"></a></li>
</ul>
</div>
<span class="question-vote-result">+1</span>
<div class="comment-meta">
<div class="date"><i class="icon-time"></i><!-- tarih --><?php echo $gob['tarih']; ?></div>
</div>
<a class="comment-reply" href="#"><i class="icon-reply"></i>Reply</a>
</div>
<div class="text"><p><!-- yazi --><?php echo $gob['yazi']; ?></p>
</div>
<div class="question-answered question-answered-done"><i class="icon-ok"></i>Best Answer</div>
</div>
</div>
</li>
<?php
}
?>
</ol><!-- End commentlist -->
</div><!-- End page-content -->
<br>
<br>
<ul class="pagination" style="position: relative;">
<?php
if($id > 1 && $id != $sayfa_sayisi){
?>
<li class="page-item">
<a href='single_question.php?butun=<?php echo $_GET['butun']; ?>&id=<?=$id - 1?>' class='page-link'>
<span aria-hidden="true">«</span>
</a>
</li>
<?php
}
for($i =$id - $gorunensayfa; $i < $id + $gorunensayfa +1; $i++){
if($i > 0 && $i <= $sayfa_sayisi){
if($i != $id){
?>
<li class='page-item'><a href='single_question.php?butun=<?php echo $_GET['butun']; ?>&id=<?php echo $i; ?>' class='page-link'><?php echo $i; ?></a></li>
<?php
}
}
}
if($id != $sayfa_sayisi){
?>
<li class="page-item">
<a href="single_question.php?butun=<?php echo $_GET['butun']; ?>&id=<?=$id+ 1?>" class="page-link">
<span aria-hidden="true">»</span>
</a>
</li>
<?php
}
?>
</ul>
<!-- burasi cevaplar kısmı -->
<div id="respond" class="comment-respond page-content clearfix">
<div class="boxedtitle page-title"><h2>Yorum at</h2></div>
<?php
if(@$_SESSION['uye'] == 1) {
?>
<form action="" method="post" id="commentform" class="comment-form">
<div id="respond-inputs" class="clearfix">
</div>
<div id="respond-textarea">
<p>
<label class="required" for="comment">yorum yaz<span>*</span></label>
<textarea id="comment" name="comment" aria-required="true" cols="58" rows="8" maxlength="3000"></textarea>
</p>
</div>
<p class="form-submit">
<input name="submit" type="submit" id="submit" value="Yorum yaz" class="button small color">
</p>
</form>
<?php
}
else{
echo 'Ancak üyeler yorum yazabilir';
}
?>
<!-- burasi yorum atma php kodlari-->
<?php
if (!empty($_POST['comment']) && !empty($_GET['butun'])) {
$tarih= date('d-m-Y H:i:s');
$comment= @$_POST['comment'];
$com= htmlspecialchars(strip_tags($comment));
$simdi= $db->prepare("INSERT INTO konuyorumlari(yazi,sayfa_no,kimden,tarih)VALUES(?,?,?,?)");
$simdi->bindParam(1,$com);
$simdi->bindParam(2,$_GET['butun']);
$simdi->bindParam(3,$_SESSION['kadi']);
$simdi->bindParam(4,$tarih);
$simdi->execute();
$sim= $simdi->rowCount();
if ($sim) {
echo '<div class="alert alert-success" role="alert">
başarı ile yorum gönderildi..!!
</div>';
header("refresh:2; url=index.php");
}
else{
echo '<div class="alert alert-danger" role="alert">
HATA..!!
</div>';
}
}
?>
<!-- burasi yorum atma php kodlari-->
</div>
</div><!-- End main -->
<?php
include('yan.php');
?>
</section><!-- End container -->
<?php
include('alt.php');
?>
<!-- js -->
<script src="js/jquery.min.js"></script>
<script src="js/jquery-ui-1.10.3.custom.min.js"></script>
<script src="js/jquery.easing.1.3.min.js"></script>
<script src="js/html5.js"></script>
<script src="js/twitter/jquery.tweet.js"></script>
<script src="js/jflickrfeed.min.js"></script>
<script src="js/jquery.inview.min.js"></script>
<script src="js/jquery.tipsy.js"></script>
<script src="js/tabs.js"></script>
<script src="js/jquery.flexslider.js"></script>
<script src="js/jquery.prettyPhoto.js"></script>
<script src="js/jquery.carouFredSel-6.2.1-packed.js"></script>
<script src="js/jquery.scrollTo.js"></script>
<script src="js/jquery.nav.js"></script>
<script src="js/tags.js"></script>
<script src="js/jquery.bxslider.min.js"></script>
<script src="js/custom.js"></script>
<!-- End js -->
</body>
</html>arkadaşlar sayfalama yapıyorum fakat sayfalama butonları yukarıdan aşağıya doğru iniyor yardım edermisiniz...