Lines Matching refs:sql

63         $sql     = "SELECT sum(value) FROM ratings WHERE page = ?";
64         $res     = $sqlite->query($sql, $ID);
68         $sql  = "SELECT value FROM ratings WHERE page = ? AND rater = ?";
69         $res  = $sqlite->query($sql, $ID, $this->userID());
95         $sql = "DELETE FROM ratings WHERE page = ?";
96         $res  = $sqlite->query($sql, $page);
113             $sql = $sqlbegin . $sqlend;
114             $res  = $sqlite->query($sql, $num);
116             $sql = $sqlbegin . "WHERE lang = ? " . $sqlend;
117             $res  = $sqlite->query($sql, $lang, $num);
119             $sql = $sqlbegin . "WHERE date >= ? " . $sqlend;
120             $res  = $sqlite->query($sql, $startdate, $num);
122             $sql = $sqlbegin . "WHERE lang = ? AND date >= ? " . $sqlend;
123             $res  = $sqlite->query($sql, $lang, $startdate, $num);
159 …   $sql = "INSERT OR REPLACE INTO ratings (page, rater, lang, date, value) VALUES (?, ?, ?, ?, ?)";
160         $sqlite->query($sql, $page, $this->userID(), $lang, $date, $rate);