Best PHP-Based Courier Management System Project

Download Code – Best PHP-Based Courier Management System Project

Management System Project in PHP: A Complete Solution

In today’s fast-paced world, businesses need an efficient system to manage their courier operations, ensuring timely deliveries and excellent customer service. A PHP-based Courier Management System offers an ideal solution to streamline the entire delivery process, making it both effective and reliable.

Key Features of the Courier Management System in PHP

Automation: Automates tasks like order entry, dispatching, tracking, and reporting, saving time and reducing errors.
Real-time Tracking: Allows businesses and customers to track packages in real time, enhancing transparency and customer trust.
Integration: The system can easily integrate with tools like GPS tracking devices and barcode scanners for smooth operations.
Reporting: The system generates detailed reports to help businesses evaluate performance metrics, identify areas for improvement, and make data-driven decisions.

Benefits of a PHP-Based Courier Management System

Efficient Operations: Automates tasks, ensuring smoother operations and less room for error.
Customer Satisfaction: Real-time tracking, automated scheduling, and effective communication help in providing better service.
Scalability: The system can grow with the business, easily handling increased demand and additional features as needed.
Platform Compatibility: Since PHP is widely compatible with various platforms, businesses can use the system across different operating systems.

Why Use PHP and MySQL for Courier Management System?

PHP is a powerful server-side scripting language ideal for developing dynamic web applications. When combined with MySQL, a reliable open-source database management system, this combination offers a strong foundation for developing a Courier Management System. The combination ensures that businesses can store and manage data efficiently while ensuring the system’s flexibility and ease of integration.

For final-year students or developers looking to gain hands-on experience, PHP and MySQL-based projects are an excellent choice, offering valuable practical knowledge and a strong portfolio project.

Steps to Run the Courier Management System in PHP

Download the Source Code: Download the courier management system project in PHP with the source code.
Extract the Files: Extract the downloaded zip file containing the project folder.
Copy the Files: Copy the project folder to your “htdocs” directory (found in XAMPP or another local server).
Create a Database: Open your browser and go to localhost/phpmyadmin. Create a new database for the project.
Import the Database: Import the provided SQL file (usually named database.sql) into your newly created database.
Check Database Connection: Open the source code and verify that the database connection settings are correct.
Access the Admin Panel: Finally, go to the project’s admin panel and log in using the credentials provided in the source code folder.

Conclusion

A well-designed Courier Management System in PHP is essential for businesses aiming to optimize their courier operations, improve customer service, and remain competitive in the logistics industry. With features like automation, real-time tracking, and seamless integration, this PHP solution offers a powerful and scalable way to manage deliveries efficiently.

By using PHP and MySQL, businesses can build a custom solution tailored to their needs and expand it as they grow, ensuring that their courier operations are always running smoothly.

index PHP

<!DOCTYPE html>
<html lang="en">
<?php session_start() ?><!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
<?php 
	if(!isset($_SESSION['login_id']))
	    header('location:login.php');
    include 'db_connect.php';
    ob_start();
  if(!isset($_SESSION['system'])){

    $system = $conn->query("SELECT * FROM system_settings")->fetch_array();
    foreach($system as $k => $v){
      $_SESSION['system'][$k] = $v;
    }
  }
  ob_end_flush();

	include 'header.php' 
?>
<body class="hold-transition sidebar-mini layout-fixed layout-navbar-fixed layout-footer-fixed">
<div class="wrapper">
  <?php include 'topbar.php' ?>
  <?php include 'sidebar.php' ?>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 

  
  <div class="content-wrapper">
  	 <div class="toast" id="alert_toast" role="alert" aria-live="assertive" aria-atomic="true">
	    <div class="toast-body text-white">
	    </div>
	  </div>
    <div id="toastsContainerTopRight" class="toasts-top-right fixed"></div>
    
    <div class="content-header">
      <div class="container-fluid">
        <div class="row mb-2">
         

        </div>
            
      </div>
    </div>
    

    
    <section class="content">
      <div class="container-fluid">
         <?php 
            $page = isset($_GET['page']) ? $_GET['page'] : 'home';
            if(!file_exists($page.".php")){
                include '404.html';
            }else{
            include $page.'.php';

            }
          ?>
      </div>
    </section>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
    
    <div class="modal fade" id="confirm_modal" role='dialog'>
    <div class="modal-dialog modal-md" role="document">
      <div class="modal-content">
        <div class="modal-header">
        <h5 class="modal-title">Confirmation</h5>
      </div>
      <div class="modal-body">
        <div id="delete_content"></div>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-primary" id='confirm' onclick="">Continue</button>
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
      </div>
      </div>
    </div>
  </div>
  <div class="modal fade" id="uni_modal" role='dialog'>
    <div class="modal-dialog modal-md" role="document">
      <div class="modal-content">
        <div class="modal-header">
        <h5 class="modal-title"></h5>
      </div>
      <div class="modal-body">
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-primary" id='submit' onclick="$('#uni_modal form').submit()">Save</button>
        <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
      </div>
      </div>
    </div>
  </div>
  <div class="modal fade" id="uni_modal_right" role='dialog'>
    <div class="modal-dialog modal-full-height  modal-md" role="document">
      <div class="modal-content">
        <div class="modal-header">
        <h5 class="modal-title"></h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span class="fa fa-arrow-right"></span>
        </button>
      </div>
      <div class="modal-body">
      </div>
      </div>
    </div>
  </div>
  <div class="modal fade" id="viewer_modal" role='dialog'>
    <div class="modal-dialog modal-md" role="document">
      <div class="modal-content">
              <button type="button" class="btn-close" data-dismiss="modal"><span class="fa fa-times"></span></button>
              <img src="" alt="">
      </div>
    </div>
  </div>
  </div>
  

  
  <aside class="control-sidebar control-sidebar-dark">
    
  </aside>
  


</div>





<?php include 'footer.php' ?>
</body>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

<!DOCTYPE html>

<?php session_start() ?><!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

<?php

if(!isset($_SESSION['login_id']))

header('location:login.php');

include 'db_connect.php';

ob_start();

if(!isset($_SESSION['system'])){

$system = $conn->query("SELECT * FROM system_settings")->fetch_array();

foreach($system as $k => $v){

$_SESSION['system'][$k] = $v;

}

ob_end_flush();

include 'header.php'

<?php include 'topbar.php' ?>

<?php include 'sidebar.php' ?>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

</div>

</div>

<?php

$page = isset($_GET['page']) ? $_GET['page'] : 'home';

if(!file_exists($page.".php")){

include '404.html';

}else{

include $page.'.php';

}

</div>

</section>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

<h5 class="modal-title">Confirmation</h5>

</div>

</div>

<button type="button" class="btn btn-primary" id='confirm' onclick="">Continue</button>

<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>

</div>

</div>

</div>

<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>

</div>

</button>

</div>

</div>

</div>

</aside>

</div>

<?php include 'footer.php' ?>

</body>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

</html>

login PHP

<!DOCTYPE html>
<html lang="en"><!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
<?php error_reporting(0);
session_start();
include('./db_connect.php');
  ob_start();

    $system = $conn->query("SELECT * FROM system_settings")->fetch_array();
    foreach($system as $k => $v){
      $_SESSION['system'][$k] = $v;
    }
  ob_end_flush();
?>
<?php 
if(isset($_SESSION['login_id']))
header("location:index.php?page=home");

?>
<?php ?>
<?php include 'header.php' ?>
<body class="hold-transition login-page">

  <div class="limiter">
    
    <div class="container-login100">
      <div class="row"style="align-items: center;">
        <div class="col-md-5">
          <div class="login-aside text-center  d-flex flex-column flex-row-auto">

            <div class="d-flex flex-column-auto flex-column pt-lg-40 pt-15">

            <div class="text-center  brand-logo">

              <img class="logo-abbr" src="assets/uploads/logo1.jpg" alt="">
            </div>

            <h3 class="mb-2">Welcome back!</h3>
            <p>Experience the Powerful Courier Management Software<br>By <a href="https://mayurik.com">Mayuri K. Freelancer</a></p>

          </div>
          <div class="aside-image" >
            <img src="assets/uploads/pic1.gif" width="200px">
          </div>
        </div>
        </div>


<div class="col-md-7">
              <div class="col-xl-12 tab-content">
              <div class="wrap-login100">
<div class="login-box">
  <div class="login-logo">
    <a href="#"><h3><?php echo $_SESSION['system']['name'] ?> - Authority Login</h3></a>
  </div>
  <!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
  <div class="card-1">
   
      <form action="" id="login-form">

<div class="form-group mb-3">
  <label class="mb-1" for="val-email"><strong>Email</strong></label>
  <div>
    <input type="email" class="form-control" value="" name="email" required placeholder="mayuri.infospace@gmail.com">

  </div>
</div>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
<div class="form-group mb-3">
  <label class="mb-1"><strong>Password</strong></label>
  <input type="password" class="form-control" name="password" required placeholder="Password">
</div>

<div class="form-group mb-3">
  <div class="custom-control custom-checkbox ml-1">
    <input type="checkbox" class="form-check-input" id="remember">
    <label class="form-check-label" for="remember">Remember my preference</label>
  </div>
</div>

<div class="text-center form-group mb-3">
  <button type="submit" class="btn btn-primary btn-block">Sign In</button>
</div>
      
          
         
          
        </div>
      </form>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 
    
    
  </div>
</div>
</div>
</div>
</div>

</div>
</div>
</div>

<script>
  $(document).ready(function(){
    $('#login-form').submit(function(e){
    e.preventDefault()
    start_load()
    if($(this).find('.alert-danger').length > 0 )
      $(this).find('.alert-danger').remove();
    $.ajax({
      url:'ajax.php?action=login',
      method:'POST',
      data:$(this).serialize(),
      error:err=>{
        console.log(err)
        end_load();

      },
      success:function(resp){
        if(resp == 1){
          location.href ='index.php?page=home';
        }else{
          $('#login-form').prepend('<div class="alert alert-danger">Username or password is incorrect.</div>')
          end_load();
        }
      }
    })
  })
  })
</script>
<?php include 'footer.php' ?>

</body>
<!--  Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com --> 

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

<!DOCTYPE html>

<html lang="en"><!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

<?php error_reporting(0);

session_start();

include('./db_connect.php');

ob_start();

$system = $conn->query("SELECT * FROM system_settings")->fetch_array();

foreach($system as $k => $v){

$_SESSION['system'][$k] = $v;

}

ob_end_flush();

<?php

if(isset($_SESSION['login_id']))

header("location:index.php?page=home");

<?php ?>

<?php include 'header.php' ?>

</div>

<h3 class="mb-2">Welcome back!</h3>

<p>Experience the Powerful Courier Management Software<br>By <a href="https://mayurik.com">Mayuri K. Freelancer</a></p>

</div>

</div>

<a href="#"><h3><?php echo $_SESSION['system']['name'] ?> - Authority Login</h3></a>

</div>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

<label class="mb-1" for="val-email"><strong>Email</strong></label>

<div>

</div>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

<label class="mb-1"><strong>Password</strong></label>

</div>

<label class="form-check-label" for="remember">Remember my preference</label>

</div>

</div>

</form>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

</div>

$(document).ready(function(){

$('#login-form').submit(function(e){

e.preventDefault()

start_load()

if($(this).find('.alert-danger').length > 0 )

$(this).find('.alert-danger').remove();

$.ajax({

url:'ajax.php?action=login',

method:'POST',

data:$(this).serialize(),

error:err=>{

console.log(err)

end_load();

success:function(resp){

if(resp == 1){

location.href ='index.php?page=home';

}else{

$('#login-form').prepend('<div class="alert alert-danger">Username or password is incorrect.</div>')

end_load();

}

})

</script>

<?php include 'footer.php' ?>

</body>

<!-- Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

</html>

gaatitrack SQL

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 15, 2023 at 05:36 PM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `gaatitrack`
--

-- --------------------------------------------------------

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int(30) NOT NULL,
  `branch_code` varchar(50) NOT NULL,
  `street` text NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `zip_code` varchar(50) NOT NULL,
  `country` text NOT NULL,
  `contact` varchar(100) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `branch_code`, `street`, `city`, `state`, `zip_code`, `country`, `contact`, `date_created`) VALUES
(4, 'dIbUK5mEh96f0Zc', 'Sample', 'Sample', 'Sample', '123456', 'Philippines', '123456', '2023-11-27 13:31:49'),
(5, 'ugjU3qv4QOVd5J8', 'Shivaji Nagar', 'Nashik', 'MH', '422201', 'India', '9090909090', '2023-07-31 07:30:11'),
(6, 'SouWaBUl38xMpIK', 'pune', 'pune', 'maharshtra', '424002', 'India', '8585858585', '2023-08-02 18:33:35'),
(9, 'PRmKESVF4tWCzl2', ' Shankar Bhawan', 'Pune', 'maharshtra', '411038', 'India', '9090909090', '2023-08-03 13:04:18'),
(10, 'FDB7N4z0CnQr2Ky', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', 'pune', 'maharshtra', '424002', 'India', '7070707070', '2023-08-03 13:07:25'),
(11, 'Fe8czxW94PY2lwq', ' 759/8, Off, Prabhat Road, next to Sahyadri Hospital, Deccan Gymkhana', 'pune', 'Maharashtra', ' 411004', 'India', '6060707070', '2023-08-03 13:08:24'),
(12, 'SVYGbLwdW7em3zh', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune', 'pune', 'Maharashtra', ' 411038', 'India', '9090909090', '2023-08-03 14:40:41');

-- --------------------------------------------------------

--
-- Table structure for table `parcels`
--

CREATE TABLE `parcels` (
  `id` int(30) NOT NULL,
  `reference_number` varchar(100) NOT NULL,
  `sender_name` text NOT NULL,
  `sender_address` text NOT NULL,
  `sender_contact` text NOT NULL,
  `recipient_name` text NOT NULL,
  `recipient_address` text NOT NULL,
  `recipient_contact` text NOT NULL,
  `type` int(1) NOT NULL COMMENT '1 = Deliver, 2=Pickup',
  `from_branch_id` varchar(30) NOT NULL,
  `to_branch_id` varchar(30) NOT NULL,
  `weight` varchar(100) NOT NULL,
  `height` varchar(100) NOT NULL,
  `width` varchar(100) NOT NULL,
  `length` varchar(100) NOT NULL,
  `price` float NOT NULL,
  `status` int(2) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `parcels`
--

INSERT INTO `parcels` (`id`, `reference_number`, `sender_name`, `sender_address`, `sender_contact`, `recipient_name`, `recipient_address`, `recipient_contact`, `type`, `from_branch_id`, `to_branch_id`, `weight`, `height`, `width`, `length`, `price`, `status`, `date_created`) VALUES
(1, '201406231415', 'John Smith', 'Sample', '+123456', 'Claire Blake', 'Sample', 'Sample', 1, '1', '0', '30kg', '12in', '12in', '15in', 2500, 7, '2023-11-26 16:15:46'),
(3, '983186540795', 'John Smith', 'Sample', '+123456', 'Claire Blake', 'Sample', 'Sample', 2, '1', '3', '20Kg', '10in', '10in', '10in', 1500, 2, '2023-11-26 16:46:03'),
(10, '798438738398', ' Mayuri', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'k', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '5', '9', '45', '120', '677', '670', 800, 0, '2023-08-03 13:14:13'),
(11, '701589720901', 'Radhika', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune, Maharashtra 411005   ', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune, Maharashtra 411005   ', '7070707070', 2, '5', '11', '55', '160', '455', '555', 7000, 0, '2023-08-03 13:18:45'),
(12, '618331985221', 'Rakesh', '759/8, Off, Prabhat Road, next to Sahyadri Hospital, Deccan Gymkhana, Pune, Maharashtra 411004', '6060707070', 'Jain', '759/8, Off, Prabhat Road, next to Sahyadri Hospital, Deccan Gymkhana, Pune, Maharashtra 411004', '6060707070', 2, '5', '', '45', '160', '455', '670', 6000, 0, '2023-08-03 13:20:55'),
(13, '275728717086', 'Radhika', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'Gandhi', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '9', '9', '45', '120', '677', '67', 6000, 0, '2023-08-03 13:22:09'),
(14, '753697280349', 'Mayuri ', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', ' 9090909090', 'k', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', ' 9090909090', 2, '6', '10', '45', '160', '677', '670', 7000, 0, '2023-08-03 13:27:19'),
(15, '667392903463', 'Radhika ', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 2, '6', '4', '45', '160', '455', '555', 7000, 0, '2023-08-03 13:33:33'),
(16, '429522865395', 'mayuri', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'k', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '6', '6', '45', '120', '677', '67', 7000, 0, '2023-08-03 13:34:34'),
(17, '726627862410', 'mayuri', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'k', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '6', '5', '45', '120', '677', '67', 6000, 0, '2023-08-03 14:27:17'),
(18, '026242450983', 'Radhika', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '7070707070', 'Gandhi', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '7070707070', 2, '6', '9', '45', '120', '677', '670', 5000, 5, '2023-08-03 14:29:54'),
(19, '923246250964', 'Radhika', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 2, '6', '9', '45', '160', '455', '670', 6000, 0, '2023-08-03 14:33:19'),
(20, '199897593227', 'Radhika', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 2, '5', '9', '45', '160', '455', '555', 7000, 4, '2023-08-03 14:45:56');

-- --------------------------------------------------------

--
-- Table structure for table `parcel_tracks`
--

CREATE TABLE `parcel_tracks` (
  `id` int(30) NOT NULL,
  `parcel_id` int(30) NOT NULL,
  `status` int(2) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `parcel_tracks`
--

INSERT INTO `parcel_tracks` (`id`, `parcel_id`, `status`, `date_created`) VALUES
(1, 2, 1, '2023-11-27 09:53:27'),
(2, 3, 1, '2023-11-27 09:55:17'),
(3, 1, 1, '2023-11-27 10:28:01'),
(4, 1, 2, '2023-11-27 10:28:10'),
(5, 1, 3, '2023-11-27 10:28:16'),
(6, 1, 4, '2023-11-27 11:05:03'),
(7, 1, 5, '2023-11-27 11:05:17'),
(8, 1, 7, '2023-11-27 11:05:26'),
(9, 3, 2, '2023-11-27 11:05:41'),
(10, 6, 1, '2023-11-27 14:06:57'),
(11, 20, 4, '2023-08-11 21:36:28'),
(12, 18, 5, '2023-08-11 21:36:36');

-- --------------------------------------------------------

--
-- Table structure for table `system_settings`
--

CREATE TABLE `system_settings` (
  `id` int(30) NOT NULL,
  `name` text NOT NULL,
  `email` varchar(200) NOT NULL,
  `contact` varchar(20) NOT NULL,
  `address` text NOT NULL,
  `cover_img` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `system_settings`
--

INSERT INTO `system_settings` (`id`, `name`, `email`, `contact`, `address`, `cover_img`) VALUES
(1, 'Courier Management System', 'mayuri.infospace@gmail.com', '+919000090000', '8, Shivaji Nagar, Pune, Maharashtra, India', '');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(30) NOT NULL,
  `firstname` varchar(200) NOT NULL,
  `lastname` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `password` text NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = admin, 2 = staff',
  `branch_id` int(30) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `password`, `type`, `branch_id`, `date_created`) VALUES
(1, 'Mayuri K', 'K', 'mayuri.infospace@gmail.com', '21232f297a57a5a743894a0e4a801fc3', 1, 0, '2023-11-26 10:57:04'),
(4, 'Suhit', 'Chavan', 'suhit@gmail.com', 'e35b98bdf7f7b2ec50eaab211dd950de', 2, 5, '2023-07-31 07:30:37'),
(5, 'mayuri', 'Kale', 'mayuri@admin.com', '21232f297a57a5a743894a0e4a801fc3', 2, 5, '2023-08-02 18:34:44'),
(6, 'Nilesh', 'Chaure', 'n@admin.com', '0192023a7bbd73250516f069df18b500', 2, 6, '2023-08-02 19:47:31'),
(7, 'Mayuri', 'K', 'mayuri1@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', 2, 9, '2023-08-03 13:09:32');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `parcels`
--
ALTER TABLE `parcels`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `parcel_tracks`
--
ALTER TABLE `parcel_tracks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `system_settings`
--
ALTER TABLE `system_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `parcels`
--
ALTER TABLE `parcels`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `parcel_tracks`
--
ALTER TABLE `parcel_tracks`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `system_settings`
--
ALTER TABLE `system_settings`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

-- phpMyAdmin SQL Dump

-- version 5.2.1

-- https://www.phpmyadmin.net/

-- Host: 127.0.0.1

-- Generation Time: Aug 15, 2023 at 05:36 PM

-- Server version: 10.4.28-MariaDB

-- PHP Version: 8.2.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `gaatitrack`

-- --------------------------------------------------------

-- Table structure for table `branches`

CREATE TABLE `branches` (

`id` int(30) NOT NULL,

`branch_code` varchar(50) NOT NULL,

`street` text NOT NULL,

`city` text NOT NULL,

`state` text NOT NULL,

`zip_code` varchar(50) NOT NULL,

`country` text NOT NULL,

`contact` varchar(100) NOT NULL,

`date_created` datetime NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table `branches`

INSERT INTO `branches` (`id`, `branch_code`, `street`, `city`, `state`, `zip_code`, `country`, `contact`, `date_created`) VALUES

(4, 'dIbUK5mEh96f0Zc', 'Sample', 'Sample', 'Sample', '123456', 'Philippines', '123456', '2023-11-27 13:31:49'),

(5, 'ugjU3qv4QOVd5J8', 'Shivaji Nagar', 'Nashik', 'MH', '422201', 'India', '9090909090', '2023-07-31 07:30:11'),

(6, 'SouWaBUl38xMpIK', 'pune', 'pune', 'maharshtra', '424002', 'India', '8585858585', '2023-08-02 18:33:35'),

(9, 'PRmKESVF4tWCzl2', ' Shankar Bhawan', 'Pune', 'maharshtra', '411038', 'India', '9090909090', '2023-08-03 13:04:18'),

(10, 'FDB7N4z0CnQr2Ky', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', 'pune', 'maharshtra', '424002', 'India', '7070707070', '2023-08-03 13:07:25'),

(11, 'Fe8czxW94PY2lwq', ' 759/8, Off, Prabhat Road, next to Sahyadri Hospital, Deccan Gymkhana', 'pune', 'Maharashtra', ' 411004', 'India', '6060707070', '2023-08-03 13:08:24'),

(12, 'SVYGbLwdW7em3zh', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune', 'pune', 'Maharashtra', ' 411038', 'India', '9090909090', '2023-08-03 14:40:41');

-- --------------------------------------------------------

-- Table structure for table `parcels`

CREATE TABLE `parcels` (

`id` int(30) NOT NULL,

`reference_number` varchar(100) NOT NULL,

`sender_name` text NOT NULL,

`sender_address` text NOT NULL,

`sender_contact` text NOT NULL,

`recipient_name` text NOT NULL,

`recipient_address` text NOT NULL,

`recipient_contact` text NOT NULL,

`type` int(1) NOT NULL COMMENT '1 = Deliver, 2=Pickup',

`from_branch_id` varchar(30) NOT NULL,

`to_branch_id` varchar(30) NOT NULL,

`weight` varchar(100) NOT NULL,

`height` varchar(100) NOT NULL,

`width` varchar(100) NOT NULL,

`length` varchar(100) NOT NULL,

`price` float NOT NULL,

`status` int(2) NOT NULL DEFAULT 0,

`date_created` datetime NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table `parcels`

INSERT INTO `parcels` (`id`, `reference_number`, `sender_name`, `sender_address`, `sender_contact`, `recipient_name`, `recipient_address`, `recipient_contact`, `type`, `from_branch_id`, `to_branch_id`, `weight`, `height`, `width`, `length`, `price`, `status`, `date_created`) VALUES

(1, '201406231415', 'John Smith', 'Sample', '+123456', 'Claire Blake', 'Sample', 'Sample', 1, '1', '0', '30kg', '12in', '12in', '15in', 2500, 7, '2023-11-26 16:15:46'),

(3, '983186540795', 'John Smith', 'Sample', '+123456', 'Claire Blake', 'Sample', 'Sample', 2, '1', '3', '20Kg', '10in', '10in', '10in', 1500, 2, '2023-11-26 16:46:03'),

(10, '798438738398', ' Mayuri', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'k', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '5', '9', '45', '120', '677', '670', 800, 0, '2023-08-03 13:14:13'),

(11, '701589720901', 'Radhika', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune, Maharashtra 411005 ', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune, Maharashtra 411005 ', '7070707070', 2, '5', '11', '55', '160', '455', '555', 7000, 0, '2023-08-03 13:18:45'),

(12, '618331985221', 'Rakesh', '759/8, Off, Prabhat Road, next to Sahyadri Hospital, Deccan Gymkhana, Pune, Maharashtra 411004', '6060707070', 'Jain', '759/8, Off, Prabhat Road, next to Sahyadri Hospital, Deccan Gymkhana, Pune, Maharashtra 411004', '6060707070', 2, '5', '', '45', '160', '455', '670', 6000, 0, '2023-08-03 13:20:55'),

(13, '275728717086', 'Radhika', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'Gandhi', ' Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '9', '9', '45', '120', '677', '67', 6000, 0, '2023-08-03 13:22:09'),

(14, '753697280349', 'Mayuri ', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', ' 9090909090', 'k', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', ' 9090909090', 2, '6', '10', '45', '160', '677', '670', 7000, 0, '2023-08-03 13:27:19'),

(15, '667392903463', 'Radhika ', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 2, '6', '4', '45', '160', '455', '555', 7000, 0, '2023-08-03 13:33:33'),

(16, '429522865395', 'mayuri', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'k', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '6', '6', '45', '120', '677', '67', 7000, 0, '2023-08-03 13:34:34'),

(17, '726627862410', 'mayuri', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 'k', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '9090909090', 2, '6', '5', '45', '120', '677', '67', 6000, 0, '2023-08-03 14:27:17'),

(18, '026242450983', 'Radhika', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '7070707070', 'Gandhi', 'Shankar Bhawan, 2nd Floor, Ravi Shankar Marg, Kothrud, Pune, Maharashtra 411038', '7070707070', 2, '6', '9', '45', '120', '677', '670', 5000, 5, '2023-08-03 14:29:54'),

(19, '923246250964', 'Radhika', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 2, '6', '9', '45', '160', '455', '670', 6000, 0, '2023-08-03 14:33:19'),

(20, '199897593227', 'Radhika', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 'Gandhi', '2nd Floor, Opposite Hotel Central Park, Apte Road, near HDFC Bank, Deccan Gymkhana, Pune,', '7070707070', 2, '5', '9', '45', '160', '455', '555', 7000, 4, '2023-08-03 14:45:56');

-- --------------------------------------------------------

-- Table structure for table `parcel_tracks`

CREATE TABLE `parcel_tracks` (

`id` int(30) NOT NULL,

`parcel_id` int(30) NOT NULL,

`status` int(2) NOT NULL,

`date_created` datetime NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table `parcel_tracks`

INSERT INTO `parcel_tracks` (`id`, `parcel_id`, `status`, `date_created`) VALUES

(1, 2, 1, '2023-11-27 09:53:27'),

(2, 3, 1, '2023-11-27 09:55:17'),

(3, 1, 1, '2023-11-27 10:28:01'),

(4, 1, 2, '2023-11-27 10:28:10'),

(5, 1, 3, '2023-11-27 10:28:16'),

(6, 1, 4, '2023-11-27 11:05:03'),

(7, 1, 5, '2023-11-27 11:05:17'),

(8, 1, 7, '2023-11-27 11:05:26'),

(9, 3, 2, '2023-11-27 11:05:41'),

(10, 6, 1, '2023-11-27 14:06:57'),

(11, 20, 4, '2023-08-11 21:36:28'),

(12, 18, 5, '2023-08-11 21:36:36');

-- --------------------------------------------------------

-- Table structure for table `system_settings`

CREATE TABLE `system_settings` (

`id` int(30) NOT NULL,

`name` text NOT NULL,

`email` varchar(200) NOT NULL,

`contact` varchar(20) NOT NULL,

`address` text NOT NULL,

`cover_img` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table `system_settings`

INSERT INTO `system_settings` (`id`, `name`, `email`, `contact`, `address`, `cover_img`) VALUES

(1, 'Courier Management System', 'mayuri.infospace@gmail.com', '+919000090000', '8, Shivaji Nagar, Pune, Maharashtra, India', '');

-- --------------------------------------------------------

-- Table structure for table `users`

CREATE TABLE `users` (

`id` int(30) NOT NULL,

`firstname` varchar(200) NOT NULL,

`lastname` varchar(200) NOT NULL,

`email` varchar(200) NOT NULL,

`password` text NOT NULL,

`type` tinyint(1) NOT NULL DEFAULT 2 COMMENT '1 = admin, 2 = staff',

`branch_id` int(30) NOT NULL,

`date_created` datetime NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Dumping data for table `users`

INSERT INTO `users` (`id`, `firstname`, `lastname`, `email`, `password`, `type`, `branch_id`, `date_created`) VALUES

(1, 'Mayuri K', 'K', 'mayuri.infospace@gmail.com', '21232f297a57a5a743894a0e4a801fc3', 1, 0, '2023-11-26 10:57:04'),

(4, 'Suhit', 'Chavan', 'suhit@gmail.com', 'e35b98bdf7f7b2ec50eaab211dd950de', 2, 5, '2023-07-31 07:30:37'),

(5, 'mayuri', 'Kale', 'mayuri@admin.com', '21232f297a57a5a743894a0e4a801fc3', 2, 5, '2023-08-02 18:34:44'),

(6, 'Nilesh', 'Chaure', 'n@admin.com', '0192023a7bbd73250516f069df18b500', 2, 6, '2023-08-02 19:47:31'),

(7, 'Mayuri', 'K', 'mayuri1@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', 2, 9, '2023-08-03 13:09:32');

-- Indexes for dumped tables

-- Indexes for table `branches`

ALTER TABLE `branches`

ADD PRIMARY KEY (`id`);

-- Indexes for table `parcels`

ALTER TABLE `parcels`

ADD PRIMARY KEY (`id`);

-- Indexes for table `parcel_tracks`

ALTER TABLE `parcel_tracks`

ADD PRIMARY KEY (`id`);

-- Indexes for table `system_settings`

ALTER TABLE `system_settings`

ADD PRIMARY KEY (`id`);

-- Indexes for table `users`

ALTER TABLE `users`

ADD PRIMARY KEY (`id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `branches`

ALTER TABLE `branches`

MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

-- AUTO_INCREMENT for table `parcels`

ALTER TABLE `parcels`

MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

-- AUTO_INCREMENT for table `parcel_tracks`

ALTER TABLE `parcel_tracks`

MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

-- AUTO_INCREMENT for table `system_settings`

ALTER TABLE `system_settings`

MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- AUTO_INCREMENT for table `users`

ALTER TABLE `users`

MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Best PHP-Based Courier Management System Project

index PHP

login PHP

gaatitrack SQL

Related Posts:

Leave a Comment Cancel Reply