include 'include/function.php';
if ($_POST) {
$book_name = trim($_POST['book_name']);
if (!isset($_POST['authors'])) {
$_POST['authors'] = '';
}
$authors = $_POST['authors'];
$error = array();
if (mb_strlen($book_name) < 3) {
$error[] = '<p>Името е прекалено късо!</p>';
}
if (!is_array($authors) || count($authors) === 0) {
$error[] = '<p>Невалидни автори<p>';
}
if (!idAuthorExist($link, $authors)) {
$error[] = '<p>Невалиден автор</p>';
}
if (count($error) > 0) {
foreach ($error as $er) {
echo '<p>' . $er . '</p>';
}
} else {
$book_name = mysqli_real_escape_string($link, $book_name);
mysqli_query($link, 'INSERT INTO books (book_name) VALUE ("' . $book_name . '")');
if (mysqli_error($link)) {
echo mysqli_error($link);
}
$id = mysqli_insert_id($link);
foreach ($authors as $author_id) {
mysqli_query($link, 'INSERT INTO books_authors (book_id,author_id) VALUE (' . $id . ',' . $author_id . ')');
<?php
session_start();
$title = 'Книги от автор';
include './include/function.php';
if (isset($_GET['author_id'])) {
$author_id = (int) $_GET['author_id'];
if (!idAuthorExist($link, $author_id)) {
$q = mysqli_query($link, 'SELECT * FROM `books_authors` as ba ' . 'INNER JOIN books as b ON ba.book_id=b.book_id ' . 'INNER JOIN books_authors as bba ON bba.book_id=ba.book_id ' . 'INNER JOIN authors as a ON bba.author_id=a.author_id where ba.author_id=' . $author_id);
if (mysqli_error($link)) {
echo 'Невалидно име на автор!';
echo mysqli_error($link);
}
$data = array();
while ($row = mysqli_fetch_assoc($q)) {
$data[$row['book_id']]['book_name'] = $row['book_name'];
$data[$row['book_id']]['authors'][$row['author_id']] = $row['author_name'];
}
render($data, './view/view_authorbooks.php');
} else {
echo '<p>Невалиден автор</p>';
}
} else {
header('Location:index.php?page=books');
exit;
}
