function updateBooks($db, $bookId, $bookName, $bookNotes, $bookCollections, $bookAthors)
{
//echo '<pre>'.print_r($bookCollections, true).'</pre>';
//echo '<pre>'.print_r($bookAthors, true).'</pre>';
if (strlen($bookName) <= 0 && $bookId <= 0 && (is_array($bookCollections) && is_array($bookAthors))) {
return false;
}
// update book title and book notes
if (!($stmtUpdate = $db->prepare("UPDATE books SET book_title = '" . $bookName . "', notes = " . ($bookNotes == "NULL" ? "NULL" : "'" . $bookNotes . "'") . " WHERE book_id=" . $bookId))) {
echo "Prepare update with book_title and notes failed: (" . $db->errno . ") " . $db->error;
return false;
}
if (!$stmtUpdate->execute()) {
echo "Execute update book failed: (" . $stmtUpdate->errno . ") " . $stmtUpdate->error;
return false;
}
if (count($bookCollections) > 0 || count($bookAthors) > 0) {
// for update of relations in books_authors we need to delete old records and insert the new ones
if (deleteRelationBookAuthorCollection($db, $bookId) === true) {
$results = insertRelationBookAuthorCollection($db, $bookId, $bookAthors, $bookCollections);
if (count($results) <= 0) {
echo "Error on insert in books_authors.";
return false;
}
} else {
echo "Error on delete books_authors.";
return false;
}
}
return true;
}
$selectedCollectionIds[] = (int) $multiCollectionId;
}
}
if (count($errMsg) > 0) {
foreach ($errMsg as $err) {
echo $err . '</ br>';
}
} else {
mysqli_autocommit($db, FALSE);
$newBookId = insertBooks($db, $bookName, $bookNotes);
if ($newBookId === false) {
echo 'Грешка при въвеждане на книга!';
mysqli_rollback($db);
} else {
$insertedIds = array();
$insertedIds = insertRelationBookAuthorCollection($db, $newBookId, $selectedAuthorIds, $selectedCollectionIds);
if (count($insertedIds) > 0 && $insertedIds !== false) {
echo 'Успешен запис на книга.';
mysqli_commit($db);
mysqli_autocommit($db, TRUE);
} else {
echo 'Грешка!';
mysqli_rollback($db);
mysqli_autocommit($db, TRUE);
header('Location: index.php');
exit;
}
}
}
}
?>
