Viewing file:  backupacc.php (8.69 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>Untitled Document</title>
<script src="SpryAssets/SpryMenuBar.js" type="text/javascript"></script>
<link href="SpryAssets/SpryMenuBarHorizontal.css" rel="stylesheet" type="text/css" />
<style type="text/css">
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
body {
background-color: #CCC;
}
</style>
</head>
<center>
<body>
<table width="953" border="0" bgcolor="#FFFFFF">
<tr>
<td width="153"><img src="images/basera logo.jpg" width="101" height="100" /></td>
<td width="537" align="center"><h1>WELCOME IN BASERA BRANCH</h1></td>
</tr>
<tr>
<td colspan="2"><table width="945" border="0">
<tr>
<td colspan="3" bgcolor="#CCCCCC"><ul id="MenuBar1" class="MenuBarHorizontal">
<li><a href="branchpage.php">Home</a> </li>
<li><a href="#" class="MenuBarItemSubmenu">Account</a>
<ul>
<li><a href="createaccount.php">Create Account</a></li>
<li><a href="#">Account Statement</a></li>
<li><a href="#">Update Account</a></li>
</ul>
</li>
<li><a class="MenuBarItemSubmenu" href="#">Member</a>
<ul>
<li><a href="#">Create Member</a> </li>
<li><a href="#">Update Member</a></li>
<li><a href="#">Member Account History</a></li>
</ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu">Payout</a>
<ul>
<li><a href="#">Monthly Payout</a></li>
<li><a href="#">Payout Details</a></li>
<li><a href="#">Payout Receipt</a></li>
</ul>
</li>
<li><a href="#" class="MenuBarItemSubmenu">Statement</a>
<ul>
<li><a href="#">Receipt</a></li>
<li><a href="#">Downline</a></li>
<li><a href="#">Expired Account</a></li>
<li><a href="#">Expired List</a></li>
<li><a href="#">Monthly Statement</a></li>
</ul>
</li>
<li><a href="logout.php">Logout</a></li>
</ul></td>
</tr>
<tr>
<td width="210" bgcolor="#6699CC">Welcome <?php echo $login_session; ?></td>
<td width="335" bgcolor="#6699CC"><a href="logout.php">Logout</a></td>
<td width="386" bgcolor="#6699CC"><?php echo "Today is " . date("d/m/y") . "<br>";?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" align="left">
<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>
<form id="form1" name="form1" method="post" action="">
<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();
}
$accountd = mysqli_real_escape_string($con, $_POST['account']);
$pannod = mysqli_real_escape_string($con, $_POST['panno']);
$email_d = mysqli_real_escape_string($con, $_POST['email']);
$qualification_d = mysqli_real_escape_string($con, $_POST['qualification']);
$nominee_name_d = mysqli_real_escape_string($con, $_POST['nominee_name']);
$agent_name_d = mysqli_real_escape_string($con, $_POST['agent_name']);
$select_d = mysqli_real_escape_string($con, $_POST['select']);
$name_d = mysqli_real_escape_string($con, $_POST['name']);
$address_d = mysqli_real_escape_string($con, $_POST['address']);
$dob_d = mysqli_real_escape_string($con, $_POST['dob']);
$date_d = mysqli_real_escape_string($con, $_POST['date']);
$nominee_d = mysqli_real_escape_string($con, $_POST['nominee_age']);
$agentcode_d = mysqli_real_escape_string($con, $_POST['agentcode']);
$planttime_d = mysqli_real_escape_string($con, $_POST['plantime']);
$f_name_d = mysqli_real_escape_string($con, $_POST['f_name']);
$phone_d = mysqli_real_escape_string($con, $_POST['phone']);
$occupation_d = mysqli_real_escape_string($con, $_POST['occupation']);
$passbookno_d = mysqli_real_escape_string($con, $_POST['passbookno']);
$nomineerelation_d = mysqli_real_escape_string($con, $_POST['nomineerelation']);
$amount_d = mysqli_real_escape_string($con, $_POST['amount']);
$receipt_d = mysqli_real_escape_string($con, $_POST['receipt']);
$paymentmode_d = mysqli_real_escape_string($con, $_POST['paymentmode']);
$nextinstdate_d = mysqli_real_escape_string($con, $_POST['nextinstdate']);
$bankname_d = mysqli_real_escape_string($con, $_POST['bankname']);
$noofinstall_d = mysqli_real_escape_string($con, $_POST['noofinstall']);
$chequeno_d = mysqli_real_escape_string($con, $_POST['chequeno']);
$sql = 'INSERT INTO new_acc (acc_no, pan_no, email, qualification, nominee_name, agent_name, plan_name, name, address, dateofbirth, date, nomineeage, agentcode, plan_time,
father_name, phone, occupation, passbookno, nomineeralation, amount, receipt_no, payment_mode, next_ins_date, bank_name, no_installment,cheque_no)
VALUES ("$accountd",'$_POST['panno']' ,"$email_d","$qualification_d","$nominee_name_d", "$agent_name_d", "$select_d", "$name_d", "$address_d", "$dob_d", "$date_d", "$nominee_d", "$agentcode_d", "$plantime_d", "$f_name_d", "$phone_d", "$occupation_d", "$passbookno_d", "$nomineerelation_d", "$amount_d", "$receipt_d", "$paymentmode_d", "$nextinstdate_d", "$bankname_d", "$noofinstall_d","$chequeno_d")';
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php
echo "<table width=\"803\" height=\"253\" border=\"0\">\n";
echo " <tr>\n";
echo " <td width=\"132\"> </td>\n";
echo " <td width=\"12\"> </td>\n";
echo " <td width=\"207\"> </td>\n";
echo " <td width=\"234\"> </td>\n";
echo " <td width=\"19\"> </td>\n";
echo " <td width=\"173\"> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Receipt</td>\n";
echo " <td>:</td>\n";
echo " <td></td>\n";
echo " <td>Account Holder Name</td>\n";
echo " <td>:</td>\n";
echo " <td>$name_d </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Account No</td>\n";
echo " <td>:</td>\n";
echo " <td>$account_d</td>\n";
echo " <td>No Installment</td>\n";
echo " <td>:</td>\n";
echo " <td>$noofinstall_d</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Address</td>\n";
echo " <td>:</td>\n";
echo " <td>$address_d</td>\n";
echo " <td>Payment Mod</td>\n";
echo " <td>:</td>\n";
echo " <td>$paymentmode_d</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Receipt Date</td>\n";
echo " <td>:</td>\n";
echo " <td>$receipt_d </td>\n";
echo " <td>Bank</td>\n";
echo " <td>:</td>\n";
echo " <td>$bankname_d</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Branch Name</td>\n";
echo " <td>:</td>\n";
echo " <td> $login_session</td>\n";
echo " <td>Next Inst. Date</td>\n";
echo " <td>:</td>\n";
echo " <td>$nextinstdate_d</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Cheque No</td>\n";
echo " <td>:</td>\n";
echo " <td>$chequeno_d</td>\n";
echo " <td>Agent Code</td>\n";
echo " <td>:</td>\n";
echo " <td>$agentcode_d</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 " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td>Amount</td>\n";
echo " <td>:</td>\n";
echo " <td>$amount_d</td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " <td> </td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
?>
</div>
<br/><br/>
<input type="button" name="printbutton" value="Prin table" onclick="return print1('print2')"/>
</form>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"><p> </p>
<form action="">
<input type="button" value="New" onclick="window.location.href='createaccount.php';"/>
</form>
<p> </p></td>
</tr>
</table>
<script type="text/javascript">
var MenuBar1 = new Spry.Widget.MenuBar("MenuBar1", {imgDown:"SpryAssets/SpryMenuBarDownHover.gif", imgRight:"SpryAssets/SpryMenuBarRightHover.gif"});
</script>
</body></center>
</html>
|