php - 我如何获得特定用户的最后 7 个投注单 (BetSlipID)

Question

我当前的代码显示最近 7 天的投注单，但我需要显示最近 7 天的投注单，无论日期如何。

select 
  betsliphistory.MatchID,Team1.Name as HomeTeam ,
  Team2.Name as AwayTeam, BetSlipID , userid , TipID , 
  matches.ResultTipID ,betsliphistory.`Date`
from betsliphistory
inner join matches on betsliphistory.MatchID = matches.MatchID
inner join teams as Team1 on matches.HomeTeamID = Team1.TeamID
inner join teams as Team2 on matches.AwayTeamID = Team2.TeamID
where userid =".$user." 
  and betsliphistory.`Date` between CURDATE()-7 and CURDATE() 
order by BetSlipID , MatchID;

Answer 1

but I need to show last 7 bet slips regardless of the date.

• 从 WHERE 子句中删除日期条件。

• 将 ORDER By BetSlipID DESC 和 LIMIT 7 用于前 7 个 BetSlipID，如下所示:

   ... -- Your current query
   WHERE userid = ".$user." 
   ORDER BetSlipID  DESC
   LIMIT 7;
  

请注意:您以这种方式编写的代码容易受到 SQL Injection 的攻击.请改用 PDO 或准备好的语句。有关更多详细信息，请参见:

• PHP: Best way to prevent SQL injection? .