Viewing file:  memberstatmentprint.php (3.82 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>
<script type="text/javascript">
function print1(strid)
{
if(confirm("Do you want to print?"))
{
var values = document.getElementById(strid);
var printing =
window.open('','','left=0,top=0,width=550,height=400,toolbar=0,scrollbars=0,sta?tus=0');
printing.document.write(values.innerHTML);
printing.document.close();
printing.focus();
printing.print();
printing.close();
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Basera Multi Biz India Limited</title>
</head>
<body>
<div id="print2">
<?php
$con=mysqli_connect("localhost","baserain_dba838","rb!bsa838mau","baserain_db838");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO create_receipt (acc_no, receive_date, branch_name,mode_payment,bank_name,amount,noofinstallment,cheque_no,
receipt2, accountholder, address, next_inst, agentcode,insdate, agentname)
VALUES ('$_POST[acname]', '$_POST[rdate]', '$_POST[branchname]', '$_POST[mpayment]', '$_POST[bankno]', '$_POST[amount]', '$_POST[noofinst]', '$_POST[chequeno]', '$_POST[accountname]','$_POST[namet]','$_POST[address]','$_POST[intdate]','$_POST[agentname]', '$_POST[intdate]','$_POST[agentname]')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php
echo "<img src='images/baseraprint.jpg' width='703' height='100' />";
echo "<table width=\"703\" border=\"0\">\n";
echo " <tr>\n";
echo " <td width=\"103\">Receipt</td>\n";
echo " <td width=\"166\">$_POST[accountname]</td>\n";
echo " <td width=\"186\">Account Holder Name</td>\n";
echo " <td width=\'220\'>$_POST[namet]</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Account No</td>\n";
echo " <td>$_POST[acname]</td>\n";
echo " <td>No Installment</td>\n";
echo " <td>$_POST[noofinst]</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Address</td>\n";
echo " <td>$_POST[address]</td>\n";
echo " <td>Payment Mod</td>\n";
echo " <td>$_POST[mpayment]</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Receipt Date</td>\n";
echo " <td>$_POST[rdate]</td>\n";
echo " <td>Bank</td>\n";
echo " <td>$_POST[bankno]</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Branch Name</td>\n";
echo " <td>$_POST[branchname]</td>\n";
echo " <td>Next Ins. Date</td>\n";
echo " <td>$_POST[nintdate]</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Chque No</td>\n";
echo " <td>$_POST[chequeno]</td>\n";
echo " <td>Agent Code</td>\n";
echo " <td>$_POST[agentname]</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Ins. Date</td>\n";
echo " <td>$_POST[intdate]</td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Amount</td>\n";
echo " <td>$_POST[amount]</td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Agent Name</td>\n";
echo " <td>$_POST[agentname]</td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td></td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " <td>\n";
echo " </td>\n";
echo " <td>Manager Signature</td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
?>
<form action="">
<input type="button" name="printbutton" value="Prin Receipt" onclick="return print1('print2')"/>
</form>
</body>
</html>
|