PHP and MySQL-Based Sanitation Management System Project with Source Code

Projects Inventory

2 days ago

Download code _ PHP and MySQL-Based Sanitation Management System Project

PHP and MySQL-Based Sanitization Management System

Introduction

The Sanitization Management System is a web application built using PHP and MySQL. It serves as a company website for sanitization services. The system has dynamic content and forms for both the admin panel (management side) and the public website (visitor side). It features an easy-to-use interface, designed with Bootstrap Framework and AdminLTE Template.

Technologies Used

This project is developed using the following technologies:

PHP
MySQL Database
HTML
CSS
JavaScript (JS)
Bootstrap
AdminLTE
jQuery
Ajax

How the System Works

Admin Panel (Management Side)

The admin panel is only accessible to company staff. There are two types of users:

Administrators – Have full control over all system features, including user management.
Staff – Have limited access to certain functions.

The admin panel allows management to:

View and manage service quotation requests
Respond to customer inquiries
Edit website content and company information

Public Website (Visitor Side)

Visitors do not need to log in or register. They can:

Browse available sanitization services
Read service descriptions
Request a service quotation by filling out a form
Send inquiries through the contact form

Features and Functionalities

Management Side (Admin Panel)

User Login and Logout
Dashboard Overview
Manage Services (Add, Edit, Delete)
Manage Website Pages
Handle Quotation Requests
Manage Customer Inquiries
Update Company Information
Manage System Users
Edit Account Credentials

Public Side (Visitor Interface)

View Website Pages (Home, About, Contact Us)
Explore Available Services
Read Detailed Service Descriptions
Submit a Service Quotation Request
Send an Inquiry

How to Install and Run the System

System Requirements

To run this project, you need a local web server like XAMPP.

Installation Steps

Enable GD Library in the php.ini file.
Open XAMPP Control Panel and start Apache and MySQL.
Download and extract the project source code.
Copy the extracted folder into the htdocs

directory of XAMPP.
Open a browser and go to phpMyAdmin (http://localhost/phpmyadmin).
Create a new database named sms_db.
Import the provided SQL file (sms_db.sql) from the database folder.
Open the project in a browser using http://localhost/php-sms/.

Admin Login Credentials

Username: admin
Password: admin123

Conclusion

This PHP and MySQL-based Sanitization Management System is available for free and can be used for educational purposes. You are free to download, modify, and customize the source code according to your needs. If you have any questions, feel free to ask.

index PHP

<?php require_once('../config.php'); ?>
 <!DOCTYPE html>
<html lang="en" class="" style="height: auto;">
<?php require_once('inc/header.php') ?>
  <body class="sidebar-mini layout-fixed control-sidebar-slide-open layout-navbar-fixed sidebar-mini-md sidebar-mini-xs text-sm" data-new-gr-c-s-check-loaded="14.991.0" data-gr-ext-installed="" style="height: auto;">
    <div class="wrapper">
     <?php require_once('inc/topBarNav.php') ?>
     <?php require_once('inc/navigation.php') ?>
     <?php if($_settings->chk_flashdata('success')): ?>
    <script>
      alert_toast("<?php echo $_settings->flashdata('success') ?>",'success')
    </script>
    <?php endif;?>      
     <?php $page = isset($_GET['page']) ? $_GET['page'] : 'home';  ?>
      <!-- Content Wrapper. Contains page content -->
      <div class="content-wrapper  pt-3" style="min-height: 567.854px;">
     
        <!-- Main content -->
        <section class="content  text-dark">
          <div class="container-fluid">
            <?php 
              if(!file_exists($page.".php") && !is_dir($page)){
                  include '404.html';
              }else{
                if(is_dir($page))
                  include $page.'/index.php';
                else
                  include $page.'.php';

              }
            ?>
          </div>
        </section>
        <!-- /.content -->
  <div class="modal fade" id="uni_modal" role='dialog'>
    <div class="modal-dialog modal-md modal-dialog-centered rounded-0" role="document">
      <div class="modal-content rounded-0">
        <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 bg-gradient-teal border-0 rounded-0" id='submit' onclick="$('#uni_modal form').submit()">Save</button>
        <button type="button" class="btn btn-secondary rounded-0" 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 rounded-0" role="document">
      <div class="modal-content rounded-0">
        <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="confirm_modal" role='dialog'>
    <div class="modal-dialog modal-md modal-dialog-centered rounded-0" role="document">
      <div class="modal-content rounded-0">
        <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  bg-gradient-teal border-0 rounded-0" id='confirm' onclick="">Continue</button>
        <button type="button" class="btn btn-secondary rounded-0" data-dismiss="modal">Close</button>
      </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>
      <!-- /.content-wrapper -->
      <?php require_once('inc/footer.php') ?>
  </body>
</html>

<?php require_once('../config.php'); ?>

<!DOCTYPE html>

<?php require_once('inc/header.php') ?>

<?php require_once('inc/topBarNav.php') ?>

<?php require_once('inc/navigation.php') ?>

<?php if($_settings->chk_flashdata('success')): ?>

alert_toast("<?php echo $_settings->flashdata('success') ?>",'success')

</script>

<?php endif;?>

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

<?php

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

include '404.html';

}else{

if(is_dir($page))

include $page.'/index.php';

else

include $page.'.php';

}

</div>

</section>

</div>

</div>

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

</div>

</button>

</div>

</div>

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

</div>

</div>

<button type="button" class="btn btn-primary bg-gradient-teal border-0 rounded-0" id='confirm' onclick="">Continue</button>

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

</div>

</div>

<?php require_once('inc/footer.php') ?>

</body>

</html>

login PHP

<?php require_once('../config.php') ?>
<!DOCTYPE html>
<html lang="en" class="" style="height: auto;">
 <?php require_once('inc/header.php') ?>
<body class="hold-transition login-page">
  <script>
    start_loader()
  </script>
  <style>
    body{
      background-image: url("<?php echo validate_image($_settings->info('cover')) ?>");
      background-size:cover;
      background-repeat:no-repeat;
      backdrop-filter: contrast(1);
    }
    #page-title{
      text-shadow: 6px 4px 7px black;
      font-size: 3.5em;
      color: #fff4f4 !important;
      background: #8080801c;
    }
  </style>
  <h1 class="text-center text-white px-4 py-5" id="page-title"><b><?php echo $_settings->info('name') ?></b></h1>
<div class="login-box">
  <!-- /.login-logo -->
  <div class="card card-navy my-2">
    <div class="card-body">
      <p class="login-box-msg">Please enter your credentials</p>
      <form id="login-frm" action="" method="post">
        <div class="input-group mb-3">
          <input type="text" class="form-control" name="username" autofocus placeholder="Username">
          <div class="input-group-append">
            <div class="input-group-text">
              <span class="fas fa-user"></span>
            </div>
          </div>
        </div>
        <div class="input-group mb-3">
          <input type="password" class="form-control"  name="password" placeholder="Password">
          <div class="input-group-append">
            <div class="input-group-text">
              <span class="fas fa-lock"></span>
            </div>
          </div>
        </div>
        <div class="row">
          <div class="col-8">
            <a href="<?php echo base_url ?>">Go to Website</a>
          </div>
          <!-- /.col -->
          <div class="col-4">
            <button type="submit" class="btn btn-primary  bg-gradient-teal border-0 btn-block">Sign In</button>
          </div>
          <!-- /.col -->
        </div>
      </form>
      <!-- /.social-auth-links -->

      <!-- <p class="mb-1">
        <a href="forgot-password.html">I forgot my password</a>
      </p> -->
      
    </div>
    <!-- /.card-body -->
  </div>
  <!-- /.card -->
</div>
<!-- /.login-box -->

<!-- jQuery -->
<script src="<?= base_url ?>plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="<?= base_url ?>plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="<?= base_url ?>dist/js/adminlte.min.js"></script>

<script>
  $(document).ready(function(){
    end_loader();
  })
</script>
</body>
</html>

<?php require_once('../config.php') ?>

<!DOCTYPE html>

<?php require_once('inc/header.php') ?>

start_loader()

</script>

<style>

body{

background-image: url("<?php echo validate_image($_settings->info('cover')) ?>");

background-size:cover;

background-repeat:no-repeat;

backdrop-filter: contrast(1);

}

#page-title{

text-shadow: 6px 4px 7px black;

font-size: 3.5em;

color: #fff4f4 !important;

background: #8080801c;

}

</style>

<p class="login-box-msg">Please enter your credentials</p>

</div>

</div>

<a href="<?php echo base_url ?>">Go to Website</a>

</div>

</div>

</div>

</form>

<!-- <p class="mb-1">

<a href="forgot-password.html">I forgot my password</a>

</p> -->

</div>

</div>

</div>

$(document).ready(function(){

end_loader();

})

</script>

</body>

</html>

sms_db SQL

-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 14, 2022 at 05:08 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.5

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

--
-- Database: `sms_db`
--

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

--
-- Table structure for table `inquiry_list`
--

CREATE TABLE `inquiry_list` (
  `id` int(30) NOT NULL,
  `fullname` text NOT NULL,
  `contact` text NOT NULL,
  `email` text DEFAULT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `inquiry_list`
--

INSERT INTO `inquiry_list` (`id`, `fullname`, `contact`, `email`, `subject`, `message`, `status`, `date_created`, `date_updated`) VALUES
(1, 'Mark Cooper', '09123456789', 'mcooper@mail.com', 'test', 'Sample Inquiry', 1, '2022-10-14 10:56:51', '2022-10-14 10:57:21');

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

--
-- Table structure for table `quote_list`
--

CREATE TABLE `quote_list` (
  `id` int(30) NOT NULL,
  `code` varchar(100) NOT NULL,
  `fullname` text NOT NULL,
  `email` text DEFAULT NULL,
  `contact` text NOT NULL,
  `address` text NOT NULL,
  `schedule` date NOT NULL,
  `remarks` text NOT NULL,
  `admin_remarks` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `quote_list`
--

INSERT INTO `quote_list` (`id`, `code`, `fullname`, `email`, `contact`, `address`, `schedule`, `remarks`, `admin_remarks`, `status`, `date_created`, `date_updated`) VALUES
(1, '2022101400001', 'Samantha Lou', 'sam23@mail.com', '09123545689', 'Sample Address 101', '2022-10-20', 'Sample remarks only', '', 1, '2022-10-14 10:45:51', '2022-10-14 10:47:03');

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

--
-- Table structure for table `quote_services`
--

CREATE TABLE `quote_services` (
  `quote_id` int(30) NOT NULL,
  `service_id` int(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `quote_services`
--

INSERT INTO `quote_services` (`quote_id`, `service_id`) VALUES
(1, 1);

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

--
-- Table structure for table `service_list`
--

CREATE TABLE `service_list` (
  `id` int(30) NOT NULL,
  `name` text NOT NULL,
  `description` text NOT NULL,
  `image_path` text DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `delete_flag` tinyint(1) NOT NULL DEFAULT 0,
  `date_created` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `service_list`
--

INSERT INTO `service_list` (`id`, `name`, `description`, `image_path`, `status`, `delete_flag`, `date_created`, `date_updated`) VALUES
(1, 'Home Cleaning and Sanita', '&lt;p&gt;&lt;span style=&quot;color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; text-align: justify;&quot;&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris lacinia gravida massa, non aliquet sapien scelerisque eget. Pellentesque neque eros, varius ac urna eget, maximus commodo ante. Donec aliquam quis risus at convallis. Suspendisse sed sagittis odio. Aenean ultrices sapien sit amet sollicitudin congue. Pellentesque dapibus lectus non purus consequat consectetur. Mauris dapibus ultrices suscipit. Nunc id mollis neque, quis convallis nibh. Curabitur quis efficitur lorem. Nullam egestas consectetur velit, eget sollicitudin sem hendrerit ac. Vestibulum vitae diam ligula. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Duis aliquam erat quis hendrerit semper. In sed mauris lorem. Fusce elementum feugiat euismod. Vivamus posuere purus ac aliquam ullamcorper.&lt;/span&gt;&lt;br&gt;&lt;/p&gt;', 'uploads/services//house-sanitization.jpg?v=1665714533', 1, 0, '2022-10-14 10:28:53', '2022-10-14 10:28:53'),
(2, 'Car Sanitization', '&lt;p&gt;&lt;span style=&quot;color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; text-align: justify;&quot;&gt;Vivamus quis metus nec ligula luctus dapibus sed et tellus. Sed non dignissim magna. Fusce tempus eget elit id dapibus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Aenean dictum lacus eget metus vestibulum, sed auctor erat egestas. Pellentesque eget sapien ut dui porta molestie a id ipsum. Ut ultricies odio non orci cursus, in convallis libero suscipit. Suspendisse in tortor velit.&lt;/span&gt;&lt;br&gt;&lt;/p&gt;', 'uploads/services//car-sanitization.png?v=1665714563', 1, 0, '2022-10-14 10:29:23', '2022-10-14 10:29:23'),
(3, 'Office Sanitzation', '&lt;p&gt;&lt;span style=&quot;color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; text-align: justify;&quot;&gt;Sed varius velit vitae quam sollicitudin, ac fermentum ex accumsan. Donec quis faucibus purus. Donec venenatis ornare lobortis. Aenean vel elementum arcu, vitae fringilla lectus. Curabitur risus mauris, ullamcorper vel nulla vitae, aliquet sodales dolor. Aenean in consectetur ante. Phasellus varius aliquam ante, vel viverra urna rhoncus in. Vestibulum dignissim purus nunc, et cursus libero ornare sit amet. Donec viverra enim a sodales hendrerit. Interdum et malesuada fames ac ante ipsum primis in faucibus. Vivamus et imperdiet tortor, nec pharetra nisl. Aenean eleifend justo eu commodo vestibulum. Pellentesque nec velit vel turpis iaculis venenatis id ut nibh. Nunc sed egestas ante, vitae rutrum justo. Maecenas dolor metus, fringilla a lectus suscipit, bibendum lacinia mauris.&lt;/span&gt;&lt;br&gt;&lt;/p&gt;', 'uploads/services//sanitize.jpeg?v=1665714611', 1, 0, '2022-10-14 10:30:11', '2022-10-14 10:30:11'),
(4, 'Hospital Sanitization', '&lt;p&gt;&lt;span style=&quot;color: rgb(0, 0, 0); font-family: &amp;quot;Open Sans&amp;quot;, Arial, sans-serif; text-align: justify;&quot;&gt;Curabitur eget varius diam. Aliquam sodales nunc in sodales suscipit. Duis sed facilisis arcu, sit amet tincidunt lorem. Pellentesque eget scelerisque nisl, vel placerat lacus. Donec faucibus justo massa, ut laoreet arcu vulputate eu. Nam velit urna, condimentum non viverra vel, aliquet et augue. Etiam et eleifend elit, at tempus eros. Vivamus quam risus, posuere quis quam vitae, imperdiet finibus lorem. Nulla viverra nibh tincidunt ex tincidunt, sed laoreet metus eleifend. Morbi tincidunt gravida sem, vel cursus eros elementum sit amet.&lt;/span&gt;&lt;br&gt;&lt;/p&gt;', 'uploads/services//1_sanitize.jpeg?v=1665714658', 1, 0, '2022-10-14 10:30:58', '2022-10-14 10:30:58');

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

--
-- Table structure for table `system_info`
--

CREATE TABLE `system_info` (
  `id` int(30) NOT NULL,
  `meta_field` text NOT NULL,
  `meta_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `system_info`
--

INSERT INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES
(1, 'name', 'Sanitization Management System'),
(6, 'short_name', 'SMS - PHP'),
(11, 'logo', 'uploads/logo.png?v=1665714862'),
(13, 'user_avatar', 'uploads/user_avatar.jpg'),
(14, 'cover', 'uploads/cover.png?v=1665714863'),
(17, 'phone', '456-987-1231'),
(18, 'mobile', '09123456987 / 094563212222 '),
(19, 'email', 'info@xyzsanitizationservices.com'),
(20, 'address', '7087 Henry St. Clifton Park, NY 12065');

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

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

CREATE TABLE `users` (
  `id` int(50) NOT NULL,
  `firstname` varchar(250) NOT NULL,
  `middlename` text DEFAULT NULL,
  `lastname` varchar(250) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `avatar` text DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 0,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='2';

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

INSERT INTO `users` (`id`, `firstname`, `middlename`, `lastname`, `username`, `password`, `avatar`, `last_login`, `type`, `date_added`, `date_updated`) VALUES
(1, 'Adminstrator', '', 'Admin', 'admin', '0192023a7bbd73250516f069df18b500', 'uploads/avatars/1.png?v=1649834664', NULL, 1, '2021-01-20 14:02:37', '2022-05-16 14:17:49');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `quote_services`
--
ALTER TABLE `quote_services`
  ADD KEY `quote_id` (`quote_id`),
  ADD KEY `service_id` (`service_id`);

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `quote_services`
--
ALTER TABLE `quote_services`
  ADD CONSTRAINT `quote_id_fk_qs` FOREIGN KEY (`quote_id`) REFERENCES `quote_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `service_id_fk_qs` FOREIGN KEY (`service_id`) REFERENCES `service_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
COMMIT;

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

254

255

-- phpMyAdmin SQL Dump

-- version 5.1.3

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

-- Host: 127.0.0.1

-- Generation Time: Oct 14, 2022 at 05:08 AM

-- Server version: 10.4.24-MariaDB

-- PHP Version: 8.1.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

-- Database: `sms_db`

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

-- Table structure for table `inquiry_list`

CREATE TABLE `inquiry_list` (

`id` int(30) NOT NULL,

`fullname` text NOT NULL,

`contact` text NOT NULL,

`email` text DEFAULT NULL,

`subject` text NOT NULL,

`message` text NOT NULL,

`status` tinyint(1) NOT NULL DEFAULT 0,

`date_created` datetime NOT NULL DEFAULT current_timestamp(),

`date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `inquiry_list`

INSERT INTO `inquiry_list` (`id`, `fullname`, `contact`, `email`, `subject`, `message`, `status`, `date_created`, `date_updated`) VALUES

(1, 'Mark Cooper', '09123456789', 'mcooper@mail.com', 'test', 'Sample Inquiry', 1, '2022-10-14 10:56:51', '2022-10-14 10:57:21');

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

-- Table structure for table `quote_list`

CREATE TABLE `quote_list` (

`id` int(30) NOT NULL,

`code` varchar(100) NOT NULL,

`fullname` text NOT NULL,

`email` text DEFAULT NULL,

`contact` text NOT NULL,

`address` text NOT NULL,

`schedule` date NOT NULL,

`remarks` text NOT NULL,

`admin_remarks` text NOT NULL,

`status` tinyint(1) NOT NULL DEFAULT 0,

`date_created` datetime NOT NULL DEFAULT current_timestamp(),

`date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `quote_list`

INSERT INTO `quote_list` (`id`, `code`, `fullname`, `email`, `contact`, `address`, `schedule`, `remarks`, `admin_remarks`, `status`, `date_created`, `date_updated`) VALUES

(1, '2022101400001', 'Samantha Lou', 'sam23@mail.com', '09123545689', 'Sample Address 101', '2022-10-20', 'Sample remarks only', '', 1, '2022-10-14 10:45:51', '2022-10-14 10:47:03');

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

-- Table structure for table `quote_services`

CREATE TABLE `quote_services` (

`quote_id` int(30) NOT NULL,

`service_id` int(30) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `quote_services`

INSERT INTO `quote_services` (`quote_id`, `service_id`) VALUES

(1, 1);

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

-- Table structure for table `service_list`

CREATE TABLE `service_list` (

`id` int(30) NOT NULL,

`name` text NOT NULL,

`description` text NOT NULL,

`image_path` text DEFAULT NULL,

`status` tinyint(1) NOT NULL DEFAULT 1,

`delete_flag` tinyint(1) NOT NULL DEFAULT 0,

`date_created` datetime NOT NULL DEFAULT current_timestamp(),

`date_updated` datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `service_list`

INSERT INTO `service_list` (`id`, `name`, `description`, `image_path`, `status`, `delete_flag`, `date_created`, `date_updated`) VALUES

(1, 'Home Cleaning and Sanita', '<p><span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;">Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris lacinia gravida massa, non aliquet sapien scelerisque eget. Pellentesque neque eros, varius ac urna eget, maximus commodo ante. Donec aliquam quis risus at convallis. Suspendisse sed sagittis odio. Aenean ultrices sapien sit amet sollicitudin congue. Pellentesque dapibus lectus non purus consequat consectetur. Mauris dapibus ultrices suscipit. Nunc id mollis neque, quis convallis nibh. Curabitur quis efficitur lorem. Nullam egestas consectetur velit, eget sollicitudin sem hendrerit ac. Vestibulum vitae diam ligula. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Duis aliquam erat quis hendrerit semper. In sed mauris lorem. Fusce elementum feugiat euismod. Vivamus posuere purus ac aliquam ullamcorper.</span><br></p>', 'uploads/services//house-sanitization.jpg?v=1665714533', 1, 0, '2022-10-14 10:28:53', '2022-10-14 10:28:53'),

(2, 'Car Sanitization', '<p><span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;">Vivamus quis metus nec ligula luctus dapibus sed et tellus. Sed non dignissim magna. Fusce tempus eget elit id dapibus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia curae; Aenean dictum lacus eget metus vestibulum, sed auctor erat egestas. Pellentesque eget sapien ut dui porta molestie a id ipsum. Ut ultricies odio non orci cursus, in convallis libero suscipit. Suspendisse in tortor velit.</span><br></p>', 'uploads/services//car-sanitization.png?v=1665714563', 1, 0, '2022-10-14 10:29:23', '2022-10-14 10:29:23'),

(3, 'Office Sanitzation', '<p><span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;">Sed varius velit vitae quam sollicitudin, ac fermentum ex accumsan. Donec quis faucibus purus. Donec venenatis ornare lobortis. Aenean vel elementum arcu, vitae fringilla lectus. Curabitur risus mauris, ullamcorper vel nulla vitae, aliquet sodales dolor. Aenean in consectetur ante. Phasellus varius aliquam ante, vel viverra urna rhoncus in. Vestibulum dignissim purus nunc, et cursus libero ornare sit amet. Donec viverra enim a sodales hendrerit. Interdum et malesuada fames ac ante ipsum primis in faucibus. Vivamus et imperdiet tortor, nec pharetra nisl. Aenean eleifend justo eu commodo vestibulum. Pellentesque nec velit vel turpis iaculis venenatis id ut nibh. Nunc sed egestas ante, vitae rutrum justo. Maecenas dolor metus, fringilla a lectus suscipit, bibendum lacinia mauris.</span><br></p>', 'uploads/services//sanitize.jpeg?v=1665714611', 1, 0, '2022-10-14 10:30:11', '2022-10-14 10:30:11'),

(4, 'Hospital Sanitization', '<p><span style="color: rgb(0, 0, 0); font-family: &quot;Open Sans&quot;, Arial, sans-serif; text-align: justify;">Curabitur eget varius diam. Aliquam sodales nunc in sodales suscipit. Duis sed facilisis arcu, sit amet tincidunt lorem. Pellentesque eget scelerisque nisl, vel placerat lacus. Donec faucibus justo massa, ut laoreet arcu vulputate eu. Nam velit urna, condimentum non viverra vel, aliquet et augue. Etiam et eleifend elit, at tempus eros. Vivamus quam risus, posuere quis quam vitae, imperdiet finibus lorem. Nulla viverra nibh tincidunt ex tincidunt, sed laoreet metus eleifend. Morbi tincidunt gravida sem, vel cursus eros elementum sit amet.</span><br></p>', 'uploads/services//1_sanitize.jpeg?v=1665714658', 1, 0, '2022-10-14 10:30:58', '2022-10-14 10:30:58');

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

-- Table structure for table `system_info`

CREATE TABLE `system_info` (

`id` int(30) NOT NULL,

`meta_field` text NOT NULL,

`meta_value` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `system_info`

INSERT INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES

(1, 'name', 'Sanitization Management System'),

(6, 'short_name', 'SMS - PHP'),

(11, 'logo', 'uploads/logo.png?v=1665714862'),

(13, 'user_avatar', 'uploads/user_avatar.jpg'),

(14, 'cover', 'uploads/cover.png?v=1665714863'),

(17, 'phone', '456-987-1231'),

(18, 'mobile', '09123456987 / 094563212222 '),

(19, 'email', 'info@xyzsanitizationservices.com'),

(20, 'address', '7087 Henry St. Clifton Park, NY 12065');

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

-- Table structure for table `users`

CREATE TABLE `users` (

`id` int(50) NOT NULL,

`firstname` varchar(250) NOT NULL,

`middlename` text DEFAULT NULL,

`lastname` varchar(250) NOT NULL,

`username` text NOT NULL,

`password` text NOT NULL,

`avatar` text DEFAULT NULL,

`last_login` datetime DEFAULT NULL,

`type` tinyint(1) NOT NULL DEFAULT 0,

`date_added` datetime NOT NULL DEFAULT current_timestamp(),

`date_updated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='2';

-- Dumping data for table `users`

INSERT INTO `users` (`id`, `firstname`, `middlename`, `lastname`, `username`, `password`, `avatar`, `last_login`, `type`, `date_added`, `date_updated`) VALUES

(1, 'Adminstrator', '', 'Admin', 'admin', '0192023a7bbd73250516f069df18b500', 'uploads/avatars/1.png?v=1649834664', NULL, 1, '2021-01-20 14:02:37', '2022-05-16 14:17:49');

-- Indexes for dumped tables

-- Indexes for table `inquiry_list`

ALTER TABLE `inquiry_list`

ADD PRIMARY KEY (`id`);

-- Indexes for table `quote_list`

ALTER TABLE `quote_list`

ADD PRIMARY KEY (`id`);

-- Indexes for table `quote_services`

ALTER TABLE `quote_services`

ADD KEY `quote_id` (`quote_id`),

ADD KEY `service_id` (`service_id`);

-- Indexes for table `service_list`

ALTER TABLE `service_list`

ADD PRIMARY KEY (`id`);

-- Indexes for table `system_info`

ALTER TABLE `system_info`

ADD PRIMARY KEY (`id`);

-- Indexes for table `users`

ALTER TABLE `users`

ADD PRIMARY KEY (`id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `inquiry_list`

ALTER TABLE `inquiry_list`

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

-- AUTO_INCREMENT for table `quote_list`

ALTER TABLE `quote_list`

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

-- AUTO_INCREMENT for table `service_list`

ALTER TABLE `service_list`

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

-- AUTO_INCREMENT for table `system_info`

ALTER TABLE `system_info`

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

-- AUTO_INCREMENT for table `users`

ALTER TABLE `users`

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

-- Constraints for dumped tables

-- Constraints for table `quote_services`

ALTER TABLE `quote_services`

ADD CONSTRAINT `quote_id_fk_qs` FOREIGN KEY (`quote_id`) REFERENCES `quote_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,

ADD CONSTRAINT `service_id_fk_qs` FOREIGN KEY (`service_id`) REFERENCES `service_list` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

COMMIT;

Download code _ PHP and MySQL-Based Sanitation Management System Project

PHP and MySQL-Based Sanitization Management System

Introduction

Technologies Used

How the System Works

Admin Panel (Management Side)

Public Website (Visitor Side)

Features and Functionalities

Management Side (Admin Panel)

Public Side (Visitor Interface)

How to Install and Run the System

System Requirements

Installation Steps

Admin Login Credentials

Conclusion

index PHP

login PHP

sms_db SQL

Related Posts: