How to Make Fees Receipt in PHP Using Mysql Database
In this article, you will learn How to Make Fees Receipt in PHP Using Mysql Database.
index.php
<html> <title>Add fees</title> </head> <body> <h1><a href="add.php">Add receipt</a>       <a href="search.php">Record</a></h1> <form method="POST" oninput="x.value=parseInt(a.value)+parseInt(b.value)+parseInt(c.value)" action="fees.php"> <input type="date" name="date"><br/><br/> Name <input type="text" name="name"><br/><br/> Registration No. <input type="number" name="rno"><br/><br/> Course <select name="course"> <option>Select Course</option> <option value="PHP">PHP</option> <option value="JAVA">JAVA</option> <option value="ACCOUNTS">ACCOUNTS</option> <option value="BASIC">BASIC</option> <option value="GRAPHIC DESIGNING">GRAPHIC DESIGNING</option> </select><br/><br/> Cash/Cheque/Draft <select name="type"> <option value="Cash">Cash</option> <option value="Cheque">Cheque</option> <option value="Draft">Draft</option> </select><br/><br/> Cheque/Draft No. <input type="number" name="cno"><br/><br/> Cheque/Draft Date <input type="date" name="cdate"><br/><br/> Programme Fees <input type="number" placeholder="0" id="a" name="a"><br/><br/> Late Fees <input type="number" placeholder="0" id="b" name="b"><br/><br/> Other Fees <input type="number" placeholder="0" id="c" name="c"><br/><br/> Balance <input type="number" placeholder="0" id="c" name="bal"><br/><br/> Total <input name="x" for="a b c" /> <br><br> <input type="submit" name="submit"> </form> </body> </html>
fees.php
<?php
include(fees.php);
if(isset($_POST['submit'])=='submit')
{
$date=$_POST['date'];
$name=$_POST['name'];
$rno=$_POST['rno'];
$course=$_POST['course'];
$type=$_POST['type'];
$cno=$_POST['cno'];
$cdate=$_POST['cdate'];
$a=$_POST['a'];
$b=$_POST['b'];
$c=$_POST['c'];
$bal=$_POST['bal'];
$x=$_POST['x'];
$insert="insert into fees set date='$date',name='$name',rno='$rno',
course='$course',type='$type',cno='$cno',cdate='$cdate',
a='$a',b='$b',c='$c',bal='$bal',total='$x'";
$query=mysql_query($insert);
}
?>
db.php
<?php
mysql_connect('localhost','root','');
mysql_select_db('fees');
?>
