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 . ')'); if (mysqli_error($link)) { echo 'error'; } } echo '<p>Книгата е добавена</p>'; } } //$data=array(); $authors = getAllAuthors($link); if ($authors === false) { echo 'грешка'; } $title = 'Нова Книга'; $data = $authors; render($data, './view/view_newbook.php');
} asort($editors); foreach ($editors as $uid => $fullname) { $slct = selected('approver', $uid); echo "<option value='{$uid}' {$slct}>{$fullname}</option>"; } ?> </select> <input type="submit" value="Filter approver"> </form> <form method="get" action="allpuzzles.php" class="inlform"> <input type="hidden" name="filterkey" value="author"> <select name="filtervalue"> <option value='-'>-</option> <?php $authors = getAllAuthors(); asort($authors); foreach ($authors as $uid => $fullname) { $slct = selected('author', $uid); echo "<option value='{$uid}' {$slct}>{$fullname}</option>"; } ?> </select> <input type="submit" value="Filter author"> </form> <form method="get" action="allpuzzles.php" class="inlform"> <input type="hidden" name="filterkey" value="tag"> <select name="filtervalue"> <option value='-'>-</option> <?php $tags = getAllTags();