public static function fetchAllDb()
{
global $logger;
$logger->LogDebug("Fetching all slider images ...");
$sliderImages = array();
$sql = "SELECT gi.* FROM bsi_slider_images ri INNER JOIN bsi_gallery_images gi ON ri.image_id = gi.id 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());
}
while ($row = mysql_fetch_assoc($query)) {
$sliderImage = SliderImage::fetchFromParameters($row);
$sliderImages[] = $sliderImage;
}
mysql_free_result($query);
return $sliderImages;
}
<?php
// TODO: Uncomment
include "access.php";
include_once "../includes/SystemConfiguration.class.php";
global $systemConfiguration;
global $logger;
$errors = array();
$message = "";
$imageId = 0;
$logger->LogInfo(__FILE__);
$logger->LogInfo(var_export($_POST, true));
$sliderImage = new SliderImage();
if (isset($_POST['id'])) {
$logger->LogInfo("Form has been submitted.");
$sliderImage = SliderImage::fetchFromParameters($_POST, $_FILES);
if (!$sliderImage->save()) {
$logger->LogError("Error saving slider image.");
foreach ($sliderImage->errors as $error) {
$logger->LogError($error);
$errors[] = $error;
}
} else {
header("Location: slider_images_list.php");
}
} else {
if (isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) {
$imageId = intval($_REQUEST['id']);
$logger->LogInfo("Page was called for image edit of slider image id: {$imageId}");
$sliderImage = SliderImage::fetchFromDb($imageId);
if ($sliderImage == null) {
