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();
