Library System with OPAC

Submitted by rinvizle on Monday, July 4, 2016 - 09:17.
Hello guys if you are looking for Library System with OPAC I have here a Library System with OPAC in PHP and Mysql as a database. And has an excellent graphical user interface and user friendly environment. The application handles the book library transactions in an efficient way. I propose this system last year in DHGGMHS for a survey of my system for more information to make it more functionally and better. Result

Sample Codes

This code is for the function or connection in a database. 
  1. <?php
  2. 	$db_host = "localhost";
  3. 	$db_username = "root";
  4. 	$db_pass = "";
  5. 	$db_name = "libsystem";
  6. 	mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
  7. 	mysql_select_db("$db_name") or die ("no database");              
  8. ?>
This code is for the Login form or index that started the session of the system 
  1. <!DOCTYPE HTML>
  2. <html>
  3. <head>
  4. <title>Library System - Login</title>
  5. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  6. 	<link rel="stylesheet" type="text/css" href="logger/reset.css">
  7. 	<link rel="stylesheet" type="text/css" href="logger/structure.css">
  8. 	<link rel="stylesheet" type="text/css" href="css/main.css" />
  9. 	<link rel="stylesheet" href="assets/css/bootstrap.min.css" type="text/css"/>
  10. 	<link rel="icon" type="image/png" href="media/images/library.png">
  11. </head>
  12. <?php
  13. 	session_start();
  14. ?>
  15. <body>
  16. <center><div id="header"><h1 class="header-login">DHGGMHS Library System</h1></div></center>
  17. <img class="bg_img" src="media/images/background_image.png">
  18. <form class="box login" method="POST">
  19. <label align="center"><font size="6" color="grey"><h3>LOGIN</h3></font></label>
  20. 	<fieldset class="boxBody">
  21. 	<label><h5>Username</h5></label>
  22. 	<input type="text"  placeholder="Username" required name="username">
  23. 	<label><a href="#" class="rLink" tabindex="5" ></a><h5>Password</h5></label>
  24. 	<input type="password" placeholder="Password" required name="password">
  25. 	<input type="submit" class="btnLogin" value="Login"  name="login">
  26. 	<input type="reset" class="btnLogin" value="Reset"  name="reset" >
  27. <?php
  28. 	if (isset($_SESSION['username'])) {
  29. 	header('Location: main.php');
  30. 	}
  31. 	else{
  32. 	}
  33. 	if(isset($_POST['login'])){		
  34. 	session_start();
  35. 	$username=$_POST['username'];
  36. 	$password=$_POST['password'];
  37. 	$passwords=md5($password);
  38. 	include('connection.php');
  39. 	$login = mysql_query("SELECT * FROM users WHERE username = '$username' and password = '$passwords'");
  40. 	if (mysql_num_rows($login) == 1){
  41. 		$_SESSION['username']=$_POST['username'];
  42. 		header("Location: main.php");
  43. 	}
  44. 	else{
  45. 		echo "
  46. 		<script language='javascript'>
  47. 			alert('Invalid Credentials');
  48. 		</script>
  49. 		";
  50. 	}
  51. }
  52. ?>
  53. </form>
  54. </body>
  55. </html>
The features of this system are the following:
  • Add, Edit, Reserve, Borrow, Return and Delete Books
  • Add Category, Add User, and it has a Penalty to be added
ResultAnd for the OPAC Form you can Search for books. Result This system includes reporting of all books recorded, books reserved, books borrowed, past due books and penalties using Data Report. The feature of this system includes user maintenance and borrower's information, transactions such as adding new books, borrowing books and returning books. 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]. Hope you like and learn from this system. Thank you. Account information: username: admin password: password

Tags

Add new comment

About text formats
  • 869 views