Databases Management System in PHP with Source code
in this php project demo you will see how to use this System To Manage Your Database Tables and Data Or Create New Ones .
this Online Application Will Help Manage Your Databases With a Beautiful User Interface.
this Online Application Will Help Manage Your Databases With a Beautiful User Interface.
Tools:
- Apache server.
- PHP programming Language.
- JavaScript JS, HTML, CSS.
- MySQL Database.
Framework:
- CodeIgniter.
- Apache server.
- PHP programming Language.
- JavaScript JS, HTML, CSS.
- MySQL Database.
Framework:
- CodeIgniter.
Watch This Project Overview Video
1 - Login
a beautiful login and logout system with forgot your password system to reset the user password
click on the select options at the top
to create a new database click on "Manage Databases".
- and select "Create Database" , now just fill the name of the database.
you can select the number of records to show ( you can select from 10 -> 50000 ) .
you can print table's data, save to pdf, csv or copy .
you can navigate data using the arrows or the numbers at the bottom to display the next page.
you can select the table you want on the bottom of the page.
- you can use the search box to search records in the selected table with the value you want.
- if you want more advanced search click on the mor options gear.
- now if you want to add more records just click on the "+ Create New Record" button and a form will show up.
- and to delete or edit a record just click on the right icons of the selected data
- When You Click On The Edit Icon a Form Will Show So You Can Change The Data You Want.
- if you want to add a new column click on the "Create new column" button.
- after that just fil up the data name, type and more.
- before adding a new column you must check out the column restrictions .
- or you can add a new restriction if you need to.
- when you click on the "Available restrictions" a new page will open with all the restrictions.
- now to edit a column click on the edit icon on the right.
- in the note Tab you can put a note relative to this table ( the selected table )
- in the "more" you can remove permanently the table or edit the table name
- you will be redirected to a new page where you can see all the users or add a new one.
- to add a new user just click on the "+Create New User" button .
- all you have to do now is to fill the new user data.
- you can view or create a new role by selecting "Roles/Permissions" on the top menu.
- you can view the Permissions On Each Table For The Selcted User
- You Can Create a New Role By Clicking the "+Create New Role" button.
- now you can view all the files name in the database.
- you can view the file or deleting it by clickng the red icon
I Hope You LIked This PHP Databases Management System.
2 - Navigation
you can navigate in this application using the top menu
3 - Database
if you want to select a database to manage or create a new one.click on the select options at the top
to create a new database click on "Manage Databases".
- and select "Create Database" , now just fill the name of the database.
4 - Records
when you login into the application you will see a page with a list of records from the default database. here you will see the selected table data.you can select the number of records to show ( you can select from 10 -> 50000 ) .
you can print table's data, save to pdf, csv or copy .
you can navigate data using the arrows or the numbers at the bottom to display the next page.
you can select the table you want on the bottom of the page.
- you can use the search box to search records in the selected table with the value you want.
- if you want more advanced search click on the mor options gear.
- now if you want to add more records just click on the "+ Create New Record" button and a form will show up.
- and to delete or edit a record just click on the right icons of the selected data
- When You Click On The Edit Icon a Form Will Show So You Can Change The Data You Want.
4 - Column
- to view the selected table columns, click on the column tab in the top
- if you want to add a new column click on the "Create new column" button.
- after that just fil up the data name, type and more.
- before adding a new column you must check out the column restrictions .
- or you can add a new restriction if you need to.
- when you click on the "Available restrictions" a new page will open with all the restrictions.
- now to edit a column click on the edit icon on the right.
- in the note Tab you can put a note relative to this table ( the selected table )
- in the "more" you can remove permanently the table or edit the table name
5 - Users
- to add a new user to manage the databases go to the top menu and click on "users"- you will be redirected to a new page where you can see all the users or add a new one.
- to add a new user just click on the "+Create New User" button .
- all you have to do now is to fill the new user data.
6 - Roles & Permissions
- Every User You Create Should Have a Roles With Specific Permissions Asigned to Him.- you can view or create a new role by selecting "Roles/Permissions" on the top menu.
- you can view the Permissions On Each Table For The Selcted User
- You Can Create a New Role By Clicking the "+Create New Role" button.
7 - Files
- to view the files on your database click the "Files" on the top menu.- now you can view all the files name in the database.
- you can view the file or deleting it by clickng the red icon
7 - Account
- if you want to edit your account informations click on the drop-down menu in the top and select account.I Hope You LIked This PHP Databases Management System.
if you want the source code click on the download button below
Courses you may like:
2 comments
commentsTravel Cloud Suite is the Best Hotel booking software in the market used to streamline and simplify the process of booking hotels for a group of travelers.
ReplyExcellent Blog, A must read.
Replybackup and disaster recovery