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();
}
