仅显示前5项结果 [英] Showing only the top 5 results

问题描述

对不起，我是在垃圾邮件，但我愿意学习。

我创建我的网站此处

并创建一个名为更多。

在此页面中，我要添加一个我的前5促销我的网站。每个促销都保存在我的mobi数据库中的mysql和我已经添加了一个计数，每次有人在我的single.php页面上查看特定促销。

基本上。我需要做的是在我的mobi数据库中的视图字段中显示最高数字的5个促销。

我目前有这些代码：

  include_once（'include / connection.php'）; 
 include_once（'include / article.php'）; 
  

和

 <？php foreach（$ articles as $ article）{？> 
 
< a href =list.php？id =<？php echo $ article ['promo_title'];？>> <？php echo $ article ['promo_title']; ？> < / a> 
  

in more.php以及

 类视图{
 public function fetch_all（）{
 global $ pdo; 
 
 $ query = $ pdo-> prepare（SELECT * FROM mobi ORDER BY views DESC LIMIT 0，5）; 
 $ query-> execute（）; 
 
 return $ query-> fetch（）; 
 
} 
 
} 
  

php只加载一些奇怪的文本tttthhwwdddd 3 3

我想我需要广告一些数组，但我不知道如何输入。

有人可以告诉我如何？

谢谢。

< fetch（）应该更改为fetchAll（）

 类视图
 {
 public function fetch_all（）
 {
全局$ pdo; 
 
 $ query = $ pdo-> prepare（SELECT * FROM mobi ORDER BY views DESC LIMIT 0，5）; 
 $ query-> execute（）; 
 
 return $ query-> fetchAll（）; 
 
} 
} 
  

添加

 <？php foreach（$ articles as $ article）{？> 
 
< a href =list.php？id =<？php echo $ article ['promo_title'];？>> 
<？php echo $ article ['promo_title']; ？> < / a> 
<？php}？> 
  

并且检查返回结果集的代码并将其发送到article.php

Sorry, I'm rubbish at php but I am willing to learn.

I'm creating my website found here

and am creating a page called more.

Within this page I want to add a list of my top 5 promotions on my site. Each promotion is saved in my mobi database in mysql and I have added a count for each time someone views a particular promotion on my single.php page.

So basically. What I need to do is display 5 promotions with the highest number in the "views" field in my mobi database.

I currently have these codes:

include_once('include/connection.php');
include_once('include/article.php');

and

<?php foreach ($articles as $article) { ?>

<a href="list.php?id=<?php echo $article['promo_title']; ?>"> <?php echo $article['promo_title']; ?> </a>

in more.php and also

class views {
public function fetch_all(){
   global $pdo;

 $query = $pdo->prepare("SELECT * FROM mobi ORDER BY views DESC LIMIT 0, 5");
   $query->execute();

return $query->fetch(); 

}

}

in articles.php which only loads some weird text of "t t t t h h w w d d d d 3 3"

I think I need to ad an array of some sort but I'm not sure how to type it.

Please can someone advise me on how?

thank you.

解决方案

fetch() should be changed to fetchAll()

 class views
 {
    public function fetch_all()
    {
      global $pdo;

      $query = $pdo->prepare("SELECT * FROM mobi ORDER BY views DESC LIMIT 0, 5");
      $query->execute();

      return $query->fetchAll(); 

    }
 }

and foreach closing bracket should also be added

<?php foreach ($articles as $article) { ?>

<a href="list.php?id=<?php echo $article['promo_title']; ?>">
<?php echo $article['promo_title']; ?> </a>
 <?php } ?>

And also check the code where you are returning the result set and sending it to the article.php

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