Online Public Access Catalog For Library System

Submitted by alpha_luna on Monday, September 12, 2016 - 14:44.

Online Public Access Catalog

If you are looking for Online Public Access Catalog for Library System or it's called OPAC then you are at the right place. We have a full source code for this kind of system Online Public Access Catalog for Library System is for viewing and providing information about books, authors, and category inside the library. This program works to provide the students the information of the book that we're gonna borrow, to know the status of the books inside the Library, and to know if the books are available or not. And, we display the image of the book in this program. The user can search by title, author, category, copyright year and the barcode of the books.

Creating our Table

For the first step, we are going to make our database. To create a database:

Open PHPMyAdmin
Create a database and name it as "opac_db".
After creating a database name, click the SQL and kindly copy the code below.

--
-- Table structure for table `book`
--
 
CREATE TABLE IF NOT EXISTS `book` (
  `book_id` int(11) NOT NULL AUTO_INCREMENT,
  `book_title` varchar(100) NOT NULL,
  `category_id` int(50) NOT NULL,
  `author` varchar(50) NOT NULL,
  `author_2` varchar(100) NOT NULL,
  `author_3` varchar(100) NOT NULL,
  `author_4` varchar(100) NOT NULL,
  `author_5` varchar(100) NOT NULL,
  `book_copies` int(11) NOT NULL,
  `book_pub` varchar(100) NOT NULL,
  `publisher_name` varchar(100) NOT NULL,
  `isbn` varchar(50) NOT NULL,
  `copyright_year` int(11) NOT NULL,
  `status` varchar(30) NOT NULL,
  `book_barcode` varchar(100) NOT NULL,
  `book_image` varchar(100) NOT NULL,
  `date_added` datetime NOT NULL,
  `remarks` varchar(100) NOT NULL,
  PRIMARY KEY (`book_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

Sample Codes - PHP This PHP source code is used for searching of the books. This is the syntax.

<?php
include('../admin/include/dbcon.php');
 
if(isset($_POST['search']))
{
        $keyword = $_POST['keyword'];
        $status = $_POST['status'];
        
        if ($status == '--All--') {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id 
                                                        where (category.classname like '%$keyword%' or
                                                        (book_barcode like '%$keyword%' or book_title like '%$keyword%'
                                                        or author like '%$keyword%' or copyright_year like '%$keyword%')) 
                                                        order by book.book_id DESC ") or die (mysql_error());
        } elseif ($status == 'Title') {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id 
                                                        where book_title like '%$keyword%'
                                                        order by book.book_id DESC ") or die (mysql_error());
        } elseif ($status == 'Author') {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id 
                                                        where author like '%$keyword%'
                                                        order by book.book_id DESC ") or die (mysql_error());
        } elseif ($status == 'Category') {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id 
                                                        where classname like '%$keyword%'
                                                        order by book.book_id DESC ") or die (mysql_error());
        } elseif ($status == 'Copyright') {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id 
                                                        where copyright_year like '%$keyword%'
                                                        order by book.book_id DESC ") or die (mysql_error());
        } elseif ($status == 'Barcode') {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id 
                                                        where book_barcode like '%$keyword%'
                                                        order by book.book_id DESC ") or die (mysql_error());
        } else {
                                                        $result= mysql_query("select * from book 
                                                        LEFT JOIN category ON book.category_id  = category.category_id
                                                        order by book.book_id DESC ") or die (mysql_error());
}                                                       
                                                        $return_count = mysql_num_rows($result);
                                                        while ($row= mysql_fetch_array ($result) ){     
                                                        $book_id=$row['book_id'];
                                                        $cat_id=$row['category_id'];
?>

Database Connection This is the script for our database connection.

<?php
mysql_select_db('opac_db',mysql_connect('localhost','root',''))or die(mysql_error());
?>

If the user searching the title of the book. This is the output. Result

Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Comments

missing table

The code is great but there is no category table. Hence, it can't search for book

Add new comment

Add new comment
763 views