Shopping Product Management Website project in PHP.

-- phpMyAdmin SQL Dump

-- version 4.7.9

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

--

-- Host: 127.0.0.1:3306

-- Generation Time: Nov 08, 2018 at 04:37 PM

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

--

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

--

-- Table structure for table `login`

--

DROP TABLE IF EXISTS `login`;

CREATE TABLE IF NOT EXISTS `login` (

`fname` varchar(100) NOT NULL,

`email` varchar(100) NOT NULL,

`password` varchar(100) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- Dumping data for table `login`

--

INSERT INTO `login` (`fname`, `email`, `password`) VALUES

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

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

--

-- Table structure for table `pcategory`

--

DROP TABLE IF EXISTS `pcategory`;

CREATE TABLE IF NOT EXISTS `pcategory` (

`pcatid` int(11) NOT NULL AUTO_INCREMENT,

`pcatname` varchar(100) NOT NULL,

`pcatimgname` varchar(100) NOT NULL,

`pcatdate` date NOT NULL,

`status` varchar(100) NOT NULL,

PRIMARY KEY (`pcatid`)

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

--

-- Dumping data for table `pcategory`

--

INSERT INTO `pcategory` (`pcatid`, `pcatname`, `pcatimgname`, `pcatdate`, `status`) VALUES

(1, 'Samsung', 'samsung.png', '2018-11-08', '0');

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

--

-- Table structure for table `subcategory`

--

DROP TABLE IF EXISTS `subcategory`;

CREATE TABLE IF NOT EXISTS `subcategory` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`pscatname` varchar(100) NOT NULL,

`subcatname` varchar(100) NOT NULL,

`subcatimgname` varchar(100) NOT NULL,

PRIMARY KEY (`id`)

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

--

-- Dumping data for table `subcategory`

--

INSERT INTO `subcategory` (`id`, `pscatname`, `subcatname`, `subcatimgname`) VALUES

(1, 'Samsung', 'Laptop', '5.png'),

(2, 'Samsung', 'Laptop', '5hp.jpeg');

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