HUB OF TUTORIALS
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
HUB OF TUTORIALS
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
HUB OF TUTORIALS
  • Business
  • Digital Marketing
  • Technology
    • HTML
    • CSS
    • jQuery
    • WordPress
    • Core PHP
    • Mysql
    • JAVA
    • Projects
    • Photography
  • Recipes
  • Others
  • Write for Us
Core PHPHTMLMysql

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> &nbsp &nbsp &nbsp  <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');
?>
challan payment e grass grasmahakosh grass mahakosh online challan online challan payment
How to Fetch Logged in UsernamePrevHow to Fetch Logged in UsernameMarch 17, 2020
How to Import Data in PHP using Mysql DatabaseMarch 17, 2020How to Import Data in PHP using Mysql DatabaseNext
Search
Recent Posts
  • 7 Educational Approaches for Diverse Learners
  • 5 Best Online Payment Gateways in India
  • How to Start and Earn from Making WooCommerce Plugins
  • Step By Step Guide to Becoming a Certified Salesforce Developer
  • A Guide to Transitioning from On-Premises to Azure Services
Categories
  • Business
  • Core PHP
  • CSS
  • Digital Marketing
  • HTML
  • JAVA
  • Jobs
  • jQuery
  • Mysql
  • News
  • Others
  • Photography
  • Projects
  • Recipes
  • WordPress

  • How to Create List in HTML
  • How to use Iframe in HTML
  • How to Create a Table in HTML and CSS
  • How to Add New HTML Content using jQuery
  • CSS Property of List tag in HTML
  • How to use CSS for Table in HTML
  • How to Make Basmati Rice Recipe
  • How to Make Indian Kheer Recipe
  • How to Make Spicy Aloo Tikki
  • How to Make Aloo Matar Samosa
  • How to Make Cheese Potato Sandwich
  • How to Make Aloo Palak Methi
  • Company Visitors Management System
  • Complaint Management System using PHP
  • Directory Management System
  • Employee Record Management System
  • Hospital Management System using PHP
  • Vehicle Parking Management System

Copyright © 2022 Hub of Tutorials. All Rights Reserved. Designed by AS Webworks