Lines Matching refs:month
58 $month = date('Ym');
60 $sql = "INSERT OR REPLACE INTO toppages (page, value, lang, month)
61 VALUES ( ?, COALESCE( (SELECT value FROM toppages WHERE page = ? and month = ? ) + 1, 1), ?, ?)";
62 $res = $this->sqlite->query($sql, $page, $page, $month, $lang, $month);
70 * @param string|null $month
74 public function best($lang, $month, $num = 10)
78 if ($lang === null && $month === null){
81 } elseif ($lang !== null && $month === null) {
84 } elseif ($lang === null && $month !== null){
85 $sql = $sqlbegin . "WHERE month >= ? " . $sqlend;
86 $res = $this->sqlite->query($sql, intval($month), $num);
88 $sql = $sqlbegin . "WHERE lang = ? AND month >= ? " . $sqlend;
89 $res = $this->sqlite->query($sql, $lang, intval($month), $num);