/**
* Inserts a row inte the table pubs
*
* @param Pub $pub
* @throws \DataBaseException
* @throws \Exception
*/
public function addPub(Pub $pub)
{
try {
$stmt = $this->conn->prepare("INSERT INTO " . self::$table . " VALUES(?, ?, ?, ?)");
if (!$stmt) {
throw new \DataBaseException($this->conn->error);
}
$id = $pub->getId();
$name = $pub->getName();
$address = $pub->getAddress();
$webpage = $pub->getWebpageURL();
$stmt->bind_param("ssss", $id, $name, $address, $webpage);
$stmt->execute();
} catch (\DataBaseException $e) {
if (\Settings::DEBUG_MODE) {
throw $e;
} else {
error_log($e->getMessage() . "\n", 3, \Settings::ERROR_LOG);
echo "Something went wrong when connecting to the database";
die;
}
}
}