• Skip to main content
  • Skip to secondary menu
  • Skip to primary sidebar
  • Home
  • About Us
  • Django
  • Laravel
  • Interview Questions
  • Tips

CodingStatus

- Learn Coding to Build Web Applications

  • JavaScript
  • jQuery
  • ReactJS
  • Ajax
  • Node.js
  • PHP
  • SQL

Admin Panel Template in PHP with Free Source Code

June 3, 2021 By Md Nurullah 29 Comments

If you are searching for Admin Panel Template in PHP, You are on the right tutorial. Here, you will get a free source code with a complete guide to integrate it into your website. I have created it with some basic template features. But once you read all the given points, you will definitely create more features according to your requirements.

If you develop a dynamic website and manage everything dynamically on the website, you will have to create an admin panel. It works as an intermediate to manage dynamic data between the database & website. Means that it fetches the data from the database based on users request using backend language.

So, I have used HTML, CSS , jquery & bootstrap in front-end and PHP, Ajax & MySQL for the backend. All the codes are written in a proper & standard form in a separate file so that you can easily understand and quickly implement it in your project. Even you can configure its setting without loading the page.

Learn more-

PHP Login System with Validation

 

admin panel template in php

Contents

  • Simple Admin Panel Template in PHP, Ajax & Bootstrap
  • How to Connect Admin Panel to Website
    • 1. Get Free Source Code
    • 2. Extract Zip File
    • 3. Import SQL Database file
    • 4. Configure Database Connection
    • 5. Log in to Admin Panel
  • How to Create an Admin Panel for the Website in PHP
    • 1. Create MySQL Database and Table
    • 2. Connect PHP Script to MySQL Database
    • 3. Create an Admin login
    • 4. Create an Admin  Dashboard
    • 5. Create Admin Header
    • 6. Create Admin Sidebar
    • 7. Create Admin Pages
    • 8. Create Ajax Script
    • 9. Create a Backend PHP Script

Simple Admin Panel Template in PHP, Ajax & Bootstrap

Before Creating an admin Panel in PHP, You should know the following information. It will help you to integrate easily into your website.

 Compatible Browsers IE11, Firefox, Safari, Opera, Chrome, Edge
 Files Included HTML, CSS, PHP, jQuery Ajax,MySQL, Bootstrap
 Software Version PHP 7.x, PHP 5.x, PHP 5.0 – 5.2

 Features

You will get the following most attractive & user-friendly features.

  • User-friendly Design
  • Mobile Responsive
  • Shared Hosting Compatible
  • PHP cURL Support
  • Fast & Secure
  • Easy to Integrate
  • Bootstrap4 Framework
  • Fully Ajax Based
  • Dynamic Data Management  without Reloading
  • MySQL Database
  • Admin Dashboard Design Setting

Functionality –

All the following functionality is created using ajax without refreshing the page –

  • Login with security
  • Logout on one click
  • Contact detail management
  • Website theming
  • Admin theming
  • Static Content Management
  • Website Title & description Management
  • Admin Profile Management

 

Admin Panel Pages

You will get the following default pages with Admin Panel.

  • Admin Login
  • Admin Dashboard
  • Website Setting
  • Theme Setting
  • Admin Logout
  • Contact Details
  • Contact Email
  • Website Menu
  • Contact Us Message
  • Home Content
  • Admin Profile
  • Change Password
  • Admin Theme Setting

How to Connect Admin Panel to Website

You can easily connect the admin panel to the website. if you configure the following steps –

1. Get Free Source Code

First of all, you need to get an admin panel script for your website. Don’t worry. I have provided free source code to connect it. you can get it through the following links –

Click Here to Get Admin Panel Source Code

2. Extract Zip File

Now, extract the zip file and paste it into your website folder.

3. Import SQL Database file

You will get database & table files in the ( config) folder. You can import either a database file or table file in your database according to your requirement.

4. Configure Database Connection

Open database.php and update the database connection details. This file remains in the ( config) folder.

5. Log in to Admin Panel

You can log in to the admin panel with the following credentials –

Admi Lodin URL – http://localhost/codingstatus/admin-panel/

 S. N Email  Password
 1 superadmin@gmail.com  admin123
 2 testadmin@gmail.com  admin123
 3 tempadmin@gmail.com  admin123

How to Create an Admin Panel for the Website in PHP

If you are a web developer and working with PHP & MySQL. You must read all the following points to learn a new & standard concept. It will also learn you How to write code in a smart way. So, It will be very helpful to increase your coding skills power.

You have already know how to get a free admin panel source code in the previous step. Here, You will get the complete information about files & setting to create an admin panel in PHP.

Before writing the code, You should create the following folder structure –

admin-panel
   |__assets/
   |    |__css/
   |        |_style.css
   |__config/
   |    |__database.php
   |__contact/
   |    |__contact-details.php
   |    |__contact-email.php
   |    |__contact-us-message.php
   |__partials/
   |    |__header.php
   |    |__sidebar.php
   |__scripts/
   |    |__ajax-script.js
   |    |__backend-script.php
   |    |__dynamic-page.php
   |    |__multilevel-script.php
   |    |__admin-login.php
   |__setting/
   |    |__admin-panel.php
   |    |__color-setting.php
   |__website-admin/
   |    |__admin-profile.php
   |    |__change-password.php
   |__website-content/
   |    |__home-content.php
   |__website-setting
   |    |__theme-setting.php
   |    |__website-menu.php
   |    |__website-setting.php
   |__dashboard.php
   |__home.php
   |__index.php
   |__logout.php

let’s start to configure the following steps –

1. Create MySQL Database and Table

You must create a MySQL database using the following query –

Database Name – admin_panel

 

You must also create tables using the following query –

Table Name – admin_profile

CREATE TABLE `admin_profile` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`full_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`status` int(10) DEFAULT 0,
`created_at` timestamp(6) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store the admin profile detail

Table Name – categories

CREATE TABLE `categpries` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`parent_id` int(10) DEFAULT NULL,
`category_name` varchar(255) DEFAULT NULL,
`menu_link` varchar(255) DEFAULT NULL,
`header_menu` int(10) DEFAULT NULL,
`footer_menu` int(10) DEFAULT NULL,
`description` text(3000) DEFAULT 0,
`created_at` timestamp(6) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store the website header & footer menu

Table Name – color_setting

CREATE TABLE `color_setting` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`navbar_background` varchar(255) DEFAULT NULL,
`sidebar_background` varchar(255) DEFAULT NULL,
`text_color` varchar(255) DEFAULT NULL,
`save_button_color` varchar(255) DEFAULT NULL,
`edit_button_color` varchar(255) DEFAULT NULL,
`delete_button_color` varchar(255) DEFAULT NULL,
`view_button_color` varchar(255) DEFAULT NULL,
`label_text_color` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store color name

Table Name – contacts

CREATE TABLE `contacts` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`full_name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`created_at` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store contact message

Full Name – contact-details

CREATE TABLE `contact_details` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`email` varchar(255) DEFAULT NULL,
`mobile` varchar(255) DEFAULT NULL,
`google_map` varchar(255) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
`facebook` varchar(255) DEFAULT NULL,
`linkedin` varchar(255) DEFAULT NULL,
`twitter` varchar(255) DEFAULT NULL,
`google_plus` varchar(255) DEFAULT NULL,
`instagram` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store contact details

Full Name – contact-email

CREATE TABLE `contact_email` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`email` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This  table is created to store contact us an email address

Full Name – home_contact

CREATE TABLE `home_contact` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`content_section` varchar(255) DEFAULT NULL,
`first_title` varchar(255) DEFAULT NULL,
`second_title` varchar(255) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store static content for the website home page

Full Name – theme_setting

CREATE TABLE `theme_setting` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`header_background` varchar(255) DEFAULT NULL,
`footer_background` varchar(255) DEFAULT NULL,
`first_title` varchar(255) DEFAULT NULL,
`second_title` varchar(255) DEFAULT NULL,
`third_title` varchar(255) DEFAULT NULL,
`footer_menu_link` int(10) DEFAULT 0,
`header_menu_link` int(10) DEFAULT 0,
`paragraphp` varchar(255) DEFAULT NULL,
`logo_name` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

This table is created to store theme color

Table Name – website_setting

CREATE TABLE `website_setting` (
`id` int(10) UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
`website_title` varchar(255) DEFAULT NULL,
`website_name` varchar(255) DEFAULT NULL,
`visible_website_name` varchar(255) DEFAULT NULL,
`website_logo` varchar(255) DEFAULT NULL,
`website_favicon` varchar(255) DEFAULT NULL,
`meta_keyword` varchar(255) DEFAULT NULL,
`meta_description` varchar(255) DEFAULT NULL,
`google_varification_code` varchar(255) DEFAULT NULL,
`google_analytics_code` varchar(255) DEFAULT NULL,
`created_at` timestamp(6) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

This table is created to store the website basics information

2. Connect PHP Script to MySQL Database

Connect Admin Panel PHP script to MySQL database –

File Name – database.php

3. Create an Admin login

Configure the following points in index.php to create an admin panel –

  • First of all, start the session
  • Assign session login email to a variable $email_address
  • $email_address is not empty, redirect to the dashboard.php.
  • Include database file database.php & admin login admin-login.php
  • Write the HTML code to create an admin login form.
  • Display login success & fail message.

4. Create an Admin  Dashboard

Configure the following points in dashboard.php to create an admin dashboard –

  • First of all, start the session
  • Assign session login email to a variable $email_address
  • $email_address is not empty, redirect to the index.php.
  • Get the value of cat & subcat query string value.
  • Include the admin files based on cat & subcat query string value.
  • Write HTML code to create an admin dashboard.

5. Create Admin Header

Configure the following points in header.php to create an admin header –

  • Write the HTML code to create the Admin Header.
  • Fetch the color value from the database.
  • print it within a CSS style to change the admin theme color.

6. Create Admin Sidebar

Configure the following points in sidebar.php to create an admin sidebar –

  • Write HTML code to create a sidebar.
  • Create sidebar link URL with a query string parameter  cat & subcat

7. Create Admin Pages

Create the following admin pages and configure the CRUD operation using ajax & PHP. It will explain in the next step –

  • Contact Detail  – Create it to update website contact detail like email, mobile number, address & social link.
  • Contact Email – Create it to set up an email for the contact us page.
  • Website Setting  – Create it to configure a basic website setting like logo, favicon, website name, website title, meta keyword &  description.
  • Contact Us Message – Create it to display contact us a message.
  • Theme Setting  – Create it to configure basic theme settings like navbar  & text color.
  • Website Menu – Create it to create a multilevel menu for header & footer
  • Home Content  – Create it to update static content on the website home page.
  • Admin Profile – Create it to update existing admin & add a new admin to assign role admin panel
  • Change Password  – Create it to change the admin password.
  • Admin Theme Setting – Create it to set up admin theme settings like text & background color.

8. Create Ajax Script

To configure the following operation without reading the page, you will have to create ajax script to send a request to backend-script.php file –

  • Open admin pages on click sidebar link with a.content-link
  • Insert form data into the database on submit with form id  #adminForm
  • Update data in a database on submitting with form id #updateForm
  • Delete data from the database on click a link with a class .delete
  • Allow admin to manage data on click link with a class .adminRole

9. Create a Backend PHP Script

You have to create a backend PHP script in the following files. Each script file has its own functionality to perform.

  • backend-scritp.php – Create it to perform the CRUD operation of admin pages.
  • dynamic-page.php – Create it to include the admin page dynamically.
  • multilevel-script.php – Create it to create a multilevel menu for the header & footer menu.

 

Summary –

I have guided you to create an admin panel template in PHP with some basic & general features & functionality. Now you can create more functionality yourself according to your project requirement.

If you have any questions related to this tutorial or web development tutorials, Ask me through the comment box. Even you can suggest web development topics to share a complete guide.

 

 

Related Posts:

  • SQL Interview Questions and Answers
  • How to Learn Web Development Step by Step
  • Create React App Project Step By Step
  • PHP Interview Questions and Answers

Filed Under: PHP

Hey there, Welcome to CodingStatus. My Name is Md Nurullah from Bihar, India. I'm a Software Engineer. I have been working in the Web Technology field for 3 years. Here, I blog about Web Development & Designing. Even I help developers to build the best Web Applications.

Reader Interactions

Comments

  1. Ravi Sharma says

    September 15, 2020 at 11:06 am

    Sir i was not entering in admin panel because your email id and password not working in this page

    Reply
    • Noor Khan says

      September 15, 2020 at 11:39 am

      Hi Ravi, Please use the following login credential,
      email – superadmin@gmail.com
      password – admin123

      Reply
      • Tom Dings says

        August 18, 2021 at 6:56 am

        Works perfectly!`

        Reply
  2. Mohammed Njidda says

    September 21, 2020 at 5:12 pm

    thank you Sir

    Reply
  3. Innovation Triggers Management Pvt. Ltd. says

    October 30, 2020 at 10:14 am

    Your post is really awesome and thanks for that source code it’s very helpful for our project.

    Reply
  4. madhu says

    November 22, 2020 at 4:58 pm

    Sir i was not entering in admin panel because your email id and password not working in this page

    Reply
    • Noor Khan says

      November 28, 2020 at 10:27 am

      Hi Madhu,
      follow the given steps carefully. you will definitely login to the admin panel with the given email &password

      Reply
  5. Renga says

    December 1, 2020 at 12:40 am

    Awesome, great work!.

    Reply
  6. Ifesinachi says

    December 8, 2020 at 9:10 pm

    It really helped me, sir.
    Although, it is still not clear to me but hopefully I will understand soon.
    Sir, the home-content.php updates the website but I don’t really know which one is the website main page.

    Reply
  7. fatima says

    December 14, 2020 at 2:00 am

    hello, please i need to form an html page that includes a bootstrap table which will be filled with home_content table database. If you can tell me the code.

    Reply
  8. Nacer says

    April 18, 2021 at 5:25 pm

    Hi,

    Thank you for the share !

    I have a question, how to create a non-admin account ?
    I want to create a simple member account, without givviing access to the admin setions.

    Thank you in advance.

    Nacer.

    Reply
  9. Justin says

    May 7, 2021 at 6:38 pm

    Hello Sir,
    Thanks for the wonderful admin panel created by you. I really love it.
    I have one doubt how to integrate admin data to home.php?? Please guide me.

    Reply
  10. Kant says

    May 19, 2021 at 6:18 am

    I should use database user name and password or something else in dashboard.php

    Reply
    • Md Nurullah says

      August 21, 2021 at 7:08 pm

      yes , you can

      Reply
  11. Arch says

    June 27, 2021 at 9:29 am

    Tq sir, your code is really helpful for us.

    Reply
    • Md Nurullah says

      June 28, 2021 at 11:05 pm

      your most welcome.. kindly continue to visit my site for getting more new coding tutorials. also, share with your friends

      Reply
  12. Gopal Prasad yadav says

    July 10, 2021 at 12:11 pm

    Hello Sir I am static web designer and I want to learn php for dynamic website development. If you provide me online tuition for php then it would be very helpful for me.

    Reply
    • Md Nurullah says

      July 17, 2021 at 4:08 pm

      Soory, At this time, I am busy. But I will teach through youtube channel asap

      Reply
    • Md Nurullah says

      July 17, 2021 at 4:08 pm

      Sorry, At this time, I am busy. But I will teach through youtube channel asap

      Reply
  13. OSHO says

    July 14, 2021 at 11:29 pm

    can i use it for my commercial purposes, also to connect this admin panel with the website i made?

    Reply
    • Md Nurullah says

      July 17, 2021 at 3:24 pm

      Yes you can

      Reply
      • Manzi Eric says

        November 16, 2021 at 11:26 pm

        But how exactly sir?

        Reply
  14. Frances Jarboe says

    August 6, 2021 at 10:57 am

    You were right. Thank you for your advice, how can I thank you?

    Reply
  15. Lala says

    August 16, 2021 at 2:03 am

    Hey, I’m trying to build a website where users can become organizers (add /delete/modify) events on the website.. can I use this?

    Reply
    • Md Nurullah says

      August 21, 2021 at 6:39 pm

      yes you can

      Reply
  16. MJ says

    August 29, 2021 at 9:22 am

    Hey man, thanks for the help. This really helps me because we are on online learning and tbh I don’t learn from it. That’s this really helped me in my capstone project. Stay safe sir.

    Reply
  17. Ranjit says

    February 4, 2022 at 9:30 pm

    Create paging functionality

    Reply
    • Md Nurullah says

      March 12, 2022 at 4:18 pm

      Hello Ranjit

      Pagination functionality will be added soon

      Reply
  18. dunnose Head says

    February 20, 2022 at 4:49 pm

    Thanks for this article, it has been very helpful !

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Follow us

  • facebook
  • twitter
  • linkedin

Recent Posts

  • SQL HAVING – Definition, Query, Syntax, Example
  • Integrate Google reCAPTCHA using PHP
  • CSS Interview Questions and Answers
  • Approve And Disapprove in Ajax, PHP & MySQL
  • HTML Interview Questions and Answers
  • Home
  • About Us
  • Privacy Policy
  • Disclaimer
  • Terms & Conditions
  • Sitemap
  • Contact Us

Copyright © 2022 CodingStatus - All Rights Reserved