/** * @param string $date * @param int $value * @return bool */ public function setValue($date, $value) { $stmt = Database::get()->prepare('INSERT INTO luckyNumbers (date, value) VALUES (:date, :value) ON DUPLICATE KEY UPDATE value=:value'); $stmt->bindParam(':date', $date, PDO::PARAM_STR); $stmt->bindParam(':value', $value, PDO::PARAM_INT); return $stmt->execute(); }
/** * Updates bells * @param array $value * @return bool */ public function set($value) { $stmt = Database::get()->prepare('UPDATE bells SET value=:value LIMIT 1'); $stmt->bindValue(':value', json_encode($value)); $stmt->execute(); return $stmt->rowCount() > 0; }
public function delete($class) { $stmt = Database::get()->prepare('DELETE FROM timetables WHERE class=:class'); $stmt->bindParam(':class', $class); $stmt->execute(); return $stmt->rowCount() > 0; }
/** * @param string $name * @param string $value * @return bool True if success */ public function setValue($name, $value) { $stmt = Database::get()->prepare('INSERT INTO settings (name, value) VALUES (:name, :value) ON DUPLICATE KEY UPDATE value=:value'); $stmt->bindParam(':name', $name, PDO::PARAM_STR); $stmt->bindParam(':value', $value, PDO::PARAM_STR); return $stmt->execute(); }
/** * @param int $pageId * @param int $limit * @return array */ public static function getStatistics($pageId, $limit) { $stmt = Database::get()->prepare('SELECT date, version, count(*) AS uniqueVisits, sum(count) AS visits FROM statistics WHERE pageId=:pageId GROUP BY date, version ORDER BY date DESC, version DESC LIMIT :limit'); $stmt->bindParam(':pageId', $pageId, \PDO::PARAM_INT); $stmt->bindParam(':limit', $limit, \PDO::PARAM_INT); $stmt->execute(); return $stmt->fetchAll(PDO::FETCH_CLASS, 'pjanczyk\\lo1olkusz\\Model\\Statistic'); }
/** * @param string $class * @param string $date * @param int $value * @return bool */ public function setValue($class, $date, $value) { $stmt = Database::get()->prepare('INSERT INTO replacements (class, date, value) VALUES (:class, :date, :value) ON DUPLICATE KEY UPDATE value=:value'); $stmt->bindParam(':class', $class, PDO::PARAM_STR); $stmt->bindParam(':date', $date, PDO::PARAM_STR); $stmt->bindValue(':value', json_encode($value), PDO::PARAM_STR); return $stmt->execute(); }