Best PHP POS Management System

Download Code – Best PHP POS Management System

Benefits of PHP-Based POS Management Systems

For any retail business, efficiently managing Point of Sale (POS) transactions is key to success. A POS system can automate various tasks, from tracking sales and processing payments to generating reports. PHP, an open-source and easy-to-learn scripting language, is ideal for building a robust POS management system for businesses of all sizes.

A PHP POS Management System enables businesses to better track sales and inventory. It’s a comprehensive solution that can be used by small retail shops or large restaurant chains. With this system, businesses can streamline operations, cut down on costs, and improve customer satisfaction.

Here’s how a PHP-based POS system can improve business operations:

1. Accuracy

Automated POS systems reduce human errors, making sales transactions more accurate and minimizing mistakes during processing.

2. Increased Efficiency

With a POS system, businesses can serve more customers in a shorter time, improving overall efficiency.

3. Real-Time Data

Businesses can make informed decisions regarding inventory and product orders using the real-time data provided by the PHP POS system.

4. Easy Reporting

The system generates reports on sales, inventory, and customer data, helping businesses analyze performance and make informed decisions.

5. Better Customer Experience

A modern, user-friendly interface, along with quick transaction processing, enhances the customer experience.

6. Increased Security

PHP-based POS systems can secure sensitive business and customer information through features like secure payment processing, inventory tracking, and data encryption.

7. Integration Capabilities

PHP POS systems can easily integrate with other software, such as accounting, customer relationship management (CRM), and e-commerce systems.

8. Customizability

PHP’s flexibility allows businesses to customize POS systems to meet their specific needs, ensuring a tailored solution.

9. Cost-Effective

Since PHP is open-source and free to download, businesses can develop and maintain their POS systems efficiently at a lower cost.

10. Versatility

PHP POS systems can be used by various businesses, from small coffee shops to large restaurants, and can be easily updated with new features like real-time inventory tracking, loyalty programs, employee management, and more.

How to Run a PHP-Based POS Management System

Download the Source Code: Download the ZIP file containing the PHP POS management system source code, along with the SQL file.
Extract the Files: Extract the ZIP file and place the project folder (source code files) in the htdocs directory.
Create the Database: Open localhost/phpmyadmin and create a new database (ensure your PHP version is at least 7.1).
Import the SQL File: Import the SQL file to set up the necessary database tables.
Verify Database Name: Open the source code files and check if the database name is correctly referenced.
Login to Admin Panel: Open the admin panel and log in using the provided credentials.

Services Offered:

I provide high-quality software projects, thesis writing services, website development, and web application development. Feel free to contact me via email for any queries or service requests.

index PHP

  <!DOCTYPE html>
  <html lang="en">
  	
  <?php session_start(); ?>
  <head>
    <meta charset="utf-8">
    <meta content="width=device-width, initial-scale=1.0" name="viewport">

    <title><?php echo isset($_SESSION['system']['name']) ? $_SESSION['system']['name'] : '' ?></title>
   	

  <?php
    if(!isset($_SESSION['login_id']))
      header('location:login.php');
   include('./header.php'); 
   // include('./auth.php'); 
   ?>

  </head>
  <style>
  	body{
          background: #f8f9fa;
    }
    .modal-dialog.large {
      width: 80% !important;
      max-width: unset;
    }
    .modal-dialog.mid-large {
      width: 50% !important;
      max-width: unset;
    }
    #viewer_modal .btn-close {
      position: absolute;
      z-index: 999999;
      /*right: -4.5em;*/
      background: unset;
      color: white;
      border: unset;
      font-size: 27px;
      top: 0;
  }
  #viewer_modal .modal-dialog {
          width: 80%;
      max-width: unset;
      height: calc(90%);
      max-height: unset;
  }
    #viewer_modal .modal-content {
         background: black;
      border: unset;
      height: calc(100%);
      display: flex;
      align-items: center;
      justify-content: center;
    }
    #viewer_modal img,#viewer_modal video{
      max-height: calc(100%);
      max-width: calc(100%);
    }
    #page {
      display: none;
  }
  #loading {
      display: block;
      position: fixed;
      top: 0;
      left: 0;
      z-index: 2150;
      width: 100%;
      height: 100vh;
      background-color: #fff;
      background-image: url("assets/uploads/loader.gif");
      background-repeat: no-repeat;
      background-position: center;
      background-size:500px;
  }
  </style>

  <body>
    <div id="page"></div>
  <div id="loading"></div>
  	<?php include 'topbar.php' ?>
  	<?php include 'navbar.php' ?>
    <div class="toast" id="alert_toast" role="alert" aria-live="assertive" aria-atomic="true">
      <div class="toast-body text-white">
      </div>
    </div>
    
    <main id="view-panel" >
        <?php $page = isset($_GET['page']) ? $_GET['page'] :'home'; ?>
    	<?php include $page.'.php' ?>
    	

    </main>


    <a href="#" class="back-to-top"><i class="icofont-simple-up"></i></a>

  <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="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>
    
  </body>

  <script>
 window.start_load = function(){
    $('body').prepend('<di id="preloader2"></di>')
  }
  window.end_load = function(){
    $('#preloader2').fadeOut('fast', function() {
        $(this).remove();
      })
  }
 window.viewer_modal = function($src = ''){
    start_load()
    var t = $src.split('.')
    t = t[1]
    if(t =='mp4'){
      var view = $("<video src='"+$src+"' controls autoplay></video>")
    }else{
      var view = $("<img src='"+$src+"' />")
    }
    $('#viewer_modal .modal-content video,#viewer_modal .modal-content img').remove()
    $('#viewer_modal .modal-content').append(view)
    $('#viewer_modal').modal({
            show:true,
            backdrop:'static',
            keyboard:false,
            focus:true
          })
          end_load()  

}
  window.uni_modal = function($title = '' , $url='',$size=""){
    start_load()
    $.ajax({
        url:$url,
        error:err=>{
            console.log()
            alert("An error occured")
        },
        success:function(resp){
            if(resp){
                $('#uni_modal .modal-title').html($title)
                $('#uni_modal .modal-body').html(resp)
                if($size != ''){
                    $('#uni_modal .modal-dialog').addClass($size)
                }else{
                    $('#uni_modal .modal-dialog').removeAttr("class").addClass("modal-dialog modal-md")
                }
                $('#uni_modal').modal({
                  show:true,
                  backdrop:'static',
                  keyboard:false,
                  focus:true
                })
                end_load()
            }
        }
    })
}
window._conf = function($msg='',$func='',$params = []){
     $('#confirm_modal #confirm').attr('onclick',$func+"("+$params.join(',')+")")
     $('#confirm_modal .modal-body').html($msg)
     $('#confirm_modal').modal('show')
  }
   window.alert_toast= function($msg = 'TEST',$bg = 'success'){
      $('#alert_toast').removeClass('bg-success')
      $('#alert_toast').removeClass('bg-danger')
      $('#alert_toast').removeClass('bg-info')
      $('#alert_toast').removeClass('bg-warning')

    if($bg == 'success')
      $('#alert_toast').addClass('bg-success')
    if($bg == 'danger')
      $('#alert_toast').addClass('bg-danger')
    if($bg == 'info')
      $('#alert_toast').addClass('bg-info')
    if($bg == 'warning')
      $('#alert_toast').addClass('bg-warning')
    $('#alert_toast .toast-body').html($msg)
    $('#alert_toast').toast({delay:3000}).toast('show');
  }
  $(document).ready(function(){
    $('#preloader').fadeOut('fast', function() {
        $(this).remove();
      })
  })
  $('.datetimepicker').datetimepicker({
      format:'Y/m/d H:i',
      startDate: '+3d'
  })
  $('.select2').select2({
    placeholder:"Please select here",
    width: "100%"
  })

  </script>	
  <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>


<script type="text/javascript">
  function googleTranslateElementInit() {
    new google.translate.TranslateElement({pageLanguage: 'en'}, 'google_translate_element');
  }
  function onReady(callback) {
    var intervalID = window.setInterval(checkReady, 1000);
    function checkReady() {
        if (document.getElementsByTagName('body')[0] !== undefined) {
            window.clearInterval(intervalID);
            callback.call(this);
        }
    }
}

function show(id, value) {
    document.getElementById(id).style.display = value ? 'block' : 'none';
}

onReady(function () {
    show('page', true);
    show('loading', false);
});
  </script>
  <style>
      .goog-logo-link {
          display:none !important;
      } 
            
      .goog-te-gadget{
          color: transparent !important;
      }
      .goog-te-gadget .goog-te-combo {
          margin: 0px 0;
          padding: 8px;
          color: #000;
          background: #eeee;
      }
      #google_translate_element{
          padding-top: 1px;
          position: absolute;
            top: 8px;
            right: 140px;
            }
      </style>
  </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

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

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

<!DOCTYPE html>

<?php session_start(); ?>

<head>

<?php

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

header('location:login.php');

include('./header.php');

// include('./auth.php');

</head>

<style>

body{

background: #f8f9fa;

}

.modal-dialog.large {

width: 80% !important;

max-width: unset;

}

.modal-dialog.mid-large {

width: 50% !important;

max-width: unset;

}

#viewer_modal .btn-close {

position: absolute;

z-index: 999999;

/*right: -4.5em;*/

background: unset;

color: white;

border: unset;

font-size: 27px;

top: 0;

}

#viewer_modal .modal-dialog {

width: 80%;

max-width: unset;

height: calc(90%);

max-height: unset;

}

#viewer_modal .modal-content {

background: black;

border: unset;

height: calc(100%);

display: flex;

align-items: center;

justify-content: center;

}

#viewer_modal img,#viewer_modal video{

max-height: calc(100%);

max-width: calc(100%);

}

#page {

display: none;

}

#loading {

display: block;

position: fixed;

top: 0;

left: 0;

z-index: 2150;

width: 100%;

height: 100vh;

background-color: #fff;

background-image: url("assets/uploads/loader.gif");

background-repeat: no-repeat;

background-position: center;

background-size:500px;

}

</style>

<body>

<?php include 'topbar.php' ?>

<?php include 'navbar.php' ?>

</div>

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

<?php include $page.'.php' ?>

</main>

<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>

</div>

</body>

window.start_load = function(){

$('body').prepend('<di id="preloader2"></di>')

}

window.end_load = function(){

$('#preloader2').fadeOut('fast', function() {

$(this).remove();

})

}

window.viewer_modal = function($src = ''){

start_load()

var t = $src.split('.')

t = t[1]

if(t =='mp4'){

var view = $("<video src='"+$src+"' controls autoplay></video>")

}else{

var view = $("<img src='"+$src+"' />")

}

$('#viewer_modal .modal-content video,#viewer_modal .modal-content img').remove()

$('#viewer_modal .modal-content').append(view)

$('#viewer_modal').modal({

show:true,

backdrop:'static',

keyboard:false,

focus:true

})

end_load()

}

window.uni_modal = function($title = '' , $url='',$size=""){

start_load()

$.ajax({

url:$url,

error:err=>{

console.log()

alert("An error occured")

success:function(resp){

if(resp){

$('#uni_modal .modal-title').html($title)

$('#uni_modal .modal-body').html(resp)

if($size != ''){

$('#uni_modal .modal-dialog').addClass($size)

}else{

$('#uni_modal .modal-dialog').removeAttr("class").addClass("modal-dialog modal-md")

}

$('#uni_modal').modal({

show:true,

backdrop:'static',

keyboard:false,

focus:true

})

end_load()

}

})

}

window._conf = function($msg='',$func='',$params = []){

$('#confirm_modal #confirm').attr('onclick',$func+"("+$params.join(',')+")")

$('#confirm_modal .modal-body').html($msg)

$('#confirm_modal').modal('show')

}

window.alert_toast= function($msg = 'TEST',$bg = 'success'){

$('#alert_toast').removeClass('bg-success')

$('#alert_toast').removeClass('bg-danger')

$('#alert_toast').removeClass('bg-info')

$('#alert_toast').removeClass('bg-warning')

if($bg == 'success')

$('#alert_toast').addClass('bg-success')

if($bg == 'danger')

$('#alert_toast').addClass('bg-danger')

if($bg == 'info')

$('#alert_toast').addClass('bg-info')

if($bg == 'warning')

$('#alert_toast').addClass('bg-warning')

$('#alert_toast .toast-body').html($msg)

$('#alert_toast').toast({delay:3000}).toast('show');

}

$(document).ready(function(){

$('#preloader').fadeOut('fast', function() {

$(this).remove();

})

$('.datetimepicker').datetimepicker({

format:'Y/m/d H:i',

startDate: '+3d'

})

$('.select2').select2({

placeholder:"Please select here",

width: "100%"

})

</script>

function googleTranslateElementInit() {

new google.translate.TranslateElement({pageLanguage: 'en'}, 'google_translate_element');

}

function onReady(callback) {

var intervalID = window.setInterval(checkReady, 1000);

function checkReady() {

if (document.getElementsByTagName('body')[0] !== undefined) {

window.clearInterval(intervalID);

callback.call(this);

}

function show(id, value) {

document.getElementById(id).style.display = value ? 'block' : 'none';

}

onReady(function () {

show('page', true);

show('loading', false);

});

</script>

<style>

.goog-logo-link {

display:none !important;

}

.goog-te-gadget{

color: transparent !important;

}

.goog-te-gadget .goog-te-combo {

margin: 0px 0;

padding: 8px;

color: #000;

background: #eeee;

}

#google_translate_element{

padding-top: 1px;

position: absolute;

top: 8px;

right: 140px;

}

</style>

</html>

login PHP

<!DOCTYPE html>
<html lang="en">
<?php 
session_start();
include('./db_connect.php');
ob_start();
// if(!isset($_SESSION['system'])){
	$system = $conn->query("SELECT * FROM system_settings limit 1")->fetch_array();
	foreach($system as $k => $v){
		$_SESSION['system'][$k] = $v;
	}
// }
ob_end_flush();
?>
<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title><?php echo $_SESSION['system']['name'] ?></title>
 	

<?php include('./header.php'); ?>
<?php 
if(isset($_SESSION['login_id']))
header("location:index.php?page=home");

?>

</head>
<style>
	body{
		width: 100%;
	    height: calc(100%);
	    position: fixed;
	    top:0;
	    left: 0;
	    background-image: url('assets/uploads/background.webp');
	    background-size: cover;
	}
	main#main{
		width:100%;
		height: calc(100%);
		display: flex;
	}

</style>

<body class="bg-dark">


  <main id="main" >
  	
  		<div class="align-self-center w-100">
		
  		<div id="login-center" class="row justify-content-start">
  			<div class="card col-md-3 ml-5">
  				<div class="card-body py-5 px-1">
  					<h4 class="text-dark text-center mb-5"><!-- ?php echo $_SESSION['system']['name'] ?> -->
  						<img src="assets/uploads/logo.png" width="300px">
  					</h4>
  					<form id="login-form" >
  						<div class="form-group">
  						<div class="input-group mb-2" >
				        <div class="input-group-prepend ">
				          <div class="input-group-text  bg-transparent border-0"><i class="fa fa-user"></i></div>
				        </div>
				        <input type="email"  pattern="[a-z0-9._%+-]+@[a-z0-9.-]+\.[a-z]{2,4}$" id="username" name="username" class="form-control border-0" placeholder="Username">
				      </div>
  						</div>
  						<div class="form-group">
							<div class="input-group mb-2" >
				        <div class="input-group-prepend ">
				          <div class="input-group-text  bg-transparent border-0"><i class="fa fa-lock"></i></div>
				        </div>
				        <input type="password" id="password" name="password" class="form-control border-0" placeholder="Password">
				      </div>
  						</div>
  						<div class="form-check py-3">
						    <input type="checkbox" class="form-check-input" id="exampleCheck1">
						    <label class="form-check-label mt-1" for="exampleCheck1"> Remember me</label>
						  </div>
  						<center><button class="btn col-md-12 btn-primary">Login</button></center>
  					</form>
  				</div>
  			</div>
  		</div>
  		</div>
  </main>

  <a href="#" class="back-to-top"><i class="icofont-simple-up"></i></a>


</body>
<script>
	$('#login-form').submit(function(e){
		e.preventDefault()
		$('#login-form button[type="button"]').attr('disabled',true).html('Logging in...');
		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)
		$('#login-form button[type="button"]').removeAttr('disabled').html('Login');

			},
			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>')
					$('#login-form button[type="button"]').removeAttr('disabled').html('Login');
				}
			}
		})
	})
</script>	
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

<!DOCTYPE html>

<?php

session_start();

include('./db_connect.php');

ob_start();

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

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

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

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

}

// }

ob_end_flush();

<head>

<?php include('./header.php'); ?>

<?php

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

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

</head>

<style>

body{

width: 100%;

height: calc(100%);

position: fixed;

top:0;

left: 0;

background-image: url('assets/uploads/background.webp');

background-size: cover;

}

main#main{

width:100%;

height: calc(100%);

display: flex;

}

</style>

</h4>

</div>

</div>

</div>

</div>

<label class="form-check-label mt-1" for="exampleCheck1"> Remember me</label>

</div>

<center><button class="btn col-md-12 btn-primary">Login</button></center>

</form>

</div>

</main>

</body>

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

e.preventDefault()

$('#login-form button[type="button"]').attr('disabled',true).html('Logging in...');

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)

$('#login-form button[type="button"]').removeAttr('disabled').html('Login');

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>')

$('#login-form button[type="button"]').removeAttr('disabled').html('Login');

}

})

</script>

</html>

kruxton SQL

-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 09, 2023 at 06:49 PM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 7.4.28

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: `kruxton`
--

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

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(30) NOT NULL,
  `name` varchar(200) NOT NULL,
  `description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `description`) VALUES
(1, 'Chinese', 'Chinese Items'),
(2, 'Mexican', 'Mexican Items'),
(3, 'Pizza', 'Pizza Items'),
(4, 'Indian', 'Indian items'),
(5, 'Sandwiches', 'Sandwiches Types'),
(6, ' Japanese', ' Japanese Items'),
(9, 'Thai', 'Thai Items');

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

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `ref_no` varchar(50) NOT NULL,
  `total_amount` float NOT NULL,
  `amount_tendered` float NOT NULL,
  `order_number` int(30) NOT NULL,
  `date_created` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `ref_no`, `total_amount`, `amount_tendered`, `order_number`, `date_created`) VALUES
(1, '278998154978', 904, 1000, 1001, '2023-02-03 19:17:03'),
(2, '091428583362', 1343, 0, 1005, '2023-02-03 19:17:34'),
(3, '543076159999', 1622, 0, 1004, '2023-02-03 19:17:56'),
(4, '967470759448', 742, 1000, 1003, '2023-02-03 19:20:26'),
(5, '300535882264', 1354, 1400, 1006, '2023-02-03 20:12:43');

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

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` int(30) NOT NULL,
  `order_id` int(30) NOT NULL,
  `product_id` int(30) NOT NULL,
  `qty` int(30) NOT NULL,
  `price` float NOT NULL,
  `amount` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `order_items`
--

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `qty`, `price`, `amount`) VALUES
(1, 1, 8, 1, 452, 452),
(2, 1, 7, 1, 452, 452),
(3, 2, 3, 1, 520, 520),
(4, 2, 6, 1, 443, 443),
(5, 2, 10, 1, 80, 80),
(6, 2, 1, 1, 300, 300),
(7, 3, 2, 1, 352, 352),
(8, 3, 1, 1, 300, 300),
(9, 3, 3, 1, 520, 520),
(10, 3, 4, 1, 450, 450),
(11, 4, 9, 1, 50, 50),
(12, 4, 8, 1, 452, 452),
(13, 4, 10, 3, 80, 240),
(14, 5, 4, 1, 450, 450),
(15, 5, 8, 2, 452, 904);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(30) NOT NULL,
  `category_id` int(30) NOT NULL,
  `name` varchar(200) NOT NULL,
  `description` text NOT NULL,
  `price` float NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=Unavailable,1=Available'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `category_id`, `name`, `description`, `price`, `status`) VALUES
(1, 1, 'Chow Mein', 'Chow mein is a Chinese dish made from stir-fried noodles with vegetables and sometimes meat', 300, 1),
(2, 1, 'Hot Pot', 'a communal meal that involves a pot filled with broth constantly simmered by a heat source underneath', 352, 1),
(3, 1, 'Kung Pao Chicken', 'Kung Pao chicken, also transcribed Gong Bao or Kung Po, is a spicy, stir-fried Chinese dish made with cubes of chicken, peanuts, vegetables, and chili peppers.', 520, 1),
(4, 1, 'Ma Po Tofu', 'Mapo tofu is a popular Chinese dish from Sichuan province. ', 450, 1),
(5, 6, 'Tofu', 'The Japanese eat it alone, as if it were meat or cheese. Another popular way of eating tofu is to serve it fried.', 452, 1),
(6, 6, 'Tempura', 'A simple and traditional tempura batter is typically made of ice water, flour, and egg yolks.', 443, 1),
(7, 6, 'Yakitori', 'This type is usually served with a sweet tare sauce, and depending on the region, it can also come with raw egg yolk for dipping.', 452, 1),
(8, 4, 'Pakora', 'Pakoras are made by coating ingredients, usually vegetables, in a spiced batter, then deep frying them. ', 452, 1),
(9, 4, 'Vada Pav', 'Vada pav, alternatively spelt wada pao, is a vegetarian fast food dish native to the Indian state of Maharashtra. ', 50, 1),
(10, 4, 'Paratha', 'Paratha is a flatbread native to South Asia, prevalent throughout the modern-day nations of India, Sri Lanka, Pakistan, Nepal, Bangladesh, Maldives, Afghanistan, Myanmar, Malaysia, Singapore, Mauritius, Fiji, Guyana, Suriname, and Trinidad and Tobago where wheat is the traditional staple.', 80, 1),
(11, 9, 'Pad Thai', 'Pad thai, phat thai, or phad thai, is a stir-fried rice noodle dish commonly served as a street food in Thailand as part of the countrys cuisine.', 452, 1);

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

--
-- 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,
  `cover_img` text NOT NULL,
  `about_content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `system_settings` (`id`, `name`, `email`, `contact`, `cover_img`, `about_content`) VALUES
(1, 'Kruxton Bristo By Mayuri K', 'mayuri.infospace@gmail.com', '9000000000', '', '&lt;p&gt;Kruxton Bristo By Mayuri K&lt;/p&gt;');

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

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

CREATE TABLE `users` (
  `id` int(30) NOT NULL,
  `name` text NOT NULL,
  `username` varchar(200) NOT NULL,
  `password` text NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 3 COMMENT '1=Admin,2=Staff'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `users` (`id`, `name`, `username`, `password`, `type`) VALUES
(3, 'Mayuri K.', 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', 1);

--
-- Indexes for dumped tables
--

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

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

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  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 `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

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

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

--
-- 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=4;
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

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

-- phpMyAdmin SQL Dump

-- version 5.1.3

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

-- Host: 127.0.0.1

-- Generation Time: Feb 09, 2023 at 06:49 PM

-- Server version: 10.4.22-MariaDB

-- PHP Version: 7.4.28

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: `kruxton`

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

-- Table structure for table `categories`

CREATE TABLE `categories` (

`id` int(30) NOT NULL,

`name` varchar(200) NOT NULL,

`description` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `categories`

INSERT INTO `categories` (`id`, `name`, `description`) VALUES

(1, 'Chinese', 'Chinese Items'),

(2, 'Mexican', 'Mexican Items'),

(3, 'Pizza', 'Pizza Items'),

(4, 'Indian', 'Indian items'),

(5, 'Sandwiches', 'Sandwiches Types'),

(6, ' Japanese', ' Japanese Items'),

(9, 'Thai', 'Thai Items');

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

-- Table structure for table `orders`

CREATE TABLE `orders` (

`id` int(11) NOT NULL,

`ref_no` varchar(50) NOT NULL,

`total_amount` float NOT NULL,

`amount_tendered` float NOT NULL,

`order_number` int(30) NOT NULL,

`date_created` datetime NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `orders`

INSERT INTO `orders` (`id`, `ref_no`, `total_amount`, `amount_tendered`, `order_number`, `date_created`) VALUES

(1, '278998154978', 904, 1000, 1001, '2023-02-03 19:17:03'),

(2, '091428583362', 1343, 0, 1005, '2023-02-03 19:17:34'),

(3, '543076159999', 1622, 0, 1004, '2023-02-03 19:17:56'),

(4, '967470759448', 742, 1000, 1003, '2023-02-03 19:20:26'),

(5, '300535882264', 1354, 1400, 1006, '2023-02-03 20:12:43');

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

-- Table structure for table `order_items`

CREATE TABLE `order_items` (

`id` int(30) NOT NULL,

`order_id` int(30) NOT NULL,

`product_id` int(30) NOT NULL,

`qty` int(30) NOT NULL,

`price` float NOT NULL,

`amount` float NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `order_items`

INSERT INTO `order_items` (`id`, `order_id`, `product_id`, `qty`, `price`, `amount`) VALUES

(1, 1, 8, 1, 452, 452),

(2, 1, 7, 1, 452, 452),

(3, 2, 3, 1, 520, 520),

(4, 2, 6, 1, 443, 443),

(5, 2, 10, 1, 80, 80),

(6, 2, 1, 1, 300, 300),

(7, 3, 2, 1, 352, 352),

(8, 3, 1, 1, 300, 300),

(9, 3, 3, 1, 520, 520),

(10, 3, 4, 1, 450, 450),

(11, 4, 9, 1, 50, 50),

(12, 4, 8, 1, 452, 452),

(13, 4, 10, 3, 80, 240),

(14, 5, 4, 1, 450, 450),

(15, 5, 8, 2, 452, 904);

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

-- Table structure for table `products`

CREATE TABLE `products` (

`id` int(30) NOT NULL,

`category_id` int(30) NOT NULL,

`name` varchar(200) NOT NULL,

`description` text NOT NULL,

`price` float NOT NULL,

`status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0=Unavailable,1=Available'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `products`

INSERT INTO `products` (`id`, `category_id`, `name`, `description`, `price`, `status`) VALUES

(1, 1, 'Chow Mein', 'Chow mein is a Chinese dish made from stir-fried noodles with vegetables and sometimes meat', 300, 1),

(2, 1, 'Hot Pot', 'a communal meal that involves a pot filled with broth constantly simmered by a heat source underneath', 352, 1),

(3, 1, 'Kung Pao Chicken', 'Kung Pao chicken, also transcribed Gong Bao or Kung Po, is a spicy, stir-fried Chinese dish made with cubes of chicken, peanuts, vegetables, and chili peppers.', 520, 1),

(4, 1, 'Ma Po Tofu', 'Mapo tofu is a popular Chinese dish from Sichuan province. ', 450, 1),

(5, 6, 'Tofu', 'The Japanese eat it alone, as if it were meat or cheese. Another popular way of eating tofu is to serve it fried.', 452, 1),

(6, 6, 'Tempura', 'A simple and traditional tempura batter is typically made of ice water, flour, and egg yolks.', 443, 1),

(7, 6, 'Yakitori', 'This type is usually served with a sweet tare sauce, and depending on the region, it can also come with raw egg yolk for dipping.', 452, 1),

(8, 4, 'Pakora', 'Pakoras are made by coating ingredients, usually vegetables, in a spiced batter, then deep frying them. ', 452, 1),

(9, 4, 'Vada Pav', 'Vada pav, alternatively spelt wada pao, is a vegetarian fast food dish native to the Indian state of Maharashtra. ', 50, 1),

(10, 4, 'Paratha', 'Paratha is a flatbread native to South Asia, prevalent throughout the modern-day nations of India, Sri Lanka, Pakistan, Nepal, Bangladesh, Maldives, Afghanistan, Myanmar, Malaysia, Singapore, Mauritius, Fiji, Guyana, Suriname, and Trinidad and Tobago where wheat is the traditional staple.', 80, 1),

(11, 9, 'Pad Thai', 'Pad thai, phat thai, or phad thai, is a stir-fried rice noodle dish commonly served as a street food in Thailand as part of the countrys cuisine.', 452, 1);

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

-- 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,

`cover_img` text NOT NULL,

`about_content` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `system_settings`

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

(1, 'Kruxton Bristo By Mayuri K', 'mayuri.infospace@gmail.com', '9000000000', '', '<p>Kruxton Bristo By Mayuri K</p>');

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

-- Table structure for table `users`

CREATE TABLE `users` (

`id` int(30) NOT NULL,

`name` text NOT NULL,

`username` varchar(200) NOT NULL,

`password` text NOT NULL,

`type` tinyint(1) NOT NULL DEFAULT 3 COMMENT '1=Admin,2=Staff'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `users`

INSERT INTO `users` (`id`, `name`, `username`, `password`, `type`) VALUES

(3, 'Mayuri K.', 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', 1);

-- Indexes for dumped tables

-- Indexes for table `categories`

ALTER TABLE `categories`

ADD PRIMARY KEY (`id`);

-- Indexes for table `orders`

ALTER TABLE `orders`

ADD PRIMARY KEY (`id`);

-- Indexes for table `order_items`

ALTER TABLE `order_items`

ADD PRIMARY KEY (`id`);

-- Indexes for table `products`

ALTER TABLE `products`

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 `categories`

ALTER TABLE `categories`

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

-- AUTO_INCREMENT for table `orders`

ALTER TABLE `orders`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

-- AUTO_INCREMENT for table `order_items`

ALTER TABLE `order_items`

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

-- AUTO_INCREMENT for table `products`

ALTER TABLE `products`

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

-- 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=4;

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 */;

1. Accuracy

2. Increased Efficiency

3. Real-Time Data

4. Easy Reporting

5. Better Customer Experience

6. Increased Security

7. Integration Capabilities

8. Customizability

9. Cost-Effective

10. Versatility

index PHP

login PHP

kruxton SQL

Related Posts:

Leave a Comment Cancel Reply