Library (database version)
Displaying id ',intval(filter_input(INPUT_GET, "bookid", FILTER_VALIDATE_INT)),' :';
$SelectString = 'SELECT * FROM farlelibraryNew WHERE id='.$_GET["bookid"];
$Ergebnis=mysqli_query($mysqli,$SelectString);
$db_output=mysqli_fetch_assoc($Ergebnis);
if($db_output)
{
echo '';
echo '
';
}
else echo 'Database not existing!';
}
else echo 'Database issue!
';
mysqli_close($mysqli);
}
else echo 'Parameter error !';
?>
| Parameter | Value'; echo ' | '; echo '
|---|---|
| ',' | '; echo ''; echo ' | '; echo '
| Author | ','',$db_output["author"],' | '; echo '
| Title | ','',$db_output["title"],' | '; echo '
| Publishing company | ','',$db_output["publisher"],' | '; echo '
| Year | ','',$db_output["year"],' | '; echo '
| ISBN | ','',$db_output["isbn"],' | '; echo '
| Primo-Code | ','',$db_output["happcode"],' | '; echo '
| Category | ','',$db_output["category"],' | '; echo '
| Keywords | ','',$db_output["keyword"],' | '; echo '
| Property | ','',$db_output["property"],' | '; echo '
| Status | ',''; if(strlen($db_output["lender"])==0 && strlen($db_output["lender_contact"])==0 ) { echo 'Entleihbar'; echo ' |
| Lender | ','',$db_output["lender"],' | '; echo '
| Lending date | ','',$db_output["lending_date"],' | '; echo '
| Location | ','',$db_output["location"],' | '; echo '
| Last change | ','',$db_output["change_date"],' by IP ',$db_output["change_ip"],' | '; echo '
| Timestamp | ','',$db_output["timestamp"],' | '; echo '
| ';
echo ' '; echo ''; echo ' | ';
echo '(conditional function!) | '; echo '