include_once("dbConnection.php");
#Select content to display
$sql99 = "select a.content from xos_CMS a where a.status = 1 and a.CMS_ID = " . $CMS_ID;
#prepare and execute sql
$SQL_OBJ99 = $db->prepare($sql99);
$SQL_OBJ99->execute();
$rsCMS = $SQL_OBJ99->fetch();
$displayContent = $rsCMS["content"];
//replace variable data
if(isSet($_SESSION['advisor_preLogin_student_firstName']))
{
$displayContent = str_replace('[advisor_preLogin_student_firstName]',$_SESSION['advisor_preLogin_student_firstName'] ,$displayContent);
}
if(isSet($_SESSION['advisor_preLogin_student_lastName']))
{
$displayContent = str_replace('[advisor_preLogin_student_lastName]',$_SESSION['advisor_preLogin_student_lastName'] ,$displayContent);
}
$displayContent = str_replace('[price]',$_SESSION['price'] ,$displayContent);
echo($displayContent);
?>
Already have an account?
Sign in here.