Edit file File name : marketing-template-setting-add.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); include("../include/simpleimage.php"); validate_admin(); //echo "<pre>";print_r($_REQUEST);die; $discount_type=mysqli_real_escape_string($GLOBALS['conn'],$_POST['discount_type']); $valid_time=mysqli_real_escape_string($GLOBALS['conn'],$_POST['valid_time']); $discount=mysqli_real_escape_string($GLOBALS['conn'],$_POST['discount']); $to_email=mysqli_real_escape_string($GLOBALS['conn'],$_POST['to_email']); $expire_date=mysqli_real_escape_string($GLOBALS['conn'],$_POST['expire_date']); $minimum_purchase=mysqli_real_escape_string($GLOBALS['conn'],$_POST['minimum_purchase']); $template_type_id=mysqli_real_escape_string($GLOBALS['conn'],$_POST['template_type_id']); $name=mysqli_real_escape_string($GLOBALS['conn'],$_POST['name']); $template_id=mysqli_real_escape_string($GLOBALS['conn'],$_POST['template_id']); if($_REQUEST['submitForm']=='yes'){ if($_REQUEST['id']==''){ $obj->query("insert into tbl_email_marketing set name='$name', template_type_id='$template_type_id', template_id='$template_id',discount_type='$discount_type',valid_time='$valid_time',discount='$discount',expire_date='$expire_date', generate_date=now(),minimum_purchase='$minimum_purchase',status=1"); $_SESSION['sess_msg']='Template Setting added sucessfully'; }else{ $obj->query("update tbl_email_marketing set name='$name', template_type_id='$template_type_id', template_id='$template_id', discount_type='$discount_type',valid_time='$valid_time',discount='$discount',expire_date='$expire_date', generate_date=now(),minimum_purchase='$minimum_purchase',status=1 where id=".$_REQUEST['id']); $_SESSION['sess_msg']='Template Setting updated sucessfully'; } header("location:marketing-setting-template-list.php"); exit(); } if($_REQUEST['id']!=''){ $sql=$obj->query("select * from tbl_email_marketing where id=".$_REQUEST['id']); $result=$obj->fetchNextObject($sql); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title><?php echo SITE_TITLE; ?></title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link href="css/admin.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" language="javascript"> function validate(obj) { if(getRadioValue('valid_for')=='Particular' && !obj.to_email.value.match(/^([A-Za-z0-9_\-\.])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/) ){ alert("Please enter valid email."); obj.to_email.focus(); return false; } if(obj.notification_id.value==''){ alert("Please select Notification Type."); obj.notification_id.focus(); return false; } if(obj.notification_freqn.value==''){ alert("Please select Notification Frequency."); obj.notification_freqn.focus(); return false; } if(obj.valid_time.value==''){ alert("Please enter Number of Uses."); obj.valid_time.focus(); return false; } if(obj.discount.value==''){ alert("Please enter discount."); obj.discount.focus(); return false; } if(obj.minimum_purchase.value==''){ alert("Please enter minimum purchase amount."); obj.minimum_purchase.focus(); return false; } if(obj.expire_date.value==''){ alert("Please select expire date."); obj.expire_date.focus(); return false; } if(obj.notification_text.value==''){ alert("Please enter Notification text."); obj.expire_date.focus(); return false; } } function getRadioValue(groupName) { var _result; try { var o_radio_group = document.getElementsByName(groupName); for (var a = 0; a < o_radio_group.length; a++) { if (o_radio_group[a].checked) { _result = o_radio_group[a].value; break; } } } catch (e) { } return _result; } var expanded = false; function showCheckboxes() { var checkboxes = document.getElementById("checkboxes"); if (!expanded) { checkboxes.style.display = "block"; expanded = true; } else { checkboxes.style.display = "none"; expanded = false; } } function showByNotificationType(notificationId) { if(notificationId==3 || notificationId==4 || notificationId==5 ) { $('#location_area').show(); }else { //$('#location_area').hide(); } } </script> <style> .multiselect { width: 250px; height: inherit; } .selectBox { position: relative; } .selectBox select { width: 100%; font-weight: bold; } .overSelect { position: absolute; left: 0; right: 0; top: 0; bottom: 0; } #checkboxes { display: none; border: 1px #dadada solid; } #checkboxes label { display: block; } #checkboxes label:hover { background-color: #1e90ff; } </style> <link href="css/jquery.multiselect.css" rel="stylesheet" /> <script type="text/javascript" src="../include/ckeditor/ckeditor.js"></script> </head> <body> <table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0"> <?php include("header.php") ?> <link rel="stylesheet" href="calender/css/jquery-ui.css"> <script src="calender/js/jquery-ui.js"></script> <script> $(function() { $( "#expire_date" ).datepicker({ changeMonth: true, changeYear: true, dateFormat:"yy-mm-dd", yearRange:'2014:<?php echo date('Y')+5; ?>' }); }); </script> <tr> <td align="right" class="paddRtLt70" valign="top"> <table width="99%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="right" valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="left" valign="middle" class="headingbg bodr text14"> <em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Add/Update Template <span style="float:right; padding-right:10px;"> <input type="button" name="add" value="View Template" class="button" onclick="location.href='marketing-template-setting-add.php'" /></span></td> </tr> <tr> <td height="100" align="left" valign="top" bgcolor="#f3f4f6" class="bodr"> <form name="frm" method="POST" enctype="multipart/form-data" action="" onsubmit="return validate(this)"> <input type="hidden" name="submitForm" value="yes" /> <input type="hidden" name="id" value="<?php echo $_REQUEST['id'];?>" /> <input type="hidden" name="name" id="name" value="<?php echo stripslashes($result->name);?>" /> <table width="100%" cellpadding="0" cellspacing="0"> <tr> <td align="center" colspan="2" class="paddRt14 paddBot11"> <font color="#FF0000"><strong><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']='';?></strong></font></td> </tr> <tr> <td width="18%" align="right" class="paddBot11 paddRt14"> </td> <td width="82%" align="left" class="paddBot11"></td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Select Template For</strong></td> <td width="82%" align="left" class="paddBot11"> <select name="template_type_id" id="template_type_id" style="width:250px;" onchange="showByNotificationType(this.value);" > <option value="">Select Template For</option> <?php $sql=$obj->query("select * from tbl_email_marketing_type where status=1"); while($result2=$obj->fetchNextObject($sql)) {?> <option value="<?php echo $result2->id;?>" <?php if($result2->id==$result->template_type_id){?> selected <?php } ?>><?php echo $result2->name;?></option> <?php } ?> </select> </td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Select Template</strong></td> <td width="82%" align="left" class="paddBot11"> <select name="template_id" id="notification_id" style="width:250px;"> <option value="">Select Template</option> <?php $sql=$obj->query("select * from tbl_email_marketing_template where status=1"); while($result3=$obj->fetchNextObject($sql)) {?> <option value="<?php echo $result3->id;?>" <?php if($result3->id==$result->template_id){?> selected <?php } ?>><?php echo $result3->template_title;?></option> <?php } ?> </select> </td> </tr> <tr style="display:none;"> <td align="right" class="paddBot11 paddRt14"><strong>Set Frequency in Days:</strong></td> <td align="left" class="paddBot11"><input placeholder="No. of days" name="noofday" type="number" id="noofday" size="36" value="" /></td> </tr> <tr style="display:none;"> <td align="right" class="paddBot11 paddRt14"><strong>Set Frequency in Minutes:</strong></td> <td align="left" class="paddBot11"><input placeholder="Set time in minute" name="timeinminute" type="number" id="timeinminute" size="36" value="" /></td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Discount Type:</strong></td> <td align="left" class="paddBot11"> <input name="discount_type" type="radio" value="Percent" checked="checked"/>Percent <input name="discount_type" type="radio" value="Direct" <?php if($result->discount_type=='Direct'){ ?>checked<?php } ?> /> Direct</td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>No. of Uses:</strong></td> <td align="left" class="paddBot11"> <input name="valid_time" type="text" id="valid_time" size="36" value="<?php echo stripslashes($result->valid_time);?>" /> Times</td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Discount:</strong></td> <td align="left" class="paddBot11"><input name="discount" type="text" id="discount" size="36" value="<?php echo stripslashes($result->discount);?>" /> $ or %</td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Minimum Purchase:</strong></td> <td align="left" class="paddBot11"><input name="minimum_purchase" type="text" id="minimum_purchase" size="36" value="<?php echo stripslashes($result->minimum_purchase);?>" /> $</td> </tr> <tr> <td align="right" class="paddBot11 paddRt14"><strong>Valid Till:</strong></td> <td align="left" class="paddBot11"><input name="expire_date" type="text" id="expire_date" size="36" value="<?php if($result->expire_date!='0000-00-00'){ echo stripslashes($result->expire_date);}?>" /></td> </tr> <tr> <td width="18%" align="right" class="paddRt14 paddBot11"> </td> <td width="82%" align="left" class="paddBot11"> <input type="submit" name="submit" value="Submit" class="submit" border="0"/> <input name="Reset" type="reset" id="Reset" value="Reset" class="submit" border="0" /></td> </tr> </table></form> </td> </tr> </table> </td> </tr> </table> </td> </tr> <?php include('footer.php'); ?> </table> </body> </html> Save