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