public static function getRandLessons($count) { $db = DBHelper::getConnection(); $result = $db->query("SELECT COUNT(*) max FROM lessons"); if (!empty($result)) { $result->setFetchMode(PDO::FETCH_ASSOC); $max = $result->fetch(); $max = $max["max"]; } else { $max = 0; } if ($count > $max) { $count = $max; } $ar_rang = array(); $ar_rand = range(1, $max); shuffle($ar_rand); $lessons = array(); for ($i = 0; $i < $count; $i++) { $result = $db->query("SELECT * FROM lessons WHERE ID={$ar_rand[$i]}"); if (!empty($result)) { $result->setFetchMode(PDO::FETCH_ASSOC); $lessons[$i] = $result->fetch(); } } return $lessons; }
public static function insertMessage($message) { $db = DBHelper::getConnection(); $subject = self::filterString($message["subject"]); $name = self::filterString($message["name"]); $email = self::filterString($message["email"]); $text = self::filterString($message["text"]); $data = array("subject" => $subject, "name" => $name, "email" => $email, "text" => $text); $query = $db->prepare("INSERT INTO guestbook (subject, name, email, text) VALUES (:subject, :name, :email, :text)"); $query->execute($data); return true; }
public static function addExtra($number, $name, $lessons, $text) { $db = DBHelper::getConnection(); $data = array("number" => $number, "name" => $name, "text" => $text); $queryExtra = $db->prepare("INSERT INTO extras (ID, name, text) VALUES (:number, :name, :text)"); $queryLessonsExtras = $db->prepare("INSERT INTO lessons_extras (id_lesson,id_extra) VALUES (:lesson, :extra)"); //Добавление записи материала $queryExtra->execute($data); //Добавление записей-связок с уроками foreach ($lessons as $lesson) { $data = array("lesson" => $lesson, "extra" => $number); $queryLessonsExtras->execute($data); } }
public static function getExtrasByLessonID($lessonID) { $db = DBHelper::getConnection(); $extras = array(); $result = $db->query("SELECT e.ID,e.name FROM extras e INNER JOIN lessons_extras le ON e.ID=le.id_extra INNER JOIN lessons l ON l.ID=le.id_lesson where l.ID=" . $lessonID . " ORDER BY e.ID"); if (!empty($result)) { $i = 0; $result->setFetchMode(PDO::FETCH_ASSOC); while ($row = $result->fetch()) { $extras[$i] = $row; $i++; } } return $extras; }
function assignToken($email, $password) { $matched = $this->credMatch($email, $password); if ($matched > 0) { $token = Util::guidv4(); } else { return 0; } $sql = "INSERT INTO Session (id, user_id, issued_time) VALUES (UNHEX(:token), :userId, NOW())\n ON DUPLICATE KEY UPDATE id = :token AND issued_time = now();"; try { $stmt = DBHelper::getConnection()->prepare($sql); $stmt->bindValue(":token", $token); if ($stmt->execute()) { return $token; } else { return -1; } } catch (PDOException $e) { return -1; } }
function __construct() { $this->conn = DBHelper::getConnection(); }