";print_r($_REQUEST);die; $template_title=mysqli_real_escape_string($GLOBALS['conn'],$_POST['template_title']); $email_subject=mysqli_real_escape_string($GLOBALS['conn'],$_POST['email_subject']); $email_content=mysqli_real_escape_string($GLOBALS['conn'],$_POST['email_content']); $template_type_id=mysqli_real_escape_string($GLOBALS['conn'],$_POST['template_type_id']); if($_REQUEST['submitForm']=='yes'){ if($_REQUEST['id']==''){ //$coupon_code=generateCouponCode(); $obj->query("insert into tbl_email_marketing_template set template_type_id='$template_type_id',template_title='$template_title', email_subject='$email_subject',email_content='$email_content',status=1"); $_SESSION['sess_msg']='Email Template added sucessfully'; }else{ $obj->query("update tbl_email_marketing_template set template_type_id='$template_type_id',template_title='$template_title', email_subject='$email_subject',email_content='$email_content',status=1 where id='".$_REQUEST['id']."'"); $_SESSION['sess_msg']='Email Template updated sucessfully'; } header("location:marketing-template-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_email_marketing_template where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?>

Admin: Add/Update Template   Select Template For Select Template For query("select * from tbl_email_marketing_type where status=1"); while($result2=$obj->fetchNextObject($sql)) {?> id==$result->template_type_id){?> selected >name;?> Template Title :   Email Template Setting Email Subject : Email Body :  Note: 1- Use {COUPON_CODE} to include coupon code in message text  Note: 2- Use {USER_NAME} to include User name in message text <?php echo stripslashes($result->email_content);?>