public static function getCareerByID($id) { $resRow = array(); $query_str = 'SELECT * FROM ' . Titles::$CAREER_TABLE_NAME . ' WHERE ' . Titles::$CAREER_ID . ' = ' . $id . ''; $conn = DBConnector::getConnection(); $resRow = $conn->query($query_str); $newList = $resRow->fetch(); return $newList; }
public static function registerClient($name, $surname, $email, $password, $card) { $dataBase = DBConnector::getConnection(); $card = self::getCardId($card); $sql = "INSERT INTO CLIENT (client_name, client_surname, client_email, client_password, card_id) VALUES ('{$name}', '{$surname}', '{$email}', '{$password}', '{$card}' )"; $result = $dataBase->query($sql); if ($result == 'true') { echo "Ваши данные успешно добавлены"; } else { echo $sql . '<br/>'; echo "Ваши данные не добавлены" . '<br/>'; var_dump($result); } }
private static function getLoginData() { $newList = array(); $conn = DBConnector::getConnection(); $resultSet = $conn->query('Select * From Admins'); if ($conn != null) { $i = 0; while ($row = $resultSet->fetch()) { $newList[$i][Titles::$USER_LOGIN] = $row['login']; $newList[$i][Titles::$USER_PASSWORD] = $row['password']; $i++; } } return $newList; }
public static function showAllArticles() { $dataList = array(); $resultSet = null; $query = 'SELECT * FROM ' . Titles::$ARTICLE_TABLE_NAME . ';'; $connection = DBConnector::getConnection(); $resultSet = $connection->query($query); if ($connection != null) { if ($resultSet != null) { $i = 0; } while ($row = $resultSet->fetch()) { $dataList[$i][Titles::$ARTICLE_TITLE] = $row[Titles::$ARTICLE_TITLE]; $dataList[$i][Titles::$ARTICLE_TEXT_DATA] = $row[Titles::$ARTICLE_TEXT_DATA]; $dataList[$i][Titles::$ARTICLE_PUBLICATION_DATE] = $row[Titles::$ARTICLE_PUBLICATION_DATE]; $i++; } } return $dataList; }
public static function getBooksList() { include_once src_path . '/classes/Book/Book.php'; $booksList = array(); $dataBase = DBConnector::getConnection(); $result = $dataBase->query('SELECT * from book ORDER BY book_id'); $i = 0; while ($row = $result->fetch()) { $booksList[$i]['book_id'] = $row['book_id']; $booksList[$i]['book_name'] = $row['book_name']; $booksList[$i]['author_id'] = $row['author_id']; $booksList[$i]['book_publish_date'] = $row['book_publish_date']; $booksList[$i]['genre_id'] = $row['genre_id']; // $booksList[$i]['book_location'] = $row['book_location']; // $booksList[$i]['book_creation'] = $row['book_creation']; // $booksList[$i]['book_update'] = $row['book_update']; $i++; } return $booksList; }
public function __construct() { $this->connection = DBConnector::getConnection(); }