只显示10条记录,然后一个按钮也显示所有记录

6ss1mwsb  于 2021-06-25  发布在  Mysql
关注(0)|答案(1)|浏览(396)

我想知道如何限制显示的记录,例如限制为10,然后他们需要一个按钮来获取所有的主题。我想知道怎么用那种方式展示它
功能代码:

  1. public function get_topics(){
  2. $getTopic = $this->database->query("
  3. SELECT topics.*, klanten.foto, klanten.voornaam, boards.topic, ledenpagina.ledenpagina_id, klanten.achternaam FROM topics
  4. LEFT JOIN ledenpagina ON ledenpagina.ledenpagina_id = topics.ledenpagina_id
  5. LEFT JOIN klanten ON topics.klant_id=klanten.id
  6. LEFT JOIN boards ON topics.board_id=boards.id
  7. WHERE ledenpagina.ledenpagina_id=:ledenpagina_id
  8. ORDER BY id ASC");
  9. $this->database->bind(":ledenpagina_id", $_SESSION['ledenpagina_id']);
  10. $topics = $this->database->resultset();
  11. return $topics;
  12. }

php代码:

  1. <section class="col-md-8 connectedSortable">
  2. <div class="clearfix paddingbottom10"></div>
  3. <div class="box box-info">
  4. <div class="panel panel-default">
  5. <div class="panel-heading main-color-bg">
  6. <h3 class="panel-title">Topics</h3>
  7. </div>
  8. div class="panel-body">
  9. <?php
  10. $toppic = $app->get_topics();
  11. foreach($toppic as $topic){
  12. echo '<a href="https://####/reactie"> <div id="topic">';
  13. echo '<div id="topicimg">';
  14. if(file_exists('assets/images/profielfotos/'.$topic['klant_id'])) {
  15. echo '<img class="img-circle" src="/assets/images/profielfotos/'.$topic['klant_id'].'/'.$topic['foto'].'" />';
  16. } else {
  17. echo '<i class="fa fa-fw fa-user img-circle"></i>';
  18. }
  19. echo '</div><div id="topictekst">';
  20. echo '<b>'.$topic['topicnaam'].'</b>';
  21. echo ' - ' . $topic['voornaam'] . " " . $topic['achternaam'] ;
  22. echo '<span style="float:right; margin-top:15px; margin-left:5px;">'.implode($app->count_reactie($topic['id'])) .' reacties</span> <span style="float:right; color:lightgrey; margin-top:15px"class="fa fa-comment"></span>';
  23. echo '<hr><span class="badge bg-red">' . implode($app->boards($topic['board_id'])) . '</span>';
  24. echo ' laatste reactie: ' .$app->tijd_reactie($topic['id']) . ' door ' .$app->reactieDoor($topic['id']);
  25. echo '</div></div></a>';
  26. }
  27. ?>
  28. </div>
  29. </div>
  30. /div><!-- /.box -->
  31. </section><!-- right col -->

这是我的第一个问题,所以请不要对我太苛刻

bjp0bcyl

bjp0bcyl1#

sql分页可以通过orderby子句的新特性实现,比如offset和fetchnext
下面是一个示例查询

  1. SELECT * FROM TableName ORDER BY ID OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY

如果将偏移量计数参数化为(页码*页行计数),则可以为网页构建分页结构

相关问题