public static function fetchFromDbForUrl($url) { $sql = "SELECT * FROM bsi_site_contents WHERE url = '" . mysql_escape_string($url) . "' ORDER BY ord"; $query = mysql_query($sql); if (!$query) { global $logger; $logger->LogFatal("Error executing query: {$sql}"); $logger->LogFatal("Database error: " . mysql_errno() . ". Message: " . mysql_error()); die("Database error: " . mysql_errno() . ". Message: " . mysql_error()); } if ($row = mysql_fetch_assoc($query)) { $pageContents = PageContents::fetchFromParameters($row); return $pageContents; } else { PageContents::setStaticError("No page contents with url " . $url . " could be found."); return NULL; } }
<?php // TODO: Uncomment include "access.php"; include_once "../includes/SystemConfiguration.class.php"; global $systemConfiguration; global $logger; $errors = array(); $message = ""; $page = new PageContents(); $logger->LogInfo("PageContents:"); if (isset($_POST['SBMT_REG'])) { $logger->LogInfo("Form was submitted. Fetching from for parameters:"); $logger->LogInfo($_POST); $page = PageContents::fetchFromParameters($_POST); if (!$page->save()) { foreach ($page->errors as $error) { $errors[] = $error; } } else { $message = "Values were updated successfully!"; } } else { if (isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $logger->LogInfo("Initial request - fetching from for parameters:"); $id = intval($_REQUEST['id']); $page = PageContents::fetchFromDb($id); } } $defaultLanguage = Language::fetchDefaultLangauge(); $light = "#666666";