function checkForError($query = null)
{
if (mysql_error()) {
// echo mysql_error();
// error_reporting(0);
// warning_reporting(0);
logSQLError($query, mysql_error());
// echo mysql_error();
die;
}
}
function deleteMovieDate($date)
{
$db = getDBConnection();
//date is always unique
$query = "DELETE from `moviedates` WHERE Date = :Date";
$statement = $db->prepare($query);
$statement->bindValue(':Date', $date);
$success = $statement->execute();
$statement->closeCursor();
if ($success) {
return $statement->rowCount();
} else {
logSQLError($statement->errorInfo());
}
}
function updateNewsItem($newsID, $headline, $content, $userID)
{
$db = getDBConnection();
$query = 'UPDATE news SET Headline = :Headline, Content = :Content, EditUserID = :EditUserID,
DateEdited = NOW() ' . 'WHERE NewsID = :NewsID';
$statement = $db->prepare($query);
$statement->bindValue(':Headline', $headline);
$statement->bindValue(':Content', $content);
$statement->bindValue(':EditUserID', $userID);
$statement->bindValue(':NewsID', $newsID);
//$statement->bindValue(':YouTubeLink', $youTube);
$success = $statement->execute();
$statement->closeCursor();
if ($success) {
return $statement->rowCount();
// Number of rows affected
} else {
logSQLError($statement->errorInfo());
// Log error to debug
}
}
function deleteRole($RoleID)
{
try {
$db = getDBConnection();
$query = "DELETE FROM roles WHERE RoleID = :RoleID";
$statement = $db->prepare($query);
$statement->bindValue(':RoleID', $RoleID);
$success = $statement->execute();
$statement->closeCursor();
if ($success) {
return $statement->rowCount();
// Number of rows affected
} else {
logSQLError($statement->errorInfo());
// Log error
}
} catch (PDOException $e) {
displayDBError($e->getMessage());
}
}
function updateAppleItem($appleID, $title)
{
$db = getDBConnection();
$query = 'UPDATE apple SET Title = :Title ' . 'WHERE AppleID = :AppleID';
$statement = $db->prepare($query);
$statement->bindValue(':AppleID', $appleID);
$statement->bindValue(':Title', $title);
$success = $statement->execute();
$statement->closeCursor();
if ($success) {
return $statement->rowCount();
// Number of rows affected
} else {
logSQLError($statement->errorInfo());
// Log error to debug
}
}
