显示更多应用 [英] Show more applicaiton

问题描述

我正在尝试开发一个节目更多应用程序。一旦用户点击showmore按钮，然后应该显示新记录。但是当我执行代码时，总是列出相同的记录



我尝试了什么：



这是index.php

I m trying to develop a show More applicaiton.Once the user click "showmore" button then new records supposed to be displayed.But When I execute the code the same records are always listed

What I have tried:

this is index.php

<?php

$con = new PDO('mysql:host=localhost;dbname=testing', 'root', '');
$str = $con->query('select * from konu order by id desc limit 2');

?>
<div id="rows">
<?php
foreach ($str as $row) {
    $id = $row['id']; ?>
<div class="item" id="<?php echo $id; ?>"><?php echo $row['header']; ?></div>
	<?php
}

?>
</div>
<?php
?>





<div class="menu" id="menu_<?php echo $id; ?>">
<span class="show" id="<?php echo $id; ?>">Show More</span>
<span class="load" style="display:none">loading</span>

</div>

<?php
?>
</body>
</html>


<script>


$(document).ready(function(){
	
		$(document).on('click','.show',function(){

	
			var id=$(this).attr("id");
			
			$('.load').show();
			
			
		$.ajax({
				url:"ajax.php",
				method:"post",
				data:{id:id},
				success:function(e){
					
					$('#rows').append(e);

				}
		})
	})
})
</script>

这是ajax php

this is ajax php

<?php
$id = $_POST['id'];
$con = new PDO('mysql:host=localhost;dbname=testing', 'root', '');

$rtn = $con->query("select * from konu where id < '".$id."' order by id desc limit 2");

foreach ($rtn as $row) {
    ?>
<div class="item" id="<?php echo $row['id']; ?>"><?php echo $row['baslik']; ?></div>
<?php
}

推荐答案

con = new PDO（'mysql：host = localhost; dbname = testing'，'root'，''）;

con = new PDO('mysql:host=localhost;dbname=testing', 'root', '');

str =

con> query（'select * from konu order by id desc limit 2'）;

？>
< div id =rows>
<？php
foreach（

con->query('select * from konu order by id desc limit 2'); ?> <div id="rows"> <?php foreach (

这篇关于显示更多应用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！