Simple Online Public Access Catalog (OPAC) using PHP and SQLite Free Source Code


This is a Simple PHP Project entitled Simple Onlne Public Access Catalog (OPAC). This is a web-based application that manages a certain school or university's library database of the materials or books in the library. The application provides the student or faculties an online platform where they can browse or search the book they are needed. This has a simple user interface/design using the Bootstrap v5 (a CSS Framework) and has user-friendly functionalities. This may help new PHP Programmers especially the students to widen their knowledge in creating a web application using PHP/OOP and SQLite3 as the database.

I developed this project using the following:

  • XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
  • PHP Language
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Bootstrap
  • and more...

About the Simple Onlne Public Access Catalog (OPAC)

This simple OPAC Web Application has 2 sides of the user interface which are the Admin Side of the Library Management Side and the User Side (Faculty and Student). The Admin Side is the side of the system where the library management stores the list of materials, books, researches, etc. held in the library. Admin users are in charge of managing the important list in the system such as the category and the sub-category list. The users or Faculty/Students can search the books they need using the application to check if it is available in the library and also to know some details of the material or book. The users can also list the book they needed into their cart and submit a borrowing request to the management. The management is the one who can validate the borrowing requests of the faculty and student.

Project Features

Admin Side

  • Secure Login/Logout
  • Home Page
  • Manage Category
    • Create New
    • List Categories
    • Edit Category Details
    • Update Category Status
    • Delete Category
  • Manage Sub Category
    • Create New
    • List Sub Categories
    • Edit Sub Category Details
    • Update Sub Category Status
    • Delete Sub Category
  • Manage Books/Materials
    • Add New Book/Materials
    • Upload Book/Material Images
    • Update Book/Materials Details
    • Update Status
    • Delete Book/Material
  • Manage User List (CRUD)
  • Manage Admin List (CRUD)
  • Manage Account Credentials


  • Login and Registration Modal
  • List All Book or Materials Held in the Library
  • Filter Material/Book List by Category
  • Filter Material/Book List by Sub Category
  • Search Material/Book
  • Display Books/Materials Details in Modal
  • Add Book/Material to Cart
  • Submit Borrowing Request to the Management
  • List All Borrowing Transactions
  • Update User Details/Credentials
  • Logout

Some of the System Snapshots

Public Home Page

Simple Onlne Public Access Catalog

Book/Material Details Modal

Simple Onlne Public Access Catalog

User Cart List

Simple Onlne Public Access Catalog

User Borrowing Transaction List

Simple Onlne Public Access Catalog

Admin Home Page

Simple Onlne Public Access Catalog

Borrowing Transaction Details Modal (Admin-Side)

Simple Onlne Public Access Catalog

How to Run


  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)


  1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and gd extension. Then, save the file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache.
  3. Extract the downloaded source code zip file.
  4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  5. Browse the Simple Onlne Public Access Catalog in a browser. i.e. http://localhost/opac/ for the public and user-side, http://localhost/opac/admin for the admin side.

Default Admin Access

Username: admin
Password: admin123


That's it! You can now explore the features and functionalities of this Simple Onlne Public Access Catalog (OPAC) project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP Projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.


Submitted byPaul Edward (not verified)on Wed, 11/09/2022 - 16:41

Hi. Added books on admin side cannot be viewed on public side. Tried creating a sample student account but the book/s don't appear. Thank you.

Add new comment