Viewing file:  reg_print.php (5.99 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('config.php');
session_start();
$user_check=$_SESSION['login_user'];
$ses_sql=mysqli_query($db,"select username from login where username='$user_check' ");
$row=mysqli_fetch_array($ses_sql,MYSQLI_ASSOC);
$login_session=$row['username'];
header("Location: reg_print.php");
if(!isset($login_session))
{
header("Location: login.php");
}
?>
<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();
}
$account_d = mysqli_real_escape_string($con, $_POST['account']);
$panno_d = 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 ("$account_d", "$panno_d" ,"$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>$receipt_d</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>
<form action="">
<input type="button" value="New" onclick="window.location.href='account_create.php';"/>
</form>
|