public static function fetchFromDb($roomId, $imageId)
{
global $logger;
$logger->LogDebug("Fetching all room images for room id: {$roomId}");
$sql = "SELECT ri.*, gi.* FROM bsi_room_images ri INNER JOIN bsi_gallery_images gi ON ri.image_id = gi.id WHERE ri.room_id = {$roomId} AND image_id = {$imageId} ORDER BY gi.display_order";
$query = mysql_query($sql);
if (!$query) {
$logger->LogFatal("Database error: " . mysql_errno() . ". Message: " . mysql_error());
$logger->LogError("SQL: " . $sql);
die("Database error: " . mysql_errno() . ". Message: " . mysql_error());
}
if ($row = mysql_fetch_assoc($query)) {
$roomImage = RoomImage::fetchFromParameters($row);
return $roomImage;
}
mysql_free_result($query);
return null;
}
<?php
// TODO: Uncomment
include "access.php";
include_once "../includes/SystemConfiguration.class.php";
global $systemConfiguration;
global $logger;
$errors = array();
$message = "";
$roomId = 0;
$imageId = 0;
$roomImage = new RoomImage();
if (isset($_POST['SBMT_REG'])) {
$logger->LogInfo("Form has been submitted.");
$roomImage = RoomImage::fetchFromParameters($_POST, $_FILES);
$logger->LogInfo("Image retrieved.");
if (is_null($roomImage) || !$roomImage->save()) {
$logger->LogError("Error saving room image.");
foreach ($roomImage->errors as $error) {
$logger->LogError($error);
$errors[] = $error;
}
} else {
$message = "Values were updated successfully!";
header("Location: room_images_list.php?room_id=" . $roomImage->roomId);
}
} else {
if (isset($_REQUEST['room_id']) && is_numeric($_REQUEST['room_id']) && isset($_REQUEST['image_id']) && is_numeric($_REQUEST['image_id'])) {
$roomId = intval($_REQUEST['room_id']);
$imageId = intval($_REQUEST['image_id']);
$logger->LogInfo("Page was called for image edit of room id: {$roomId} and image id: {$imageId}");
