static function add_author($host, $db_user, $db_password, $db_name, $author_firstname, $author_surname)
{
//returns id of author, adds new record if necessary
$connection = @new mysqli($host, $db_user, $db_password, $db_name);
if ($connection->connect_errno != 0) {
//echo "Error: ".$connection->connect_errno;
} else {
if (($author_id = LibraryManager::try_author($connection, $author_firstname, $author_surname)) > 0) {
//echo "AUTHOR $author_firstname $author_surname ALREADY IN THE DATABASE WITH ID $author_id<br></br>";
return $author_id;
} else {
$sql = "INSERT INTO author (id, firstname, surname) VALUES (NULL, '{$author_firstname}', '{$author_surname}')";
if ($received_data = @$connection->query($sql)) {
$author_id = @$connection->insert_id;
//echo "AUTHOR $author_firstname $author_surname ADDED TO THE DATABASE WITH ID $author_id<br></br>";
return $author_id;
} else {
//echo "WRONG QUERY! <br></br>";
return 0;
}
}
$connection->close();
//echo "CONNECTION CLOSED ";
}
}
