hocam get ile yerine post yapsak daha sağlıklı olur mu örneğin ;
<script type="text/javascript">
$(document).ready(function(){
$(document).on('click','.show_more',function(){
var ID = $(this).attr('id');
$('.show_more').hide();
$('.loding').show();
$('.loding').append('<center><img src="img/loading.gif"></center>');
$.ajax({
type:'POST',
url:'ajaxam/ajax_haber.php',
data:'id='+ID,
success:function(html){
$('#show_more_main'+ID).remove();
$('.timeline-items').append(html);
}
});
});
});
</script>gibi yazsak ondan sonra onu başka bir ajax içinde çeksek diyorum çünkü orada problem yaşıyorum zaten. aşağıdaki kodları ne gibi problem yaşıyorum çözemedim ajax_haber.php içindeki böyle
<?php
require '.../includes/config.php';
if(isset($_POST["id"])){
$get_id = strip_tags($_POST['id']);
$query = $db->query("SELECT COUNT(*) as num_rows FROM posts INNER JOIN categories ON categories.category_id = posts.p_categories WHERE p_status = '1' && p_id < ".$get_id." ORDER BY p_id DESC")->fetch(PDO::FETCH_ASSOC);
$row = $query->fetch_assoc();
$totalRowCount = $row['num_rows'];
$showLimit = 2;
$query = $db->prepare("SELECT * FROM posts WHERE INNER JOIN categories ON categories.category_id = posts.p_categories WHERE p_status = '1' && p_id < ".$get_id." ORDER BY p_id DESC LIMIT ".$showLimit." ");
$query->execute();
if($query->rowCount() > 0){
while($row = $query->fetch(PDO::FETCH_ASSOC)){
$id = $row['p_id'];
$date = getdate($row['p_date']);
$day = $date['mday'];
$month = $date['month'];
$year = $date['year'];
$title = $row['p_title'];
$author = $row['p_author'];
$author_image = $row['p_author_image'];
$image = $row['p_image'];
$categories = $row['p_categories'];
$tags = $row['p_tags'];
$post_data = $row['p_post'];
$views = $row['p_views'];
$status = $row['p_status'];
$post_id = $id;
$ing_aylar = array("January","February","March","May","April","June","July","August","September","October","November","December");
$tr_aylar = array("Ocak","Şubat","Mart","Nisan","Mayıs","Haziran","Temmuz","Ağustos","Eylül","Ekim","Kasım","Aralık");
$ing_gunler = array("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday");
$tr_gunler = array("Pazartesi","Salı","Çarşamba","Perşembe","Cuma","Cumartesi","Pazar");
$month = str_replace($ing_aylar,$tr_aylar,$month);
$day = str_replace($ing_gunler,$tr_gunler,$day);
?>
<div class="col-12 timeline-items" id="<?=$post_id?>">
<div class="post-block-style">
<div class="row ts-gutter-20 align-items-center">
<div class="col-md-6">
<div class="post-thumb">
<a href="<?php echo $row["p_seolink"]; ?>">
<?php if(!empty($image) > 0){ ?>
<img src="images/news/<?php echo $image;?>" width="100%" height="100%" title="<?php echo $title;?>" alt="Manset Fotoğrafı">
<?php } else { ?>
<img src="images/resimYok.jpg" width="850" height="100%" title="<?php echo $title;?>" alt="Manset Fotoğrafı">
<?php } ?>
</a>
</div>
</div>
<div class="col-md-6">
<div class="post-content">
<a class="post-cat tech" href="kategori/<?php echo $row["category_url"]; ?>" title="<?php echo $row['category_title']; ?>"><?php echo $row['category_title']; ?></a>
<h2 class="post-title title-md" title="<?php echo $title;?>">
<a href="<?php echo $row["p_seolink"]; ?>"><?php echo $title;?></a>
</h2>
<div class="post-meta mb-7">
<span class="post-author">
<?php if(!empty($author)){ ?>
<a href="#" title="Yazar: <?php echo ucfirst($author);?>"><i class="fa fa-user"></i> <?php echo ucfirst($author);?></a>
<?php } else { ?>
<a href="#" title="Yazar: Patiliyoruz Ekibi"><i class="fa fa-user"></i> Patiliyoruz Ekibi</a>
<?php } ?>
</span>
<span class="post-date"><i class="fa fa-clock-o"></i> <?php echo $day;?> <?php echo $month;?> <?php echo $year;?></span>
</div>
<?php
$uzunluk = strlen($post_data);
$limit = 150;
if ($uzunluk > $limit) {
?>
<p><?php echo substr($post_data,0,$limit) . "...";?></p>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
<?php
}
}
else{
echo "<div align='center'><b>Hiçbir Haber Yazısı Mevcut Değil :(</b></div>";
}
?>
<?php if($all_Rows > $showLimit){?>
<div class="col-12 show_more_main" id="show_more_main<?php echo $post_id; ?>">
<div class="load-more-btn text-center">
<button id="<?php echo $post_id;?>" class="btn show_more">Daha Fazla Göster</button>
</div>
<center>
<span class="loding" style="display: none;"></span>
</center>
</div><!-- tab content -->
<?php } ?>
<?php
}
?>index.php içindeki kod satırı böyle şuanda
<?php
define("INDEX", true);
include 'pages/header.php';
?>
<!-- Site Title -->
<title><?php echo $ayarcek["s_title"]; ?> - <?php echo $ayarcek["s_slogan"]; ?></title>
<?php include 'pages/slider.php';
?>
<section class="block-wrapper">
<div class="container">
<div class="row ts-gutter-30">
<div class="col-lg-8 col-md-12">
<h2 class="block-title">
<span class="title-angle-shap"><i class="far fa-newspaper"></i> Haberler</span>
</h2>
<div class="row ts-gutter-30">
<?php
$query = $db->prepare("SELECT * FROM posts INNER JOIN categories ON categories.category_id = posts.p_categories WHERE p_status = '1' ORDER BY p_id DESC LIMIT 1,6");
$query->execute();
if($query->rowCount() > 0){
while($row = $query->fetch(PDO::FETCH_ASSOC)){
$id = $row['p_id'];
$date = getdate($row['p_date']);
$day = $date['mday'];
$month = $date['month'];
$year = $date['year'];
$title = $row['p_title'];
$author = $row['p_author'];
$author_image = $row['p_author_image'];
$image = $row['p_image'];
$categories = $row['p_categories'];
$tags = $row['p_tags'];
$post_data = $row['p_post'];
$views = $row['p_views'];
$status = $row['p_status'];
$post_id = $id;
$ing_aylar = array("January","February","March","May","April","June","July","August","September","October","November","December");
$tr_aylar = array("Ocak","Şubat","Mart","Nisan","Mayıs","Haziran","Temmuz","Ağustos","Eylül","Ekim","Kasım","Aralık");
$ing_gunler = array("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday");
$tr_gunler = array("Pazartesi","Salı","Çarşamba","Perşembe","Cuma","Cumartesi","Pazar");
$month = str_replace($ing_aylar,$tr_aylar,$month);
$day = str_replace($ing_gunler,$tr_gunler,$day);
?>
<div class="col-12 timeline-item" id="<?=$post_id?>">
<div class="post-block-style">
<div class="row ts-gutter-20 align-items-center">
<div class="col-md-6">
<div class="post-thumb">
<a href="<?php echo $row["p_seolink"]; ?>">
<?php if(!empty($image) > 0){ ?>
<img src="images/news/<?php echo $image;?>" width="100%" height="100%" title="<?php echo $title;?>" alt="Manset Fotoğrafı">
<?php } else { ?>
<img src="images/resimYok.jpg" width="850" height="100%" title="<?php echo $title;?>" alt="Manset Fotoğrafı">
<?php } ?>
</a>
</div>
</div>
<div class="col-md-6">
<div class="post-content">
<a class="post-cat tech" href="kategori/<?php echo $row["category_url"]; ?>" title="<?php echo $row['category_title']; ?>"><?php echo $row['category_title']; ?></a>
<h2 class="post-title title-md" title="<?php echo $title;?>">
<a href="<?php echo $row["p_seolink"]; ?>"><?php echo $title;?></a>
</h2>
<div class="post-meta mb-7">
<span class="post-author">
<?php if(!empty($author)){ ?>
<a href="#" title="Yazar: <?php echo ucfirst($author);?>"><i class="fa fa-user"></i> <?php echo ucfirst($author);?></a>
<?php } else { ?>
<a href="#" title="Yazar: Patiliyoruz Ekibi"><i class="fa fa-user"></i> Patiliyoruz Ekibi</a>
<?php } ?>
</span>
<span class="post-date"><i class="fa fa-clock-o"></i> <?php echo $day;?> <?php echo $month;?> <?php echo $year;?></span>
</div>
<?php
$uzunluk = strlen($post_data);
$limit = 150;
if ($uzunluk > $limit) {
?>
<p><?php echo substr($post_data,0,$limit) . "...";?></p>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
<?php
}
}
else{
echo "<div align='center'><b>Hiçbir Haber Yazısı Mevcut Değil :(</b></div>";
}
?>
<div class="col-12 show_more_main" id="show_more_main<?php echo $post_id; ?>">
<div class="load-more-btn text-center" id="<?php echo $post_id;?>">
<button class="btn">Daha Fazla Göster</button>
</div>
<center>
<span class="loding" style="display: none;"></span>
</center>
</div><!-- tab content -->
</div>
</div>
<?php include 'pages/sidebar.php'; ?>
</section><!-- First block end -->
<?php include 'pages/footer.php'; ?>