Viewing file:  acc_printdd.php (4.44 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Create Account</title>
</head>
<center>
<body>
<?php
$dates=$_POST[jdate].'/'.$_POST[jmonth].'/'.$_POST[jyear];
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO dd (agentname,agentcode,amount,days,date,planamount,serialno,accountno,address,mobileno,identityproof,cname,fname,first_reg)
VALUES ('$_POST[agentname]','$_POST[mcode]','$_POST[amount]', '$_POST[days]', '$dates' , '$_POST[planamount]', '$_POST[receipt]', '$_POST[account]', ' $_POST[address]','$_POST[phone]', '$_POST[idf]','$_POST[cname]','$_POST[fname]','ACTIVE')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<div id="print2">
<table width="900" border="0" cellspacing="0" cellpadding="0" background="images/logo.jpg" >
<tr>
<td height="77" colspan="4" bgcolor="#FFFFFF"><p><img src="images/printbanner.jpg" width="900" height="120" alt="printbanner" /></p></td>
</tr>
<tr>
<td width="154" height="31" align="left" bgcolor="#EBEBEB"><strong>Receipt No</strong></td>
<td width="229" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receipt] ?></td>
<td width="142" align="left" bgcolor="#EBEBEB"><strong>Print Date</strong></td>
<td width="369" align="left" bgcolor="#EBEBEB"><?php echo date('d/m/Y') ?></td>
</tr>
<tr>
<td align="left"><strong>Branch Name</strong></td>
<td align="left"><?php echo $_POST[branchname] ?></td>
<td align="left"></td>
<td align="left"></td>
</tr>
<tr>
<td align="left"><strong>Name</strong></td>
<td align="left"><?php echo $_POST[cname].$_POST[cmidname]. $_POST[csurname] ?></td>
<td align="left">Father Name</td>
<td align="left"><?php echo $_POST[fname] ?></td>
</tr>
<tr>
<td align="left" valign="top"><strong>Applicant Address</strong></td>
<td colspan="3" align="left" valign="top"><?php echo $_POST[village]. " ".$_POST[post]." ". $_POST[distt]. " ".$_POST[pin] ?>
<p> </p></td>
<td width="1" align="left"></td>
<td width="5" align="left"></td>
</tr>
<tr>
<td align="left"><strong>Plan Amount</strong></td>
<td align="left"><?php echo $aaamount ?></td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left">Deposit Amount</td>
<td align="left"> </td>
<td align="left"><strong>Deposit Date</strong></td>
<td align="left"><?php echo $regdate ?></td>
</tr>
<tr>
<td align="left"><strong>Account No</strong></td>
<td align="left"><?php echo $_POST[account] ?></td>
<td align="left"><strong>Plan Times</strong></td>
<td align="left"><?php echo $_POST[plantime]."Years" ?> Months</td>
</tr>
<tr>
<td align="left"><strong>Plan Name</strong></td>
<td align="left"><?php echo $_POST[select] ?></td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left"><strong>Member Code</strong></td>
<td align="left"><?php echo $_POST[mcode] ?></td>
<td align="left"><strong></strong></td>
<td align="left"></td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE">Authorised Signatory</td>
</tr>
</table>
</div>
<br/><br/>
<table width="300" border="0" cellspacing="10" cellpadding="10">
<tr>
<td><input type="button" name="printbutton" value="Prin table" onclick="return print1('print2')"/> </form></td>
<td><form action=""><input type="button" value="New" onclick="window.location.href='ddnewaccount.php';"/> </form> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"><?php include('footer.php'); ?></td>
</tr>
</table>
</body></center>
</html>
|