Viewing file: dd_acc_print.php (9.63 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php $con=mysqli_connect("localhost","anshdiam_user","rb!ans838","anshdiam_sarkmicr_data"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $sql = "INSERT INTO dd (receipt,agent_name,accountno,credit,days,latefees,agent_code,cname,jdate,jmonth,jyear,branchname) VALUES ('$_POST[receiptno]','$_POST[agent_name]','$_POST[accountno]', '$_POST[premium]', '$_POST[days]' , '$_POST[latefees]', '$_POST[agent_code]', '$_POST[cname]', '$_POST[jdate]', ' $_POST[jmonth]', '$_POST[jyear]','$_POST[branchname]')";
if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); }
mysqli_close($con); ?> <?php include('session.php'); ?>
<?php $keywords = $_POST[ids]; $premiums=$_POST[oldpaidamount]+$_POST[premium]; $alldays = $_POST[odays]+$_POST[days];
$con=mysqli_connect("localhost","anshdiam_user","rb!ans838","anshdiam_sarkmicr_data"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); }
$sql = "UPDATE dd SET loanamount ='$premiums' WHERE ID='$keywords'";
if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); }
mysqli_close($con);
?> <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=20,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> <style type="text/css"> ansh { color: #F00; } #print2 table tr td table tr td table tr td table tr td h2 { color: #F00; } </style> <div id="print2"> <table border="0"> <tr> <td> </td> </tr> <tr> <td height="87"><table width="100%" border="1" cellspacing="4" cellpadding="4"> <tr> <td><table width="900" border="0" cellspacing="0" cellpadding="0" > <tr> <td height="77" colspan="4" bgcolor="#FFFFFF"><table width="100%" border="0" bgcolor="#FFFFFF"> <tr> <td height="20" align="right" bgcolor="#FFFFFF">Client Copy</td> </tr> <tr> <td width="940" height="20" align="center"><h2>ANSH DIAMOND GROUP</h2></td> </tr> <tr> <td height="20" align="center">Corporate Office : CP 4/1Vinay Khand, Gomati Nagar Station Road Lucknow (U.P.)</td> </tr> <tr> <td height="20" align="center">MOBILE : 05525-2440130</td> </tr> <tr> <td height="20" align="center">EMAIL : ganeshdiamond@gmail.com</td> </tr> </table> <p> </p></td> </tr> <tr> <td height="30" align="left" bgcolor="#EBEBEB"><strong>Receipt No</strong></td> <td height="30" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receiptno] ?></td> <td height="30" align="left" bgcolor="#EBEBEB"><strong>Print Date</strong></td> <td height="30" align="left" bgcolor="#EBEBEB"><?php echo $_POST[jdate].'/'.$_POST[jmonth].'/'.$_POST[jyear] ?></td> </tr> <tr> <td height="30" align="left"><strong>Branch Name</strong></td> <td height="30" align="left"><?php echo $_POST[branchname] ?></td> <td height="30" align="left"><strong>Account No</strong></td> <td height="30" align="left"><?php echo $_POST[accountno] ?></td> </tr> <tr> <td height="30" align="left"><strong>Applicant Name</strong></td> <td height="30" align="left"><?php echo $_POST[cname] ?></td> <td height="30" align="left"><strong>Agent Code</strong></td> <td height="30" align="left"><?php echo $_POST[agent_code] ?></td> </tr> <tr> <td height="30" align="left"><strong>Previous Deposit Amount</strong></td> <td height="30" align="left"><?php echo $_POST[oldpaidamount] ?></td> <td height="30" align="left"><strong>Deposit Date</strong></td> <td height="30" align="left"><?php echo $_POST[jdate].'/'.$_POST[jmonth].'/'.$_POST[jyear] ?></td> </tr> <tr> <td height="30" align="left"><strong>Deposit Amount</strong></td> <td height="30" align="left"><?php echo $_POST[premium]." Rs" ?></td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> </tr> <tr> <td width="194" height="30" align="left"> </td> <td width="200" height="30" align="left"> </td> <td width="142" height="30" align="left"> </td> <td width="364" height="30" align="left"> </td> </tr> <tr> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> </tr> <tr> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"><strong></strong></td> <td height="30" align="right">Authorised Signatory</td> </tr> <tr> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="21"> </td> </tr> <tr> <td><table width="100%" border="1" cellspacing="4" cellpadding="4"> <tr> <td><table width="900" border="0" cellspacing="0" cellpadding="0" > <tr> <td height="77" colspan="4" bgcolor="#FFFFFF"><table width="100%" border="0" bgcolor="#FFFFFF"> <tr> <td height="20" align="right" bgcolor="#FFFFFF">Office Copy</td> </tr> <tr> <td width="940" height="20" align="center"><h2>ANSH DIAMOND GROUP</h2></td> </tr> <tr> <td height="20" align="center">Corporate Office : CP 4/1Vinay Khand, Gomati Nagar Station Road Lucknow (U.P.)</td> </tr> <tr> <td height="20" align="center">MOBILE : 05525-2440130</td> </tr> <tr> <td height="20" align="center">EMAIL : ganeshdiamond@gmail.com</td> </tr> </table> <p> </p></td> </tr> <tr> <td width="173" height="30" align="left" bgcolor="#EBEBEB"><strong>Receipt No</strong></td> <td width="212" height="30" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receiptno] ?></td> <td width="144" height="30" align="left" bgcolor="#EBEBEB"><strong>Print Date</strong></td> <td width="371" height="30" align="left" bgcolor="#EBEBEB"><?php echo $_POST[jdate].'/'.$_POST[jmonth].'/'.$_POST[jyear] ?></td> </tr> <tr> <td height="30" align="left"><strong>Branch Name</strong></td> <td height="30" align="left"><?php echo $_POST[branchname] ?></td> <td height="30" align="left"><strong>Account No</strong></td> <td height="30" align="left"><?php echo $_POST[accountno] ?></td> </tr> <tr> <td height="30" align="left"><strong>Applicant Name</strong></td> <td height="30" align="left"><?php echo $_POST[cname] ?></td> <td height="30" align="left"><strong>Agent Code</strong></td> <td height="30" align="left"><?php echo $_POST[agent_code] ?></td> </tr> <tr> <td height="30" align="left"><strong>Previous Deposit Amount</strong></td> <td height="30" align="left"><?php echo $_POST[oldpaidamount] ?></td> <td height="30" align="left"><strong>Deposit Date</strong></td> <td height="30" align="left"><?php echo $_POST[jdate].'/'.$_POST[jmonth].'/'.$_POST[jyear] ?></td> </tr> <tr> <td height="30" align="left"><strong>Deposit Amount</strong></td> <td height="30" align="left"><?php echo $_POST[premium]." Rs" ?></td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> </tr> <tr> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> </tr> <tr> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"><strong></strong></td> <td height="30" align="right">Authorised Signatory</td> </tr> <tr> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> <td height="30" align="left"> </td> </tr> </table></td> </tr> </table></td> </tr> </table></div> <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='ddcreateaccount.php';"/> </form> </td> </tr> </table>
|