public static function fetchFromDbForCode($emailContentsCode) { EmailContents::$staticErrors = array(); $sql = "SELECT * FROM bsi_email_contents WHERE trim(lower(email_code)) = '" . strtolower(trim(mysql_escape_string($emailContentsCode))) . "'"; $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)) { $emailContents = EmailContents::fetchFromParameters($row); return $emailContents; } else { EmailContents::setStaticError("Email contents with code: " . $emailContentsCode . " does not exist."); return null; } }
<?php // TODO: Uncomment include "access.php"; include_once "../includes/SystemConfiguration.class.php"; include "header.php"; global $systemConfiguration; global $logger; $errors = array(); $message = ""; $emailContents = new EmailContents(); if (isset($_POST['SBMT_REG'])) { $logger->LogInfo("Form was submitted."); $emailContents = EmailContents::fetchFromParameters($_POST); if (!$emailContents->save()) { $logger->LogError("Email contents failed to save."); foreach ($emailContents->errors as $error) { $logger->LogError($error); $errors[] = $error; } } else { $message = "Values were updated successfully!"; } } else { if (isset($_REQUEST['id']) && is_numeric($_REQUEST['id'])) { $logger->LogInfo("Form was called with id: " . $_REQUEST['id']); $id = intval($_REQUEST['id']); $emailContents = EmailContents::fetchFromDb($id); } } $defaultLanguage = Language::fetchDefaultLangauge();