libsystem
This is a web-based application project that can help a certain school library manage their books information and borrow/return transactions of the student. This system has a user-friendly functionality and a pleasing user interface using a certain template for the design. This has the common features that are needed for a library management system. Talking about the system works, this system stores the list of books along with their system required information and also the list of the students. The said list must be populated by the system admin user or the librarian before proceeds to any transaction feature of this system..
Our project consists of
- ptms : Frontend application.
- ptms API: Backend application API with MySQL Workbench.
- ✅ HTML for creating frontend application.
- ✅ JavaScript for building our frontend HTML application
- ✅ Bootstrap for styling our application.
Our main language of development is PHP
- MySQL Workbench for our database.
First, check the required
- Bitnami Applications for PHP or other application server.
You can check by typing
into the your browser.
http://localhost:8080
You can download Bitnami here
You go to your browser and paste url http://localhost:8080/Name your project folder.
will see the web application runs at http://localhost:8080/Name your project folder.
Reminder: this topic needs to be done only once.
check file initialize.php to setting base_url that is correct port and project folder fo but in my setting port is 8888 you should change it Usually the normal port is at 80 or http://localhost
and correct name database user name and password
Reminder: this topic needs to be done only once.
At ptms, we use MySQL Workbench to store user data and credentials, this section will teach you how to set up the database locally. But first of all
- You should have MySQL Workbench installed in your machine.
- You should know your master password of
phpmyadmin
superuser. (They will ask for it during the installation).
If top 2 requirements surpassed. You're ready to develop ptms's database. These are steps to get the database running.
if you want to develop more database use My SQL Workbench for easy to add more table or etc.
WARNING: You should follow the instructions exactly or you'll end up with a broken database that's super hard to work with and fix.
-
Go your browser
Login php my admin on your browser
Next
CREATE DATABASE "libsystem" select utf8 unicode ci and then click Create ;
This means you've successfully created a database.
-
import simple database
Click import on your database and select file.sql on floder db
and click go You should see a message saying
Import has been successfully finished.
This means you've import successfully to the database.