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();
