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}");