Viewing file:  feesadd.php (5.43 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
session_start();
?>
<?php
include('receiptno.php');
?>
<?php
include('session.php');
?>
<!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>Fees Update</title>
<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>
</head>
<body>
<div id="print2">
<?php
$pf=$_POST[paidfees];
$gid=$nmembercode;
echo "<table width=\"800\" border='1' cellspacing=\"0\" bgcolor='#CCCCCC' cellpadding=\"1\">\n";
echo " <tr>\n";
echo " <td width=\"\" align=\"left\" valign=\"top\" > <h1>PURUSHOTTAM COMPUTER CLASSES </h1> </td>\n";
echo " </tr>\n";
echo "</table>\n";
echo "\n";
echo "<table width=\"800\" height='400' border=\"1\" cellspacing=\"0\" cellpadding=\"1\">\n";
echo " <tr>\n";
echo " <td width=\"171\" align=\"left\" valign=\"top\" >RECEIPT NO</td>\n";
echo " <td>$gid</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td width=\"171\" align=\"left\" valign=\"top\" >ROLL NO</td>\n";
echo " <td width=\"360\">\n";
echo " $_POST[rollno]";
echo " </td>\n";
echo " <tr>\n";
echo " <td width=\"171\" align=\"left\" valign=\"top\" >BRANCH NAME</td>\n";
echo " <td width=\"360\">\n";
echo " $_POST[branchname] ";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"left\" valign=\"top\" >COURSE NAME</td>\n";
echo " <td>\n";
echo " $_POST[coursename]";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"left\" valign=\"top\" >STUDENT NAME</td>\n";
echo " <td>\n";
echo " $_POST[studentname]";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"left\" valign=\"top\" >FATHER NAME</td>\n";
echo " <td>\n";
echo " $_POST[fathername]";
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"left\" valign=\"top\" >COURSE FEES</td>\n";
echo " <td>\n";
echo " $_POST[coursefees]".'Rs.';
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"left\" valign=\"top\" >DEPOSIT FEES</td>\n";
echo " <td>\n";
echo " $pf".'Rs.';
echo " </td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo " <td align=\"left\" valign=\"top\" >DATE</td>\n";
echo " <td>\n";
echo " $_POST[cdate]";
echo " </td>\n";
echo " </tr>\n";
echo "</table></form>\n";
echo "\n";
?>
</div>
<table width="500" border="0" cellspacing="1" cellpadding="1">
<td><input type="button" name="printbutton" value="Prin table" onclick="return print1('print2')"/> </td>
<td><form action="">
<input type="button" value="New" onclick="window.location.href='fee_registration.php';"/>
</form> </td>
<td> <form action="">
<input type="button" value="Home" onclick="window.location.href='branchpage.php';"/>
</form> </td>
</tr>
</table>
</body>
</html>
<?php
$con=mysqli_connect("localhost",'itce_user','rb!itc838','itce_data');
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$coursefees=$_POST[coursefees];
$idss=$_POST[ids];
$totaldeposit=$_POST[deposit]+$_POST[paidfees];
$remaing=$coursefees-$totaldeposit;
$sql = "INSERT INTO student_admission ( lesarno,roll_no, branch,programname, stduentname, studentfathername,totalfees,depositfees,tdate, gender,address,cyear,mobileno,main)
VALUES ( $gid, '$_POST[rollno]', '$_POST[branchname]', '$_POST[coursename]', '$_POST[studentname]', '$_POST[fathername]','$_POST[coursefees]',$pf,'$_POST[cdate]','$_POST[gender]','$_POST[address]','$_POST[year]','$_POST[mobileno]','PAID')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php
$con=mysqli_connect("localhost",'itce_user','rb!itc838','itce_data');
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$coursefees=$_POST[coursefees];
$idss=$_POST[ids];
$totaldeposit=$_POST[deposit]+$_POST[paidfees];
$remaing=$coursefees-$totaldeposit;
$sql = "INSERT INTO fees ( fees_serial_no,roll_no, branch,class, student_name, father_name,total_fees,deposite_fees,date, gender,laser_no,address,year,mobile_no)
VALUES ( $gid, '$_POST[rollno]', '$_POST[branchname]', '$_POST[coursename]', '$_POST[studentname]', '$_POST[fathername]','$_POST[coursefees]',$pf,'$_POST[cdate]','$_POST[gender]','$_POST[laser_no]','$_POST[address]','$_POST[year]','$_POST[mobileno]')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php
$dates=date('d/m/Y');
$con=mysqli_connect("localhost",'itce_user','rb!itc838','itce_data');
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "UPDATE student_admission
SET depositfees='$totaldeposit'
WHERE ID=$idss;";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
|