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']); }