1
Acharya Narendra Dev Kisan P.G. College
Babhnan Gonda (U.P.) 271313
(Community College)
Skilled Based Program
Approved by
University Grant Commission, New Delhi
Session 2023-24
DIPLOMA IN COMPUTER APPLICATION
Project Report- Student
Registration Form
Submitted by Submitted to
Abhishek Yogi Mr. Vikram Pandey
Roll No. 22C1076 Dept. of Computer
Page 1 of 40
2
INDEX
S.No. Content
1. Certificate
2. Acknowledge
3. Candidate Declaration
4. Title of the Project - Student Registration
Form
5. Scripting language - PHP
6. Backend – DBMS
7. Server – Apache
8. 3rd Party Software – XAMPP
9. Student Registration Form
10. Database
11. Code
Page 2 of 40
3
CERTIFICATE
This is to certify that report represents the original
work done by Abhishek Yogi during this project
submission as a partial fulfilment of the requirement
for the PHP Project of Diploma in Computer
Application, Last Semester, of Acharya Narendra Dev
Kisan P.G. College Babhnan – Gonda (U.P.) 271313.
Project Guide:
Mr. Vikram Pandey
Page 3 of 40
4
ACKNOWLEDGEMENT
I would like to express my special thanks of gratitude
to my teacher Mr. Vikram Panday who gave me tha
golden opportunity to do this wonderful PHP Project
on the topic DCA Stu_info, which also helped me in
doing a lot of Research and I came to know about so
many new things. I am really thankful to them.
We are highly indebted to our Principal Dr.
Dharmendra Kumar Shukla, A.N.D.K.P.G. College, for
the facilities provided to accomplish this project.
Secondly, I would also like to thanks my
Friends who helped me a lot in finalizing this project
within the limited time frame.
Name of the Students
Page 4 of 40
5
1. Abhishek Yogi, 22C1076
2. Utkarsh Shukla,22C1067
TITLE OF THE
PROJECT
Student Registration Form-
A student information collection form is a document
used by college staff’s to collect data about their
students. A student record system has a unified
database that allows us to manage student data to
maintain all college – related information.
This way we can view essential information related to
student record consists of all personal details (like
Name, Father’s Name, Address, Contact) academic
and any other recorded information, that is collected
and stored by the college relating to a student.
Page 5 of 40
6
Candidate
Declaration
I hereby declare that the PHP Project work being
presented in this report entitled “STUDENT
REGISTRATION FORM” submitted in the Department
of Computer, Acharya Narendra Dev Kisan P.G.
College Babhnan – Gonda(U.P.) is the authentic work
carried out by me under the guidance of Mr. Vikram
Pandey , Department of Computer, A.N.D.K.P.G.
College Babhnan – Gonda.
Page 6 of 40
7
Date- Abhishek Yogi
Diploma in Computer Application
Final Semester
A.N.D.K.P.G.CollegeBabhnan-
Gonda
PHP
PHP is an abbreviation or acronym for
“HypertextPreprocessor”. It’s a web based open
source server-side scripting language that’s
integrated in our HTML files.
We use it to make webpage’s that are both
responsive and interactive with the database.
ADVANTAGE OF
PHP
PHP has many benefits, and here are a few of them:-
PHP is Simple to Use :-
Page 7 of 40
8
We don’t need to study extensively to learn and use
PHP because its syntax is sensible and well-organized.
The command function are also easy to work with
because they help you understand exactly what they
do.
PHP Helps We Collect Data from
Forms:-
We can use PHP to collect data from a form that has
been created with HTML (like Name, E-mail, Phone
Number or Password). Many websites use this
particular function of PHP.
DBMS
Data Base Management System:-
It is a software that allows access to data store in a
database.
We can organized data into tables, rows, columns and
index it to make it easier to find relevant information
and provide and easy and effective method of:
Defining the information
Storing the information
Manipulating the information
Page 8 of 40
9
Protecting the information from system crashes
or data theft
Differentiating access permission for different
users
The main purpose of the database is to operate a
large amount of information by storing, retrieving,
and managing data.
DBMS acts as an interface between the user and the
database.
Web Server
Apache is the web server that process requests and
servers web assets and content via HTTP.
As a Web server ,Apache is responsible for accepting
directory (HTTP) requests from internet users and
Page 9 of 40
10
sending them their desired information in the form of
files and Web pages.
Much of the Web’s software and code is designed to
work along with Apache’s features.
XAMPP
The acronym XAMPP stands for Cross-platform,
Apache, MySQL, PHP and Perl.XAMPP is free and
open source web server that allows us to develop,
test and build websites on a local server.
Unlink PHP ,XAMPP installation is quite simple and
uncomplicated.
Page 10 of 40
11
Many people know from their own experience that
it’s noteasy to install an Apache web server and it
gets harder if we want to add MariaDB, PHP and Perl.
The goal of XAMPP is to build an easy to install
distribution for developers to get into the world of
Apache. To make it convenient for developers,
XAMPP is configured with all features turned on. In
the case of commercial use please take a look at the
product licenses, from the XAMPP point of view
commercial use is also free. Thereare currently
distribution for Windows, Linux and OSX.
1. Home Page
Page 11 of 40
12
2. Registration Form
3. Total Record Page
Page 12 of 40
13
4. Total Registration
5. Update Record Page
6. Delete Record page
Page 13 of 40
14
Back-end
Page 14 of 40
15
Page 15 of 40
16
rd
3 Party
Software
Page 16 of 40
17
Database Connection Code
<?php
$servername='localhost';
$username='root';
$password='';
$database='college';
$conn=mysqli_connect($servername,$username,$password,
$database);
if($conn)
{
echo "Connection
Sucessful";
}
else
{
echo "Connection
failed";
}
?>
Page 17 of 40
18
Registration Form Code
<?PHP
Include("connection.php");
?>
<html>
<head>
<title>New Registration</title>
</head>
<body bgcolor="gray">
<h1 align="center"><font face="Times New Roman"
color="black">Acharya Narendra Dev Kisan P.G College
</h1></font>
<p align="center"><font face="Times New Roman"
color="black">Babhnan,Gonda U.P:271313</P></font>
<P align="center"><font face="Times New Roman"
color="black">Community College Approach by</p></font>
<h2 align="center"><font face="Times New Roman"
color="black">University Grants Comission,New
Delhi</h2></font>
<h3 align="center"><font face="Times New Roman"
Page 18 of 40
19
color="black"><u>Diploma in Computer
Application(DCA)</h3></u></font>
<br>
<br>
<center>
<h2>New Registration</h2>
<form method="post">
<table border="0">
<tr>
<td>Name:</td><td><input type="text" name="name"
placeholder="Student_name"></td></tr>
<tr>
<td>Email:</td><td><input
type="email"name="email"placeholder="email"></td></tr>
<tr>
<td>Class:</td><td><input
type="class"name="class"placeholder="class"></td></tr>
<tr>
<td>Address:</td><td><input type="address"
name="address"placeholder="address"></td></tr>
Page 19 of 40
20
<tr>
<td>Mobile No.:</td><td><input type="text"
name="mobile"placeholder="mobile"></td></tr>
<tr>
<td>D.O.B.:</td><td><input type="date"
name="dob"placeholder="D.O.B"></td></tr>
<tr>
<td>Gender:</td><td><input type="radio" name="gender"
value="male"><label>male</label><input type="radio"
name="gender"
value="Female"><label>Female</label></td></tr>
<tr>
<td>Father's Name:</td><td><input type="text" name="fname"
placeholder="fname"></td></tr>
<tr>
<td><input type="submit" name="submit" value="submit"></td>
</tr>
</table>
<button><a href="total.php">Veiw Record</a></button>
<br><br><br>
Page 20 of 40
21
</form>
<?php
if(isset($_POST["submit"]))
{
$name=$_POST["name"];
$email=$_POST["email"];
$class=$_POST["class"];
$address=$_POST["address"];
$mobile=$_POST["mobile"];
$dob=$_POST["dob"];
$gender=$_POST["gender"];
$fname=$_POST["fname"];
mysqli_select_db($conn,"college");
$query="insert into
stu_info(name,email,class,address,mobile,dob,gender,fname)valu
es('$name','$email','$class','$address','$mobile','$dob','$gender','
$fname')";
//echo $insert;
Page 21 of 40
22
if(mysqli_query($conn,$query)){
echo"<br>";
echo"Data inserted successfully.";}
else{echo"some error".mysqli_error($conn);}
$query="select* from stu_info";
$data=mysqli_query($conn,$query);
$total=mysqli_num_rows($data);
echo"<br>";
echo"The total value is:".$total;
}
?>
<br><br><br><br><br><br><br><br><br><br>
</td></tr></table>
</center>
</body>
</html>
Page 22 of 40
23
Display data Code
<?php
include ("connection.php");
?>
<html>
<head>
<title>College</title>
</head>
<body bgcolor="white">
<center>
<table border="1">
<tr>
<th>id</th>
<th>Name</th>
<th>Father's
Page 23 of 40
24
Name</th>
<th>DOB</th>
<th>Gender</th>
<th>Mobile_No</th>
<th>Email</th>
<th>Address</th>
<th>Class</th>
<th>Operation1</th>
<th>Operation2</th>
</tr>
<br>
<br>
<?php
{
Page 24 of 40
25
$query="select * from stu_info";
$data=
mysqli_query($conn,$query);
$total=mysqli_num_rows($data);
echo "<br>";
echo "The Total
Values of this program is: ".$total;
echo "<br>";
}
if($total!=0){
$n=1;
//$result=mysqli_fetch_assoc($data);
while(($result=mysqli_fetch_assoc($data)))
{
echo"
<tr>
<td>".
$result['id']."</td>
<td>".
$result['name']."</td>
<td>".
Page 25 of 40
26
$result['fname']."</td>
<td>".
$result['dob']."</td>
<td>".
$result['gender']."</td>
<td>".
$result['mobile']."</td>
<td>".
$result['email']."</td>
<td>".
$result['address']."</td>
<td>".
$result['class']."</td>
<td><a
href='update.php?id=$result[id]'><input type='submit'
value='Update'></a></td>
<td><a
href='delete.php?id=$result[id]'><input type='submit'
value='Delete' onclick='return checkdelete()'></a></td>
</tr>
";
}
}
Page 26 of 40
27
else{
echo"No record
Found";
}
$n++;
?>
</table>
<br>
<br>
<br>
<br>
<button><a href="stu_info.php">Admission Form</a></button>
<button><a href="home.php">Home Page</a></button>
</body>
</html>
<script>
function
checkdelete()
{
Page 27 of 40
28
return confirm('Are
you want to delete this Data');
}
</script>
Update Data Code
<?php
include ("connection.php");
?>
<html>
<head>
Page 28 of 40
29
<title>College</title>
</head>
<body bgcolor="white">
<center>
<table border="1">
<tr>
<th>id</th>
<th>Name</th>
<th>Father's
Name</th>
<th>DOB</th>
<th>Gender</th>
<th>Mobile_No</th>
<th>Email</th>
<th>Address</th>
<th>Class</th>
Page 29 of 40
30
<th>Operation1</th>
<th>Operation2</th>
</tr>
<br>
<br>
<?php
{
$query="select * from stu_info";
$data=
mysqli_query($conn,$query);
$total=mysqli_num_rows($data);
echo "<br>";
echo "The Total
Values of this program is: ".$total;
echo "<br>";
}
if($total!=0){
$n=1;
Page 30 of 40
31
//$result=mysqli_fetch_assoc($data);
while(($result=mysqli_fetch_assoc($data)))
{
echo"
<tr>
<td>".
$result['id']."</td>
<td>".
$result['name']."</td>
<td>".
$result['fname']."</td>
<td>".
$result['dob']."</td>
<td>".
$result['gender']."</td>
<td>".
$result['mobile']."</td>
<td>".
$result['email']."</td>
<td>".
$result['address']."</td>
<td>".
$result['class']."</td>
Page 31 of 40
32
<td><a
href='update.php?id=$result[id]'><input type='submit'
value='Update'></a></td>
<td><a
href='delete.php?id=$result[id]'><input type='submit'
value='Delete' onclick='return checkdelete()'></a></td>
</tr>
";
}
}
else{
echo"No record
Found";
}
$n++;
?>
</table>
<br>
<br>
Page 32 of 40
33
<br>
<br>
<button><a href="stu_info.php">Admission Form</a></button>
<button><a href="home.php">Home Page</a></button>
</body>
</html>
<script>
function
checkdelete()
{
return confirm('Are
you want to delete this Data');
}
</script>
Page 33 of 40
34
Delete Data Code
<?php
include ("connection.php");
$id= $_GET['id'];
$query="delete from stu_info where id='$id'";
$data= mysqli_query($conn,$query);
if($data)
{
echo "Record
Deleted";
?>
<meta http-equiv="refresh" content ="0;
url=http://localhost/college/display.php"/>
<?php
}
else
{
echo "Failed";
}
?>
Page 34 of 40
35
Home Page Code
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-
scale=1.0">
<title>Home Page</title>
<style>
body {
font-family: Arial, sans-serif;
background-color: #f4f4f4;
margin: 0;
padding: 0;
}
.container {
width: 80%;
margin: 0 auto;
text-align: center;
padding-top: 100px;
}
Page 35 of 40
36
h1 {
color: #333;
}
.button {
display: inline-block;
padding: 15px 25px;
background-color: #87CEEB;
color: white;
text-align: center;
text-decoration: none;
font-size: 20px;
margin: 10px;
cursor: pointer;
border: none;
border-radius: 100px;
transition: background-color 0.3s;
}
.button:hover {
background-color: #87CEEB;
}
</style>
</head>
<body>
Page 36 of 40
37
<div class="container">
<h1>Acharya
Narendra Dev Kisan P.G. College, Babhnan, Gonda</h1>
<h1>Diploma
Program</h1>
<h1>Welcome to the Home Page</h1>
<a href="stu_info.php" class="button">Add New
Student</a>
<a href="display.php" class="button">View All Records</a>
<a href="total.php" class="button">Total Admission</a>
</div>
</body>
</html>
Page 37 of 40
38
Total Value Data Code
<?php
include ("connection.php");
?>
<html>
<head>
<title>College</title>
</head>
<body bgcolor="Pink">
<center>
<h1>Acharya Narendra Dev Kisan P.G. College, Babhnan,
Gonda</h1>
<?php
Page 38 of 40
39
{
$query="select * from stu_info";
$data=
mysqli_query($conn,$query);
$total=mysqli_num_rows($data);
echo "<br>";
echo "The Total
Values of this program is: ".$total;
echo "<br>";
}
?>
</table>
<br>
<br>
<br>
<br>
<button><a href="stu_info.php">Admission Form</a></button>
<button><a href="home.php">Home Page</a></button>
<button><a href="display.php">Total Admission</a></button>
</body>
</html>
Page 39 of 40
40
Page 40 of 40
