Hosting Services Management Admin Panel project in PHP.

-- phpMyAdmin SQL Dump

-- version 4.7.9

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

--

-- Host: 127.0.0.1:3306

-- Generation Time: Sep 28, 2018 at 07:45 AM

-- Server version: 5.7.21

-- PHP Version: 5.6.35

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

SET AUTOCOMMIT = 0;

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

--

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

--

-- Table structure for table `addservice`

--

DROP TABLE IF EXISTS `addservice`;

CREATE TABLE IF NOT EXISTS `addservice` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user` varchar(50) NOT NULL,

`services` varchar(100) NOT NULL,

`price` varchar(50) NOT NULL,

`reamt` varchar(50) NOT NULL,

`regsdate` date NOT NULL,

`enddate` date NOT NULL,

`domname` varchar(100) NOT NULL,

`payvia` varchar(100) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--

-- Dumping data for table `addservice`

--

INSERT INTO `addservice` (`id`, `user`, `services`, `price`, `reamt`, `regsdate`, `enddate`, `domname`, `payvia`) VALUES

(10, 'man@gmail.com', 'Hosting, Domain, Service, ', '5000', '6000', '2017-05-31', '2019-07-30', 'khbjzdknhbds.net', 'PayU Money'),

(11, 'kar@gmail.com', 'Hosting, Domain, Service, ', '2000', '30000', '2018-09-10', '2019-09-10', 'abc.com', 'Net Banking');

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

--

-- Table structure for table `adduser`

--

DROP TABLE IF EXISTS `adduser`;

CREATE TABLE IF NOT EXISTS `adduser` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(50) NOT NULL,

`address` varchar(500) NOT NULL,

`mobile` varchar(20) NOT NULL,

`email` varchar(50) NOT NULL,

`regdate` date NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--

-- Dumping data for table `adduser`

--

INSERT INTO `adduser` (`id`, `name`, `address`, `mobile`, `email`, `regdate`) VALUES

(1, 'Manpreet Singh', 'Vikas Puri', '975121121', 'man@gmail.com', '2018-08-31'),

(2, 'Kartik', 'bhaduragarh', '9876181515', 'kar@gmail.com', '2018-08-28'),

(3, 'Aryan', 'uttam nager', '987412547', 'xyz@gmail.com', '2018-09-06'),

(4, 'Jack', 'janak puri', '987456321', 'jack@gamil.com', '2018-10-04'),

(5, 'Abc', 'ncuhbdc', '9887121815', 'xyz@gmail.com', '2018-10-21'),

(6, 'Amit', 'hsbcjgv', '6842184518', 'amit@yahoo.com', '2018-09-14'),

(7, 'Amrit', 'Tilak Nager', '987456254', 'am@gmail.com', '2018-09-10'),

(8, 'Amitdc', 'dcd', '9876181515', 'kar@gmail.com', '2018-09-10');

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

--

-- Table structure for table `admin`

--

DROP TABLE IF EXISTS `admin`;

CREATE TABLE IF NOT EXISTS `admin` (

`email` varchar(50) NOT NULL,

`password` varchar(50) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `admin`

--

INSERT INTO `admin` (`email`, `password`) VALUES

('abc@gmail.com', 'admin');

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