public static function Add($conn, $params)
{
//peredelat Add nehvatilo vremeni ...
$q = "SELECT id FROM books WHERE books.name = '{$params['book_name']}'";
$res = $conn->query($q);
$zzz = $res->fetch_row();
if (count($zzz)) {
echo "Book already exist in database";
return;
}
if ($params['book_name'] == "") {
echo "Empty book name";
return;
}
if (Category::GetId($conn, $params['category']) < 0) {
$q = "INSERT INTO Categories (name) VALUES ('{$params['category']}')";
$conn->query($q);
}
if (Publisher::GetId($conn, $params['publisher_name']) < 0) {
$q = "INSERT INTO Publishers (name) VALUES ('{$params['publisher_name']}')";
$conn->query($q);
}
if (Author::GetId($conn, $params['author_name'], $params['author_surname'], $params['author_birthdate']) < 0) {
$q = "INSERT INTO Authors (name, surname, birthdate) " . "VALUES ('{$params['author_name']}', '{$params['author_surname']}', '{$params['author_birthdate']}')";
$conn->query($q);
}
$q = "INSERT INTO Books (name, pages, date, category_id, publisher_id) " . "VALUES ('{$params['book_name']}', '{$params['pages']}', '{$params['date']}', " . "(SELECT id FROM Categories WHERE Categories.name = '{$params['category']}'), " . "(SELECT id FROM Publishers WHERE Publishers.name = '{$params['publisher_name']}'))";
//echo $q;
$conn->query($q);
$q = "INSERT INTO BooksAuthors (book_id, author_id) VALUES (" . "(SELECT id FROM Books WHERE Books.name = '{$params['book_name']}'), " . "(SELECT id FROM Authors WHERE Authors.name = '{$params['author_name']}' AND " . "Authors.surname = '{$params['author_surname']}' AND " . "Authors.birthdate = '{$params['author_birthdate']}'))";
//echo $q;
$conn->query($q);
echo "Book was added in the database ";
//echo Category::GetId($conn, $params['category']);
//echo Publisher::GetId($conn, $params['publisher_name']);
//echo Author::GetId($conn, $params['author_name'], $params['author_surname'], $params['author_birthdate']);
}
