PHP Project

A
MICRO PROJECT REPORT ON

“LIBRARY MANAGEMENT SYSTEM”
FOR THE DIPLOMA IN COMPUTER ENGINEERING
SUBMITTED BY
SANDHYARANI SHIVAJI SALUNKE
RUCHIKA GANESH TONGIRE
SAYALI SUBHASH SONAWANE
UNDER THE GUIDANCE OF

Ms.P.V.POLSHETWAR
DEPARTMENT OF COMPUTER ENGINEERING

CSMSS COLLEGE OF POLYTECHNIC, AURANGABAD
MAHARASHTRA, INDIA
AND
MAHARASHTRA STATE BOARD OF TECHNICAL
EDUCATION, MUMBAI
ACADEMIC YEAR 2022-23
1
CERTIFICATE
This is to certify that Following Students of Sixth semester of Diploma in
Computer Engineering of Institute CSMSS College of Polytechnic (code:1152) have
completed the Micro Project satisfactorily in subject Web Page Designing With
PHP (22619) for the academic year 2022-2023 as prescribed in the curriculum.
Place: Ch.Sambhajinagar
Date:
Sr. No. Name of Student Enrollment No.

1 SANDHYARANI SHIVAJI SALUNKE 2111520314
2 RUCHIKA GANESH TONGIRE 2011520133
3 SAYALI SUBHASH SONAWANE 2011520127
PROJECT GUIDE HEAD OF DEPARTMENT
PRINCIPAL
2
ACKNOWLEDGEMENT
We would like to express our thanks to the people who have helped us most throughout our
project. We would like to express our sincere thanks to the principal of CSMSS College of
Polytechnic Dr. G.B. Dongre for being always with us as a motivator. We are thankful to the
H.O.D. Mrs.R.S.Pophale of Computer Engineering Department for his kind support. We are
grateful to our Project Guide Ms.P.V.Polshetwar for nonstop support and continuous
motivation for the project. His help made us possible to complete our project with all accurate
information. A special thanks of our goes to our friends who helped us in completing the
project, where they all exchanged their own interesting ideas. We wish to thanks our parents
for their personal support or attention who inspired us to go our own way. Finally, we would
like to thank God who made all things possible for us till the end.
Sr. No. Name of Student Sign
1 SANDHYARANI SHIVAJI SALUNKE
2 RUCHIKA GANESH TONGIRE
3 SAYALI SUBHASH SONAWANE
3
INDEX
Sr. No Content Page No.
1 Micro-project Proposal 5
2 Rationale 6
3 Aims/Benefits of the micro-project 7
4 Course Outcome Achieved 8
5 Literature Review 9-11
6 Actual Procedure Followed 12
7 Output Of The Project 13
8 Skill developed / learning outcomes of micro-project 14
9 Appliancation of micro project 15
10 Conclusion 16
11 References 17
4
1. MICRO - PROJECT PROPOSAL
TITLE: Library Management System
1.0 AIMS /BENEFITS OF THE MICRO PROJECT -

 PHP is a general-purpose, server-side scripting language that runs a web server that's
designed to make dynamic pages and applications.
 PHP as a web development option is secure, fast, and reliable.
 In the growing field of Web technology, every Diploma pass outs need to learn PHP
Language to help them build interactive web applications.
 This course is designed to inculcate web-based application development skills in students
using server-side scripting with PHP.
2.0 COURSE OUTCOMES ADDRESSED -

Use form controls with validation to collect the user's input
Perform database operations in PHP
3.0 PROPOSED METHODOLOGY
The Library Management system (LMS) acts as a tool to transform traditional libraries into
digital libraries. In traditional libraries, the students/user has to search for books which are
hassle process and there is no proper maintenance of database about issues/fines.
4.0 ACTION PLANS:
Planned Name of Team

Planned
Sr.no Detail of Activity started Member
finished date
date
Refer book information to get All

1 10/02/23 10/02/23
information about PHP
discuss the micro-project with a All

2 24/02/23 24/02/23
subject teacher
3 collect information from the internet 09/03/23 09/03/23 All
Discuss the project with team All

4 24/03/23 24/03/23
members
create micro-project format in ms All

5 08/04/23 08/04/23
word
6 Create a library management system. 24/04/23 24/04/23 All
7 Print the project 02/05/23 02/05/23 All
5
5.0 RESOURCES REQUIRED:
Sr. Name of Resource Specifications Quantity Remarks

No. / Material
1 Textbook Web-Based Application 1
development with PHP
22619
2 Internet W3 school/ geek4geek
3 PC Windows 11 1
NAMES OF TEAM MEMBER WITH ROLL NO:

Name of Student Roll
No.
SANDHYARANI SHIVAJI SALUNKE 77
RUCHIKA GANESH TONGIRE 67
SAYALI SUBHASH SONAWANE 62
Approved by,
Ms.P.V.Polshetwar
2. RATIONALE
PHP is a general purpose, server-side scripting language run a web server that’s designed to make dynamic
pages and applications. PHP as a web development option is secure, fast and reliable. In the growing field
6 of
Web technology it is essential for every Diploma pass outs to learn PHP Language to help them build
interactive web applications. This course is designed to inculcate web based applications development skills
in students using server side scripting with PHP.
7
3. AIMS / BENEFITS OF THE MICRO PROJECT
 PHP is a general-purpose, server-side scripting language that runs a web server that's
designed to make dynamic pages and applications.
 PHP as a web development option is secure, fast, and reliable.
 In the growing field of Web technology, every Diploma pass outs need to learn PHP
Language to help them build interactive web applications.
 This course is designed to inculcate web-based application development skills in students
using server-side scripting with PHP.
8
4. COURSE OUTCOMES ACHIEVED
Use form controls with validation to collect the user's input

Perform database operations in PHP
Develop the program using control statement
Perform operations based on array and object.
9
5.LITERATURE REVIEW
1.0 Brief Description:-

The project on "LIBRARY MANAGEMENT SYSTEM” gives us complete details about the library.
We can enter the record of the latest books and regain the details of books available in the library.
We can allocate the books to the students and maintain their records and can also inspect how many
books are issued and supply available in the library. In this project, we can maintain the late fine of
students who returns the issued books after the due date. The project is very helpful for those who
want to learn about Library Management systems.
I. PROBLEM DEFINITION
The Library Management System is created & developed for the receipt and allocation of books in
the library along with the student's details. The books acquired in the library are entered in the Books
Entry form and the related student details are entered in the student user form. When the student
wants to get the preferred book the same is issued on the availability base on the student. The
issuance and due date for the return of the book are also entered into the Book Issue form under the
menu Book Issue. The student has to pay the fine if any on the base of no. days delayed return of the
book in the library.
II. THEORETICAL BACKGROUND
HTML Form created for a selection of the different Menus. Subsequent menu options have been
provided in this Home Form
1. Books Entry
2. User Entry
3. Issue of Books
a) Issue of Books
b) Return of Books.
4. Book Delete And the web page design is as follows.
HOME PAGE
10
As said earlier, the web page has the following options "BOOK ENTRY', 'BOOK ISSUE', BOOK
RETURN", "BOOK SEARCH', 'BOOK DELETE'.
BOOK-ENTRY
By clicking the Book Entry Menu of the HTML web page ( home page) the above form is shown for the
entry of new books in the library. Following TextBoxes have been delivered for the entry of the books
related information:
1. Book no.
2. ISBN No.
11
3. Subject
4. Name of the Book
5. Author
6. Publisher
7. Edition
8. Copies
9. Price
In addition, Enter and Reset buttons have been provided in the form.
USER ACCOUNTS
By clicking any one of the menus 'BOOK ISSUE' or BOOK RETURN', the webpage will first direct to a
"User Entry” page and this form can be obtained for the entry of the new user coming to the library as a
user account as well as the returning of a book
In addition, the login and Refresh buttons have been provided in the form.
The following requirements have been provided in this form:

12
 Student Id
 Roll No.
 Name of the Student
 Branch
BOOK ISSUE
This form can be obtained by clicking the “BOOK ISSUE" for allocating a particular book available in the
library along with the issue and due date.
The following text boxes have been delivered for entry of Allocation of the Book.
 Book No.
 Student ID
 Current No. of Copies Available
 Issue Date
 Due Date
In addition, the Issue and Refresh buttons have been given in the form.
BOOK RETURN
This form can be fetched by clicking the "BOOK RETURN" for returning a particular book issued to the
user from the library along with the issue, due date, and return date with a fine if any.
The following text boxes have been provided for entry of return of the Books.
 Book No.
 Student ID
 Current No. of Copies Available
 Issue Date
 Due Date
 Fine, if any
In addition, Return and Refresh buttons have been given in the form.
BOOK SEARCH
This form can be acquired by clicking the menu "BOOK SEARCH" for getting particulars about a
particular book.
The following text boxes have been provided for entry of return of the Books.
 Book Name
 Author Name.
In addition, Submit button has been provided in the form.
If the book is found in the database, then the resulting web page will be shown.
BOOK DELETE
By clicking the Delete Menu of the HTML web page (home form) this form is shown for the deletion of
books in the library if required. Following TextBoxes have been provided for the finding books for
deletion:
13
 Book Name
 Author Name.
Table Design
Every web page is connected to a database (Microsoft Access 2010) form using a JSP page. And table
design for each form is given as follows.
USER ACCOUNT
FILED NAME DATATYPE
STUDENT ID AuoNumber
ROLL NO Number
STUDENT NAME Text
BRANCH Text
New Book entry
FIELD NAME DATATYPE
ID AuoNumber
BOOK_NAME Text
ISBN Number
SUBJECT Text
AUTHOR_NAME Text
PUBLISHER Text
EDITION Number
NO_OF_COPIE
Number
S
COST Number
BOOK ISSUE
FIELD NAME DATATYPE
BOOK NO AuoNumber
STUDENT ID Number
NO OF COPIES Number
14
ISSUE DATE Number
RETURN DATE Number
BOOK RETURN
FIELD NAME DATATYPE
BOOK NO AuoNumber
STUDENT ID Number
NO OF COPIES Number
ISSUE DATE Number
RETURN DATE Number
FINE IF ANY Number
15
6. ACTUAL METHODOLOGY FOLLOWED
PROGRAM CODE
A server-side technology, Java Server Pages is an extension to the Java servlet technology that was
created by Sun. JSPs have a dynamic scripting ability that works in tandem with HTML code,
separating the page logic from the static elements -- the actual design and display of the page -- to
assist create the HTML more functional (i.e. dynamic database queries). JSP codes that I used are
listed below.
1 LIB ENTRY
Code.
<%@page import="java.sql.*"%>
<%@page import-"java.io.*"%>
<html>
<body>
<%
String bno-request.getParameter("book_no");
String bn-request.getParameter("book_name");
String isbn-request.getParameter("book_isbn");
String sub-request.getParameter("book_subject");
String an-request.getParameter("author_name");
String pub-request.getParameter("book_publisher"); String ed-
request.getParameter("book_edition");
String cp-request.getParameter("no_of_copies");
String cst-request.getParameter("book_cost");
Class.forName("sun.jdbc.odbc.JdbcOdbc Driver");
Connection con-DriverManager.getConnection("Jdbc.Odbc:NEWBOOK");
Statement stmt-con.createStatement();
String s="INSERT INTO new_book_entry
тел
VALUES("+bno+":"+bn+":"+isbn+":"+sub+","+an+":"+pub+","+ed+":"+cp+":"+cst+"')";
stmt.executeUpdate(s);
con.commit();
%>
<body background-"image/7.jpg">
<br><br><br>
<br><center>
<FONT FACE-"COMIC SANS MS" COLOR="GREEN" SIZE="40%">
BOOK ADDED</CENTER></FONT><BR><BR>
<center><table width="40%" height="10%" bgcolor="#8ACA59"> <tbody>
<tr>
<td colspan=2 align="center"></td>
</tr>
<tr>
</tr>
<td><h3>A new book added to database!!!!!!</h3></td>
</tbody>
<BR><BR><BR>
</table>
</form>
</form>
<form name="form 1" action="BOOK_ISSUE.html">
16
<br><br><br><input type="submit" value="BACK" style="height: 50px; width:
150px"></center>
</form>
</body>
</html>
2.LIB ISSUE
Code:
<%@page import-"java.sql."%>
<html>
<body>
<%
String bno-request.getParameter("book_no");
String sid-request.getParameter("student_id");
String cp-request.getParameter("no_of_copies"); String is-request.getParameter("issue_date");
String rd-request.getParameter("return_date");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con-DriverManager.getConnection("Jdbc:Odbc:ISSUE"); Statement stmt-
con.createStatement();
String s-"INSERT INTO book_issue
VALUES(""+bno+":"+sid+", "+cp+":"+is+""""+rd+"")";
con.commit();
%>
<body background="image/7.jpg">
<br><br><br>
<br><center>
<FONT FACE="COMIC SANS MS" COLOR="GREEN" SIZE="40%">
<center><table width="40%" height="10%" bgcolor="#8ACA59">
<tbody>
<tr>
<td colspan-2 align="center"></td>
</tr>
<tr>
</tr>
<td><h3>BOOK ISSUED!!!!!!</h3></td>
</tbody>
<BR><BR><BR>
</table>
</form>
</form>
<form name="form 1" action="BOOK ISSUE.html">
<br><br><br><input type="submit" value="BACK" style="height: 50px; width.
150px"></center>
</form>
</body>
</html>
3.LIB RETURN
Code:
17
<html>
<body>
String bno-request.getParameter("book_no"); String sid-request.getParameter("student_id");
String cp-request.getParameter("no_of_copies");
String is-request.getParameter("issue_date");
String rd-request.getParameter("return_date");
String fn-request.getParameter("fine");
Connection con-DriverManager.getConnection("Jdbc.Odbc.RETURN"); Statement stmt-
String s-"INSERT INTO book_return
VALUES("+bno+":"+sid+":"+cp+":"+is+":"+rd+":"+fn+")";
%>
con.commit();
<br><br><br>
<br><center>
<FONT FACE="COMIC SANS MS" COLOR="GREEN" SIZE="40%">
<center><table width="40%" height="10%" bgcolor="#8ACA59">
<tbody>
<tr>
<td colspan=2 align="center"></td>
</tr>
<tr>
</tr>
<td><h3>BOOK RETURNED!!!!!!</h3></td>
</tbody>
<BR><BR><BR>
</table>
</form>
</form>
<form name="form1" action="USER_ACCOUNTS1.html">
150px"></center>
</form>
</body>
</html>
4.LIB SEARCH
Code:
<%@page import-"java.sql."%> <%@page import-"java.io."%>
try
{
Connection con-DriverManager.getConnection("Jdbc.Odbc.SEARCH"); Statement stmt-
String sub-request.getParameter("bname");
String st="select * from new_book_entry where BOOK_NAME="+sub+" ResultSet rs-
stmt.executeQuery(st);
%>
<html>
18
<head>
<title></title>
</head>
<form method="POST" action="">
<center>
<%
if(rs.next())
{
%>
<br><br><br><br>
<table border="1">
<BR><BR><BR><BR><BR><BR>
<tr>
<td><font face="comic sans ms" color="yellow">Book Id</font></td>
<td><font face="comic sans ms" color="yellow">Book Name</font></td>
<td><font face="comic sans ms" color="yellow">ISBN NO</font></td> <td><font face="comic
sans ms" color="yellow">Subject</font></td>
<td><font face="comic sans ms" color="yellow">Author Name</font></td>
<td><font face="comic sans ms" color="yellow">Publisher</font></td>
<td><font face="comic sans ms" color="yellow">Edition</font></td>
<td><font face="comic sans ms" color="yellow">No of Copies</font></td>
<td><font face="comic sans ms" color="yellow">Cost</font></td>
</tr>
<%
do
{
%>
<tr>
<td><font face-"comic sans ms" color="yellow"
><%out.println(rs.getString("BOOK_NAME"));%></font></td>
><%out.println(rs.getString("ID")); %></font></td>
><%out.println(rs.getString("ISBN")); %></font></td> <td><font face-"comic sans ms"
color="yellow"
><%out.println(rs.getString("SUBJECT")); %></font></td>
<td><font face="comic sans ms" color="yellow"
><%out.println(rs.getString("AUTHOR_NAME")); %></font></td> <td><font face="comic sans
ms" color="yellow"
><%out.println(rs.getString("PUBLISHER")); %></font></td>
><%out.println(rs.getString("EDITION")); %></font></td>
><%out.println(rs.getString("NO_OF_COPIES")); %></font></td>
><%out.println(rs.getString("COST")); %></font></td>
</tr>
} while(rs.next());
}
else
{
19
%>
<br><br><br><br><br><br<br><br><br><font face="comic sans ms"
color="yellow" size="20%">
<%
out.println("No such books found !!!!!!");
}
}
catch(Exception e)
{
System.out.println(e);
}
%7
</table>
</center>
</form>
</form>
<CENTER><form name="form1" action="BOOK_SEARCH.html">
150px"></center>
</form>
</body>
</html>
5.LIB_DELETE
Code:
<%@page import-"java.sql."%> <%@page import-"java.io.*"%>
<html>
<%
Class.forName("sun.jdbc.odbe.Jdbc0dbcDriver");
Connection con-DriverManager.getConnection("Jdbc.Odbc.NEWBOOK"); Statement st-
String find-request.getParameter("bname");
String r="select * from new_book_entry where BOOK_NAME="+find+"
ResultSet rs-st.executeQuery(r);
if(rs.next())
{
%>
<body background-"image/7.jpg">
<h1><center><b><font color="green"><BR><BR><BR>
<CENTER><FONT FACE="COMIC SANS MS" COLOR="GREEN" SIZE="40%">
BOOK DELETED</CENTER></FONT><BR><BR>
<form action="BOOK_DELETE.html">
<center><br><br><br><input type="submit" value="BACK" style="height: 50px; width:
150px"></center>
</form>
String delete="DELETE* from new_book_entry where BOOK_NAME="+find+"
st.executeUpdate(delete);
con.commit();}
else
{
<BR><BR><BR><BR><BR><BR><CENTER><FONT FACE-"COMIC SANS MS"
20
COLOR="GREEN" SIZE="40%">
INVALID ENTRY</CENTER></FONT><CENTER><BR><BR>
<form action-"BOOK DELETE.html">
<center><br><br><br><input type="submit" value="BACK" style="height: 50px; width:
150px"></center>
</form>
<% } %>
</body>
</html>
</form>
</body>
</html>
6.LIB USER
Code:
<html>
<body>
<%
String sid-request.getParameter("student_id"); String r-request.getParameter("roll_no");
String snm-request.getParameter("student_name"); String br-request.getParameter("branch");
Class.forName("sun.jdbc.odbc.Jdbc0dbcDriver");
Connection con-DriverManager.getConnection("Jdbc.Odbc.USER"); Statement stmt-
String s-"INSERT INTO user_account VALUES ("+sid+":"+m+":"+snm+":"+br+"')";
con.commit();
%7
</body>
</html>
21
7.ACTUAL RESOURCES USED
Sr. Name of Resource Specifications Quantity Remarks

No. / Material
1 Laptop Intel core(i3) 1
2 Windows OS Windows 10 1
3 MS Word MS Office 2010 1
22
8. SKILL DEVELOPED / LEARNING OUTCOMES OF MICRO - PROJECT:
a. Develop group discussion skills.

b. Communication skills improved.
c. MS WORD skills developed.
d. PHP
23
9. APPLICATIONS OF MICRO - PROJECT
A library management system is used to maintain library records. It tracks the records of the
number of books in the library, how many books are issued, or how many books have been
returned or renewed or late fine charges.
College Library Management Systems are web and mobile-based applications that allow higher
education institutions to deliver content and resources to students, faculty, and staff.
24
10. CONCLUSION
Wireless Sensor Networks (WSNs) is

an upcoming technology
with so many issues and challenges,
and it capable of creating
advanced technological solutions for
the residential, industrial
and every day world. A lot more
challenges will be raised,
considering that the technology
grows faster, the equipment
and hardware is being minimised and
the urge for ease and
convenience inreases too. In the
future fully co-operation of
the WSNs and the Internet will be
expected, achieving finally
the Internet of Things, which will
radically change the world
and the daily life. In this paper we
have used two different 25
sensing technologies the
environmental Crossbow platform
and the iPhone’s sensors to observe,
record and come with
results on how those two can work
together to implement a
smart home service within the realm of
WSNs and IoT. After
thorough testing and collection of
several results the average
values were plotted in this paper. As
part of the case study, the
latency of the sensing of motes was
tested to understand and
make sure that the best QoS can be
achieved. Throughout the
entire paper up to the final results,
a more in depth
understanding and knowledge aims to
be attained and used as
future reference to new projects.
26
have used two different
27
WSNs and IoT. After
a more in depth
28
29
WSNs and IoT. After
a more in depth
30
31
WSNs and IoT. After
a more in depth
32
33
WSNs and IoT. After
a more in depth
34
After we have finished the assignment we are sure that the problems in the current system would
overcome. The “LIBRARY MANAGEMENT SYSTEM" process was made computerized to reduce
human mistakes and to improve efficiency. The main focus of this assignment is to reduce human
efforts. The upkeep of the records is made efficient, as all the records are kept in the ACCESS
database, through which data can be recovered easily. The navigation control is fed in all the forms
to navigate through a large number of records. If the numbers of records are very large then the user
has to just type in the search string and the user gets the results instantly. The editing is also made
simpler. The user has to just type in the necessary field and press the submit button to get the desired
information.
11. REFERENCE 35
https://www.researchgate.net/
https://www.gsma.com/
https://pubmed.ncbi.nlm.nih.gov
36

PHP Project

Uploaded by

Copyright:

Available Formats

PHP Project

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

PHP Project

Uploaded by

Copyright:

Available Formats

A

MICRO PROJECT REPORT ON

FOR THE DIPLOMA IN COMPUTER ENGINEERING

UNDER THE GUIDANCE OF

DEPARTMENT OF COMPUTER ENGINEERING

ACADEMIC YEAR 2022-23

Sr. No. Name of Student Enrollment No.

3 SAYALI SUBHASH SONAWANE 2011520127

PROJECT GUIDE HEAD OF DEPARTMENT

Sr. No. Name of Student Sign

1 SANDHYARANI SHIVAJI SALUNKE

2 RUCHIKA GANESH TONGIRE

3 SAYALI SUBHASH SONAWANE

Sr. No Content Page No.

3 Aims/Benefits of the micro-project 7

4 Course Outcome Achieved 8

5 Literature Review 9-11

6 Actual Procedure Followed 12

7 Output Of The Project 13

8 Skill developed / learning outcomes of micro-project 14

9 Appliancation of micro project 15

1.0 AIMS /BENEFITS OF THE MICRO PROJECT -

2.0 COURSE OUTCOMES ADDRESSED -

3.0 PROPOSED METHODOLOGY

4.0 ACTION PLANS:

Planned Name of Team

Refer book information to get All

discuss the micro-project with a All

3 collect information from the internet 09/03/23 09/03/23 All

Discuss the project with team All

create micro-project format in ms All

6 Create a library management system. 24/04/23 24/04/23 All

7 Print the project 02/05/23 02/05/23 All

Sr. Name of Resource Specifications Quantity Remarks

NAMES OF TEAM MEMBER WITH ROLL NO:

RUCHIKA GANESH TONGIRE 67

SAYALI SUBHASH SONAWANE 62

Use form controls with validation to collect the user's input

1.0 Brief Description:-

II. THEORETICAL BACKGROUND

The following requirements have been provided in this form:

In addition, Submit button has been provided in the form.

FILED NAME DATATYPE

STUDENT NAME Text

FIELD NAME DATATYPE

FIELD NAME DATATYPE

RETURN DATE Number

FIELD NAME DATATYPE

ISSUE DATE Number

RETURN DATE Number

FINE IF ANY Number

Sr. Name of Resource Specifications Quantity Remarks

1 Laptop Intel core(i3) 1

3 MS Word MS Office 2010 1

a. Develop group discussion skills.

Wireless Sensor Networks (WSNs) is

You might also like