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

START TRANSACTION;



--
-- Database: `itmsofts_ecom_web_db`
--

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

--
-- Table structure for table `about_section`
--

CREATE TABLE `about_section` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `about_title` varchar(500) NOT NULL,
  `about_subtitle` varchar(3000) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `about_section`
--

INSERT INTO `about_section` (`id`, `user_id`, `about_title`, `about_subtitle`, `userPic`) VALUES
(17, 140, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(18, 141, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(19, 142, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(20, 143, 'Welcome To Swazis International LTD.', '<h3><strong>Company profile</strong></h3>\r\n<p style=\"text-align: justify;\"><br />Production, import and marketing of various micro nutrients, bio-fertilizers, pesticides.Seek always good faith business. Country growing agrochemical company since 2009.</p>\r\n<p style=\"text-align: justify;\">Corporate address:- 22/3-C, Golapbug, Dhaka-1203.Factory:- Asekpur, Ranirhat, Bogra, Bangladesh.</p>\r\n<p style=\"text-align: justify;\">Contact Person Mr. Mahbub. Managing Director. Email- kawsartuva@gmail.com +8801718161837 Mr Mahfuz.</p>\r\n<p style=\"text-align: justify;\">Chairman Email - sornamoni2010@gmail.com +8801712685090 Also web in tradeforde, fb, youtube as swazis international limited.<br /><br /><strong>Company type(s):</strong>Importer<br /><br /><strong>Products / Services:</strong><br />1. Agriculture: Fertilizers, Pesticides, Seeds, Agro machineries etc.</p>', 'prince-475206-swazis...jpg'),
(21, 144, 'Welcome To Agro Feed Ltd', '<p><strong><a href=\"https://www.qfl.com.bd/\"><span style=\"color: #808080;\">Quality Feeds Ltd</span></a>&nbsp;</strong>was&nbsp;founded in 1995, with a commitment to produce and market animal feed products of high quality standard and absolute hygiene for the farmers. <span style=\"color: #808080;\"><a style=\"color: #808080;\" href=\"https://www.qfl.com.bd/\">QFL</a></span> has deep roots and connections to some of the feed industry pioneers who paved the way for excellence in animal nutrition.</p>\r\n<p><span style=\"color: #808080;\"><a style=\"color: #808080;\" href=\"https://www.qfl.com.bd/\">QFL</a></span> produces and distributes poultry, fish, shrimp, and cattle feed throughout Bangladesh through 04 Sectors, 09&nbsp; Zonal Offices, 29 Regional Offices, 23 Depots, 10 Poultry Diseases Diagnosis Lab, and 02 Fish Diseases Diagnosis Lab with the contribution of more than 1000 plus agents. <span style=\"color: #808080;\"><a style=\"color: #808080;\" href=\"https://www.qfl.com.bd/\">QFL</a></span> has over the years become synonymous with quality &amp; a trusted partner as a feed manufacturer in Bangladesh. The Company has 17 independent plants capable of producing both pelleted feed and mash feed. The plants are strategically located in Gazipur and Bogura.</p>\r\n<p>The total installed output capacity is 5,50,000 metric tons per year.</p>\r\n<p><span style=\"color: #808080;\"><a style=\"color: #808080;\" href=\"https://www.qfl.com.bd/\">QFL</a></span> has Six sister concern companies involved in the poultry and fish value chain agro processing and packaging.</p>', 'prince-11381-about.jpg'),
(22, 145, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(23, 146, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(24, 147, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(25, 148, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(26, 149, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg'),
(27, 150, 'Welcome To Progati Security Services Ltd.', '<p>Bangladesh Honda Pvt. Ltd. opened a new showroom in Tongi, Gazipur on September 14, 2022 under the dealership of <strong>Moto Craze</strong>. The showroom is new and will help the people of Tongi Sadar area to get Honda all model bikes, service and spare parts from this showroom.</p>\r\n<p>&ldquo;In Bangladesh, it is also our aim to increase customer satisfaction by providing the product with the excellent fuel economy, good design, reliability and 4S service by our dealers. It is our wish that <strong>Moto Craze </strong>will be a very good support for customers in Tongi Sadar area by providing the outstanding services which exceeding customer expectation and we BHL will extend our every effort to realize such wish.&rdquo; said Mr. Shigeru Matsuzaki, Managing Director &amp; CEO of Bangladesh Honda Private Limited.</p>\r\n<p>&nbsp;</p>', 'prince-200077-motocrxz.jpg');

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

--
-- Table structure for table `activitylog`
--

CREATE TABLE `activitylog` (
  `activitylog` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `action` varchar(100) NOT NULL,
  `activity_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `activitylog`
--

INSERT INTO `activitylog` (`activitylog`, `userid`, `action`, `activity_date`) VALUES
(618, 22, 'Delete Stuff - Name: Regan', '2019-09-29 09:41:44'),
(619, 22, 'Delete Stuff - Name: ', '2019-09-29 09:41:58'),
(620, 22, 'Delete Stuff - Name: à¦œà§à§Ÿà§‡à¦²', '2020-02-03 14:56:31'),
(621, 22, 'Delete Stuff - Name: à¦®à§‹à¦ƒ à¦à¦¨à¦¾à¦®à§à¦² à¦¹à¦•', '2020-02-03 14:56:35'),
(622, 22, 'Delete Stuff - Name: Jakiul Hasan Ruel', '2020-02-03 14:56:38'),
(623, 22, 'Delete Stuff - Name: Jikrul Hasan Jewel', '2020-02-03 14:56:41'),
(624, 22, 'Delete Stuff - Name: Megh', '2020-02-03 14:56:45'),
(625, 22, 'Update account', '2020-07-18 21:53:28'),
(626, 22, 'Update account', '2020-07-18 21:53:53'),
(627, 130, 'Add New Client - Name: Kalam', '2022-02-06 20:48:46'),
(628, 22, 'Add New Client - Name: Kalam', '2022-02-06 21:10:10'),
(629, 22, 'Add New Client - Name: Kalam', '2022-02-06 21:21:11'),
(630, 22, 'Add New Client - Name: Kalam', '2022-02-06 21:21:48'),
(631, 22, 'Add New Client - Name: Kalam', '2022-02-06 13:23:16'),
(632, 22, 'Add New Client - Name: Kalam', '2022-02-06 13:54:58'),
(633, 22, 'Add New Client - Name: Tausif', '2022-03-18 06:00:10'),
(634, 22, 'Add New Client - Name: Tausif', '2022-03-20 02:28:47'),
(635, 22, 'Add New Client - Name: Tausif', '2022-03-23 10:17:59'),
(636, 22, 'Add New Client - Name: Tausif', '2022-03-23 10:18:43'),
(637, 22, 'Add New Client - Name: Abul Azad', '2022-03-23 10:25:02'),
(638, 22, 'Add New Client - Name: Tausif', '2022-03-23 10:35:19'),
(639, 22, 'Add New Client - Name: Abul Azad', '2022-03-23 10:35:27'),
(640, 22, 'Add New Client - Name: S.M Imran Islam', '2022-04-06 12:27:57'),
(641, 22, 'Add New Client - Name: S.M Imran Islam', '2022-04-06 12:29:00'),
(642, 22, 'Add New Client - Name: Imran Islam', '2023-04-14 20:12:11'),
(643, 22, 'Add New Client - Name: Tausif', '2023-04-14 20:14:28'),
(644, 22, 'Add New Client - Name: Tausif', '2023-08-31 21:34:40'),
(645, 22, 'Add New Client - Name: Fashion', '2023-11-12 13:43:18'),
(646, 22, 'Add New Client - Name: Fashion', '2023-11-12 13:43:39'),
(647, 22, 'Add New Client - Name: Fashion', '2023-11-12 13:45:50'),
(648, 22, 'Add New Client - Name: Cow Farm', '2023-11-16 16:49:39'),
(649, 22, 'Add New Client - Name: Swazis', '2023-11-16 16:51:42'),
(650, 22, 'Add New Client - Name: Agro Feed', '2023-11-21 23:50:33'),
(651, 22, 'Add New Client - Name: Rice Mills', '2023-11-22 04:42:35'),
(652, 22, 'Add New Client - Name: Agro Feed', '2024-01-09 03:32:26'),
(653, 22, 'Add New Client - Name: Cattle Farm', '2024-02-05 03:27:08');

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

--
-- Table structure for table `apply`
--

CREATE TABLE `apply` (
  `student_id` int(150) NOT NULL,
  `user_id` int(50) NOT NULL,
  `student_no` int(50) NOT NULL,
  `batch_no` varchar(250) NOT NULL,
  `course_name` varchar(200) NOT NULL,
  `student_name` varchar(250) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `bld_grp` varchar(50) NOT NULL,
  `father_name` varchar(250) NOT NULL,
  `mother_name` varchar(250) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `apply`
--

INSERT INTO `apply` (`student_id`, `user_id`, `student_no`, `batch_no`, `course_name`, `student_name`, `gender`, `bld_grp`, `father_name`, `mother_name`) VALUES
(101, 130, 2, 'Md.Samiul Alom', '', 'Managing Director', 'Male', '', 'Tinmatha', '01751458998'),
(103, 130, 3, 'New Customer', '', '', 'Male', '', 'Bogura', '01751456623'),
(104, 130, 4, 'Zobayer2', '', '', 'Male', '', 'Meghai', '01611-717527'),
(105, 135, 5, 'Kiron Alom', '', '', 'Male', '', 'Dhaka', '01751894256'),
(106, 136, 6, 'Talha Khan', '', '', 'Male', '', 'Dhaka', '054654'),
(107, 135, 7, 'Rubel Hossain', '', '', 'Male', '', 'Dhaka', '00154545'),
(108, 135, 8, 'Bappi Hasan', '', 'Marketing Officer1', 'Male', '', 'Mirpur-12, Dhaka', '017589'),
(109, 137, 9, 'Jhon doe', '', 'Managing director', 'Male', '', 'New York City, USA', '846446456'),
(110, 137, 10, 'Samiul Alom', '', 'CEO', 'Male', '', 'Bogura', '01751891037'),
(111, 140, 1, 'Sidgao', '1', 'Interney Marketing', '', '', 'USA', '3232323232'),
(112, 137, 11, 'Kalam', '', 'Business', 'Male', '', 'Bizrul', '01751-895247'),
(113, 140, 2, 'Batch-25', 'Office Application', 'Md.Salam Ali', 'Male', '', 'Md.Abbas', 'Mrs.Salma'),
(114, 140, 3, 'Batch-25', '1', 'Md.Jamal Sheakh1', '', '', 'Jalal Sheakh1', 'Jomila Sheakh1'),
(115, 137, 0, 'Batch-25', '1', 'Salam', '', '', 'father', 'mother'),
(116, 140, 4, 'Batch-25', '1', 'a', 'Male', '', 'as', 'as'),
(117, 140, 5, '7', '25', 'DD', 'Other', 'O+', 'sf', 'sf'),
(118, 22, 12, '1', '25', 'DD', 'Female', 'A+', 'safa', 'asf');

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

--
-- Table structure for table `batch`
--

CREATE TABLE `batch` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `batch_name` varchar(300) NOT NULL,
  `batch_no` varchar(100) NOT NULL,
  `trainer` varchar(350) NOT NULL,
  `entry_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `batch`
--

INSERT INTO `batch` (`id`, `user_id`, `batch_name`, `batch_no`, `trainer`, `entry_date`) VALUES
(1, 130, 'Domain ', '1000', 'Anik', '2022-01-28'),
(2, 135, 'Nasta', '200', 'rr', '2022-01-30'),
(3, 130, 'nasta', '50', 'dd', '2022-01-30'),
(4, 136, 'Nasta', '50', 'dd', '2022-01-31'),
(5, 137, 'Dinner ', '230', 'Bbn', '2022-02-13'),
(6, 140, 'Tea 3cup', '30', 'sa', '2022-04-08'),
(7, 140, 'Nasta Tea 4-cup', '20', 'ss', '2022-05-29'),
(8, 140, 'Biscuit 2Pack', '40', 'aa', '2022-05-30'),
(9, 140, 'Nasta Tea 4-cup', '55', 'aff', '2022-05-31'),
(10, 140, 'Evening', '456', 'nhjty', '2023-04-16'),
(11, 140, 'nyjh', 'rnn', 'gnrtn', '2023-04-16');

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

--
-- Table structure for table `bld_grp`
--

CREATE TABLE `bld_grp` (
  `bld_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bld_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bld_grp`
--

INSERT INTO `bld_grp` (`bld_id`, `user_id`, `bld_name`) VALUES
(2, 140, 'Bogura'),
(3, 140, 'Rajshahi'),
(4, 140, 'Bsc'),
(5, 140, 'O-'),
(6, 140, 'A-'),
(7, 140, 'O+');

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

--
-- Table structure for table `board`
--

CREATE TABLE `board` (
  `brd_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `brd_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `board`
--

INSERT INTO `board` (`brd_id`, `user_id`, `brd_name`) VALUES
(2, 140, 'Bogura'),
(3, 140, 'Rajshahi'),
(4, 140, 'Bsc'),
(5, 140, 'Rangpur');

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `br_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `br_name` varchar(300) NOT NULL,
  `br_address` varchar(200) NOT NULL,
  `br_contact` varchar(50) NOT NULL,
  `br_mail` varchar(200) NOT NULL,
  `br_img` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`br_id`, `user_id`, `br_name`, `br_address`, `br_contact`, `br_mail`, `br_img`) VALUES
(1, 140, 'Uttara', 'North Uttara', '0123655', 'me@mail.com', '973186.');

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

--
-- Table structure for table `chair_man_massage`
--

CREATE TABLE `chair_man_massage` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `title` varchar(500) NOT NULL,
  `subtitle` varchar(5000) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `chair_man_massage`
--

INSERT INTO `chair_man_massage` (`id`, `user_id`, `title`, `subtitle`, `userPic`) VALUES
(18, 130, 'Chairman', 'Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level. Action oriented education is the main driver of development and progress. The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.', '829213.jpg');

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

--
-- Table structure for table `choose_section`
--

CREATE TABLE `choose_section` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `choose_title` varchar(200) NOT NULL,
  `choose_subtitle` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `choose_section`
--

INSERT INTO `choose_section` (`id`, `user_id`, `choose_title`, `choose_subtitle`, `userPic`) VALUES
(9, 130, 'World Class Service', 'Provide World Class Service According To Your Demand', '576321.png'),
(10, 130, 'Best Quality Product', 'We always try to our best quality product service.', '443611.png'),
(11, 130, 'Best Price For You', 'We Take Affordable Price And Best Quality Product', '665496.png'),
(12, 130, 'Best Price For You', 'We Take Affordable Price And Best Quality Product', '812993.png'),
(13, 130, 'Best Price For You', 'We Take Affordable Price And Best Quality Product', '67187.png'),
(14, 130, 'Best Price For You', 'We Take Affordable Price And Best Quality Product', '538535.jpg'),
(15, 130, 'Best Price For You', 'We Take Affordable Price And Best Quality Product', '700985.jpg');

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

--
-- Table structure for table `choose_us`
--

CREATE TABLE `choose_us` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `choose_us`
--

INSERT INTO `choose_us` (`id`, `user_id`, `title`, `sub_title`, `image`) VALUES
(4, 141, 'Unique Design ', '<p>Unique Design<br></p>', 'itm-978975-fashion-logo.png'),
(5, 141, 'Best Quality', '<p>Best Quality<br></p>', 'itm-25000-bbtt.jpg'),
(6, 141, 'Export Quality', '<p>Export Quality<br></p>', 'itm-95083-bbtt.jpg'),
(7, 144, 'Best Quality Products', '<p>Best Quality Products<br></p>', 'itm-467896-feed-logos.png'),
(8, 144, 'Time To Time Delivery', '<p>Time To Time Delivery<br></p>', 'itm-337157-feed-logos.png'),
(9, 144, '100% Quality Ensure ', '<p>100% Quality Ensure <br></p>', 'itm-464475-feed-logos.png');

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

--
-- Table structure for table `color_web`
--

CREATE TABLE `color_web` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `Top Header` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `color_web`
--

INSERT INTO `color_web` (`id`, `user_id`, `Top Header`, `bg_color`, `text_color`, `link_color`, `hover_color`, `status`) VALUES
(1, 140, '#5c0e86', '#b095d0', '#ebe3ee', '', '', 1),
(3, 141, '#0087c3', '#544870', '#000000', '', '', 1),
(4, 150, '#d67c41', '#eea886', '#f8e9dc', '', '', 1);

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

--
-- Table structure for table `color_web_footer`
--

CREATE TABLE `color_web_footer` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `color_web_footer`
--

INSERT INTO `color_web_footer` (`id`, `user_id`, `bg_color`, `text_color`, `link_color`, `hover_color`, `status`) VALUES
(1, 140, '#b095d0', '#ebe3ee', '', '', 1),
(3, 141, 'bg-info', 'text-success', 'text-danger', 'text-warning', 1),
(4, 150, '#eea886', '#f8e9dc', '', '', 1);

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `phone` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `user_id`, `phone`, `email`, `address`, `userPic`) VALUES
(14, 140, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(15, 141, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(16, 142, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(17, 143, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(18, 144, '01751891037', 'agrofeed@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(19, 145, '01751-891037', 'ricemill@gmail.com', 'Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(20, 146, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(21, 147, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(22, 148, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(23, 149, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png'),
(24, 150, '01610-762576', ' pcltd75@gmail.com', 'Puran Bogura, Rajshahi Division, Bangladesh', '946098.png');

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

--
-- Table structure for table `contact_info`
--

CREATE TABLE `contact_info` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `subject` varchar(200) NOT NULL,
  `message` varchar(1000) NOT NULL,
  `entry_date` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_info`
--

INSERT INTO `contact_info` (`id`, `user_id`, `name`, `email`, `phone`, `subject`, `message`, `entry_date`) VALUES
(20, 140, 'Md. Samiul alom', 'samiulbdb@gmail.com', '01751-891037', 'I Need 10 Box Asmon ', 'I Need 10 Box Asmon ', '2020-05-28'),
(21, 140, 'Fahim', 'sanu@gmail.com', '01751-891037', 'I Need 10 Box Asmon', 'afshoasjfas', '2020-06-02');

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `phone` varchar(11) NOT NULL,
  `email` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `entry_date` date NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`id`, `user_id`, `name`, `phone`, `email`, `message`, `entry_date`) VALUES
(2, 0, 'John', '938994849', 'b@gmail.com', 'Message for contact Us', '2023-10-18'),
(3, 0, 'New Bank', '0157657659', 'sam@ggg.com', 'asfasfas', '2023-10-22'),
(5, 0, 'Raju', '938994849', 'email@gmail.com', 'fjfdjftfghf', '2023-11-01'),
(6, 140, 'Com', '938994849', 'email@gmail.com', 'khjkghjkh', '2023-11-01'),
(7, 141, 'ARIFIN SIR', '01738566947', 'samiul@gmail.com', 'Hi....', '2023-11-13');

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

--
-- Table structure for table `crse_topic`
--

CREATE TABLE `crse_topic` (
  `crse_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `crse_name` varchar(300) NOT NULL,
  `topic` varchar(200) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `crse_topic`
--

INSERT INTO `crse_topic` (`crse_id`, `user_id`, `crse_name`, `topic`, `status`) VALUES
(11, 140, '25', ' Basic Hardware, Software', '1'),
(12, 140, '25', 'Introduction to Computer Operating System', '1'),
(13, 140, '25', ' Microsoft Word', '1'),
(14, 140, '25', 'Microsoft Excel', '1');

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

--
-- Table structure for table `degree`
--

CREATE TABLE `degree` (
  `deg_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `deg_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `degree`
--

INSERT INTO `degree` (`deg_id`, `user_id`, `deg_name`) VALUES
(2, 140, 'Bogura'),
(3, 140, 'Rajshahi'),
(4, 140, 'Bsc'),
(5, 140, 'fgnbfg');

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

--
-- Table structure for table `diploma_admission`
--

CREATE TABLE `diploma_admission` (
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ad_name` varchar(255) NOT NULL,
  `ad_details` text NOT NULL,
  `userPic` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `diploma_admission`
--

INSERT INTO `diploma_admission` (`ad_id`, `user_id`, `ad_name`, `ad_details`, `userPic`) VALUES
(1, 140, 'CSE1', '<p>CSE Here1</p>', '872646.png');

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

--
-- Table structure for table `district`
--

CREATE TABLE `district` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `dist_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `district`
--

INSERT INTO `district` (`id`, `user_id`, `dist_name`) VALUES
(2, 140, 'Bogura'),
(3, 140, 'Rajshahi'),
(4, 140, 'Pabna');

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

--
-- Table structure for table `division`
--

CREATE TABLE `division` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `area_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `division`
--

INSERT INTO `division` (`id`, `user_id`, `area_name`) VALUES
(1, 130, 'Dhaka'),
(2, 130, 'Rajshahi');

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `id` int(20) NOT NULL,
  `emp_name` varchar(100) NOT NULL,
  `father_name` varchar(100) NOT NULL,
  `national_id` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `contact_info` varchar(50) NOT NULL,
  `birthdate` date NOT NULL,
  `gender` varchar(50) NOT NULL,
  `photo` varchar(200) NOT NULL,
  `position` varchar(200) NOT NULL,
  `hire_date` date NOT NULL,
  `sal_type` varchar(200) NOT NULL,
  `salary` int(200) NOT NULL,
  `status` int(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `expense`
--

CREATE TABLE `expense` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `expense_name` varchar(300) NOT NULL,
  `exp_details` varchar(300) NOT NULL,
  `ammount` varchar(200) NOT NULL,
  `expense_cost` varchar(100) NOT NULL,
  `reference` varchar(350) NOT NULL,
  `entry_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `expense`
--

INSERT INTO `expense` (`id`, `user_id`, `expense_name`, `exp_details`, `ammount`, `expense_cost`, `reference`, `entry_date`) VALUES
(7, 22, '3', 'TruckTruckTruckTruck', '', '10000', 'Nahid', '2020-10-01'),
(8, 22, '3', 'keyboard', '', '500', 'à¦•à¦¾à¦®à¦¾à¦²1', '2020-10-11'),
(9, 22, '5', 'keyboard', '1ps', '1000', 'aaa', '2020-10-11'),
(10, 22, '5', 'keyboard', '5ps', '1000', 'à¦•à¦¾à¦®à¦¾à¦²', '2020-10-11'),
(11, 22, '6', 'Drone', '1pcs', '45500', 'Dd', '2020-10-11'),
(12, 22, '3', 'shgrbhfhy', '1kg', '100', 'gh', '2020-10-11'),
(13, 22, '7', 'color', '1 galon', '540', 'ASX', '2020-10-11'),
(14, 22, '8', 'zdshkjvbhng', '5', '1000', 'Asraf', '2020-10-16'),
(15, 130, '9', 'aifgnxcujv', '1pcs', '250', 'Asraf', '2020-11-27'),
(16, 130, '10', 'computer', '2 Pcs', '30000', '', '2021-01-01'),
(17, 130, '13', '100 pcs ', '100', '2000', 'Suvo', '2021-04-07'),
(18, 130, '5', 'A4 Tech mouse', '1', '300', 'dsd', '2021-04-07'),
(19, 130, '14', '1 Bigha Land', '1', '5000', 'rr', '2021-04-16'),
(20, 130, '14', 'Fish 30kg Medum Size', '30', '6000', 'mm', '2021-04-16'),
(21, 130, '14', 'Food 5kg ', '5', '750', 'ff', '2021-04-16'),
(22, 140, '15', 'Small Fan', '1', '1050', 'aa', '2022-05-30'),
(25, 140, '5', 'dd', '1', '55', 'll', '2022-05-31'),
(26, 140, '16', 'ss', '1', '120', 'ss', '2022-06-05');

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

--
-- Table structure for table `expense_other`
--

CREATE TABLE `expense_other` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `expense_name` varchar(300) NOT NULL,
  `expense_cost` varchar(100) NOT NULL,
  `reference` varchar(350) NOT NULL,
  `entry_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `expense_other`
--

INSERT INTO `expense_other` (`id`, `user_id`, `expense_name`, `expense_cost`, `reference`, `entry_date`) VALUES
(1, 130, 'Domain ', '1000', 'Anik', '2022-01-28'),
(2, 135, 'Nasta', '200', 'rr', '2022-01-30'),
(3, 130, 'nasta', '50', 'dd', '2022-01-30'),
(4, 136, 'Nasta', '50', 'dd', '2022-01-31'),
(5, 137, 'Dinner ', '230', 'Bbn', '2022-02-13'),
(6, 140, 'Tea 3cup', '30', 'sa', '2022-04-08'),
(7, 140, 'Nasta Tea 4-cup', '20', 'ss', '2022-05-29'),
(8, 140, 'Biscuit 2Pack', '40', 'aa', '2022-05-30'),
(9, 140, 'Nasta Tea 4-cup', '55', 'aff', '2022-05-31');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `title` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `user_id`, `title`, `userPic`) VALUES
(23, 140, 'g2', 'prince-870069-8.jpg'),
(24, 140, 'Program Photo', 'prince-104213-6.jpg'),
(25, 140, 'Program Photo', 'prince-417576-3.jpg'),
(26, 140, 'Program Photo', 'prince-967362-2.jpg'),
(27, 140, 'Program Photo', 'prince-328917-1.jpg');

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

--
-- Table structure for table `map`
--

CREATE TABLE `map` (
  `mp_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `mp_title` varchar(300) NOT NULL,
  `mp_link` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `map`
--

INSERT INTO `map` (`mp_id`, `user_id`, `mp_title`, `mp_link`) VALUES
(1, 140, 'title', 'https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3001156.4288297426!2d-78.01371936852176!3d42.72876761954724!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x4ccc4bf0f123a5a9%3A0xddcfc6c1de189567!2sNew%20York%2C%20USA!5e0!3m2!1sen!2sbd!4v1603794290143!5m2!1sen!2sbd');

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

--
-- Table structure for table `medical_admission`
--

CREATE TABLE `medical_admission` (
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ad_name` varchar(255) NOT NULL,
  `ad_details` text NOT NULL,
  `userPic` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `medical_admission`
--

INSERT INTO `medical_admission` (`ad_id`, `user_id`, `ad_name`, `ad_details`, `userPic`) VALUES
(1, 140, 'Medical1', '<p>Details Medical<br></p>', '611412.png');

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

--
-- Table structure for table `medical_assistant_admission`
--

CREATE TABLE `medical_assistant_admission` (
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ad_name` varchar(255) NOT NULL,
  `ad_details` text NOT NULL,
  `userPic` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `medical_assistant_admission`
--

INSERT INTO `medical_assistant_admission` (`ad_id`, `user_id`, `ad_name`, `ad_details`, `userPic`) VALUES
(1, 140, 'Medical Assistant', '<p>Details Medical Assistant<br></p>', '361786.png');

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

--
-- Table structure for table `mission`
--

CREATE TABLE `mission` (
  `ms_id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `details` longtext NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mission`
--

INSERT INTO `mission` (`ms_id`, `user_id`, `name`, `details`, `userPic`) VALUES
(1, 140, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(2, 141, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(3, 142, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(4, 143, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(5, 144, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(6, 145, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(7, 146, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(8, 147, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(9, 148, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(10, 149, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png'),
(11, 150, 'Our Mission', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress. </span></p>\r\n<p><span style=\"font-size: 12pt;\">The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '22254.png');

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

--
-- Table structure for table `month`
--

CREATE TABLE `month` (
  `mnt_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `mnth_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `month`
--

INSERT INTO `month` (`mnt_id`, `user_id`, `mnth_name`) VALUES
(1, 140, 'June'),
(2, 140, 'July'),
(3, 140, 'August');

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

--
-- Table structure for table `news_section`
--

CREATE TABLE `news_section` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `news_title` varchar(500) NOT NULL,
  `news_subtitle` longtext NOT NULL,
  `news_date` date NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `news_section`
--

INSERT INTO `news_section` (`id`, `user_id`, `news_title`, `news_subtitle`, `news_date`, `userPic`) VALUES
(17, 140, 'ডেটা নির্দেশিকায় পরিবর্তন, কমেছে প্যাকেজ ও মেয়াদ', '<div class=\"news_block\">\r\n                                    \r\n                    <div class=\"tittle_area\">\r\n                        <div class=\"newsdetails_top\">\r\n                            \r\n                            <p><span style=\"font-family: sans-serif; background-color: var(--bs-table-bg); font-size: var(--bs-body-font-size); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">প্রায় দেড় বছর আগে করা ডেটা নির্দেশিকায় পরিবর্তন-পরিমার্জন এনে নতুন \r\nনির্দেশিকা করেছে নিয়ন্ত্রণ সংস্থাটি। ইতোমধ্যে মোবাইল ফোন অপারেটরদের তা \r\nবাস্তবায়নের নির্দেশনাও দেয়া হয়েছে। নতুন এসব সিদ্ধান্ত অক্টোবর হতে \r\nবাস্তবায়ন করতে হবে।</span></p></div></div></div><div class=\"news_row\"><div class=\"post_details\">\r\n\r\n\r\n\r\n<p>নির্দেশিকায় ২১ টি সিদ্ধান্ত পরিবর্তন-পরিমার্জন বা নতুন করে যুক্ত হয়েছে। যেখানে একটি সিদ্ধান্ত বিলুপ্ত করা হয়েছে।</p><p><span style=\"background-color: var(--bs-table-bg); font-size: var(--bs-body-font-size); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\"> </span><span style=\"background-color: var(--bs-table-bg); font-size: var(--bs-body-font-size); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">অপারেটর যে প্যাকেজেই দিক না কেনো তার মেয়াদ হবে ৭ দিন, ৩০ দিন এবং \r\nআনলিমিটেড। আগে এটি ছিলো ৩ দিন, ৭ দিন, ১৫ দিন এবং ৩০ দিন। যেখানে ডেটা \r\nভলিউম সংক্রান্ত কিছু নির্দেশনাও ছিল।</span></p>\r\n\r\n\r\n\r\n<p>একটি অপারেটরের নিয়মিত, বিশেষ, রিসার্চ ও ডেভেলমেন্ট, সব ধরনের \r\nব্র্যান্ড (গ্রামীণফোন, স্কিটো, রবি, এয়ারটেল, বাংলালিংক ইত্যাদিসহ যা আছে)\r\n মিলিয়ে প্যাকেজের সংখ্যা হবে ৪০টি। আগে এটি ছিলো ৮৫টি।  </p>\r\n\r\n\r\n\r\n<p>মেয়াদ শেষ হওয়ার আগে একই প্যাকেজ কিনলে ডেটা ক্যারি ফরওয়ার্ড হবে। এতে \r\nএকই ভলিউম এবং একই কন্টেন্টের ৭ বা ৩০ দিন মেয়াদের প্যাকেজ ব্যবহার করার \r\nক্ষেত্রে মেয়াদ শেষ হওয়ার আগেই গ্রাহক ওই প্যাকেজ আবার কিনলে ডেটা ক্যারি \r\nফরওয়ার্ড হবে। ক্যারি ফরওয়ার্ড করা যাবে সর্বোচ্চ ৫০ জিবি ডেটা পর্যন্ত। </p>\r\n\r\n\r\n\r\n<p>কমানো হয়েছে প্রমোশনাল এসএমএসের সংখ্যাও। আগে প্রতিদিন সর্বোচ্চ ৪ টি এসএমএস দিতে পারত অপারে', '2023-09-09', '861086.jpg'),
(18, 140, ' কুমিল্লায় ১৭৫ কোটি টাকায় নলেজ পার্ক', '<p><b>প্রায় ১৭৫ কোটি টাকা</b> ব্যয়ে কুমিল্লা জেলার লালমাই উপজেলার দত্তপুর \nমৌজায় ৭.৮৮ একর জায়গায় ‘নলেজ পার্ক’ এর ভিত্তিপ্রস্তর স্থাপন করলেন \nঅর্থমন্ত্রী আ হ ম মুস্তফা কামাল ও আইসিটি প্রতিমন্ত্রী <b>জুনাইদ আহমেদ পলক</b>। </p><p>শনিবার <b>নলেজ পার্কের</b> ভিত্তিপ্রস্তর স্থাপন অনুষ্ঠানে আয়োজিত আলোচনা \nসভায় প্রধান অতিথির বক্তব্যে অর্থমন্ত্রী আ হ ম মুস্তফা কামাল বলেন, এ \nনলেজ পার্কের মাধ্যমে সমগ্র কুমিল্লার ছেলে-মেয়েরা প্রযুক্তির ক্ষেত্র \nএগিয়ে যাবে। আমরা সবাই মিলে কুমিল্লাকে এগিয়ে নেবো।</p><p>\n\n\n\n\n\n\n\n</p><p>সভাপতির বক্তব্যে আইসিটি প্রতিমন্ত্রী জুনাইদ আহমেদ পলক বলেন, \n‘কুমিল্লার অনেক সনামধন্য শিক্ষা প্রতিষ্ঠানে হাজার হাজার শিক্ষার্থী \nরয়েছেন। এই তরুণ-তরুনীদেরকে যদি আমরা আমরা আইটিতে দক্ষ মানবসম্পদ হিসেবে \nগড়ে তুলতে পারি তাহলে এই অঞ্চলের অর্থনীতির ইকোসিস্টেমে আমূল পরিবর্তন \nআসবে।</p><p>তিনি বলেন, ১৫ বছর আগেও দেশের স্বল্প শিক্ষিত তরুণ প্রজন্ম \nকর্মসংস্থানের জন্য যেখানে গার্মেন্টসসহ অন্যান্য শ্রমনির্ভর শিল্পের উপর \nনির্ভরশীল ছিলো সেখানে বর্তমানে তারা আইটি শিল্পে নিজেদের ক্যারিয়ার গড়ে \nতুলছে। এছাড়া স্টার্টআপ এবং ক্ষুদ্র ও মাঝারি প্রতিষ্ঠানগুলোর \nইন্ডাস্ট্রিতে প্রবেশের হার বাড়ানো এবং জেন্ডার ইনক্লুসিভ \nএন্টারপ্রেনারশিপ তৈরিতে এই নলেজ পার্ক সরাসরি ভূমিকা রাখবে। আগামীর \nস্মার্ট বাংলাদেশ হবে বিশ্বের অন্যতম আইটি হাব। </p>\n\n\n\n<p>পলক বলেন, বাংলাদেশ থেকেই পরিচালিত হবে বিশ্বের অনেক জায়ান্ট কোম্পানি।\n সেগুলোর পরিচালনায় নেতৃত্ব দেবে আমাদের নতুন প্রজন্মের সন্তানেরা। সেই \nসময়ের উদ্ভাবনী মেধাসম্পন্ন তরুণ-তরুণীর মেধার বিকাশ ঘটবে আইটি বিজনেস \nইনকিউবেটর, ইনোভেশন হাব-এর মতো প্রতিষ্ঠানের মাধ্যমে। শীঘ্রই এই পার্কের \nপাশে ‘শেখ কামাল আইটি ট্রেনিং এন্ড ইনকিউবেশন সেন্টার’ এর নির্মাণ কাজ শেষ \nহবে। এখানে যে দক্ষ জনবল সৃষ্টি হবে তারাই আবার এই নলেজ পার্কে কাজ করবে। \nতখন এই পার্কের জন্য প্রয়োজনীয় দক্ষ মানবসম্পদ পেতে সমস্যা হবে না।</p>\n\n\n\n<p>স্বাগত বক্তব্যে বাংলাদেশ হাই-টেক পার্ক কর্তৃপক্ষ এর ব্যবস্থাপনা \nপরিচালক (গ্রেড-১) জি এস এম জাফরউল্লাহ্ বলেন, বাংলাদেশ হাই-টেক পার্ক \nকর্তৃপক্ষ এর মাধ্যমে বর্তমানে সারা দেশে সরাকারি উদ্যোগে ৯২টি হাই-টেক \nপার্ক/সফটওয়্যার টেকনোলজি পার্ক/আইটি ট্রেনিং এন্ড ইনকিউবেশন সেন্টার \nস্থাপনের কাজ চলমান রয়েছে, ইতোমধ্যে ১১টি পার্ক স্থাপনের কাজ সমাপ্ত \nহয়েছে যেখানে ইতোমধ্যে ব্যবসায়িক কার্যক্রম শুরু হয়েছে। এছাড়া বেসরকারি\n উদ্যোগে গঠিত হয়েছে আরো ১৭টি পার্ক। ৪র্থ শিল্প বিপ্লবের প্রতিযোগিতা \nমোকাবেলায় বিভিন্ন বিশ্ববিদ্যালয়ে আইওটি, রোবোটিক্স, সাইবার সিকিউরিটির \nউচ্চপ্রযুক্তির ৩৩টি বিশেষায়িত ল্যাব স্থাপন করা হয়েছে এবং \nবিশ্ববিদ্যালয়গুলোতে আইটি বিজনেস ইনকিউবেটর স্থাপন করা হচ্ছে।</p>\n\n\n\n<p>প্রকল্প পরিচালক এ, কে, এ, এম, ফজলুল হক জানান,  এই ‘নলেজ পার্ক’ \nস্থাপনের কাজ শেষ হলে এখানে প্রায় ১০০০ জনের কর্মসংস্থানের সুযোগ সৃষ্টি \nহবে। এছাড়া প্রকল্পের আওতায় প্রতি বছর ৩০০০ জনকে প্রশিক্ষণ প্রদান করা \nহবে।</p>\n\n\n\n<p><span style=\"background-color: var(--bs-table-bg); font-size: var(--bs-body-font-size); font-weight: var(--bs-body-font-weight); text-align: var(--bs-body-text-align);\">ভিত্তিপ্রস্তর স্থাপন অনুষ্ঠানে বাংলাদেশ হাই-টেক পার্ক কর্তৃপক্ষ ও স্থানীয় প্রশাসনের অন্যান্য কর্মকর্তারা উপস্থিত ছিলেন।</span> </p>', '2023-09-09', '795722.jpg'),
(19, 140, 'News Title Somoy TV', '<p><b>News Channel</b></p><p><b><u>Somoy TV</u><br></b><br></p>', '2023-10-19', '902830.png'),
(20, 141, 'Recondition your old t-shirts', '<p class=\"MsoNormal\">I think everyone of us has stored somewhere in the house some <em>old t-shirts</em>\r\n that keep inside lots of memories. T-shirts have the tendency to become\r\n very personal, because they carry moments of our life and then they’re \r\nno longer wearable. It’s very hard to get rid of them for sentimental \r\nreasons sometimes. But we have a solution for you.</p><p class=\"MsoNormal\">Instead\r\n of simply throwing them away and be sorry, here are 10 ways to get your\r\n old t-shirt out of the box and recondition it. I’ve also included some \r\nlinks to tutorials that I found on the Internet in case you want to try \r\nany of these methods.</p>', '2023-11-19', '558799.png'),
(21, 144, 'Organic Raw materials', '<p><span style=\"color: rgb(122, 122, 122); font-family: Roboto, sans-serif; text-align: justify;\">We are proud to say that we are 99% organic in terms of sourcing our raw materials for our feed division. We understand the importance our customers place in healthy living and eating, and as a part of this process we ensure the RM we use in our food operations are free of any harmful substances, as well as ensuring all our processed food is antibiotic, MBM and preservative free.</span><br></p>', '2023-11-23', '123112.jpg'),
(22, 144, 'Using Husk to power our Boiler units', '<p><span style=\"color: rgb(122, 122, 122); font-family: Roboto, sans-serif; text-align: justify;\">As an alternative to diesel our feed production plants are using husk to operate the boilers. This has been instrumental in allowing for a safe and sustainable way to power our operations and reduce carbon emission.</span><br></p>', '2023-11-23', '295477.jpg'),
(23, 144, 'Waste Reduction and Recycling', '<p><span style=\"color: rgb(122, 122, 122); font-family: Roboto, sans-serif; text-align: justify;\">For our food processing unit we have installed a rendering plant which ensures all waste and bi-product are processed for further use. In our farming operations we have installed biogas plants which convert chicken waste and litter into energy, while our Bag production unit is fully recycling its PP woven bag wastage to reduce environmental harm.</span><br></p>', '2023-11-23', '813551.jpg');

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

--
-- Table structure for table `nursing_admission`
--

CREATE TABLE `nursing_admission` (
  `ad_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ad_name` varchar(255) NOT NULL,
  `ad_details` text NOT NULL,
  `userPic` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `nursing_admission`
--

INSERT INTO `nursing_admission` (`ad_id`, `user_id`, `ad_name`, `ad_details`, `userPic`) VALUES
(1, 140, 'Nursing', '<p>Details Nursing<br></p>', '468257.png');

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

--
-- Table structure for table `office_exp_name`
--

CREATE TABLE `office_exp_name` (
  `of_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `office_exp_name`
--

INSERT INTO `office_exp_name` (`of_id`, `user_id`, `name`) VALUES
(3, 22, 'Keyboard'),
(4, 22, 'Keyboard'),
(5, 22, 'Mouse'),
(6, 22, 'Mavic mini'),
(7, 22, 'White paint'),
(8, 22, 'Costacb'),
(9, 130, 'New'),
(11, 130, 'Charger'),
(12, 130, 'profit'),
(13, 130, 'Khata'),
(14, 130, 'Pond-01 Season-01 ( January To December-2021 )'),
(15, 140, 'Fan'),
(16, 140, 'Burger'),
(17, 140, 'New Dd');

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

--
-- Table structure for table `order_list`
--

CREATE TABLE `order_list` (
  `OrderId` int(11) NOT NULL,
  `ProId` int(11) NOT NULL,
  `UserId` int(11) DEFAULT NULL,
  `Price` float NOT NULL,
  `Qty` int(11) NOT NULL,
  `CustName` varchar(100) NOT NULL,
  `TotalPrice` float NOT NULL,
  `Phone` varchar(11) NOT NULL,
  `Address` varchar(255) NOT NULL,
  `create_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_list`
--

INSERT INTO `order_list` (`OrderId`, `ProId`, `UserId`, `Price`, `Qty`, `CustName`, `TotalPrice`, `Phone`, `Address`, `create_at`) VALUES
(3, 41, NULL, 700, 3, 'Jimmy', 2100, '947494749', 'Jons\'s Town', '2023-10-18 22:17:43'),
(4, 43, NULL, 540, 2, 'Jimmy', 1080, '947494749', 'Jons\'s Town', '2023-10-18 22:18:44'),
(5, 40, NULL, 4900, 1, 'John', 4900, '947494749', 'Jons\'s Town', '2023-10-18 22:24:50'),
(7, 35, 140, 620, 1, 'Alif', 620, '1684168464', 'Bangladesh', '2023-11-01 21:55:19'),
(8, 42, 140, 3450, 3, 'Raju', 10350, '50230750347', 'Bangladesh', '2023-11-01 21:56:34'),
(9, 50, 141, 1500, 1, 'ARIFIN SIR', 1500, '01738566947', 'Dhaka', '2023-11-13 13:58:39'),
(10, 61, 141, 1200, 1, 'Menon ', 1200, '0157657659', 'Bogura', '2023-11-15 14:11:28'),
(11, 92, 141, 1500, 1, 'hdghdh', 1500, '43524465787', 'gdgf  kkj', '2023-12-14 04:53:50'),
(12, 111, 141, 4000, 1, 'cggc', 4000, '132456', 'fhfhfy', '2023-12-14 06:33:39'),
(13, 93, 141, 250, 1, 'Tasmin Akhter', 250, '01796768976', 'Polytecnic road, Gobindonogor', '2024-06-29 06:40:34'),
(14, 85, 141, 1200, 2, 'Asass', 2400, 'dgsdg', 'BB', '2024-09-27 05:42:44'),
(15, 86, 141, 1500, 1, 'Salam', 1500, '654654', 'Dhaka', '2024-11-17 23:04:10');

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

--
-- Table structure for table `parner`
--

CREATE TABLE `parner` (
  `pr_id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `pr_name` varchar(200) NOT NULL,
  `pr_details` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `parner`
--

INSERT INTO `parner` (`pr_id`, `user_id`, `pr_name`, `pr_details`, `userPic`) VALUES
(2, 140, 'brch', 'Na', 'prince-458233-brch.png'),
(3, 140, 'Govt', 'Na', 'prince-340454-govt.jpg'),
(4, 140, 'bteb', 'Na', 'prince-223069-bteb.jpg'),
(5, 140, 'bteb', 'Na', 'prince-885739-bteb.jpg'),
(6, 140, 'blmdt', 'Na', 'prince-613366-blmdt.jpg');

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(110) NOT NULL,
  `user_id` int(110) NOT NULL,
  `order_id` int(110) NOT NULL,
  `customer_id` int(110) NOT NULL,
  `order_date` date NOT NULL,
  `last_update` date NOT NULL,
  `pre_due` varchar(500) NOT NULL,
  `today_total` varchar(500) NOT NULL,
  `grand_total` varchar(500) NOT NULL,
  `paid` varchar(240) NOT NULL,
  `recent_due` varchar(500) NOT NULL,
  `dues_or_paid` varchar(30) NOT NULL,
  `dues_or_paid_status` int(50) NOT NULL,
  `cuses` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `user_id`, `order_id`, `customer_id`, `order_date`, `last_update`, `pre_due`, `today_total`, `grand_total`, `paid`, `recent_due`, `dues_or_paid`, `dues_or_paid_status`, `cuses`) VALUES
(2, 130, 1301031, 101, '2022-02-02', '2022-02-02', '0.00', '90.00', '90.00', '90', '0.00', 'Dues', 5, 'By Invoice'),
(3, 130, 0, 102, '2020-08-05', '2020-08-05', '0', '0', '0', '0', '0', 'Dues', 4, 'New Customer'),
(4, 130, 1301030, 104, '2022-02-02', '2022-02-02', '0.00', '2700.00', '2700.00', '2000', '700.00', 'Dues', 4, 'By Invoice'),
(5, 135, 1020, 105, '2022-01-30', '2022-01-30', '0.00', '1280.00', '1280.00', '1000', '280.00', 'Dues', 4, 'By Invoice'),
(6, 136, 1022, 106, '2022-01-31', '2022-01-31', '10000.00', '0', '0', '10000', '0', 'Dues', 5, 'Dues Paid'),
(7, 135, 1023, 107, '2022-02-01', '2022-02-01', '0', '200.00', '200.00', '1600', '0.00', 'Dues', 4, 'Invoice Update'),
(8, 135, 0, 108, '2022-02-01', '2022-02-01', '0', '0', '0', '0', '0', 'Dues', 4, 'New Customer'),
(9, 137, 1371042, 109, '2022-02-10', '2022-02-10', '0.00', '1100.00', '1100.00', '1000', '100.00', 'Dues', 4, 'By Invoice'),
(10, 137, 1371045, 110, '2022-03-18', '2022-03-18', '7500.00', '1170.00', '8670.00', '870', '7800.00', 'Dues', 4, 'By Invoice'),
(11, 140, 1301047, 111, '2022-03-23', '2022-03-23', '0', '2000.00', '2000.00', '1000', '1000.00', 'Dues', 4, 'By Invoice'),
(12, 137, 0, 112, '2022-03-20', '2022-03-20', '0', '0', '0', '0', '0', 'Dues', 4, 'New Customer');

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

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

CREATE TABLE `products` (
  `pro_id` int(30) NOT NULL,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `pdct_typ` int(100) NOT NULL,
  `user_id` int(30) NOT NULL,
  `product_name` varchar(300) NOT NULL,
  `short_details` varchar(500) NOT NULL,
  `details` longtext NOT NULL,
  `size` varchar(150) NOT NULL,
  `weight` varchar(50) NOT NULL,
  `price` varchar(40) NOT NULL,
  `offer_price` varchar(50) NOT NULL,
  `photo` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `products` (`pro_id`, `category_id`, `pdct_typ`, `user_id`, `product_name`, `short_details`, `details`, `size`, `weight`, `price`, `offer_price`, `photo`) VALUES
(33, 9, 0, 140, 'Zeblaze VIBE 3 Pro Touch Screen Smart Watch', 'Men Real-time Weather Optical Heart Rate Monitor All-day Tracking Sports Smartwatch', '<table style=\"margin: 0px; padding: 0px; border-spacing: 0px; color: rgb(102, 102, 102); font-family: opensans, arial; font-size: 14px; width: 700px;\"><tbody style=\"margin: 0px; padding: 0px;\"><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 180px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\">Brand</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-weight: 600;\"> Zeblaze</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Model</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-weight: 600;\"> VIBE 3 Pro</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td data-spm-anchor-id=\"a2a0e.pdp.product_detail.i1.43495ce5svMKhu\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Color</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" data-spm-anchor-id=\"a2a0e.pdp.product_detail.i0.43495ce5svMKhu\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Blue</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> bluetooth Version</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> BT 4.0 or above</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Compatible OS</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Android 4.4 or above , iOS 8.0 or above</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Operating Mode</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> Touch Screen</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> APP Name</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(255, 0, 0);\"> Da Fit</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr><tr style=\"margin: 0px; padding: 0px;\"><td style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 160px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> APP Language</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td><td colspan=\"3\" style=\"margin: 0px; padding-top: 3px; padding-bottom: 3px; width: 459px;\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(0, 0, 0);\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; font-size: 14px;\"><span style=\"margin: 0px; padding: 0px;\"><span style=\"margin: 0px; padding: 0px; color: rgb(101, 109, 120);\"><span style=\"margin: 0px; padding: 0px; font-size: 18px;\"> English, Português(Brasil), Português(Portuguesa),  русский, Español, Italiano,<br style=\"margin: 0px; padding: 0px;\"> Français, Deutsch, Polish</span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></span></td></tr></tbody></table>', '12', '120gm', '1520', '', 'itm-bike-343823-watch.webp'),
(34, 9, 0, 140, 'Digital Waterproof sports Watch for Kids -blue', 'Digital Waterproof sports Watch for Kids -blue', '<ul class=\"\" style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; list-style: none; margin-block-start: 1em; font-size: 14px; overflow: hidden; columns: 2; column-gap: 32px; font-family: Roboto, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;\"><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Band Length: 22cm</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Waterproof performance: 30M (waterproof for life, not for bathing or swimming)</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Strap Material: Rubber</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Type: Digital Wristwatches</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Case Thickness: 16mm</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Quantity: 1Pc</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Dial Diameter: 36mm</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Band Length: 22cm</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">· Package Included: 1 * Digital Watch</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">. Multi Functions</li></ul>', '41', '1.2', '500', '', '311732.jpeg'),
(35, 10, 0, 140, 'Bangladesh Cricket World Cup Jersey 2023', 'Bangladesh Cricket World Cup Jersey 2023', '<ul class=\"\" style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; list-style: none; margin-block-start: 1em; font-size: 14px; overflow: hidden; columns: 2; column-gap: 32px; font-family: Roboto, -apple-system, BlinkMacSystemFont, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;\"><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Brand Name : Bangladesh</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Sleeve: Half Sleeve</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Fabric: Polyester</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Main Materials: Polyester</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Season: Bangladesh Cricket World Cup Jersey</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Style: Polo Shirt</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">Size Chart:</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">M - Length 27.5\" chest 38\"</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">L - Length 28.5\" chest: 40\"</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">XL - Length 29.5\" chest 42\"</li><li class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 15px; position: relative; line-height: 18px; text-align: left; list-style: none; word-break: break-word; break-inside: avoid;\">XXL - Length 30.5\" chest 44\"</li></ul>', 'L', '100gm', '620', '', '798030.jpeg'),
(36, 11, 0, 140, 'Honda Livo 110 Disc', 'Honda Livo 110 Disc', '<h2 class=\"browse-bikes-head ps-0\" style=\"font-weight: 700; font-size: 24px; padding: 0px 20px; color: rgb(33, 37, 41); margin-right: 0px; margin-left: 0px; outline: 0px; text-transform: capitalize; margin-bottom: 0px !important;\"><span style=\"font-family: roboto, sans-serif, Arial; font-size: 16px; font-weight: 400; text-align: justify; text-transform: none;\">The new Livo has the same 110 cc engine as the&nbsp;</span><a href=\"https://www.bikebd.com/bn/blog/honda-dream-neo-110-6000-km-user-review-shuvo\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"color: rgb(13, 110, 253); text-decoration: none; background-color: rgb(255, 255, 255); font-family: roboto, sans-serif, Arial; font-weight: 400; padding: 0px; margin: 0px; outline: 0px; font-size: 16px; text-align: justify; text-transform: none;\">Honda dream Neo</a><span style=\"font-family: roboto, sans-serif, Arial; font-size: 16px; font-weight: 400; text-align: justify; text-transform: none;\">&nbsp;has. The engine is actually 109.19 CC, 4-stroke, single-cylinder, overhead cam, air-cooled, 2 valves, a single spark, HET engine. The HET, by the way, is Honda’s new technical term for better fuel-efficient engines that have been developed by Honda Motorcycle and Scooter India, Private Limited.</span></h2>', '1', '150Kg', '132000', '', 'itm-bike-447012-livo.png'),
(37, 11, 0, 140, 'Honda X-Blade 160', 'Honda X-Blade 160', '<a href=\"https://www.bikebd.com/bn/blog/%25E0%25A6%25AC%25E0%25A6%25BE%25E0%25A6%2582%25E0%25A6%25B2%25E0%25A6%25BE%25E0%25A6%25A6%25E0%25A7%2587%25E0%25A6%25B6%25E0%25A7%2587-%25E0%25A6%2585%25E0%25A6%25AB%25E0%25A6%25BF%25E0%25A6%25B8%25E0%25A6%25BF%25E0%25A7%259F%25E0%25A6%25BE%25E0%25A6%25B2%25E0%25A6%25BF-%25E0%25A6%25B2%25E0%25A6%259E%25E0%25A7%258D%25E0%25A6%259A-%25E0%25A6%25B9%25E0%25A6%25B2%25E0%25A7%258B-honda-x-blade-160-abs-%25E0%25A6%25AD%25E0%25A6%25BE%25E0%25A6%25B0%25E0%25A7%258D%25E0%25A6%25B6%25E0%25A6%25A8\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"padding: 0px; margin: 0px; outline: 0px; color: rgb(13, 110, 253); text-decoration: none; font-family: roboto, sans-serif, Arial; font-weight: 400; text-align: justify; background-color: rgb(255, 255, 255);\">Honda X Blade</a><span style=\"color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial; text-align: justify;\">&nbsp;was first launched in December 2018 in India. In Bangladesh, the launch date was done with a two-day event in the International Convention City, Bashundhara in 13-14 December of 2019. Bikers of the country received this bike with great joy at the launch of this new bike.</span>', 'L', '146Kg', '191,500', '', 'itm-bike-880800-honda-x-blade.jpg'),
(38, 11, 0, 140, 'Honda CB Hornet 160R ABS', 'Honda CB Hornet 160R ABS', '<p><span style=\"color: rgb(65, 65, 65); font-size: 14px; text-align: justify;\">One is welcomed with a trapezoidal headlamp unit with twin pilot lamps smartly incorporated into it, while the vast tank and edgy fuel tank extensions deliver the motorcycle a sharp searching profile. The posterior segment is petite with split snatch rails, and the X-shaped LED tail lamp endows the&nbsp;</span><a href=\"https://www.bikebd.com/blog/honda-cb-hornet-160r-10000-km-review\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"padding: 0px; margin: 0px; outline: 0px; color: rgb(13, 110, 253); text-decoration: none; font-family: sans-serif; font-size: 14px; font-weight: 400; text-align: justify;\">Honda CB Hornet 160R</a><span style=\"color: rgb(65, 65, 65); font-size: 14px; text-align: justify;\">&nbsp;with an individual searching tail section.</span><br></p>', 'L', '160Kg', '255,000', '', 'itm-bike-675069-hornet.jpg'),
(39, 11, 0, 140, 'New Honda CBR 150R', 'New Honda CBR 150R', '<p><a href=\"https://www.bikebd.com/blog/honda-cbr-150r\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"padding: 0px; margin: 0px; outline: 0px; color: rgb(13, 110, 253); text-decoration: none; font-family: Andika, arial; font-weight: 400; text-align: justify;\"><span style=\"padding: 0px; margin: 0px; outline: 0px; font-size: 14px;\">Honda CBR 150R</span></a><span style=\"padding: 0px; margin: 0px; outline: 0px; color: rgb(51, 51, 51); font-family: Andika, arial; text-align: justify; font-size: 14px;\">&nbsp;2021 Indonesia can be considered as the most hyped sports bike of 2021. The bike’s announcement took the&nbsp;</span><a href=\"https://www.facebook.com/groups/bikebdofficial/\" rel=\"noopener noreferrer\" target=\"_blank\" style=\"padding: 0px; margin: 0px; outline: 0px; color: rgb(13, 110, 253); text-decoration: none; font-family: Andika, arial; font-weight: 400; text-align: justify;\"><span style=\"padding: 0px; margin: 0px; outline: 0px; font-size: 14px;\">biking community</span></a><span style=\"padding: 0px; margin: 0px; outline: 0px; color: rgb(51, 51, 51); font-family: Andika, arial; text-align: justify; font-size: 14px;\">&nbsp;by storm. People had been waiting anxiously for the bike. As soon as the news came out that the bike has reached Bangladeshi soil, people went bonkers. Honda CBR 150R being one of the top competitors of the sports bike segment and a serious threat to the Yamaha R15 V3 has out done itself.</span><br></p>', 'L', '155Kg', '565,000', '', 'itm-bike-563017-cbr.png'),
(40, 12, 0, 140, 'GearX X1 Aquamarine Blue - Helmet', 'GearX X1 Aquamarine Blue - Helmet', '<p>GearX X1 Aquamarine Blue - Helmet<br></p>', '12', '1.5Kg', '4900', '', 'itm-bike-524411-GearX.png'),
(41, 12, 0, 140, 'Windbreaker-Black Blue Yellow', 'Wayther Windbreaker-Versicolor-Black Blue Yellow', '<p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝐁𝐫𝐚𝐧𝐝: WAYTHER</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝗦𝘁𝘆𝗹𝗲 𝗻𝗼: JK220206</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝗗𝗲𝘀𝗶𝗻𝗴: Wayther</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝐅a𝐛𝐫𝐢𝐜: Poly Micro</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗬𝗲𝗮𝗿: Summer 2022</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝐂𝐨𝐮𝐧𝐭𝐫𝐲 𝐨𝐟 𝐎𝐫𝐢𝐠𝐢𝐧: Bangladesh</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">𝗣𝗿𝗼𝗱𝘂𝗰𝘁 𝗗𝗲𝘀𝗰𝗿𝗶𝗽𝘁𝗶𝗼𝗻.</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">The premium jacket is an incredibly windbreaker/ dust cost featuring subtle and elegant design details. Its superior quality and finish keeps you protected, comfortable and stylish in all circumstances..</p>', 'L', '100gm', '700', '', 'itm-bike-464885-windbreaker-versicolor-blac.jpg'),
(42, 12, 0, 140, 'MRF Masseter FX 90/90-17 Tyre', 'MRF Masseter FX 90/90-17 Tyre', '<p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\">Optimised stability and handling on-road, even on advanced lean angles. So you can take every twist and turn like a pro.</p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\"><span style=\"font-weight: bolder; font-size: 14.4px; background-color: var(--bs-table-bg); text-align: var(--bs-body-text-align);\">High Speed Stability</span><br></p><p style=\"padding: 0px; margin-right: 0px; margin-left: 0px; outline: 0px; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial;\"><span style=\"padding: 0px; margin: 0px; outline: 0px; font-size: 14.4px;\">Excellent directional stability, for sustained high speeds on straight-line rides.</span></p>', '100', '2KG', '3450', '', 'itm-bike-555964-Masseter.jpg'),
(43, 12, 0, 140, 'Mobil Super Moto 20W40 4T', 'Mobil Super Moto 20W40 4T', '<h2 class=\"browse-bikes-head\" style=\"padding: 0px 20px; margin-right: 0px; margin-left: 0px; outline: 0px; font-weight: 700; font-size: 24px; text-transform: capitalize; color: rgb(33, 37, 41); font-family: roboto, sans-serif, Arial; margin-bottom: 0px !important;\">Mobil Super Moto 20W40 4T Brands In Bangladesh</h2>', 'L', '1Litre', '540', '', 'itm-bike-255446-mobil-lubricating-oil.jpg'),
(44, 14, 2, 141, 'Denim Pant', 'For Men', '<p>Casual Jeans Pant For men<br></p>', 'M', '00', '950', '', 'photo-133687-1.png'),
(45, 14, 0, 141, 'Pant 1', 'Denim Pant', '', 'M', '', '800', '', 'photo-63202-12.PNG'),
(46, 14, 0, 141, 'Pant 2', 'Denim Pant', '', 'L', '', '1200', '', 'photo-698993-13.PNG'),
(47, 14, 0, 141, 'Pant 3', 'Denim Pant', '', 'M', '', '1200', '', 'photo-235078-14.PNG'),
(48, 14, 0, 141, 'Pant 4', 'Denim Pant', '', 'L', '', '950', '', 'photo-176924-15.PNG'),
(49, 17, 3, 141, 'Panjabi 1', '', '', 'M', '', '1200', '', 'photo-824608-2.PNG'),
(50, 17, 3, 141, 'Panjabi 2', 'Design Panjabi', '', 'XL', '', '1500', '', 'photo-456691-3.PNG'),
(51, 17, 3, 141, 'Panjabi 3', 'Design Panjabi', '', 'XLL', '', '1300', '', 'photo-638199-11.PNG'),
(52, 17, 3, 141, 'Panjabi 4', 'Design Panjabi', '', 'XL', '', '950', '', 'photo-406067-20.PNG'),
(53, 17, 0, 141, 'Panjabi 5', 'Design Panjabi', '', 'L', '', '800', '', 'photo-642316-21.PNG'),
(54, 17, 3, 141, 'Panjabi 6', 'Design Panjabi', '', 'XL', '', '950', '', 'photo-568079-22.PNG'),
(55, 17, 3, 141, 'Panjabi 7', 'Design Panjabi', '', 'XLL', '', '1200', '', 'photo-606006-11.PNG'),
(56, 17, 3, 141, 'Panjabi 8', 'Design Panjabi', '', 'XL', '', '1500', '', 'photo-303345-20.PNG'),
(57, 14, 3, 141, 'Pant 5', 'Men Pant', '', 'M', '', '1200', '', 'photo-20646-pant-5.PNG'),
(58, 14, 3, 141, 'Pant 6', '', '', 'L', '', '1200', '', 'photo-340116-pant-6.PNG'),
(59, 14, 3, 141, 'Pant 7', 'Men Pant', '<p>New Arrival<br></p>', 'XLL', '', '1500', '', 'photo-324562-pant-7.PNG'),
(60, 14, 3, 141, 'Pant 8', 'Men Pant', '', 'M', '', '1500', '', 'photo-724597-p-8.PNG'),
(61, 20, 3, 141, 'Belt 1', 'Original Leather Belt', '', 'M', '', '1200', '', 'photo-9284-b-1.PNG'),
(62, 20, 3, 141, 'Belt 2', 'Original Leather Belt', '', 'XLL', '', '1200', '', 'photo-370880-b-2.PNG'),
(63, 20, 3, 141, 'Belt 3', 'Original Leather Belt', '', 'XLL', '', '1200', '', 'photo-490609-b-3.PNG'),
(64, 20, 3, 141, 'Belt 4', 'Original Leather Belt', '', 'All', '', '1000', '', 'photo-248053-b-4.PNG'),
(65, 20, 3, 141, 'Belt 5', 'Original Leather Belt', '', 'All', '', '1000', '', 'photo-485408-b-5.PNG'),
(66, 20, 3, 141, 'Belt 6', 'Original Leather Belt', '', 'XLL', '', '1500', '', 'photo-240253-b-6.PNG'),
(67, 20, 3, 141, 'Belt 7', 'Original Leather Belt', '', 'All', '', '1000', '', 'photo-824637-b-7.PNG'),
(68, 20, 3, 141, 'Belt 8', 'Original Leather Belt', '', 'All', '', '1500', '', 'photo-615008-b-8.PNG'),
(69, 21, 3, 141, 'Junior\'s T-Shirt 1', '', '', 'All', '', '1000', '', 'photo-168289-7.PNG'),
(70, 21, 3, 141, 'Junior\'s T-Shirt 2', 'Junior\'s T-Shirt ', '', 'All', '', '1200', '', 'photo-107555-jt-1.PNG'),
(71, 21, 3, 141, 'Junior\'s T-Shirt 3', 'Junior\'s T-Shirt', '', 'All', '', '1200', '', 'photo-530934-jt-2.PNG'),
(72, 21, 3, 141, 'Junior\'s T-Shirt 4', '', '', 'All', '', '1000', '', 'photo-88451-jt-3.PNG'),
(73, 21, 3, 141, 'Junior\'s T-Shirt 5', 'Junior\'s T-Shirt', '', 'All', '', '1000', '', 'photo-524333-jt-4.PNG'),
(74, 21, 3, 141, 'Junior\'s T-Shirt 6', 'Junior\'s T-Shirt', '', 'All', '', '1500', '', 'photo-774087-jt-5.PNG'),
(75, 21, 3, 141, 'Junior\'s T-Shirt 7', 'Junior\'s T-Shirt', '', 'All', '', '1000', '', 'photo-781194-jt-6.PNG'),
(76, 21, 3, 141, 'Junior\'s T-Shirt 8', 'Junior\'s T-Shirt', '', 'All', '', '1200', '', 'photo-585779-jt-7.PNG'),
(77, 19, 3, 141, 'Tie 1', 'Easy Tie', '', 'All', '', '1000', '', 'photo-506104-5.PNG'),
(78, 19, 0, 141, 'Tie 2', 'Easy Tie', '', 'All', '', '1000', '', 'photo-611826-bl-1.PNG'),
(79, 19, 0, 141, 'Tie 3', 'Easy Tie', '', 'All', '', '1000', '', 'photo-53452-bl-2.PNG'),
(80, 19, 0, 141, 'Tie 4', 'Easy Tie', '', 'All', '', '1000', '', 'photo-262417-bl-3.PNG'),
(81, 19, 0, 141, 'Tie 5', 'Easy Tie', '', 'All', '', '1000', '', 'photo-573608-bl-4.PNG'),
(82, 19, 0, 141, 'Tie 6', 'Easy Tie', '', 'All', '', '1000', '', 'photo-827771-bl-5.PNG'),
(83, 19, 0, 141, 'Tie 7', 'Easy Tie', '', 'All', '', '1000', '', 'photo-687056-bl-6.PNG'),
(84, 19, 0, 141, 'Tie 8', 'Easy Tie', '', 'All', '', '1000', '', 'photo-949421-bl-7.PNG'),
(85, 15, 3, 141, 'Polo T-Shirt 1', 'Polo T-Shirt', '', 'All', '', '1200', '', 'photo-950621-ts-1.PNG'),
(86, 15, 3, 141, 'Polo T-Shirt 2', 'Polo T-Shirt', '', 'All', '', '1500', '', 'photo-327356-ts-2.PNG'),
(87, 15, 3, 141, 'Polo T-Shirt 3', 'Polo T-Shirt', '', 'All', '', '1500', '', 'photo-50874-ts-3.PNG'),
(88, 15, 3, 141, 'Polo T-Shirt 4', 'Polo T-Shirt', '', 'All', '', '1500', '', 'photo-708936-ts-4.PNG'),
(89, 15, 3, 141, 'Polo T-Shirt 5', 'Polo T-Shirt', '', 'All', '', '1500', '', 'photo-163754-ts-5.PNG'),
(90, 15, 3, 141, 'Polo T-Shirt 6', 'Polo T-Shirt', '', 'All', '', '1000', '', 'photo-932095-ts-6.PNG'),
(91, 15, 3, 141, 'Polo T-Shirt 7', 'Polo T-Shirt', '', 'All', '', '1500', '', 'photo-220631-ts-7.PNG'),
(92, 15, 0, 141, 'Polo T-Shirt 8', 'Polo T-Shirt', '<p>afasf</p>', 'All', '1', '1500', '1400', 'photo-247814-ts-8.PNG'),
(93, 13, 2, 141, 'New TT', 'Digital Waterproof sports Watch for Kids -blue', '<p>sgsdg</p>', 'L', '160Kg', '250', '300', 'photo-25798-bbtt.jpg'),
(94, 23, 4, 143, 'Kaicin 80 WG', 'Kaicin 80 WG', '<p>মাত্রা ১২০-২৪০ গ্রাম/একর।<br></p>', 'L', '200gm', '500', '450', 'photo-766829-kaisin.jpg'),
(95, 25, 5, 144, 'Champion', 'Champion', '', '50 Kg', '50 Kg', '4000', '3900', 'photo-820957-ch1.jpg'),
(97, 25, 6, 144, 'Sonali Plus', 'Sonali Plus', '', '25 Kg', '25 Kg', '2500', '2400', 'photo-804773-sn-1.jpg'),
(98, 25, 6, 144, 'Layer Premium', 'Layer Premium', '', '25 Kg', '25 Kg', '2500', '2400', 'photo-298089-layer-p.jpg'),
(99, 26, 6, 144, 'Koi Floating Premium', 'Koi Floating Premium', '<p>Koi Floating Premium<br></p>', '25 Kg', '25 Kg', '2500', '2400', 'photo-761338-koi-f-p.jpg'),
(100, 26, 6, 144, 'Pabda Gulsha', 'Pabda Gulsha', '<p>Pabda Gulsha<br></p>', '25 Kg', '25 Kg', '2500', '2400', 'photo-234901-pabda-gulsha.jpg'),
(101, 26, 6, 144, 'Telapiya Shulov', 'Telapiya Shulov', '<p>Telapiya Shulov<br></p>', '25 Kg', '25 Kg', '2500', '2400', 'photo-380211-telapiya-sulov.jpg'),
(102, 27, 6, 144, 'Gold Plus', 'Gold Plus', '<p>Gold Plus<br></p>', '25 Kg', '25 Kg', '2500', '2400', 'photo-467526-shrmp-gld.jpg'),
(103, 27, 6, 144, 'Shrimp Sundori Plus', 'Shrimp Sundori Plus', '<p>Shrimp Sundori Plus<br></p>', '25 Kg', '25 Kg', '2500', '2400', 'photo-93245-sh-sndri.jpg'),
(104, 27, 6, 144, 'Shrimp Special', 'Shrimp Special', '<p>Shrimp Special<br></p>', '25 Kg', '25 Kg', '2500', '2400', 'photo-523153-sh-sp.jpg'),
(105, 24, 6, 144, 'Dairy Premium', 'Dairy Premium', '<p>Dairy Premium<br></p>', '50 Kg', '50 Kg', '5000', '4900', 'photo-637603-dairy-pm.jpg'),
(106, 24, 6, 144, 'Dairy Performance', 'Dairy Performance', '<p>Dairy Performance<br></p>', '50 Kg', '50 Kg', '5000', '4900', 'photo-479688-dairy-perf.jpg'),
(107, 24, 6, 144, 'Dairy Classic', 'Dairy Classic', '<p>Dairy Classic<br></p>', '50 Kg', '50 Kg', '5000', '4900', 'photo-299880-dairy-clss.jpg'),
(108, 28, 6, 144, 'Quality Gold', 'Quality Gold', '<p>Quality Gold<br></p>', '5 Kg', '5 Kg', '1500', '1450', 'photo-406889-aq1.PNG'),
(109, 28, 6, 144, 'Quality Platinum', 'Quality Platinum', '<p>Quality Platinum<br></p>', '5 Kg', '5 Kg', '2000', '1950', 'photo-923389-ql-aq-pt.PNG'),
(110, 29, 6, 144, ' Aquarium Sinking', 'Aquarium Sinking', '<p>Sinking Feed for New Born Fishes</p>', '5 Kg', '5 Kg', '1500', '1450', 'photo-508814-aq1.PNG'),
(111, 30, 3, 141, 'Dron', 'fhfh fhjfjh', '<p>fxbvb grrgtykl kjhkh<br></p>', '12', '2', '4000', '3500', 'photo-221128-71rVQegxA9L._AC_SL1500_.jpg');

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

--
-- Table structure for table `product_category`
--

CREATE TABLE `product_category` (
  `cat_id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `cat_name` varchar(200) NOT NULL,
  `cat_details` varchar(200) NOT NULL,
  `link` varchar(300) NOT NULL,
  `show_colum` int(20) NOT NULL,
  `cat_photo` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_category`
--

INSERT INTO `product_category` (`cat_id`, `user_id`, `cat_name`, `cat_details`, `link`, `show_colum`, `cat_photo`) VALUES
(9, 140, 'Smart Watches', '<p><font color=\"#757575\" face=\"Roboto-Regular, Helvetica, Arial, sans-serif\"><span style=\"font-size: 14px;\">Smart Watches</span></font><br></p>', 'Na', 0, 'itm-bike-562338-watch.webp'),
(10, 140, 'Apparel', 'Apparel', 'Na', 0, '924468.jpeg'),
(11, 140, 'Motorcycle', '<p>Motorcycle<br></p>', 'Na', 0, 'itm-bike-116273-cbr.png'),
(12, 140, 'Accessories', '<p>Bike Accessories<br></p>', 'Na', 0, 'itm-bike-893332-GearX.png'),
(13, 141, 'Dress', '<p>All Kinds Of Dress</p>', 'Na', 4, 'photo-815496-dress.jpg'),
(14, 141, 'Pants', '<p>All Kinds Of Pants</p>', 'Na', 6, 'photo-354532-pant.jpg'),
(15, 141, 'Polo T-Shirt', '<p>Polo T-Shirt</p>', 'Na', 6, 'photo-543501-polo-t-shirt.jpg'),
(16, 141, 'Half Shirt', '<p>Half Shirt<br></p>', 'Na', 4, 'photo-277542-half-shirt.jpg'),
(17, 141, 'Design Panjabi', '<p>Exclusive Panjabi<br></p>', 'Na', 6, 'photo-226441-2.PNG'),
(18, 141, 'Casual Shirt', '<p>Full sleeve Shirt<br></p>', 'Na', 4, 'photo-565552-4.PNG'),
(19, 141, 'Easy Tie', 'Easy Premium Quality Tie<br>', 'Na', 6, 'photo-638501-5.PNG'),
(20, 141, 'Leather Belt', '<p>Easy Leather Belt<br></p>', 'Na', 6, 'photo-563208-6.PNG'),
(21, 141, 'Junior\'s ', '<p>Printed T-Shirt For Juniors<br></p>', 'Na', 6, 'photo-903549-7.PNG'),
(22, 141, 'Boys Shirt', '<p>Boys Casual Shirt<br></p>', 'Na', 4, 'photo-312365-10.jpg'),
(23, 143, 'কীটনাশক', '<p>কীটনাশক, মাজরা পোকা দমনের জন্য।<br></p>', 'Na', 6, 'photo-168264-kitnasok.jpg'),
(24, 144, 'Cattle Feed', 'Cattle Feed<br>', 'Na', 6, 'photo-49514-feed-cat1.jpg'),
(25, 144, 'Poultry Feed', 'Poultry Feed<br>', 'Na', 6, 'photo-96097-feed-cat2-poltry.jpg'),
(26, 144, 'Fish Feed', '<p>Fish Feed<br></p>', 'Na', 6, 'photo-238974-Pabda-Gulsha.jpg'),
(27, 144, 'Shrimp Feed', '<p>Shrimp Feed<br></p>', 'Na', 6, 'photo-754046-sh1.jpg'),
(28, 144, 'Aquarium', '<p>Aquarium<br></p>', 'Na', 6, 'photo-255257-aq1.PNG'),
(29, 144, 'Aquarium 2', '<p>Aquarium 2<br></p>', 'Na', 6, 'photo-999657-aq1.PNG'),
(30, 141, 'Dron', '<p>hdhdh dhtdh<br></p>', 'Na', 4, 'photo-228115-71rVQegxA9L._AC_SL1500_.jpg'),
(31, 141, 'Hair', '<p>hhg dhh<br></p>', 'Na', 6, 'photo-375480-The_Quiff_with_Full_Beard_360x477.jpg');

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

--
-- Table structure for table `product_type`
--

CREATE TABLE `product_type` (
  `ptype_id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `type_name` varchar(200) NOT NULL,
  `status` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_type`
--

INSERT INTO `product_type` (`ptype_id`, `user_id`, `type_name`, `status`) VALUES
(2, 141, 'Offer', '1'),
(3, 141, 'Regular', '1'),
(4, 143, 'All', '1'),
(5, 144, 'Offer', '1'),
(6, 144, 'Regular', '1');

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

--
-- Table structure for table `publish1`
--

CREATE TABLE `publish1` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `pb_title` varchar(500) NOT NULL,
  `pb_subtitle` longtext NOT NULL,
  `pb_date` date NOT NULL,
  `pb_file` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `publish1`
--

INSERT INTO `publish1` (`id`, `user_id`, `pb_title`, `pb_subtitle`, `pb_date`, `pb_file`) VALUES
(1, 140, ' Result Of Computer Science Engineering (4th Semester)', '<p><span style=\"color: rgb(82, 83, 104); font-family: &quot;Open Sans&quot;, sans-serif; font-size: 14px; background-color: rgb(243, 242, 242);\">Diploma in Engineering</span><br></p>', '2023-09-13', '');

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

--
-- Table structure for table `publish_result_routine`
--

CREATE TABLE `publish_result_routine` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `type` int(20) NOT NULL,
  `title` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL,
  `entry_date` datetime NOT NULL,
  `status` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `publish_result_routine`
--

INSERT INTO `publish_result_routine` (`id`, `user_id`, `type`, `title`, `userPic`, `entry_date`, `status`) VALUES
(33, 140, 1, 'Result Of Computer Science Engineering (4th Semester)', 'prince-894464-Institution Approval Letter.pdf', '2023-10-06 21:33:25', 1),
(34, 140, 2, 'Medical Assistant Programme 12', 'prince-1863-Fordwing Domail.pdf', '2023-10-06 21:35:20', 1),
(35, 140, 3, 'Nursing & Midwifery Programme', 'prince-588781-Dental bangla Email.pdf', '2023-10-06 21:38:54', 1);

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

--
-- Table structure for table `service`
--

CREATE TABLE `service` (
  `sv_id` int(30) NOT NULL,
  `category_id` int(11) NOT NULL,
  `user_id` int(200) NOT NULL,
  `sv_name` varchar(500) NOT NULL,
  `course_fee` varchar(100) NOT NULL,
  `duration` varchar(100) NOT NULL,
  `total_semester` varchar(100) NOT NULL,
  `sv_details` longtext NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service`
--

INSERT INTO `service` (`sv_id`, `category_id`, `user_id`, `sv_name`, `course_fee`, `duration`, `total_semester`, `sv_details`, `userPic`) VALUES
(3, 3, 140, 'Computer Science Engineering', '200000', '4-Years', '8-Semester', '<p><span style=\"font-size: 12pt;\">Computer Science Engineering encompasses studies on the design, analysis, implementation, and application of computer technology. Computing plays a vital role in all fields, including science and medicine, music and art, business, law, and human communication; hence, the study of computer science and engineering can be interdisciplinary in nature.</span></p>\r\n<p><span style=\"font-size: 12pt;\">A computer engineer is responsible for constructing and managing an organization&rsquo;s computer system and providing technical support to the organization. A computer engineer typically works in an office or laboratory environment as part of a team and enjoys a traditional work schedule. A computer engineer, who may be a software engineer, is responsible for developing, testing, and evaluating the software that enables our computer to work. They may help in the development of new computer games and business applications or even in the design of entirely new operating systems. Whether a student&rsquo;s goal is to become a computing professional, DTI is committed to helping them gain the background they need to be a world class engineer.</span></p>\r\n<p>&nbsp;</p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Objectives &amp; Outcomes:</strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">&bull;&nbsp; Provides the highest quality education so that students can cope with both undergraduate and graduate program.</span><br /><span style=\"font-size: 12pt;\">&bull; Provides state-of-the-art education.</span><br /><span style=\"font-size: 12pt;\">&bull; Establish a productive Computer Science and Engineering career in industry, academia, or government sector.</span><br /><span style=\"font-size: 12pt;\">&bull; Ensure career development in the field of computer systems engineering or software systems engineering.</span><br /><span style=\"font-size: 12pt;\">&bull; Students will be trained in such a way that they can work as a team member or be able to lead a team effectively.</span><br /><span style=\"font-size: 12pt;\">&bull; Students will learn the development of innovative systems and solutions using hardware and software</span><br /><span style=\"font-size: 12pt;\">integration.</span></p>\r\n<p>&nbsp;</p>\r\n<p><span style=\"font-size: 12pt;\"><strong>Course Outline:</strong></span></p>\r\n<div class=\"row\">\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-1</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Engineering Drawing</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Fundamental</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Application-1</span></li>\r\n<li><span style=\"font-size: 12pt;\">Basic Electricity</span></li>\r\n<li><span style=\"font-size: 12pt;\">Applied English</span></li>\r\n<li><span style=\"font-size: 12pt;\">Mathematics-1</span></li>\r\n<li><span style=\"font-size: 12pt;\">Chemistry</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-2</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Application-2</span></li>\r\n<li><span style=\"font-size: 12pt;\">Basic Electronics</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Workshop Practice</span></li>\r\n<li><span style=\"font-size: 12pt;\">Physics-1</span></li>\r\n<li><span style=\"font-size: 12pt;\">Mathematics-2</span></li>\r\n<li><span style=\"font-size: 12pt;\">Bangla</span></li>\r\n<li><span style=\"font-size: 12pt;\">Physical &amp; Life Skill Education</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-3</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Programming in C</span></li>\r\n<li><span style=\"font-size: 12pt;\">Web Design</span></li>\r\n<li><span style=\"font-size: 12pt;\">Digital Electronics-1</span></li>\r\n<li><span style=\"font-size: 12pt;\">Electrical Device &amp; Circuits</span></li>\r\n<li><span style=\"font-size: 12pt;\">Mathematics-3</span></li>\r\n<li><span style=\"font-size: 12pt;\">Physics-2</span></li>\r\n<li><span style=\"font-size: 12pt;\">Social Science</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-4</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Object Oriented Programming in C++</span></li>\r\n<li><span style=\"font-size: 12pt;\">Graphic Design</span></li>\r\n<li><span style=\"font-size: 12pt;\">Data Structure &amp; Algorithm</span></li>\r\n<li><span style=\"font-size: 12pt;\">Web Development</span></li>\r\n<li><span style=\"font-size: 12pt;\">Digital Electronics-2</span></li>\r\n<li><span style=\"font-size: 12pt;\">Electrical Machines</span></li>\r\n<li><span style=\"font-size: 12pt;\">Discrete Mathematics</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-5</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Programming in C#</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer System Software</span></li>\r\n<li><span style=\"font-size: 12pt;\">Database Management System</span></li>\r\n<li><span style=\"font-size: 12pt;\">E-commerce &amp; CMS</span></li>\r\n<li><span style=\"font-size: 12pt;\">Web Development Project</span></li>\r\n<li><span style=\"font-size: 12pt;\">Book Keeping &amp; Accounting</span></li>\r\n<li><span style=\"font-size: 12pt;\">Environmental Management</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-6</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Programming in JAVA</span></li>\r\n<li><span style=\"font-size: 12pt;\">Microprocessor &amp; Microcomputer</span></li>\r\n<li><span style=\"font-size: 12pt;\">Data Communication &amp; Computer Network</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Architecture &amp; Peripherals</span></li>\r\n<li><span style=\"font-size: 12pt;\">Database Management System Project</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Servicing &amp; Maintenance</span></li>\r\n<li><span style=\"font-size: 12pt;\">Industrial Management</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-7</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Embedded System &amp; PLC</span></li>\r\n<li><span style=\"font-size: 12pt;\">Mobile Apps Development</span></li>\r\n<li><span style=\"font-size: 12pt;\">Network Administration &amp; Management</span></li>\r\n<li><span style=\"font-size: 12pt;\">Digital Marketing Technology</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Engineering Project</span></li>\r\n<li><span style=\"font-size: 12pt;\">Information Management and Security</span></li>\r\n<li><span style=\"font-size: 12pt;\">Entrepreneurship</span></li>\r\n<li><span style=\"font-size: 12pt;\">Electrical Engineering Project</span></li>\r\n</ul>\r\n</div>\r\n<div class=\"col-md-3\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\"><strong>SEMESTER-8</strong></span></li>\r\n<li><span style=\"font-size: 12pt;\">Industrial Training</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n<p>&nbsp;</p>', 'prince-558033-diploma-computer.jpg');
INSERT INTO `service` (`sv_id`, `category_id`, `user_id`, `sv_name`, `course_fee`, `duration`, `total_semester`, `sv_details`, `userPic`) VALUES
(4, 3, 140, 'Diploma in Civil Engineering', '', '', '', '<p><span style=\"font-size: 12pt;\"><strong>A Diploma in Civil Engineering</strong> program can be a good choice for your career. An important branch of modern engineering &amp; technology is civil engineering, the main subject of which is planning, design, and structural execution. These include various challenging facilities including public works design supervision and construction activities like roads, bridges, tunnels, buildings, airports, dams, sewerage systems, ports, etc.</span></p>\r\n<p><span style=\"font-size: 12pt;\">A Civil Engineer is essential for the planning/implementation and maintenance of the project. We called him a civil engineer who has a degree Diploma in Civil Engineering in order to acquire engineering knowledge as well as administrative skills. They can establish themselves in the positions of site engineer/manager, design, research, education, etc., at various construction sites, both public and private. They also have the opportunity to work as Deputy Assistant Engineers in various government, semi-government and autonomous organizations. Possibly LGED, PWD, R&amp;H, BR, BBA, MES, EED, WASA, DESCO, DPDC, WDB, BADC, Bangladesh Airlines, Telecom Industry, and various public and private housing and development projects.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><img style=\"display: block; margin-left: auto; margin-right: auto;\" src=\"data:image/jpeg;base64,[BLOB]\" /></span></p>\r\n<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-e17d8ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e17d8ca\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-row\">\r\n<div class=\"aux-parallax-section elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-700acd5\" data-id=\"700acd5\" data-element_type=\"column\">\r\n<div class=\"elementor-column-wrap elementor-element-populated\">\r\n<div class=\"elementor-widget-wrap\">\r\n<div class=\"elementor-element elementor-element-ea6020f elementor-widget elementor-widget-heading\" data-id=\"ea6020f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\r\n<div class=\"elementor-widget-container\">\r\n<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 12pt;\">Career Prospects</span></h3>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-d75c709 elementor-widget elementor-widget-text-editor\" data-id=\"d75c709\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"elementor-text-editor elementor-clearfix\"><span style=\"font-size: 12pt;\">Diploma in Civil Engineering is a 4-year long program consisting of 8 semesters (1 Semester = 6 months). The final and the midterm exams of each semester is conducted under the supervision of Bangladesh Technical Education Board (BTEB). All the exams question, answer script checking and final results are published by the <a href=\"http://www.bteb.gov.bd/\" target=\"_blank\" rel=\"nofollow noopener\">BTEB</a>. Besides this, each student has to attend the regular class test, quiz test, and semester final project. After the successful completion, a student will receive a Diploma in&nbsp;<a href=\"https://en.wikipedia.org/wiki/Civil_engineering\" target=\"_blank\" rel=\"noopener\">civil engineering</a>&nbsp;certificate from BTEB.</span></div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-6d3e88a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6d3e88a\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-row\">\r\n<div class=\"aux-parallax-section elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-9ddbe64\" data-id=\"9ddbe64\" data-element_type=\"column\">\r\n<div class=\"elementor-column-wrap elementor-element-populated\">\r\n<div class=\"elementor-widget-wrap\">\r\n<div class=\"elementor-element elementor-element-045a41e elementor-widget elementor-widget-heading\" data-id=\"045a41e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\r\n<div class=\"elementor-widget-container\">\r\n<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 12pt;\">Career Path</span></h3>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-cf792ea elementor-widget elementor-widget-text-editor\" data-id=\"cf792ea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"elementor-text-editor elementor-clearfix\">\r\n<p><span style=\"font-size: 12pt;\">As a qualified civil engineer you can find work in a range of sectors, particularly in the construction sector, on buildings and large structures of all kinds, transport and communications infrastructure. You can also work for employers involved in the production, storage and distribution of electricity, gas and water.</span></p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-c4e0c41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c4e0c41\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-row\">\r\n<div class=\"aux-parallax-section elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-832bef1\" data-id=\"832bef1\" data-element_type=\"column\">\r\n<div class=\"elementor-column-wrap elementor-element-populated\">\r\n<div class=\"elementor-widget-wrap\">\r\n<div class=\"elementor-element elementor-element-f56c896 elementor-widget elementor-widget-heading\" data-id=\"f56c896\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\r\n<div class=\"elementor-widget-container\">\r\n<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 12pt;\">Admission Eligibility</span></h3>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-f6b1970 elementor-widget elementor-widget-text-editor\" data-id=\"f6b1970\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"elementor-text-editor elementor-clearfix\">\r\n<p><span style=\"font-size: 12pt;\">Minimum SSC equivalent from any discipline with minimum GPA: 2.00 .</span></p>\r\n<p><span style=\"font-size: 12pt;\">HSC (Science) Students can directly join in 3rd Semester</span><br /><span style=\"font-size: 12pt;\">&amp; HSC (Vocational) students can directly join in 4th Semester.( Passing year 2011, GPA: 2.00 )</span></p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-bacecb7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bacecb7\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-row\">\r\n<div class=\"aux-parallax-section elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-c5e2651\" data-id=\"c5e2651\" data-element_type=\"column\">\r\n<div class=\"elementor-column-wrap elementor-element-populated\">\r\n<div class=\"elementor-widget-wrap\">\r\n<div class=\"elementor-element elementor-element-d298675 elementor-widget elementor-widget-heading\" data-id=\"d298675\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\r\n<div class=\"elementor-widget-container\">\r\n<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 12pt;\">Admission Guidelines</span></h3>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-4a4c1cb elementor-widget elementor-widget-text-editor\" data-id=\"4a4c1cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"elementor-text-editor elementor-clearfix\">\r\n<p><span style=\"font-size: 12pt;\">Students are advice to collect admission form the admission office.</span></p>\r\n<p><span style=\"font-size: 12pt;\">To confirm the admission, students must submit</span></p>\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\">4 copy of recent PP size photo</span></li>\r\n<li><span style=\"font-size: 12pt;\">Main copy of SSC transcript&nbsp;</span></li>\r\n<li><span style=\"font-size: 12pt;\">Photocopy of Parent&rsquo;s NID Card.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Along with the properly filled admission form.</span></li>\r\n<li><span style=\"font-size: 12pt;\"><strong>NOTE: Students will be admitted for the limited </strong><strong>seats.</strong></span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5d79718 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d79718\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-row\">\r\n<div class=\"aux-parallax-section elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-7e3cf4d\" data-id=\"7e3cf4d\" data-element_type=\"column\">\r\n<div class=\"elementor-column-wrap elementor-element-populated\">\r\n<div class=\"elementor-widget-wrap\">\r\n<div class=\"elementor-element elementor-element-a3f1a70 elementor-widget elementor-widget-heading\" data-id=\"a3f1a70\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\r\n<div class=\"elementor-widget-container\">\r\n<h3 class=\"elementor-heading-title elementor-size-default\"><span style=\"font-size: 12pt;\">&nbsp;Lab Facilities</span></h3>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-45b5ef3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"45b5ef3\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-row\">\r\n<div class=\"aux-parallax-section elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-2d5ee79\" data-id=\"2d5ee79\" data-element_type=\"column\">\r\n<div class=\"elementor-column-wrap elementor-element-populated\">\r\n<div class=\"elementor-widget-wrap\">\r\n<div class=\"elementor-element elementor-element-20add89 elementor-widget elementor-widget-text-editor\" data-id=\"20add89\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"elementor-text-editor elementor-clearfix\">\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\">Construction Lab</span></li>\r\n<li><span style=\"font-size: 12pt;\">Surveying Lab</span></li>\r\n<li><span style=\"font-size: 12pt;\">Computer Lab</span></li>\r\n<li><span style=\"font-size: 12pt;\">Hydraulics Lab</span></li>\r\n<li><span style=\"font-size: 12pt;\">Geotechnical Lab</span></li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>', 'prince-882505-diploma-in-civil-engineering.jpg');
INSERT INTO `service` (`sv_id`, `category_id`, `user_id`, `sv_name`, `course_fee`, `duration`, `total_semester`, `sv_details`, `userPic`) VALUES
(5, 6, 140, 'Diploma In Nursing Science And Midwifery', '', '', '', '<p><span style=\"font-size: 12pt;\">The applicant who meets the following criteria will be eligible to enter into the <strong>Diploma in nursing Science and Midwifery</strong> course.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong> 1. <u>Eligibility of admission for the Local students</u></strong></span></p>\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\">The applicant must be the citizen of Bangladesh.</span></li>\r\n<li><span style=\"font-size: 12pt;\">The applicants have to be passed both SSC and HSC or equivalent examinations from any group in total CGPA 6.00 with at least GPA 2.50 either SSC or HSC or equivalent examination.</span></li>\r\n<li><span style=\"font-size: 12pt;\">The applicant should apply within 02 (Two) years of passing HSC or equivalent Examination following SSC or equivalent examination as continual.</span></li>\r\n<li><span style=\"font-size: 12pt;\"><strong>Applicant must be seated for the admission test examination arranged by BNC and have to get at least 40% marks.</strong></span></li>\r\n</ul>\r\n<p><span style=\"font-size: 12pt;\"><strong>2. <u>Eligibility of admission for the Foreign Students</u></strong></span></p>\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\">The applicants must need Cumulative Grading Point Average(CGPA) both O&rsquo;level and A&rsquo;level or equivalent examinations from any group in total 6.00 but not less than CGPA 2.50 in either O&rsquo;level or A&rsquo;level examination.</span></li>\r\n<li><span style=\"font-size: 12pt;\">The applicant should apply within 02 (Two) years of passing A&rsquo;level or equivalent Examination following O&rsquo;level or equivalent examination as continual.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Students who meet up mentioned criteria above, they will get the opportunity to study in any non-government nursing college in Bangladesh. One-third of total seat will reserve for foreign students. If not found, Bangladeshi students can be admitted with the vacant seats.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Foreign students must be attested their application form, O&rsquo;level and A&rsquo;level or equivalent certificate and transcript by their Ministry of Foreign Affairs through Bangladesh embassy and submitted to the Ministry of Foreign Affairs of Bangladesh in time. Ministry of Foreign Affairs will send it to Director General, Nursing and Midwifery council. With permission of the Health education and family welfare division, Bangladesh Nursing and Midwifery council will take necessary steps to equalize marks and others criteria. Ministry of Foreign Affairs will permit to admit with mark equalize report from the Council.</span></li>\r\n</ul>\r\n<p><span style=\"font-size: 12pt;\"><strong>3. <u>Student Registration:</u></strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">Students have to be registered after admission as per BNMC rules and regulation.</span></p>\r\n<p><span style=\"font-size: 12pt;\"><strong>4. <u>Medical Fitness:</u></strong></span></p>\r\n<p><span style=\"font-size: 12pt;\">Successful candidate must be performed medical fitness check-up before admission.</span></p>', 'prince-416688-Diploma-in-Nursing-Science-and-Midwifery.jpg'),
(6, 5, 140, 'Diploma in Medical Assistant', '', '', '', '<div class=\"elementor-element elementor-element-66ecc47 elementor-widget elementor-widget-wd_text_block\" data-id=\"66ecc47\" data-element_type=\"widget\" data-widget_type=\"wd_text_block.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"wd-text-block reset-last-child text-left\">\r\n<div class=\"wpb_text_column wpb_content_element\">\r\n<div class=\"wpb_wrapper\">\r\n<div class=\"wpb_text_column wpb_content_element\">\r\n<div class=\"wpb_wrapper\">\r\n<p><span style=\"font-size: 12pt;\">The Diploma in Medical Assistant (DMA) course is a two-year program that provides students with theoretical and practical knowledge in various areas of healthcare. The curriculum of the course includes the following subjects:</span></p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-af38de1 elementor-widget elementor-widget-wd_infobox\" data-id=\"af38de1\" data-element_type=\"widget\" data-widget_type=\"wd_infobox.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"info-box-wrapper\">\r\n<div class=\"wd-info-box text-left box-icon-align-top box-style-base color-scheme- cursor-pointer\">\r\n<div class=\"info-box-content\">\r\n<h4 class=\"info-box-title title box-title-style-default wd-fontsize-s\" data-elementor-setting-key=\"title\"><span style=\"font-size: 12pt;\">Diploma in Medical Assistant (DMA):</span></h4>\r\n<div class=\"info-box-inner set-cont-mb-s reset-last-child\" data-elementor-setting-key=\"content\">\r\n<ol>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Anatomy and Physiology: This subject covers the study of the human body\'s structure and functions.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Medical Terminology: This subject covers the study of medical terms and vocabulary used in the healthcare industry.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Medical Ethics and Law: This subject covers the ethical and legal aspects of healthcare practice.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Pharmacology: This subject covers the study of drugs and their effects on the human body.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Clinical Procedures: This subject covers various clinical procedures such as taking vital signs, collecting samples, and administering medications.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Medical Office Management: This subject covers the management and administration of medical offices, including scheduling appointments, maintaining records, and managing finances.</span></p>\r\n</li>\r\n</ol>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-f0627db elementor-widget elementor-widget-wd_infobox\" data-id=\"f0627db\" data-element_type=\"widget\" data-widget_type=\"wd_infobox.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"info-box-wrapper\">\r\n<div class=\"wd-info-box text-left box-icon-align-top box-style-base color-scheme- cursor-pointer\">\r\n<div class=\"info-box-content\">\r\n<h4 class=\"info-box-title title box-title-style-default wd-fontsize-s\" data-elementor-setting-key=\"title\"><span style=\"font-size: 12pt;\">Benefits of Diploma in Medical Assistant (DMA) Course:</span></h4>\r\n<div class=\"info-box-inner set-cont-mb-s reset-last-child\" data-elementor-setting-key=\"content\">\r\n<ol>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Job Opportunities: Graduates of the Diploma in Medical Assistant (DMA) course have a wide range of job opportunities in various healthcare facilities, including hospitals, clinics, and private practices.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Competitive Salary: Medical assistants are in high demand, and they receive a competitive salary.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Professional Development: The Diploma in Medical Assistant (DMA) course provides students with the knowledge and skills needed to pursue further education and professional development in the healthcare industry.</span></p>\r\n</li>\r\n<li>\r\n<p><span style=\"font-size: 12pt;\">Job Satisfaction: Medical assistants play a crucial role in the healthcare industry and have a significant impact on patients\' lives. This can provide a sense of job satisfaction and fulfillment.</span></p>\r\n</li>\r\n</ol>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"elementor-element elementor-element-08dea7a elementor-widget elementor-widget-wd_text_block\" data-id=\"08dea7a\" data-element_type=\"widget\" data-widget_type=\"wd_text_block.default\">\r\n<div class=\"elementor-widget-container\">\r\n<div class=\"wd-text-block reset-last-child text-left\">\r\n<p><span style=\"font-size: 12pt;\"><strong>Conclusion</strong></span></p>\r\n<blockquote>\r\n<p><span style=\"font-size: 12pt;\">The Diploma in Medical Assistant (DMA) course is an excellent program for individuals who aspire to work in the healthcare industry. The course provides comprehensive training in various areas of healthcare, including clinical procedures, medical office management, and pharmacology. Graduates of the program have excellent job opportunities, receive competitive salaries, and can pursue further education and professional development in the healthcare industry.</span></p>\r\n</blockquote>\r\n</div>\r\n</div>\r\n</div>', 'prince-578263-medical-assist-diploma.jpg'),
(7, 4, 140, 'Diploma in Medical Technology', '150000', '3-Years', '12-Semester', '<div class=\"elementor elementor-2706 elementor-bc-flex-widget\" data-elementor-type=\"wp-post\" data-elementor-id=\"2706\">\r\n<section class=\"elementor-section elementor-top-section elementor-element elementor-element-61bb93c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"61bb93c\" data-element_type=\"section\">\r\n<div class=\"elementor-container elementor-column-gap-default\">\r\n<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-61bbe22\" data-id=\"61bbe22\" data-element_type=\"column\">\r\n<div class=\"elementor-widget-wrap elementor-element-populated\">\r\n<div class=\"elementor-element elementor-element-61bc1e8 elementor-widget elementor-widget-text-editor\" data-id=\"61bc1e8\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\r\n<div class=\"elementor-widget-container\">\r\n<p><span style=\"font-size: 12pt;\">A <strong>Medical laboratory </strong> or <strong> Clinical laboratory </strong>&nbsp;is a&nbsp;laboratory&nbsp;where&nbsp;clinical pathology&nbsp;tests are carried out on clinical specimens to obtain information about the&nbsp;health&nbsp;of a&nbsp;patient to aid in diagnosis, treatment, and prevention of disease. Clinical Medical laboratories are an example of&nbsp;applied science, as opposed to&nbsp;research laboratories&nbsp;that focus on&nbsp;basic science, such as found in some&nbsp;academic&nbsp;institutions.</span></p>\r\n<p><span style=\"font-size: 12pt;\">Medical laboratories vary in size and complexity and so offer a variety of testing services. More comprehensive services can be found in acute-care hospitals and medical centers, where 70% of clinical decisions are based on laboratory testing.<sup id=\"cite_ref-2\" class=\"reference\"></sup>Doctors offices and clinics, as well as skilled nursing and long-term care facilities, may have laboratories that provide more basic testing services. Commercial medical laboratories operate as independent businesses and provide testing that is otherwise not provided in other settings due to low test volume or complexity.</span></p>\r\n<h2><span id=\"Departments\" class=\"mw-headline\" style=\"font-size: 12pt;\">Departments</span></h2>\r\n<p><span style=\"font-size: 12pt;\">In hospitals and other patient-care settings, laboratory medicine is provided by the Department of Pathology, and generally divided into two sections, each of which will be subdivided into multiple specialty areas. The two sections are:</span></p>\r\n<ul>\r\n<li><span style=\"font-size: 12pt;\">Anatomic pathology: areas included here are&nbsp;histopathology,&nbsp;cytopathology, and&nbsp;electron microscopy.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Clinical pathology, which typically includes the following areas:</span></li>\r\n<li><span style=\"font-size: 12pt;\">Clinical Microbiology: This encompasses several different sciences, including&nbsp;bacteriology,&nbsp;virology,&nbsp;parasitology,&nbsp;immunology, and&nbsp;mycology.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Clinical Chemistry: This area typically includes automated analysis of blood specimens, including tests related to&nbsp;enzymology,&nbsp;toxicology&nbsp;and&nbsp;endocrinology.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Hematology: This area includes automated and manual analysis of blood cells. It also often includes&nbsp;coagulation.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Blood Bank&nbsp;involves the testing of blood specimens in order to provide blood transfusion and related services.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Molecular diagnostics&nbsp;DNA testing may be done here, along with a subspecialty known as&nbsp;cytogenetics.</span></li>\r\n<li><span style=\"font-size: 12pt;\">Reproductive biology&nbsp;testing is available in some laboratories, including&nbsp;Semen analysis,&nbsp;Sperm bank&nbsp;and&nbsp;assisted reproductive technology.</span></li>\r\n</ul>\r\n<p><span style=\"font-size: 12pt;\">Layouts of clinical laboratories in health institutions vary greatly from one facility to another. For instance, some health facilities have a single laboratory for the microbiology section, while others have a separate lab for each specialty area.</span></p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</section>\r\n</div>', 'prince-977468-diploma-in-medi-technology.jpg'),
(8, 3, 140, 'Power', '150000', '8-Semester', '4-Years', '<p>Power Tec</p>', 'prince-580425-exam-mcq.jpg');

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

--
-- Table structure for table `service_category`
--

CREATE TABLE `service_category` (
  `cat_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `cat_name` varchar(500) DEFAULT NULL,
  `cat_details` longtext DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  `cat_photo` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_category`
--

INSERT INTO `service_category` (`cat_id`, `user_id`, `cat_name`, `cat_details`, `link`, `cat_photo`) VALUES
(3, 140, 'Diploma in Engineering', '<p><span style=\"font-size: 12pt;\">Computer Science Engineering encompasses studies on the design, analysis, implementation, and application of computer technology. Computing plays a vital role in all fields, including science and medicine, music and art, business, law, and human communication; hence, the study of computer science and engineering can be interdisciplinary in nature.</span></p>', 'diploma-engineering', 'prince-866726-diploma-eng.jpeg'),
(4, 140, 'Diploma in Medical Technology', '<p><span style=\"font-size: 12pt;\">Diploma in Medical Programmed</span></p>', 'medical-diploma', 'prince-356169-Diploma-in-Medical.png'),
(5, 140, 'Diploma in Medical Assistant', '<p><span style=\"font-size: 12pt;\">Diploma in Medical Assistant Programmed</span></p>', 'medical-assistant', 'prince-104741-Diploma-in-Medical.png'),
(6, 140, 'Diploma in Nursing & Midwifery', '<p><span style=\"font-size: 12pt;\">Diploma in Nursing &amp; Midwifery</span></p>', 'diploma-nursing', 'prince-353940-Diploma-in-Nursing-Science-and-Midwifery.jpg');

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

--
-- Table structure for table `skill_section`
--

CREATE TABLE `skill_section` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `percent` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `skill_section`
--

INSERT INTO `skill_section` (`id`, `user_id`, `name`, `percent`) VALUES
(6, 130, 'Web Development', '80%'),
(7, 130, 'Adobe', '60%'),
(67, 130, 'Microsoft Office', '70%');

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

--
-- Table structure for table `slider_info`
--

CREATE TABLE `slider_info` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `sub_title` varchar(255) DEFAULT NULL,
  `link1` varchar(255) DEFAULT NULL,
  `link2` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider_info`
--

INSERT INTO `slider_info` (`id`, `title`, `sub_title`, `link1`, `link2`) VALUES
(1, 'Moto Craze', 'Moto Craze 4S Center, The most popular official Honda motorbike 4S facility in Tongi area.', '#', '#');

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

--
-- Table structure for table `slider_section`
--

CREATE TABLE `slider_section` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `slider_title` varchar(200) NOT NULL,
  `slider_subtitle` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider_section`
--

INSERT INTO `slider_section` (`id`, `user_id`, `slider_title`, `slider_subtitle`, `userPic`) VALUES
(1, 140, 'Welcome To ITM SHOP', 'A Better Name Of ITM SHOP', 'photo-itm-23938-carousel-1.jpg'),
(2, 140, 'Welcome To ITM SHOP', 'A Better Name Of ITM SHOP', 'photo-itm-182885-carousel-2.jpg'),
(3, 140, 'Welcome To ITM SHOP', 'A Better Name Of ITM SHOP', 'photo-itm-470303-ppapple.jpg'),
(9, 141, 'Welcome To ITM Fashion', 'Welcome To ITM Fashion', 'photo-452088-b1.png'),
(10, 141, 'Welcome To ITM Fashion', 'Welcome To ITM Fashion', 'photo-891072-b2.jpg'),
(11, 141, 'Welcome To ITM Fashion', 'Welcome To ITM Fashion', 'photo-310188-b33.jpg'),
(12, 143, 'Welcome To Swazis', 'Welcome To Swazis', 'photo-684678-swazis-limia-slider2.jpg'),
(13, 143, 'Lalmia 2-EC', 'Lalmia 2-EC', 'photo-127951-swazis-limia-slider2.jpg'),
(14, 143, 'Zoar', 'Zoar', 'photo-162043-zoar-slider-swazis.jpg'),
(15, 142, 'Welcome To ITM  Cattle Farm', 'Welcome To ITM  Cattle Farm', 'photo-806209-cow-ba.jpg'),
(16, 144, 'Welcome To Agro Feed', 'Welcome To Agro Feed', 'photo-221475-slide2.jpg'),
(17, 144, 'Welcome To Agro Feed', 'Welcome To Agro Feed', 'photo-207024-slide11.jpg'),
(18, 144, 'Welcome To Agro Feed', 'Welcome To Agro Feed', 'photo-157417-slide12.jpg'),
(19, 145, 'Welcome To Auto Rice Mill', 'Welcome To Auto Rice Mill', 'photo-99175-slider1.jpeg'),
(20, 145, 'Welcome To Auto Rice Mill', 'Welcome To Auto Rice Mill', 'photo-595837-slider2.jpg'),
(21, 145, 'Welcome To Auto Rice Mill', 'Welcome To Auto Rice Mill', 'photo-645292-slider3.jpg');

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

--
-- Table structure for table `social_media`
--

CREATE TABLE `social_media` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `facebook` varchar(100) NOT NULL,
  `twitter` varchar(100) NOT NULL,
  `youtube` varchar(100) NOT NULL,
  `instagram` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `social_media`
--

INSERT INTO `social_media` (`id`, `user_id`, `facebook`, `twitter`, `youtube`, `instagram`) VALUES
(15, 140, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(16, 141, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(17, 142, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(18, 143, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(19, 144, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(20, 145, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(21, 146, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(22, 147, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(23, 148, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(24, 149, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/'),
(25, 150, 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/', 'https://www.facebook.com/princeedubd/');

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

--
-- Table structure for table `stats`
--

CREATE TABLE `stats` (
  `st_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `st_name` varchar(300) NOT NULL,
  `st_num` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `stats`
--

INSERT INTO `stats` (`st_id`, `user_id`, `st_name`, `st_num`) VALUES
(1, 140, 'Teachers', '27'),
(2, 140, 'Courses', '30'),
(3, 140, 'Students', '2000'),
(4, 140, 'Awards Achieved', '20');

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

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `student_id` int(150) NOT NULL,
  `user_id` int(50) NOT NULL,
  `student_no` int(50) NOT NULL,
  `batch_no` varchar(250) NOT NULL,
  `course_name` varchar(200) NOT NULL,
  `student_name` varchar(250) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `bld_grp` varchar(50) NOT NULL,
  `father_name` varchar(250) NOT NULL,
  `mother_name` varchar(250) NOT NULL,
  `pre_vill` varchar(300) NOT NULL,
  `pre_post` varchar(200) NOT NULL,
  `pre_upazila` varchar(150) NOT NULL,
  `pre_dist` varchar(150) NOT NULL,
  `par_vill` varchar(150) NOT NULL,
  `par_post` varchar(150) NOT NULL,
  `par_upazila` varchar(150) NOT NULL,
  `par_dist` varchar(150) NOT NULL,
  `marriage_info` varchar(150) NOT NULL,
  `religion` varchar(150) NOT NULL,
  `nationality` varchar(150) NOT NULL,
  `birth_date` date NOT NULL,
  `student_phone` varchar(150) NOT NULL,
  `student_email` varchar(150) NOT NULL,
  `guardian_phone` varchar(150) NOT NULL,
  `degree` varchar(150) NOT NULL,
  `institute_name` varchar(250) NOT NULL,
  `board_roll` varchar(100) NOT NULL,
  `pass_year` varchar(100) NOT NULL,
  `gpa` varchar(100) NOT NULL,
  `board_name` varchar(200) NOT NULL,
  `reference` varchar(350) NOT NULL,
  `join_date` date NOT NULL,
  `status` int(10) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `students`
--

INSERT INTO `students` (`student_id`, `user_id`, `student_no`, `batch_no`, `course_name`, `student_name`, `gender`, `bld_grp`, `father_name`, `mother_name`, `pre_vill`, `pre_post`, `pre_upazila`, `pre_dist`, `par_vill`, `par_post`, `par_upazila`, `par_dist`, `marriage_info`, `religion`, `nationality`, `birth_date`, `student_phone`, `student_email`, `guardian_phone`, `degree`, `institute_name`, `board_roll`, `pass_year`, `gpa`, `board_name`, `reference`, `join_date`, `status`, `userPic`) VALUES
(101, 130, 2, 'Md.Samiul Alom', '', 'Managing Director', 'Male', '', 'Tinmatha', '01751458998', 'samiulbdb@gmail.com', '000', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2020-02-05', 1, '182825.jpg'),
(103, 130, 3, 'New Customer', '', '', 'Male', '', 'Bogura', '01751456623', '', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2020-08-05', 1, '637900.jpg'),
(104, 130, 4, 'Zobayer2', '', '', 'Male', '', 'Meghai', '01611-717527', '', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2020-08-10', 1, '344615.jpg'),
(105, 135, 5, 'Kiron Alom', '', '', 'Male', '', 'Dhaka', '01751894256', '', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-01-30', 1, '470799.jpg'),
(106, 136, 6, 'Talha Khan', '', '', 'Male', '', 'Dhaka', '054654', '', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-01-31', 1, '911154.'),
(107, 135, 7, 'Rubel Hossain', '', '', 'Male', '', 'Dhaka', '00154545', '', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-02-01', 1, '448091.'),
(108, 135, 8, 'Bappi Hasan', '', 'Marketing Officer1', 'Male', '', 'Mirpur-12, Dhaka', '017589', 'bapp1@gmail.com', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-02-01', 1, '450629.jpg'),
(109, 137, 9, 'Jhon doe', '', 'Managing director', 'Male', '', 'New York City, USA', '846446456', 'jhondoe@gmail.com', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-02-03', 1, '428090.'),
(110, 137, 10, 'Samiul Alom', '', 'CEO', 'Male', '', 'Bogura', '01751891037', 'samiulbdb\"gmail.com', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-02-23', 1, '548913.'),
(111, 140, 1, 'Sidgao', '1', 'Interney Marketing', '', '', 'USA', '3232323232', 'tausif@sidago.com', '232323', 'Gaibhandha', 'Gaibhandha', 'rr', 'rr', 'Gaibhandha', 'Gaibhandha', 'Yes', 'Muslim', 'Other', '0000-00-00', 'r', 'rr', 'rr', 'JSC', 'rr', 'rr', 'rr', 'r', 'r', 'rr', '2022-03-18', 1, '540258.'),
(112, 137, 11, 'Kalam', '', 'Business', 'Male', '', 'Bizrul', '01751-895247', 'kalam@gmail.com', '00', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '', '', '', '', '', '', '', '', '', '2022-03-20', 1, '294341.'),
(113, 140, 2, 'Batch-25', 'Office Application', 'Md.Salam Ali', 'Male', '', 'Md.Abbas', 'Mrs.Salma', 'Model village', 'Model Para', 'Gaibhandha', 'Gaibhandha', 'Model village1', 'Model Para1', 'Gaibhandha', 'Gaibhandha', 'Yes', 'Muslim', 'Bangladeshi', '2022-04-01', '01751891037', 'salam@gmail.com', '0198798646', 'JDC', 'GG College', '1256', '2011', '4.20', 'Ranpur', 'Kalam Ali', '2022-04-01', 1, 'itm-dtc-'),
(114, 140, 3, 'Batch-25', '1', 'Md.Jamal Sheakh1', '', '', 'Jalal Sheakh1', 'Jomila Sheakh1', 'Pal Para1', 'Gator', 'Sadullapur', 'Gaibhandha', 'Pal Para', 'Gator', 'Sadullapur', 'Gaibhandha', 'No', 'Hindu', 'Bangladeshi', '2022-04-02', '01751891999', 'jamal@gmail.com', '0198798145', 'JSC', 'BAM Scjool', '8541', '2016', '4.35', '4.35', 'Kazul PP', '2022-04-02', 1, 'itm-dtc-'),
(115, 137, 0, 'Batch-25', '1', 'Salam', '', '', 'father', 'mother', 'chota shoula', 'asfdas', 'Gaibhandha', 'Gaibhandha', 'chota shoula', 'sadf', 'Gaibhandha', 'Gaibhandha', 'Yes', 'Muslim', 'Bangladeshi', '2022-06-01', '54654', 'mahmud@gmail.com', '54', 'JSC', 'asdf', '545', '2022', '5', '5', 'peon', '2022-06-01', 1, 'itm-dtc-'),
(116, 140, 4, 'Batch-25', '1', 'Aa', '', '', 'as', 'as', 'sa', 's', 'Gaibhandha', 'Gaibhandha', 'a', 'a', 'Gaibhandha', 'Gaibhandha', 'Yes', 'Muslim', 'Bangladeshi', '2023-04-15', 'a', 'jabed@gmail.com', 'as', 'JSC', 'saa', '45', '2023', '5', '5', 'qw', '2023-04-15', 1, '941721.jpg'),
(117, 22, 12, '1', '26', 'Jamal', 'Male', 'A+', 'ff', 'mm', 'Dhaka', 'Dhaka1', '#', '#', 'sg', 'pp', '#', '#', 'Yes', 'Muslim', 'Bangladeshi', '2023-05-02', '848465', 'jabed@gmail.com', 'fgjd', '#', 'dh', 'dh', 'dh', 'dh', '#', 'dh', '2023-05-02', 1, 'itm-dtc-'),
(118, 22, 13, '2', '25', 'Abdul Alim', 'Male', 'A+', 'Father', 'Mother', 'Atibazar', 'Atibazar1', '2', '2', 'Atibazar', 'Atibazar', '2', '2', 'Yes', 'Muslim', 'Bangladeshi', '2023-05-04', '098798798', 'jabed@gmail.com', '098798798', '2', 'Dhaka Model College', '2566', '2022', '5.00', '3', 'SAD', '2023-05-04', 1, 'itm-dtc-');

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

--
-- Table structure for table `stuff`
--

CREATE TABLE `stuff` (
  `userid` int(11) NOT NULL,
  `stuff_name` varchar(50) NOT NULL,
  `position` varchar(500) NOT NULL,
  `contact_info` varchar(50) NOT NULL,
  `business_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `business_details` varchar(250) NOT NULL,
  `service_charge` varchar(250) NOT NULL,
  `business_phone` varchar(100) NOT NULL,
  `business_email` varchar(250) NOT NULL,
  `biz_web` varchar(200) NOT NULL,
  `business_address` varchar(500) NOT NULL,
  `invoice_welcome` varchar(500) NOT NULL,
  `photo` varchar(150) NOT NULL,
  `sign_img` text NOT NULL,
  `join_date` date NOT NULL,
  `status` int(20) NOT NULL,
  `software_status` int(150) NOT NULL,
  `comments` varchar(500) NOT NULL,
  `division_id` int(150) NOT NULL,
  `district_id` int(150) NOT NULL,
  `upazila_id` int(150) NOT NULL,
  `inv_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `stuff`
--

INSERT INTO `stuff` (`userid`, `stuff_name`, `position`, `contact_info`, `business_name`, `business_details`, `service_charge`, `business_phone`, `business_email`, `biz_web`, `business_address`, `invoice_welcome`, `photo`, `sign_img`, `join_date`, `status`, `software_status`, `comments`, `division_id`, `district_id`, `upazila_id`, `inv_name`) VALUES
(22, 'Admin', 'Admin', 'Admin', '', '', '', '', '', '', '', '', '212', '', '2020-03-22', 0, 0, '', 0, 0, 0, ''),
(130, 'Samiul ITM', 'CEO', '01751891037', 'ITM Computer & Tech Gadget', '', '', '01751891037', 'samiulbdb@gmail.com', '', 'Bogura City, Bogura', '', 'upload/com-logo_1643530916.jpg', '', '2019-07-10', 1, 0, '', 0, 0, 0, ''),
(131, 'romel', 'Show Room 2', '01746895819', '', '', '', '', '', '', '', '', '', '', '0000-00-00', 1, 0, '', 0, 0, 0, ''),
(132, 'FARUK', 'Collection', '01742078781', '', '', '', '', '', '', '', '', '', '', '0000-00-00', 1, 0, '', 0, 0, 0, ''),
(133, 'ABU ZIHAD', 'Show Room 3  ', '01719826237', '', '', '', '', '', '', '', '', '', '', '2020-02-23', 0, 0, '', 0, 0, 0, ''),
(134, 'mozahid', 'Collector  ', '01794776083', '', '', '', '', '', '', '', '', '', '', '2020-03-03', 0, 0, '', 0, 0, 0, ''),
(135, 'Samim', ' Samims Graphics      ', '017545', '', '', '', '', '', '', '', '', 'upload/findusbd_1643652845.png', '', '2022-01-30', 1, 0, '', 0, 0, 0, ''),
(136, 'Siddik', 'Siddik Seo Firm, Dhaka  ', '01648886878', 'বা', '', '', 'Na', 'Na', '', '??', '', 'upload/samlogo_1643642558.jpg', '', '2022-01-31', 1, 0, '', 0, 0, 0, ''),
(137, 'Nafiz Imtiaz', 'CEO  ', '01918-001177', 'Light Hax', '', '', '01918-001177', 'imtiazither@gmail.com', '', 'Baily Road,Segun Bagicha,Dhaka1', '', 'upload/cropped-Lighthax-Logo_1643872544.png', '', '2022-02-03', 1, 0, '', 0, 0, 0, ''),
(138, 'Abul Azad', 'Ac          ', '01648886878', 'AA', '', '', '8798', 'Na', '', 'Baily Road,Segun Bagicha,Dhaka', 'Thanks For Work With Us', '', '', '2022-02-03', 1, 1, '', 0, 0, 0, ''),
(139, 'Kalam', 'CEO          ', '01648886777', 'Kalam BB', '', '', '01648886777', 'kalam@gmail.com', '', 'dhaka', '', '', '', '2022-02-06', 0, 3, 'Trail', 1, 1, 1, ''),
(140, 'ITM-SHOP', 'Prince Education  ', '01751891037', 'ITM-SHOP', 'Shop', '500', '01751891037', 'itmshop@gmail.com', 'itmshop.com', 'Savar, Dhaka', 'Thanks For Work With Us', 'upload/prince-logo_1694186162.png', 'upload/Samiul_1694185179.jpg', '2022-04-11', 1, 2, 'Trail', 1, 5, 14, 'iss'),
(141, 'Fashion', 'Managing director              ', '01712-048534', 'Fashion', '', '500', '01712-048534', 'fashion@gmail.com', '', 'Bokshigonj Bazar, Sadullapur, Bangladesh', 'Thanks For Training With Us', 'upload/fashion-logo_1699775019.png', '', '2022-04-11', 1, 2, 'Trail', 2, 1, 1, ''),
(142, 'Cattle Farm', 'Cow Farm    ', '01712-048598', 'Cattle Farm', 'Cattle Farm', '500', '01712-048598', 'cow@gmail.com', 'CattleFarm.com', 'Savar, Dhaka', 'Thanks For Work With Us', 'upload/cow-logo_1700403090.png', '', '2022-04-10', 1, 2, 'Trail', 1, 1, 1, ''),
(143, 'Swazis', 'Swazis  ', '01751891037', 'Swazis', 'Swazis', '500', '01751891037', 'swazis@gmail.com', 'https://swazisltd.com/', 'Ranir Hat, Bogura', 'Thanks For Work With Us', 'upload/swazis-logo_1700131902.png', '', '2022-04-10', 1, 2, 'Trail', 2, 2, 2, 'dta'),
(144, 'Agro Feed', 'CEO      ', '01765000003', 'Agro Feed', '', '1200', '01765000003', 'agrofeed@gmail.com', '', 'Khaja Super Market, 2nd to 7th Floor, Kallyanpur Bus Stop, Mirpur Road, Dhaka-1207.', 'Thanks For Work With Us', 'upload/feed-logo_1700645862.png', '0', '2022-09-06', 1, 2, 'Trail', 0, 3, 2, 'kdc'),
(145, 'Rice Mills', 'Busines Owner    ', '01751-891037', 'Rice Mills', '', '750', '01751-891037', 'ricemill@gmail.com', '', 'Gazipur, Bangladesh', 'Thanks For Shopping From Us', 'upload/rice-logo_1700646176.png', 'upload/samiul_1667973736.jpg', '2022-11-09', 1, 2, 'Trail', 1, 0, 0, 'sps'),
(146, 'Nazmul Ahmmed ', 'Busines Owner            ', '0157657874', 'Phone Shop Bd', 'Phone Buy - Sale', '750', '0157657874', 'samiulbdb@gmail.com', '', 'Bogura', 'Thanks For Shopping', 'upload/surma-tarpin_1690179048.jpg', '0', '2022-12-05', 1, 1, 'Trail', 0, 0, 1, 'psb'),
(147, 'Samiul Alam', 'CEO', '01751891037', 'Dhaka Agro', 'Dhaka Agro', '500', '01751891037', 'samiul.promisegroup@gmail.com', 'ww.idealclipping.com/', 'No', 'Thanks For Work With Us', 'upload/user-male_1684224339.png', '0', '2023-05-16', 1, 2, 'Trail', 1, 0, 0, 'kdc'),
(148, '????? ?????? ????? ??????', 'Busines Owner', '01915-732878', 'সুরমা তারপিন থিনার বগুড়া', '??? ?????? ???????, ??????, ?????', '750', '01915-732878', 'surmatarpin@gmail.com', 'Na', '????? ????? ?????, ??????', 'Thanks For Buy From Us', 'upload/surma-tarpin_1690180049.jpg', '0', '2023-07-24', 1, 2, 'Trail', 1, 0, 0, 'st');

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

--
-- Table structure for table `stuff_details`
--

CREATE TABLE `stuff_details` (
  `id` int(30) NOT NULL,
  `userid` int(11) NOT NULL,
  `own_name` varchar(300) NOT NULL,
  `business_name` varchar(300) NOT NULL,
  `status` int(50) NOT NULL,
  `software_status` int(50) NOT NULL,
  `comments` varchar(300) NOT NULL,
  `division_id` int(150) NOT NULL,
  `district_id` int(150) NOT NULL,
  `upazila_id` int(150) NOT NULL,
  `entry_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `stuff_details`
--

INSERT INTO `stuff_details` (`id`, `userid`, `own_name`, `business_name`, `status`, `software_status`, `comments`, `division_id`, `district_id`, `upazila_id`, `entry_date`) VALUES
(746, 170, 'Samiul ITM ( Test )', '', 1, 1, 'Paid', 0, 0, 0, '2020-01-06 00:32:55'),
(747, 171, 'King Computer', '', 1, 2, 'Trail', 0, 0, 0, '2020-01-06 00:46:43'),
(748, 170, 'Samiul ITM ( Test )', '', 1, 2, 'Trail ', 0, 0, 0, '2020-01-06 00:47:38'),
(749, 171, 'King Computer', '', 1, 2, 'Trail', 0, 0, 0, '2020-01-06 00:50:12'),
(750, 171, 'King Computer', '', 1, 2, 'Trail', 0, 0, 0, '2020-01-06 00:53:34'),
(751, 171, 'King Computer', '', 1, 2, 'Trail', 0, 0, 0, '2020-01-06 12:25:30'),
(752, 170, 'Samiul ITM ( Test )', '', 1, 2, 'Trail ', 0, 0, 0, '2020-01-06 15:02:28'),
(753, 172, 'Salam House', '', 1, 2, 'trail', 0, 0, 0, '2021-12-18 00:00:00'),
(754, 172, 'Salam House', '', 1, 2, 'trail', 0, 0, 0, '2021-12-18 00:00:00'),
(755, 174, 'Salam House2', '', 1, 2, 'trail', 1, 1, 2, '2021-12-18 00:00:00'),
(756, 174, 'Salam House2', '', 0, 3, 'trail', 0, 0, 0, '2022-02-06 20:20:28'),
(757, 139, 'Kalam', 'Kalam BB', 1, 2, 'Trail', 1, 1, 1, '2022-02-06 00:00:00'),
(758, 140, 'Tausif', 'Affordable SEO Firm', 1, 1, 'abc', 1, 1, 1, '2022-03-18 00:00:00'),
(759, 141, 'Imran Islam', '???????? ?????? ????????? ??????? ??????????', 1, 2, 'Trail', 2, 1, 1, '2022-04-08 00:00:00'),
(760, 142, 'Siddik', 'Siddik Seo', 1, 2, 'Trail', 1, 1, 1, '2022-04-10 00:00:00'),
(761, 143, 'Samiul Alom', 'DTA64', 1, 2, 'Trail', 1, 1, 1, '2022-04-10 00:00:00'),
(762, 144, 'HM Talha', 'Digital Dental', 1, 1, 'Trail', 2, 0, 0, '2022-09-06 00:00:00'),
(763, 145, 'Smart Phone ', 'Smart Phone Shop', 1, 2, 'Trail', 1, 0, 0, '2022-11-09 00:00:00'),
(764, 146, 'Nazmul Ahmmed ', 'Phone Shop Bd', 1, 1, 'Trail', 1, 0, 0, '2022-12-05 00:00:00'),
(765, 147, 'Samiul Alam', 'Dhaka Agro', 1, 2, 'Trail', 1, 0, 0, '2023-05-16 00:00:00'),
(766, 148, '????? ?????? ????? ??????', '????? ?????? ????? ??????', 1, 2, 'Trail', 1, 0, 0, '2023-07-24 00:00:00');

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

--
-- Table structure for table `team_section`
--

CREATE TABLE `team_section` (
  `id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `team_title` varchar(200) NOT NULL,
  `team_subtitle` varchar(200) NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `team_section`
--

INSERT INTO `team_section` (`id`, `user_id`, `team_title`, `team_subtitle`, `userPic`) VALUES
(18, 140, 'Teacher - 01', 'Teacher', '931875.jpg'),
(19, 140, 'Teacher - 02', 'Teacher', 'prince-23288-t2.jpg'),
(20, 140, 'Teacher - 03', 'Teacher ', 'prince-729416-t3.jpg'),
(21, 140, 'Teacher - 04', 'Teacher ', 'prince-992248-t4.jpg'),
(22, 141, 'Hasan', 'Manager', 'prince-712934-The_Quiff_with_Full_Beard_360x477.jpg');

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `ts_id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `name` varchar(100) NOT NULL,
  `position` varchar(200) NOT NULL,
  `details` text NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`ts_id`, `user_id`, `name`, `position`, `details`, `userPic`) VALUES
(2, 140, 'Mahmuda Begum', 'Senior Stuff Nurse', '<div style=\"font-family: Consolas, \" courier=\"\" new\",=\"\" monospace;=\"\" line-height:=\"\" 22px;=\"\" white-space:=\"\" pre;\"=\"\"><div style=\"font-family: Consolas, \"Courier New\", monospace; line-height: 22px; white-space: pre;\">As a pharmacy student, I am grateful for the exceptional education provided by my college. The curriculum blends scientific knowledge with practical skills, equipping me to serve as a trusted healthcare provider. The supportive faculty, cutting-edge facilities, and diverse clinical experiences have prepared me to make a positive impact on patient care.</div></div>', '271032.jpeg'),
(3, 140, 'Sabbir Ahmmed', 'Pharmacist BSMMU', '<div style=\"font-family: Consolas, \" courier=\"\" new\",=\"\" monospace;=\"\" line-height:=\"\" 22px;=\"\" white-space:=\"\" pre;\"=\"\"><div style=\"font-family: Consolas, \"Courier New\", monospace; line-height: 22px; white-space: pre;\">Being a pathology student at my college has been an enlightening experience. The comprehensive curriculum, state-of-the-art laboratories, and expert guidance from faculty members have nurtured my passion for understanding disease processes. The collaborative environment and research opportunities have prepared me for a promising career in diagnostic medicine.</div></div>', '674364.jpg'),
(4, 140, 'Al Amin', 'Medical Technologist', '<div style=\"font-family: Consolas, \" courier=\"\" new\",=\"\" monospace;=\"\" line-height:=\"\" 22px;=\"\" white-space:=\"\" pre;\"=\"\"><div style=\"font-family: Consolas, \" courier=\"\" new\",=\"\" monospace;=\"\" line-height:=\"\" 22px;=\"\" white-space:=\"\" pre;\"=\"\"><b>My college</b> has been instrumental in shaping me as a skilled <u><b>medical technologis</b></u>t. The rigorous training, emphasis on laboratory techniques, and exposure to advanced technologies have honed my diagnostic skills. The supportive faculty and hands-on experiences have prepared me to excel in the dynamic field of medical diagnostics.</div></div>', '983571.png'),
(5, 141, 'Salam BG', 'Business Owner', '<p>Best Product Ever Seen , Nice Design<br></p>', '817528.'),
(6, 141, 'Akash', 'Job', '<p>T Shirt is very nice product&nbsp;</p>', '804164.'),
(7, 141, 'Fahim', 'Job', '<p>Nice Product , Thanks..</p>', '344656.'),
(8, 144, 'Md Zahidul Islam', 'Talukder Traders; Sagardighi Bazar, Tangail', '<p><i style=\"padding: 0px; margin: 0px; box-sizing: inherit; color: rgb(105, 98, 72); font-family: \"Times New Roman\", Times, serif; font-size: 25px; letter-spacing: 0.5px;\">Iâ€™m Md Zahidul Islam, Proprietor of M/S Talukder Traders. I use this Layer and Broiler feed from its inception. I have been involving in this sector more than 15 years and I can guarantee that this feed is best.</i><br></p>', '413586.png'),
(9, 144, 'Harun Or Rashid', 'M/S Rayhan Poultry Complex; Sreepur, Gazipur', '<p><i style=\"padding: 0px; margin: 0px; box-sizing: inherit; color: rgb(105, 98, 72); font-family: \" times=\"\" new=\"\" roman\",=\"\" times,=\"\" serif;=\"\" font-size:=\"\" 25px;=\"\" letter-spacing:=\"\" 0.5px;\"=\"\">I prefer This Layer and Broiler feed because it has been formulated by experts, itâ€™s safe, and it produces excellent results. Their service is always good, whether on the phone or in the store. Always pleasure to work with them.</i><br></p>', '351222.png'),
(10, 144, 'Sahil Uddin', 'S.K Poultry & Feed Center ; Tremuhuni, Fatekharkul, Ramu, Coxâ€™s Bazar', '<p><i style=\"box-sizing: inherit; padding: 0px; margin: 0px; color: rgb(105, 98, 72); font-family: \" times=\"\" new=\"\" roman\",=\"\" times,=\"\" serif;=\"\" font-size:=\"\" 25px;=\"\" letter-spacing:=\"\" 0.5px;\"=\"\">Iâ€™m Sahil Uddin , Proprietor of S.K Poultry &amp; Feed Center, This feed is excellent and nutritious, and theyâ€™re some of the best people we do business with. They certainly have the most knowledge in this sector. They have technical expertise in feed and ingredients. Their service is also excellent.</i><br></p>', '859141.png');

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

--
-- Table structure for table `thana`
--

CREATE TABLE `thana` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `thana_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `thana`
--

INSERT INTO `thana` (`id`, `user_id`, `thana_name`) VALUES
(1, 22, 'Mirpur'),
(2, 22, 'Uttara');

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

--
-- Table structure for table `title_name`
--

CREATE TABLE `title_name` (
  `id` int(10) NOT NULL,
  `location` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `stutas` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `title_name`
--

INSERT INTO `title_name` (`id`, `location`, `name`, `stutas`) VALUES
(2, 'Header', 'Digital Training Center', 0),
(5, 'Title Bar', 'Digital Training Center', 0),
(6, 'Report Title', 'Digital Training Center', 0),
(7, 'Photo Name', 'photo', 0);

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

--
-- Table structure for table `upazila`
--

CREATE TABLE `upazila` (
  `id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `upazila_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `upazila`
--

INSERT INTO `upazila` (`id`, `user_id`, `upazila_name`) VALUES
(2, 140, 'Bogura'),
(3, 140, 'Rajshahi'),
(4, 140, 'Bogura Sadar'),
(5, 140, 'Gabtoli'),
(6, 140, 'Sherpur');

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

--
-- Table structure for table `userlog`
--

CREATE TABLE `userlog` (
  `userlogid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `login` datetime NOT NULL,
  `logout` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `vision`
--

CREATE TABLE `vision` (
  `ms_id` int(30) NOT NULL,
  `user_id` int(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `details` longtext NOT NULL,
  `userPic` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vision`
--

INSERT INTO `vision` (`ms_id`, `user_id`, `name`, `details`, `userPic`) VALUES
(1, 140, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(2, 141, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(3, 142, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(4, 143, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(5, 144, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(6, 145, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(7, 146, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(8, 147, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(9, 148, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(10, 149, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg'),
(11, 150, 'Our Vision', '<p><span style=\"font-size: 12pt;\">Prince Education Group has been established to keep pace with the progress of science and information technology and to achieve success in the journey of progress of Bangladesh with the potential of a large population and to expand teaching and research activities with due importance in the field of technical and work-oriented education and modern knowledge practice at the national level.Action oriented education is the main driver of development and progress.</span></p>\r\n<p><span style=\"font-size: 12pt;\"> The economic emancipation of the common people lies in the wide spread of this education. Today it is the need of the hour to take this education to the grass root level, at the doorstep of all the hardworking people. Various organizations are being established at the public and private level with the aim of promoting, expanding, skilling and developing career-oriented education, innovative development projects have been adopted and are being implemented.</span></p>', '608594.jpg');

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

--
-- Table structure for table `web_setting_blog_home`
--

CREATE TABLE `web_setting_blog_home` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_blog_home`
--

INSERT INTO `web_setting_blog_home` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'bg-light', 'text-danger', 'text-warning', 'text-dark', 'btn-light', 1),
(5, 142, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'btn-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', '#b095d0', '#ebe3ee', '', '', '', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_breadcrumb`
--

CREATE TABLE `web_setting_breadcrumb` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_breadcrumb`
--

INSERT INTO `web_setting_breadcrumb` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(5, 142, 'container-fluid', 'container', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(7, 144, 'container-fluid', 'container', '#b095d0', '#ebe3ee', '', '', '', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(12, 149, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(13, 150, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(14, 151, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(15, 152, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(16, 153, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(17, 154, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(18, 155, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_category`
--

CREATE TABLE `web_setting_category` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_category`
--

INSERT INTO `web_setting_category` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(5, 142, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'bg-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', 'bg-light', 'text-dark', '', '', 'btn-primary', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_chose_us`
--

CREATE TABLE `web_setting_chose_us` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_chose_us`
--

INSERT INTO `web_setting_chose_us` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(5, 142, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'btn-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', '#b095d0', '#ebe3ee', '', '', '', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_customer_review`
--

CREATE TABLE `web_setting_customer_review` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_customer_review`
--

INSERT INTO `web_setting_customer_review` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(5, 142, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'btn-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', '#b095d0', '#ebe3ee', '', '', '', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_header`
--

CREATE TABLE `web_setting_header` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_header`
--

INSERT INTO `web_setting_header` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container', 'container', 'bg-warning', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(5, 142, 'container', 'container', 'bg-primary', 'text-dark', '', '', '', 1),
(6, 143, 'container', 'container', 'bg-success', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', 'bg-danger', '#ebe3ee', '', '', '', 1),
(8, 145, 'container-fluid', 'container', 'bg-warning', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_latest_product`
--

CREATE TABLE `web_setting_latest_product` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_latest_product`
--

INSERT INTO `web_setting_latest_product` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'bg-light', 'text-dark', 'text-warning', 'text-dark', 'btn-warning', 1),
(5, 142, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'btn-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', 'bg-light', '#ebe3ee', '', '', 'btn-primary', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_offer_product`
--

CREATE TABLE `web_setting_offer_product` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_offer_product`
--

INSERT INTO `web_setting_offer_product` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'bg-light', 'text-dark', 'text-warning', 'text-dark', 'btn-warning', 1),
(5, 142, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'btn-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', '#b095d0', '#ebe3ee', '', '', 'btn-primary', 1),
(8, 145, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_slider`
--

CREATE TABLE `web_setting_slider` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_slider`
--

INSERT INTO `web_setting_slider` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container', 'container', 'bg-light', 'text-dark', 'text-success', 'text-warning', 'btn-success', 1),
(5, 142, 'container', 'container', '#b095d0', '#ebe3ee', '', '', '', 1),
(6, 143, 'container', 'container', 'btn-light', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container', 'container', 'bg-light', 'text-warning', '', '', 'btn-warning', 1),
(8, 145, 'container', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `web_setting_top_header`
--

CREATE TABLE `web_setting_top_header` (
  `id` int(30) NOT NULL,
  `user_id` int(100) NOT NULL,
  `bg_container` varchar(50) NOT NULL,
  `cont_container` varchar(50) NOT NULL,
  `bg_color` varchar(50) NOT NULL,
  `text_color` varchar(50) NOT NULL,
  `link_color` varchar(50) NOT NULL,
  `hover_color` varchar(50) NOT NULL,
  `button_color` varchar(50) NOT NULL,
  `status` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `web_setting_top_header`
--

INSERT INTO `web_setting_top_header` (`id`, `user_id`, `bg_container`, `cont_container`, `bg_color`, `text_color`, `link_color`, `hover_color`, `button_color`, `status`) VALUES
(1, 140, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(3, 141, 'container-fluid', 'container', 'bg-dark', 'text-light', 'text-warning', 'text-warning', 'bg-warning', 1),
(5, 142, 'container-fluid', 'container', 'bg-dark', 'text-success', '', '', '', 1),
(6, 143, 'container-fluid', 'container', 'bg-danger', 'text-light', 'text-success', 'text-warning', 'bg-success', 1),
(7, 144, 'container-fluid', 'container', 'bg-dark', 'text-light', '', '', '', 1),
(8, 145, 'container-fluid', 'container', 'bg-success', 'text-light', 'text-success', 'text-warning', 'bg-warning', 1),
(9, 146, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(10, 147, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(11, 148, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1),
(12, 144, '', '', '#b095d0', '#ebe3ee', '', '', '', 1),
(13, 150, 'container-fluid', 'container', 'btn-light', 'text-dark', 'text-success', 'text-warning', 'bg-warning', 1);

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

--
-- Table structure for table `year_name`
--

CREATE TABLE `year_name` (
  `yer_id` int(20) NOT NULL,
  `user_id` int(100) NOT NULL,
  `yer_name` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `year_name`
--

INSERT INTO `year_name` (`yer_id`, `user_id`, `yer_name`) VALUES
(1, 140, '2023'),
(2, 140, '2024');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `apply`
--
ALTER TABLE `apply`
  ADD PRIMARY KEY (`student_id`);

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

--
-- Indexes for table `bld_grp`
--
ALTER TABLE `bld_grp`
  ADD PRIMARY KEY (`bld_id`);

--
-- Indexes for table `board`
--
ALTER TABLE `board`
  ADD PRIMARY KEY (`brd_id`);

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`br_id`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `crse_topic`
--
ALTER TABLE `crse_topic`
  ADD PRIMARY KEY (`crse_id`);

--
-- Indexes for table `degree`
--
ALTER TABLE `degree`
  ADD PRIMARY KEY (`deg_id`);

--
-- Indexes for table `diploma_admission`
--
ALTER TABLE `diploma_admission`
  ADD PRIMARY KEY (`ad_id`);

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

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

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

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

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

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

--
-- Indexes for table `map`
--
ALTER TABLE `map`
  ADD PRIMARY KEY (`mp_id`);

--
-- Indexes for table `medical_admission`
--
ALTER TABLE `medical_admission`
  ADD PRIMARY KEY (`ad_id`);

--
-- Indexes for table `medical_assistant_admission`
--
ALTER TABLE `medical_assistant_admission`
  ADD PRIMARY KEY (`ad_id`);

--
-- Indexes for table `mission`
--
ALTER TABLE `mission`
  ADD PRIMARY KEY (`ms_id`);

--
-- Indexes for table `month`
--
ALTER TABLE `month`
  ADD PRIMARY KEY (`mnt_id`);

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

--
-- Indexes for table `nursing_admission`
--
ALTER TABLE `nursing_admission`
  ADD PRIMARY KEY (`ad_id`);

--
-- Indexes for table `office_exp_name`
--
ALTER TABLE `office_exp_name`
  ADD PRIMARY KEY (`of_id`);

--
-- Indexes for table `order_list`
--
ALTER TABLE `order_list`
  ADD PRIMARY KEY (`OrderId`);

--
-- Indexes for table `parner`
--
ALTER TABLE `parner`
  ADD PRIMARY KEY (`pr_id`);

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

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`pro_id`);

--
-- Indexes for table `product_category`
--
ALTER TABLE `product_category`
  ADD PRIMARY KEY (`cat_id`);

--
-- Indexes for table `product_type`
--
ALTER TABLE `product_type`
  ADD PRIMARY KEY (`ptype_id`);

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

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

--
-- Indexes for table `service`
--
ALTER TABLE `service`
  ADD PRIMARY KEY (`sv_id`);

--
-- Indexes for table `service_category`
--
ALTER TABLE `service_category`
  ADD PRIMARY KEY (`cat_id`);

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

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

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

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

--
-- Indexes for table `stats`
--
ALTER TABLE `stats`
  ADD PRIMARY KEY (`st_id`);

--
-- Indexes for table `students`
--
ALTER TABLE `students`
  ADD PRIMARY KEY (`student_id`);

--
-- Indexes for table `stuff`
--
ALTER TABLE `stuff`
  ADD PRIMARY KEY (`userid`);

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

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

--
-- Indexes for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD PRIMARY KEY (`ts_id`);

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

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

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

--
-- Indexes for table `userlog`
--
ALTER TABLE `userlog`
  ADD PRIMARY KEY (`userlogid`);

--
-- Indexes for table `vision`
--
ALTER TABLE `vision`
  ADD PRIMARY KEY (`ms_id`);

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `year_name`
--
ALTER TABLE `year_name`
  ADD PRIMARY KEY (`yer_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `activitylog`
--
ALTER TABLE `activitylog`
  MODIFY `activitylog` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=654;

--
-- AUTO_INCREMENT for table `apply`
--
ALTER TABLE `apply`
  MODIFY `student_id` int(150) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

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

--
-- AUTO_INCREMENT for table `bld_grp`
--
ALTER TABLE `bld_grp`
  MODIFY `bld_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `board`
--
ALTER TABLE `board`
  MODIFY `brd_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `br_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `crse_topic`
--
ALTER TABLE `crse_topic`
  MODIFY `crse_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `degree`
--
ALTER TABLE `degree`
  MODIFY `deg_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `diploma_admission`
--
ALTER TABLE `diploma_admission`
  MODIFY `ad_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `division`
--
ALTER TABLE `division`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `expense`
--
ALTER TABLE `expense`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `expense_other`
--
ALTER TABLE `expense_other`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

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

--
-- AUTO_INCREMENT for table `map`
--
ALTER TABLE `map`
  MODIFY `mp_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `medical_admission`
--
ALTER TABLE `medical_admission`
  MODIFY `ad_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `medical_assistant_admission`
--
ALTER TABLE `medical_assistant_admission`
  MODIFY `ad_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `month`
--
ALTER TABLE `month`
  MODIFY `mnt_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `nursing_admission`
--
ALTER TABLE `nursing_admission`
  MODIFY `ad_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `office_exp_name`
--
ALTER TABLE `office_exp_name`
  MODIFY `of_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `order_list`
--
ALTER TABLE `order_list`
  MODIFY `OrderId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `parner`
--
ALTER TABLE `parner`
  MODIFY `pr_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

--
-- AUTO_INCREMENT for table `product_category`
--
ALTER TABLE `product_category`
  MODIFY `cat_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT for table `product_type`
--
ALTER TABLE `product_type`
  MODIFY `ptype_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

--
-- AUTO_INCREMENT for table `service`
--
ALTER TABLE `service`
  MODIFY `sv_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `service_category`
--
ALTER TABLE `service_category`
  MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

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

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

--
-- AUTO_INCREMENT for table `stats`
--
ALTER TABLE `stats`
  MODIFY `st_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `students`
--
ALTER TABLE `students`
  MODIFY `student_id` int(150) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=119;

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

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

--
-- AUTO_INCREMENT for table `testimonial`
--
ALTER TABLE `testimonial`
  MODIFY `ts_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `thana`
--
ALTER TABLE `thana`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `upazila`
--
ALTER TABLE `upazila`
  MODIFY `id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `userlog`
--
ALTER TABLE `userlog`
  MODIFY `userlogid` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `year_name`
--
ALTER TABLE `year_name`
  MODIFY `yer_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
COMMIT;

