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

START TRANSACTION;



--
-- Database: `wahpgyuz_wahcantt-website`
--

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

--
-- Table structure for table `ads`
--

CREATE TABLE `ads` (
  `id` int(11) NOT NULL,
  `left_ad_image` text NOT NULL,
  `right_ad_image` text NOT NULL,
  `left_ad_link` text NOT NULL,
  `right_ad_link` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ads`
--

INSERT INTO `ads` (`id`, `left_ad_image`, `right_ad_image`, `left_ad_link`, `right_ad_link`) VALUES
(29, 'images/ads/Pin.png', 'images/ads/Pink.png', 'https://wahpublic.pk/jobs', 'https://wahpublic.pk/contact');

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

--
-- Table structure for table `colleges`
--

CREATE TABLE `colleges` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `c_link` text NOT NULL,
  `srch_tags` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `colleges`
--

INSERT INTO `colleges` (`id`, `name`, `c_link`, `srch_tags`) VALUES
(29, 'Roots', 'http://www.rootsinternational.edu.pk/?directory=roots-international-schools-gandhara-campus', 'roots'),
(30, 'CB Public Girls School & College', 'https://www.facebook.com/CBSchoolsWahOfficial/', 'cb college'),
(31, 'Cantt Public Boys School & College, Lala Rukh', 'https://www.facebook.com/cbwah3/', 'cantt public boys college'),
(32, 'F. G. Degree College for Men', 'https://www.facebook.com/FGCollegeforMenWahCantt/', 'fg degree college for men'),
(33, 'W.S.S.O Mashal Degree College for Women', 'http://mdc.uow.edu.pk/', 'mds college'),
(34, 'Zarghoona College for Women', 'https://www.facebook.com/zarghoonacollege/', 'Zarghoona College for Women'),
(35, 'Cantt College for Girls', 'https://canttcollege.edu.pk/', 'Cantt College for Girls'),
(36, 'Jinnah College, Lala Rukh', 'https://www.facebook.com/pg/JccWah/about/', 'Jinnah College, Lala Rukh'),
(37, 'The Hope College of Science & Commerce', 'https://www.facebook.com/pages/category/College---University/The-Hope-College-Of-Science-Commerce-Wah-Cantt-113362352691075/', 'The Hope College of Science & Commerce'),
(38, 'Rise & Shine College', 'https://www.facebook.com/RSPSOFFICIAL/', 'Rise & Shine College'),
(39, 'The Model Science College', 'https://www.facebook.com/msc051/', 'The Model Science College'),
(40, 'Punjab Superior College', 'https://www.facebook.com/pages/Punjab-Superior-College-Wah-Cantt/351044409148874', 'Punjab Superior College'),
(41, 'Askaria College', 'http://www.askaria.edu.pk/', 'Askaria College'),
(42, 'Horizon College for Girls', 'https://www.facebook.com/pages/Horizon-degree-college-for-girls-wah-cantt/191559304314034', 'Horizon College for Girls'),
(43, 'Indus College of Commerce', 'https://www.facebook.com/induscc/', 'Indus College of Commerce'),
(44, 'Punjab College of Excellence in Commerce', 'https://www.facebook.com/pcecWahcantt/', 'Punjab College of Excellence in Commerce'),
(45, 'Wah College of Accountancy', 'https://wca.edu.pk/', 'Wah College of Accountancy wca\r\n'),
(46, 'Sir Syed Scholars College', 'https://www.facebook.com/pages/category/Education/Sir-Syed-Scholars-School-College-Wahcantt-684519145271306/', 'Sir Syed Scholars College'),
(47, 'Punjab College, Wah Cantt', 'https://www.facebook.com/pgcfamily/', 'Punjab College, Wah Cantt'),
(50, 'Base College Of Science And Commerce', 'http://www.basecollege.edu.pk/', 'Base College Of Science And Commerce'),
(51, 'Swedish College of Engineering And Technology', 'http://www.scetwah.edu.pk/', 'Swedish College of Engineering And Technology'),
(52, 'Wah Polytechnic College', 'https://wah-polytechnic-college.business.site/', 'Wah Polytechnic College'),
(53, 'Sir Syed College', 'https://www.facebook.com/sirsyedcollege/', 'Sir Syed College'),
(54, 'Federal Science Degree College', 'https://www.facebook.com/pages/Federal-Science-Degree-College-Wah-Cantt/175638939275040', 'Federal Science Degree College'),
(55, 'Gandhara Homoeopathic Medical College', 'https://gandhara-homoeopathic-medical-college.business.site/?utm_source=gmb&utm_medium=referral', 'Gandhara Homoeopathic Medical College'),
(56, 'Institute Of Nursing', 'https://www.facebook.com/IoNWMC', 'Institute Of Nursing'),
(57, 'Rawalpindi College Of Commerce', 'https://www.facebook.com/pages/category/School/Rawalpindi-College-of-Commerce-Wah-Campus-1501325040123466/', 'Rawalpindi College Of Commerce'),
(58, 'WIMS Degree College', 'https://www.facebook.com/wimsschoolofficial/', 'WIMS Degree College'),
(59, 'Mashal Degree College for Women', 'http://mdc.uow.edu.pk/', 'Mashal Degree College for Women'),
(60, 'Post Graduate College for Women', 'https://www.facebook.com/pages/Fgpost-Graduate-College-for-Women-Wahcantt/239649272845680', 'Post Graduate College for Women'),
(61, 'The Scholars Science College', 'http://www.scholars.edu.pk/', 'The Scholars Science College'),
(62, 'Brilliant science college', 'https://www.facebook.com/bscwah.official/', 'Brilliant science college');

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

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

CREATE TABLE `contact_us` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `cell_num` text NOT NULL,
  `message` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `contact_us` (`id`, `name`, `email`, `cell_num`, `message`) VALUES
(2, 'Muhammad Ahmed', 'ar64496@gmail.com', '03075171431', 'The link to school name New Foundation Public School is wrong \r\nThe link is for Foundation Public School which is located in gudwal \r\nNew Foundation Public School is in lalazar wah cantt \r\nEstablished in 1991 and affilated with FBISE and permenantly registered with Govt. of Pakistan \r\nPlease contact on 03075171431 \r\nfor proper link and information \r\nand please correct that information as soon as possible thanks '),
(19, 'Deloriscem', 'contact1@theonlinepublishers.com', '', 'Hello, we are The Online Publishers (TOP) and want to introduce ourselves to you.  TOP is an established comprehensive global online hub.  We connect clients to expert freelancers in all facets of the world of digital marketing such as writers, journalists, bloggers, authors, advertisers, publishers, social media influencers, backlinks managers, Vloggers/video marketers and reviewers… A few of the many services we offer are content creation and placement, publishing, advertising, online translation, and social media management.  We also have two full online libraries, one of photographs and the other of eBooks and informative resources. \r\nSave money and time by using TOP services.  Rather than having to search for multiple providers of various tasks, we are a one-stop-shop.  We have all the services you will ever need right here.  For a complete list, check out our website https://www.theonlinepublishers.com \r\nTOP can help any business surge ahead of its competition and increase sales.  Join The Online Publishers today.'),
(20, 'Mike Gimson\r\n', 'no-replyPonse@google.com', '', 'Hi there \r\nIf you want to get ahead of your competition, have a higher Domain Authority score. Its just simple as that. \r\nWith our service you get Domain Authority above 50 points in just 30 days. \r\n \r\nThis service is guaranteed \r\n \r\nFor more information, check our service here \r\nhttps://www.monkeydigital.co/Get-Guaranteed-Domain-Authority-50/ \r\n \r\nthank you \r\nMike Gimson\r\n \r\nMonkey Digital \r\nsupport@monkeydigital.co');

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

--
-- Table structure for table `industries_categories`
--

CREATE TABLE `industries_categories` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `link` text NOT NULL,
  `type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `industries_categories`
--

INSERT INTO `industries_categories` (`id`, `name`, `link`, `type`) VALUES
(1, 'HBL Bank Limited', 'https://hblasset.com/location/wah-cantt-p-o-f/', 'Banks'),
(4, 'Bank Alfalah Wah Cantt', 'https://www.bankalfalah.com/branch-atm-locator/', 'Banks'),
(5, 'Soneri Bank', 'https://www.soneribank.com/', 'Banks'),
(7, 'National Bank of Pakistan, Wah Cantt', 'https://www.nbp.com.pk/BRNTWRK/Branch_Details.aspx?bCode=MDQxNQ==', 'Banks'),
(8, 'The Bank of Punjab', 'https://www.bop.com.pk/Locator.aspx?sitemap=1', 'Banks'),
(9, 'Bank Islami', 'https://bankislami.com.pk/', 'Banks'),
(10, 'Faysal Bank', 'https://www.faysalbank.com/', 'Banks'),
(11, 'POF Hospital', 'http://www.hospital.pof.gov.pk/', 'Hospitals'),
(12, 'Alam Family Hospital', 'https://www.facebook.com/alam.family.hospital1/', 'Hospitals'),
(13, 'IDC Aslam Uppal Diagnostic Centre ', 'https://idc.net.pk/location/islamabad-diagnostic-centre-wah-cantt-audc/?__cf_chl_jschl_tk__=91f2637579c81503cb834bd00d456af893b3fc74-1587737507-0-AbVoRdwyG0ZNvAGQMpp6empiLUxC6f83pApKl30yLFnaszPkArlyyyR5y9K_oaBJzjsHH4hyfOudV15rDRVhgSiqPExP_oV6LrZ2l4CyGTqDru_C9uPSTPQ7Sshwte0FmDegmUQDSK49oPH73mUhC2qIq095m3vSXxVUmwfK5Wy45Hq4mujFyknY64iIgxNlKUILS6Mj4elAN6yE6SBMbqEehqfO8NPWWyP_2GisZcRKPexMEijlYou05PVZVOiyKQmgpzLhNTF6pyPndApZZnFxaIV5FHso1wJSOm7mVeKwMF6gT5pqdzdLAG1ws7duug-GRKZ9YkWCuYRUG8KOh50', 'Hospitals'),
(14, 'City Hospital', 'https://www.facebook.com/pages/category/Medical-Company/City-Hospital-Wah-Cantt-1469450556689213/', 'Hospitals'),
(15, 'Rawal Surgical Hospital', 'https://www.facebook.com/Rawal9977/', 'Hospitals'),
(16, 'Wah General Hospital', 'https://www.facebook.com/wahgenralhospitalunoffical/', 'Hospitals'),
(17, 'Al Elaj Hospital', 'https://www.facebook.com/pages/category/Hospital/Al-Elaj-Hospital-Wah-cantt-100768654861084/', 'Hospitals'),
(18, 'Doctorz Hospital', 'https://www.facebook.com/pages/Doctors-Hospital-GT-Road-Wah-Cantt/1807485386129723', 'Hospitals'),
(19, 'Amer Eye Hospital', 'http://www.amereye.com/', 'Hospitals'),
(20, 'Al-Moeed Hospital', 'https://www.facebook.com/Almoeed-Hospital-Wahcantt-757806454291887/', 'Hospitals'),
(21, 'Al-Abbas Hospital', 'https://www.facebook.com/pages/category/Medical-Company/Al-Abbas-Hospital-1709049416036098/', 'Hospitals'),
(22, 'Noori Hospital', 'https://pk.locale.online/noori-hospital-wah-cantt-1672911573.html', 'Hospitals'),
(23, 'Sharif Hospital', 'https://sharif-hospital.business.site/', 'Hospitals'),
(24, 'Izzat Ali Shah Hospital', 'http://iash.com.pk/', 'Hospitals'),
(25, 'Muzafar Surgical Hospital', 'https://www.facebook.com/pages/Muzaffar-Khan-Surgical-Hospital-Wah-Cantt/262837243851522', 'Hospitals'),
(26, 'EDO Eye Hospital ', 'http://www.edowah.org/', 'Hospitals'),
(27, 'Fahad Hospital', 'https://oladoc.com/pakistan/hyderabad/dr/eye-specialist/fahad-shaikh/8219', 'Hospitals'),
(28, 'Nayab Hospital', 'https://www.facebook.com/Nayab-Surgical-Hospital-Wah-Cantt-1095292793972871/services', 'Hospitals'),
(30, 'Ayaz Memorial Hospital', 'https://www.facebook.com/pages/category/Hospital/Ayaz-Memorial-Hospital-1637470296511716/', 'Hospitals'),
(31, 'Wah International Hospital', 'https://www.facebook.com/pages/category/Hospital/Wah-International-Hospital-Taxila-1029869153781238/', 'Hospitals'),
(32, 'Ghulam Rasool Hospital', 'https://www.facebook.com/pages/Ghulam-Rasul-Hospital-Wah-Cantt/390230847727377', 'Hospitals'),
(33, 'Ali Family Hospital', 'https://www.facebook.com/pages/ali-family-hospital/164409220420095', 'Hospitals'),
(34, 'Allied Bank Limited', 'https://www.abl.com/', 'Banks'),
(35, 'MCB BANK', 'https://www.mcb.com.pk/', 'Banks'),
(36, 'United Bank - UBL', 'https://www.ubldigital.com/', 'Banks'),
(37, 'Askari Bank Limited Islamic Banking Branch', 'https://askaribank.com/cities/wah-cantt/?branch-type=conventional', 'Banks'),
(38, 'Bank Al Habib', 'https://www.bankalhabib.com/', 'Banks'),
(39, 'First Women Bank Ltd. (FWBL) ', 'http://www.fwbl.com.pk/', 'Banks'),
(40, 'Samba Bank', 'https://www.samba.com.pk/samba/personal-banking', 'Banks'),
(41, 'Habibmetro Bank', 'https://www.habibmetro.com/', 'Banks'),
(42, 'AlBaraka Bank', 'https://www.albaraka.com.pk/', 'Banks'),
(43, 'Pakistan Currency', 'http://pakistancurrency.com/', 'Banks'),
(44, 'Meezan Bank ', 'https://www.meezanbank.com/', 'Banks'),
(45, 'JS Bank', 'https://jsbl.com/', 'Banks'),
(46, 'Xpress money', 'https://www.xpressmoney.com/money-transfer-location', 'Banks'),
(47, 'University of Wah', 'http://uow.edu.pk/', 'Universities'),
(48, 'Wah Engineering College WEC', 'http://www.wecuw.edu.pk/', 'Universities'),
(49, 'COMSATS University, Wah Campus', 'http://cuiwah.edu.pk/', 'Universities'),
(50, 'Virtual University', 'https://www.vu.edu.pk/', 'Universities'),
(51, 'Sarmad Book Palace', 'https://www.facebook.com/people/Sarmad-Book-Palace/100007650016879', 'Bookstores'),
(52, 'Punjab Book Center', 'https://www.facebook.com/PUNJABBOOKDEPOO/?ref=py_c', 'Bookstores'),
(53, 'Anwaria Kitab Ghar', 'https://www.facebook.com/akg.wah', 'Bookstores'),
(54, 'National Book Foundation Outlet', 'http://www.nbf.org.pk/index.php?option=com_content&view=article&id=155&Itemid=208', 'Bookstores'),
(55, 'Wah Stationery Mart', 'https://www.facebook.com/wahstationery/', 'Bookstores'),
(56, 'Readers point', 'https://www.facebook.com/pages/category/Education/Readers-Point-wah-Cantt-195567397654729/', 'Bookstores'),
(57, 'Bhatti Book Centre', 'https://www.facebook.com/bhattibook/', 'Bookstores'),
(58, 'Rashid Book Centre', 'https://www.facebook.com/rasheed.books/', 'Bookstores'),
(59, 'Ahmad Book Center', 'https://www.facebook.com/pg/Ahmad-Book-Stantionary-Wahcantt-275949003125165/posts/?ref=page_internal', 'Bookstores'),
(60, 'Bhatti Education Mart', 'https://www.facebook.com/pages/category/Bookstore/Bhatti-Education-Mart-198852477612598/', 'Bookstores'),
(61, 'Hafiz Book Centre', 'https://www.facebook.com/Hafiz-book-center-819741768058515/', 'Bookstores'),
(62, 'Khokhar Book Shop and Sports', 'https://www.facebook.com/khokharbookdepot/', 'Bookstores'),
(63, 'Amin And Sons Book Depot', 'https://www.facebook.com/aminsonsbooks/?ref=nf', 'Bookstores'),
(64, 'Mir Book', 'https://www.facebook.com/pages/category/Bookstore/Mir-BooksUniform-Garments-788997244575112/', 'Bookstores'),
(65, 'Moon Shopping Mall', 'https://www.facebook.com/pages/category/Interest/Moon-shopping-mall-1716631968564565/', 'Shopping Malls'),
(66, 'Asian Mall', 'https://www.facebook.com/pages/category/Company/Asian-Mall-wah-cantt-2058513134446465/', 'Shopping Malls'),
(67, 'Wah Shopping', 'https://www.facebook.com/wahshopping/', 'Shopping Malls'),
(68, 'Alnoor Shopping Center', 'https://www.facebook.com/zabi.butt.ikram.butt/', 'Shopping Malls'),
(69, 'Gelani Mart', 'https://www.facebook.com/GelaniMart/', 'Shopping Malls'),
(70, 'Rana Garments The Shopping Mall', 'https://www.facebook.com/RanaGarmentsOfficial/', 'Shopping Malls'),
(71, 'Save Mart', 'https://www.facebook.com/minesavemart/', 'Shopping Malls'),
(72, 'Qazi Mega Store', 'https://www.facebook.com/QaziMegaMart', 'Shopping Malls'),
(73, 'Al-Makkah Shopping Mart', 'https://www.facebook.com/almakkahwah', 'Shopping Malls'),
(74, 'Fatima Family Mart', 'https://www.facebook.com/FatimaFamilyMart/', 'Shopping Malls'),
(75, 'Al Faisal Mall', 'https://www.facebook.com/AlFaisalMallOnline/?ref=bookmarks', 'Shopping Malls'),
(76, 'Madina Cloth', 'https://www.facebook.com/madinaclothwahcantt/', 'Shopping Malls'),
(77, 'Sapna Cloth Depot', 'https://www.facebook.com/pages/category/Women-s-Clothing-Store/SAPNA-CLOTH-736438896398182/', 'Shopping Malls'),
(78, 'Hanias', 'https://hanias.business.site/', 'Shopping Malls'),
(79, 'Sher-e-Punjab Cloth', 'https://www.facebook.com/smhakhan/', 'Shopping Malls'),
(80, 'Naveed fancy cloth', 'https://www.facebook.com/naveedfancycloth', 'Shopping Malls'),
(81, 'Islamabad Cloth And Tailors', 'http://islamabadtailors.com/', 'Shopping Malls'),
(82, 'Charizma', 'https://www.houseofcharizma.com/', 'Shopping Malls'),
(83, 'Mughal Dress Designer', 'https://www.facebook.com/MughalDressDesigner/?ref=py_c', 'Shopping Malls'),
(84, 'Karachi Cloth', 'https://www.facebook.com/Karachiclothwah/', 'Shopping Malls'),
(85, 'Sitara Cloth', 'https://www.facebook.com/kasimbilal23/', 'Shopping Malls'),
(86, 'Limelight', 'https://www.limelight.pk/', 'Shopping Malls'),
(87, 'edenrobe', 'https://edenrobe.com/', 'Shopping Malls'),
(88, 'Warda', 'https://www.warda.com.pk/', 'Shopping Malls'),
(89, 'Bonanza Satrangi', 'https://www.bonanzasatrangi.com/pk/', 'Shopping Malls'),
(90, 'Froebels International School', 'http://froebels.edu.pk/', 'Schools'),
(91, 'Green City Public High School', 'https://www.facebook.com/GCPHS/', 'Schools'),
(92, 'Quality School', 'https://www.facebook.com/pages/category/Community-College/Quality-School-and-College-Wah-Cantt-1725580067485195/', 'Schools'),
(93, 'Sir Syed School', 'https://www.facebook.com/sirsyedcollege/', 'Schools'),
(94, 'The City School', 'https://thecityschool.edu.pk/', 'Schools'),
(95, 'F.G. Model High School', 'https://www.facebook.com/pages/category/School/F-G-model-high-school-wah-cantt-798532453494375/', 'Schools'),
(96, 'IQRA School Movement', 'https://www.facebook.com/iqraschoolmovementwahcantt/', 'Schools'),
(97, 'The City Model Secondary School', 'https://www.facebook.com/TheCityModelSecondarySchool/', 'Schools'),
(98, 'Lahore Grammar School and College', 'https://www.facebook.com/lgswah/', 'Schools'),
(99, 'Govt. Gillani Model High School', 'https://www.facebook.com/pages/GOVT-GILANI-MODEL-HIGH-SCHOOL-WAH-CANTT/218150351663111', 'Schools'),
(100, 'Margalla Grammar School', 'https://www.facebook.com/mgswahcantt/', 'Schools'),
(101, 'Quaid e Azam Public Model School', 'https://www.facebook.com/QPSWC/', 'Schools'),
(102, 'F.G Junior Public School Gadwal', 'https://www.facebook.com/pages/category/Elementary-School/FG-Junior-Public-School-Gudwal-Wah-Cantt-194832954386766/', 'Schools'),
(103, 'CB Public School and College', 'https://www.facebook.com/CBSchoolsWahOfficial/', 'Schools'),
(104, 'Beacon House School system', 'https://www.beaconhouse.net/branch/wah-cantt-campus/', 'Schools'),
(105, 'Roots International Schools', 'http://www.rootsinternational.edu.pk/', 'Schools'),
(106, 'The Country School', 'https://www.facebook.com/The-Country-School-Lalazar-Wah-Cantt-1028144900575288/', 'Schools'),
(107, 'Suffah Islamic School System', 'https://m.facebook.com/suffaislamicschoolsystemwahcantt/', 'Schools'),
(108, 'The Arqam School', 'https://the-arqam-school-wah-cantt.business.site/?utm_source=gmb&utm_medium=referral', 'Schools'),
(109, 'Dar E Arqam School', 'https://das.edu.pk/', 'Schools'),
(110, 'The Savvy School ', 'http://savvyschool.edu.pk/', 'Schools'),
(111, 'New Foundation Public School', 'https://www.facebook.com/fpswah/', 'Schools'),
(112, 'Farooqi Model High School', 'https://www.facebook.com/Farooqi-Model-High-School-wah-cantt-544132088964430/', 'Schools'),
(113, 'POF Secondary School', 'https://www.facebook.com/POFSecondarySchool/', 'Schools'),
(114, 'Saint Paul High School', 'https://www.facebook.com/Saint-paul-high-school-wah-cantt-126344890751304/', 'Schools'),
(115, 'The Sepal Schools International', 'https://www.facebook.com/TheSepalSchoolsInternational/', 'Schools'),
(116, 'City Grammar School', 'https://www.facebook.com/pages/category/School/City-Grammar-School-Officers-Colony-Wah-Cantt-1444292592312994/', 'Schools'),
(117, 'Rise & Shine Public School', 'https://www.facebook.com/RSPSOFFICIAL/', 'Schools'),
(118, 'Frobell School System', 'http://www.froebels.edu.pk/', 'Schools'),
(119, 'The Educators School', 'https://www.educatorstaxila.com/', 'Schools'),
(120, 'Allied School', 'https://alliedschools.edu.pk/', 'Schools'),
(121, 'WAH SIDDIQUE PUBLIC SCHOOL', 'https://www.facebook.com/pages/wah-siddique-public-school-wah-cantt/1422250654665491', 'Schools'),
(122, 'Misali Superior Secondary School', 'https://www.facebook.com/pages/category/School/Misali-Superior-Cadet-School-Wah-Cantt-450072771789789/', 'Schools'),
(123, 'Base School System Wah Cantt', 'https://www.facebook.com/baseschoolsystemwah/', 'Schools'),
(124, 'Wca schooling system', 'https://www.facebook.com/pages/category/Education-Website/Wca-schooling-system-wah-cantt-1492382520905844/', 'Schools'),
(125, 'Aatish BBQ Restaurant', 'https://www.foodpanda.pk/restaurant/u5cv/aatish-restaurant', 'Food'),
(126, 'Kentucky Pizza & Fried Chicken', 'https://www.facebook.com/wahtast/', 'Food'),
(127, 'Fri Chicks', 'https://www.facebook.com/frichickswah41/', 'Food'),
(128, 'Mandi House', 'https://www.facebook.com/MandiHouse.WahCantt/', 'Food'),
(129, 'Moto Munch (LwC)', 'https://www.facebook.com/MotoMunch/', 'Food'),
(130, 'Keyani Restaurant ', 'https://www.facebook.com/pages/Kiyani-Resturant-Wah-Cant/560441994010685', 'Food'),
(131, 'Ordnance Club', 'https://pof.gov.pk/ordnanceclub', 'Food'),
(132, 'Cafe a la modé', 'https://www.facebook.com/pages/category/Fast-Food-Restaurant/Cafe-A-La-Mode-Wah-Cant-130849644242603/', 'Food'),
(133, 'Green Lagoon', 'http://www.greenlagoons.com.pk/', 'Food'),
(134, 'Full Flame Fast Food Basti', 'https://www.facebook.com/pages/category/Fast-Food-Restaurant/Full-flame-Grill-Chill-356515001669395/', 'Food'),
(135, 'Wah Student Biryani', 'https://www.facebook.com/pages/Wah-Student-Biryani/166936490540541', 'Food'),
(136, 'Khyber Shinwari Tikka House', 'https://www.facebook.com/Khybershinwariresturant/', 'Food'),
(137, 'Pizza Club', 'https://www.facebook.com/pizzzzaclub/', 'Food'),
(138, 'Butt Karahi', 'https://www.facebook.com/buttkarahi.pk/', 'Food'),
(139, 'Al-Qadeem Tikka Shop', 'https://www.facebook.com/269227470638651/posts/al-qadeem-behari-and-tikka-house-opening-its-new-branch-at-main-gt-road-wah-cant/280057192889012/', 'Food'),
(140, 'Hungry bunny', 'https://www.facebook.com/pages/category/Restaurant/Hungry-Bunnys-9-163083870497037/', 'Food'),
(141, 'Kiyani Sajji & Restaurant', 'https://www.facebook.com/pages/Kiyani-Resturant-Wah-Cant/560441994010685', 'Food'),
(142, 'Samad Chinese Pakistani', 'https://www.facebook.com/Al-Samad-fast-food-chinese-restaurant-109580362727611/', 'Food'),
(143, 'Nisaar Charsi Tikka', 'https://www.facebook.com/NisarCharsiTikka/', 'Food'),
(144, 'Shiekh Tikka House', 'https://www.facebook.com/pages/Al-Sheikh-Tikka-House/1068390389921848', 'Food'),
(145, 'The Taste Maker', 'https://www.facebook.com/Thetastemaker111/', 'Food'),
(146, 'Maharaja Restaurant', 'https://www.facebook.com/pages/category/Hotel/Maharaja-B-B-Q-and-Restaurant-361724277902039/', 'Food'),
(147, 'Corner Sweet', 'https://www.facebook.com/pages/Corner-Sweet/447862941918394', 'Food'),
(148, 'YASEEN TIKKA', 'https://www.facebook.com/YaseenTikka/', 'Food'),
(149, 'Munna Bhai Tikka Shop', 'https://www.foodpanda.pk/restaurant/u7zf/munna-tikka-restaurant#', 'Food'),
(150, 'Taste Inn Restaurant', 'https://www.facebook.com/pages/category/Restaurant/Taste-Inn-Official-789198158089693/', 'Food'),
(151, 'Lahori Food Corner', 'https://www.facebook.com/pages/Lahori-Food-Corner/1561920277456576', 'Food'),
(152, 'Max Burger & Refreshment', 'https://www.facebook.com/Max.Burger.Refreshment.point/?rc=p', 'Food'),
(153, 'Bombay Biryani', 'https://www.facebook.com/bbiryani/', 'Food'),
(154, 'Rawal Foods & Refreshment center', 'https://www.facebook.com/RawalFoodsAndRefreshment/', 'Food'),
(155, 'TSHKILA', 'https://www.facebook.com/tshkila2020', 'Food'),
(156, 'Yum Cafe & Grill', 'https://www.facebook.com/yumcafegrill/', 'Food'),
(157, 'Saif Ullah Hotel', 'https://www.facebook.com/pages/Saifullah-Hotel/177637326239540', 'Food'),
(158, 'Pizza Hut', 'https://www.facebook.com/PizzaHutWahCantt/', 'Food'),
(159, 'Burger King', 'https://www.bkpakistan.com/home/get-map', 'Food'),
(160, 'Anwaaria Restaurant', 'https://www.facebook.com/Anwaariarestaurant/', 'Food'),
(161, 'Marhaba Multani Restaurant', 'https://www.facebook.com/pages/category/Restaurant/Marhaba-Multani-Restaurant-1661496167237629/', 'Food'),
(162, 'Malang Jaan Beef Pulao', 'https://www.facebook.com/pages/Malang-Jan-Banu-Beaf-Plao-Tarnol/1368387466594863', 'Food'),
(163, 'Capri Continental Hotel & Resturant', 'https://sw-ke.latest.facebook.com/pages/Capri-Continental-Hotel-Resturant/1062830583919130', 'Food'),
(164, 'KFC', 'https://www.kfcpakistan.com/', 'Food'),
(165, 'Subway', 'https://www.subway.com/en-pk', 'Food'),
(166, 'Sher Shah Park', 'https://www.facebook.com/pages/category/Landmark---Historical-Place/Sher-Shah-Park-Wah-Cantt-2329607643938546/', 'Parks'),
(167, 'Fatima Jinnah Park', 'https://pakistantourism.net/fatima-jinnah-park-f-9', 'Parks'),
(168, 'haha', 'https://www.youtube.com/', 'Universities');

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

--
-- Table structure for table `job_applicant_details`
--

CREATE TABLE `job_applicant_details` (
  `id` int(11) NOT NULL,
  `applicant_name` text NOT NULL,
  `applicant_email` text NOT NULL,
  `cell_num` text NOT NULL,
  `applicant_resume` text NOT NULL,
  `applicant_aboutself` text NOT NULL,
  `applied_for_job` text NOT NULL,
  `job_posted_by` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `job_applicant_details`
--

INSERT INTO `job_applicant_details` (`id`, `applicant_name`, `applicant_email`, `cell_num`, `applicant_resume`, `applicant_aboutself`, `applied_for_job`, `job_posted_by`) VALUES
(1, 'Chaudhary Inzamam khan', 'Chinzamamk@gmail.com', '03065644519', 'resume/1579729250_Inzamamkhan.doc', '', 'UI/UX Designer', 'Sharjeelkhan'),
(2, 'Muhammad Subhan', 'msubhany69@gmail.com', '03118551097', 'Aoa sir how can i help u?', 'resume/inbound8804364299367990734.jpg', 'Content Writer', 'Sharjeelkhan');

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

--
-- Table structure for table `job_details`
--

CREATE TABLE `job_details` (
  `id` int(11) NOT NULL,
  `job_title` text NOT NULL,
  `job_category` text NOT NULL,
  `job_timing` text NOT NULL,
  `job_salary` text NOT NULL,
  `job_location` text NOT NULL,
  `job_lastdate` text NOT NULL,
  `job_description` text NOT NULL,
  `search_tags` text NOT NULL,
  `user_name` text NOT NULL,
  `user_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `job_details`
--

INSERT INTO `job_details` (`id`, `job_title`, `job_category`, `job_timing`, `job_salary`, `job_location`, `job_lastdate`, `job_description`, `search_tags`, `user_name`, `user_image`) VALUES
(13, 'UI/UX Designer', 'Designing', 'Morning Shift', '20000', 'Wah', '2020-09-10', ' We need UI/UX Graphic Designer for deisigning web and app design,\r\nSkills: Adobe Photoshop,Adobe illustrator, Coral Draw ', ' UI/UX Graphic Designer ', 'Sharjeelkhan', 'images/users/DSC_00243-removebg-preview.png'),
(18, 'Content Writer', 'Education', 'Part Time', '20000', 'Wah Cantt', '2020-09-02', 'We have a website, So we need a content writer who can write a blog and post it on our website daily basis', 'content writer', 'Sharjeelkhan', 'images/users/DSC_00243-removebg-preview.png');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `p_name` text NOT NULL,
  `p_price` text NOT NULL,
  `description` text NOT NULL,
  `p_link` text NOT NULL,
  `p_category` text NOT NULL,
  `p_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `products` (`id`, `p_name`, `p_price`, `description`, `p_link`, `p_category`, `p_image`) VALUES
(5, 'Pubg Mobile Controller with 4 Triggers', '$8.99', '✔ Six-Finger Operation: Playing mobile game with 6 fingers, define the button as you like and quickly upgrade your skills, improve your operational response and reduce embarrassment.\r\n✔ Ergonomic Design: This controller is adopt ergonomic design. Comfortable grip prevents sudden slipping, avoid sweat on screen that provides a good tactile experience for gamers.', 'https://amzn.to/3flZIzo', 'Mobile', 'images/shop/trigers.jpg'),
(6, 'OMOTON Desktop Cell Phone Stand', '$10.99', 'tfhtrhtr', 'https://amzn.to/2L7ko0g', 'Mobile', 'images/shop/mobile stand.jpg'),
(7, 'Kuxiu for GoPro Hero 7 6 5 4 3+ Action Camera', '$19.99', 'aaaaaa', 'https://amzn.to/2L1L3vg', 'Mobile', 'images/shop/goprostand.jpg'),
(8, 'Case for Samsung Galaxy S20 ', '$10.99', 's20', 'https://amzn.to/3bblEd6', 'Mobile', 'images/shop/s20case.jpg'),
(9, 'XLR Condenser Microphone', '$69.99', 'mic', 'https://amzn.to/2SD39ba', 'Electronics', 'images/shop/condenser mic.jpg'),
(10, 'Laptop Stand Desk with Phone Stand', '$15.95', 'laptop stand', 'https://amzn.to/2SGUZPf', 'Electronics', 'images/shop/laptop stand.jpg'),
(11, 'Makeup Brushes 16 PCs Makeup Brush Set', '$12.99', 'Mack up Brushes ', 'https://amzn.to/3fpD4pU', 'Women Fashion', 'images/shop/burshes mackup.jpg'),
(12, 'Carry All Makeup Train Case ', '$31.76', 'Mach up Set', 'https://amzn.to/2WuZYnb', 'Women Fashion', 'images/shop/mackup full set.jpg'),
(13, 'Laptop Tote Bag, Large Women Work Bag', '$26.99', 'Women Purse', 'https://amzn.to/2zjQfb6', 'Women Fashion', 'images/shop/womens purse.jpg'),
(14, 'Satchel Purses and Handbags', '$23.99', 'Black Purse', 'https://amzn.to/2W7fvdG', 'Women Fashion', 'images/shop/black purse.jpg'),
(15, 'Regular-Fit Short-Sleeve Poplin Shirt', '$4.25 - $17.94', 'Men Shirt', 'https://amzn.to/2YHuxZo', 'Men Fashion', 'images/shop/mans shirt.jpg'),
(16, 'Mens Running Shoes Womens', '$36.99 - $46.99', 'Men Shoes Red', 'https://amzn.to/3do8bAo', 'Men Fashion', 'images/shop/men shoes red.jpg'),
(17, 'Girls Full-Zip Active Jacket', '$13.38', 'Kid girl Jacket', 'https://amzn.to/2W7Ea1O', 'Kid Fashion', 'images/shop/kids girls jacket.jpg');

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

--
-- Table structure for table `softwares`
--

CREATE TABLE `softwares` (
  `id` int(11) NOT NULL,
  `software_name` text NOT NULL,
  `software_image` text NOT NULL,
  `software_link` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `softwares`
--

INSERT INTO `softwares` (`id`, `software_name`, `software_image`, `software_link`) VALUES
(5, 'Office 2016 Pro Plus Updated Sep 2019, 32 & 64 bit', 'images/softwares/Office2016.jpg', 'https://getintopc.com/softwares/office-tools/office-2016-pro-plus-updated-sep-2019-free-download-1049356/'),
(6, 'Videoscribe Pro Setup Free Download', 'images/softwares/Videoscribe-Pro.jpeg', 'https://getintopc.com/softwares/video-editing/videoscribe-pro-setup-free-download-2725259/'),
(7, 'Adobe Photoshop CC 2020 Free Download', 'images/softwares/Adobe-Photoshop-CC-2020.jpg', 'https://getintopc.com/softwares/photo-editing/adobe-photoshop-cc-2020-free-download-6627106/'),
(8, 'WinRAR Free Download', 'images/softwares/Winrar_4.10.png', 'https://getintopc.com/softwares/compression/winrar-free-download/'),
(9, 'Adobe Premiere Pro CC 2020 Free Download', 'images/softwares/adobe premium.png', 'https://getintopc.com/softwares/video-editing/adobe-premiere-pro-cc-2020-free-download/'),
(10, 'Chrome Free Download', 'images/softwares/chrome6f293bbfae451a37.png', 'https://www.google.com/chrome/');

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

--
-- Table structure for table `sub_newsletter`
--

CREATE TABLE `sub_newsletter` (
  `id` int(11) NOT NULL,
  `news_email` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sub_newsletter`
--

INSERT INTO `sub_newsletter` (`id`, `news_email`) VALUES
(6, 'mustafakhattak33@gmail.com'),
(7, 'asadmk345@gmail.com'),
(9, 'asadmk702@gmail.com'),
(10, 'asadmksoltech@gmail.com'),
(11, 'arifktk451@gmail.com'),
(12, 'expertcomputer07@gmail.com'),
(13, 'rehmatullahpyf@gmail.com'),
(14, 'M.ausama.47@gmail.com'),
(15, 'danyialkhalid8@gmail.com'),
(16, 'zeeshan.muneer93@gmail.com'),
(17, 'ammarmuqeem94@gmail.com'),
(21, 'sohailhamza156@gmail.com'),
(22, 'asadfarooq5082@gmail.com'),
(23, 'mspak465@gmail.com'),
(25, 'khanhadi482@gmail.com'),
(26, 'fawadkhattak9282@gmail.com'),
(27, 'muzzamil75@gmail'),
(28, 'raabta786@yahoo.com'),
(29, 'mesamnaqvi@gmail.com'),
(30, 'acegikmoqsuwyz@gmail.com'),
(31, 'nidahaq11@gmail.com'),
(32, 'sajidbhuttah@gmail.com'),
(33, 'shahidchishti78686@gmail.com'),
(34, 'naeemawankhaki@gmail.com'),
(35, 'ahmerkhan7240@gmail.com'),
(36, 'naeem284@gmail.com'),
(37, 'saqib.nauman23@gmail.com'),
(38, 'kseebal0914@gmail.com'),
(40, 'Nakhil14@gmail.com'),
(43, 'malaksiabkhan77@gmail.com'),
(45, 'imrealnida@gmail.com'),
(46, 'mehmaqudsia@yahoo.com'),
(47, 'bushsalahuddin@gmail.com'),
(48, 'awantanveer03@gmail.com'),
(50, 'angila.shoaib834@gmail.com'),
(51, 'ridabatool259@gmail.com'),
(52, 'sadaf.younis12@gmail.com'),
(54, 'khanhajra97@gmail.com'),
(55, 'bushrakhan78@icloud.com'),
(56, 'zil.khan66@gmail.com'),
(58, 'danyalzakki@gmail.com'),
(59, 'Malikmariafarooq@gmail.com'),
(60, 'arubaaltaf18@gmal.com'),
(63, 'siqra886@gmail.com'),
(65, 'wazeemamunib1@gmail.com'),
(66, 'tahirajaved54@yahoo.com'),
(67, 'ummaurayyan@gmail3'),
(68, 'anayakhan7811@gmail.com'),
(69, 'mujtababaig1999@gmail.com'),
(70, 'nulhuda039@gmail.com'),
(71, 'syedamutahiranaqvi.95@gmail.com'),
(72, 'tawab.ahmad031119@gmail.com'),
(73, 'hamzamaqsood35@gmail.com'),
(74, 'khabzubaria10@gmail.com'),
(75, 'shahbaz.shah98.ss@gmail.com'),
(76, 'javiriasabir@gmail.com'),
(77, 'zoyaa.ahmad143@gmail.com'),
(78, 'qaziseefi@gmail.com'),
(79, 'viruskhan03@gmail.com'),
(80, 'malik.taha.gul1877@gmail.com'),
(81, 'areejawan727@gmail.com'),
(86, 'manojdey23@gmail.com'),
(88, 'asadmksoltech@gmail.com'),
(90, 'housenmubarak@gmail.com'),
(91, 'housenmubarak@gmail.com'),
(92, 'housenmubarak@gmail.com'),
(93, 'housenmubarak@gmail.com'),
(94, 'housenmubarak@gmail.com'),
(95, 'housenmubarak@gmail.com'),
(96, 'housenmubarak@gmail.com'),
(97, 'housenmubarak@gmail.com'),
(98, 'housenmubarak@gmail.com'),
(99, 'housenmubarak@gmail.com');

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

--
-- Table structure for table `teachers`
--

CREATE TABLE `teachers` (
  `id` int(11) NOT NULL,
  `teacher_name` text NOT NULL,
  `teacher_subject` text NOT NULL,
  `teacher_qualifications` text NOT NULL,
  `teacher_experience` text NOT NULL,
  `teacher_current_tutoring` text NOT NULL,
  `teacher_cell_no` text NOT NULL,
  `teacher_email` text NOT NULL,
  `teacher_about` text NOT NULL,
  `teacher_image` text NOT NULL,
  `views` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`id`, `teacher_name`, `teacher_subject`, `teacher_qualifications`, `teacher_experience`, `teacher_current_tutoring`, `teacher_cell_no`, `teacher_email`, `teacher_about`, `teacher_image`, `views`) VALUES
(1, 'Muhammad kashif ', 'Physics', 'BS Physics, MS Physics (In Process)', '4 years', 'Lahore grammar school and college wah cant & Kips preparation wah cant campus ', '0334 5028572', 'muhammadkashifiiui@gmail.com', 'I have been teaching since last 4 years at intermediate, Bachelors and Masters level. Futhermore, you can also reach me for the preparation of MDCAT and ECAT. Thanks', 'images/teachers/kashif_bhai_wahpublic.jpg', '335'),
(2, 'Saeed khan', 'Mathematics', 'M.Phil, B.Ed', '3 years', 'F. G Degree College For Men wah Cantt', '0302578007', 'saeedanwar243991@yahoo.com', 'Learns and Teaches Mathematics', 'images/teachers/saeedbhaiimage.jpeg', '115'),
(3, 'Zeeshan Arif', 'Physics', 'BS (electronics) ', '2 years ', 'Rise and Shine Public school wah cantt ', '03025287867 ', 'muhammadzeshanarif@gmail.com', 'Physics and math teacher having experience of 2 years! ', 'images/teachers//IMG_20190429_183649.jpg', '77'),
(4, 'Zulfiqar Ali', 'Physics', 'MS Physics', '3 years ', 'Scholar Science College Wah Cantt', '03045698586', 'Xulfiqarntz@gmail.com', '', 'images/teachers/_DSC4253.jpg', '80'),
(5, 'Marium Mumtaz ', 'Computer', 'Msc computer science', '5 years', 'Real scholars school and college wahcantt', '0302-5373210', 'Mariummumtaz343@gmail.com', '', 'images/teachers/img_avatar2.png', '79'),
(6, 'Muhammad Ausama Saleem', 'Physics', 'M.Sc Physics', '4 years', 'Alhuda Montessori School and College', '03165011510', 'm.ausama.47@gmail.com', '', 'images/teachers/IMG_20190517_231358.jpg', '85'),
(7, 'Muhammad Ammar', 'Physics', 'BS-Electronics', '5 years', 'AL-Huda Montessori School & College, Wah', '03005676800', 'alnoor.34@hotmail.com', '', 'images/teachers/IMG-20190713-WA0002-1.jpg', '89'),
(8, 'Muhammad Ammar', 'Mathematics', 'BS-Electronics', '5 Years', 'AL-Huda Montessori School & College, Wah', '03005676800', 'alnoor.34@hotmail.com', 'Upto SSc. Level', 'images/teachers/IMG-20190713-WA0002-1.jpg', '87'),
(9, 'Muhammad Arslan', 'Physics', 'BS (Hons) Physics, MS Physics (Cont.)', '5 Years', 'Base Group of Colleges, Wah Cantt. ', '03009871122', 'marslanrs@gmail.com', '', 'images/teachers/20200215_230704.jpg', '66'),
(10, 'Atsham Ul Haq Ch', 'Statistics', 'MS (Statistics) ', '2 years', 'Hope collage of Science & Commerce ', '03495614785 ', 'shamch1510@gmail.com ', '', 'images/teachers/imgedit-20190428-WA0093.jpg', '58'),
(11, 'Muhammad Waqar', 'Physics', 'MSc ', '5 years', 'The Educationists School System wah model town', '03485518065', 'Waqarmuhammad192@gmail.com', '', 'images/teachers/img_avatar.png', '74'),
(12, 'Kashif Ghafoor', 'Physics', 'MS', '10 Years', 'F. G Degree College For Men (Wah Cantt) & The Scholar Science College (Wah Cantt))', '03335831727', 'ch.kashifghafoor@yahoo.co', 'Director:\r\n(The FAST Academy)\r\nLecturer: Physics \r\nF.G Degree College For Men Wah Cantt &\r\nThe Scholar Science College Wah Cantt\r\nI am member of subject (Physics)Committee in FBISE.\r\nI have been teaching since last 10 years at intermediate and Bachelors level. Futhermore, you can also reach me for the preparation of MDCAT and ECAT. Thanks', 'images/teachers/FB_IMG_1589438109859.jpg', '97'),
(13, 'Aqib', 'Mathematics', 'Electrical Engineering ', '4 Years ', 'Wah Cantt ', '03085094792', 'aqibasghar423@gmail.com ', 'Hi!!\r\nI\'m Aqib .I have been Graduated from Comsats University wah cantt. \r\nI can Teach Mathematics & Physics with giving students full Satisfaction & ease .\r\nIf We\'ll work together as a teacher & student then We both\' ll b helpful ...', 'images/teachers/img_avatar.png', '77'),
(14, 'Hamza Sohail', 'Computer', 'Mcs', '5 years', 'Alhuda Montessori School and College', '03365735699', 'sohailhamza156@gmail.com', 'Well experienced and qualified.', 'images/teachers/img_avatar.png', '74'),
(15, 'Ammar Muqeem', 'Chemistry', 'Msc + MS in progrees', '5 years', 'Base school wah cantt.', '03126082974', 'ammarmuqeem94@gmail.com', '', 'images/teachers/ammar.jpg', '275'),
(16, 'Hamza khalid', 'Physics', 'Electrical engineer ', '3 years', 'Al Huda School & College Wah Cantt', '03135733880', 'hk.5669613@gmail.com ', 'Got best teacher award in Alhuda Montessori school & college', 'images/teachers/img_avatar.png', '78'),
(17, 'Asad Farooq', 'Accountancy', 'M.com & MS management Science HR ongoing', '-', 'Wah Cantt ', '-', 'asadfarooq5082@gmail.com', 'Financial Accounting, Cost Accounting, Banking & Finance  ', 'images/teachers/asad farooqq.jpeg', '177'),
(18, 'Chaudhary Inzamam khan', 'Computer', 'BSCS hons ', '4 years', 'Indus college wah cantt', '03065644519', 'chinzamamk@gmail.com', 'I have been serving as a lecturer of Computer Sciences at Intermediate and Bachelors level since last 4 years. This includes the prominent Colleges and Academies of Wah Cantt and Surroundings. You Can reach me at the aforementioned contact info', 'images/teachers/inzibhai.png', '89'),
(19, 'Nouman Haris', 'Mathematics', 'Msc.Mathematics', '4 years online teaching experience', 'Online', '03048739953', 'hariss.0331@gmail.com', '', 'images/teachers/img_avatar.png', '87'),
(20, 'Abdul hadi', 'Mathematics', 'M.phil Mathematics', '2 years ', 'Punjab Superior College Taxila', '0312 0896128', 'Khanhadi482@gmail.com', '', 'images/teachers/CamScanner 04-14-2020 13.34.16 - Page 12.jpg', '65'),
(21, 'Muhammad Ismail', 'Mathematics', 'MA/ Bsc/ M.Ed', '22 years', 'FG model public school Wah Cantt', '03005075463', 'ismailnoor267@gmail.com', 'Teaching Matric level all science subjects. \r\nAlso Teaching O level Math ,Physics and Chemistry', 'images/teachers/img_avatar.png', '65'),
(22, 'Ali Afaq', 'Medical Sciences', 'Physiotherapist', '3 Years', 'University of Lahore', '03028755795', 'ali.afaq.426@gmail.com', '', 'images/teachers/inbound9050897599534995679.jpg', '196'),
(23, 'AMJAD SHEHZAD', 'Urdu', 'MA ', '15 YEARS', 'WAH COLLEGE OF ACCOUNTANCY, WAH CANTT', '03005192709', 'amjadshahzad7866@gmail.com', '', 'images/teachers/amjad_shahid_wahpublic.jpg', '76'),
(24, 'AMJAD SHEHZAD', 'English', 'MA ', '15 YEARS', 'WAH COLLEGE OF ACCOUNTANCY, WAH CANTT', '03005192709', 'amjadshahzad7866@gmail.com', '', 'images/teachers/amjad_shahid_wahpublic.jpg', '126'),
(25, 'Dr Haris ', 'Medical Sciences', 'Mbbs ', '1 yr', 'Practising final year mbbs in railway ', '03215684080', 'Harisnawab72@gmail.com ', 'I am a mbbs final year student.\r\nAnd Im best at teaching  any subject related to mbbs e.g\r\n\r\nPhysiology\r\nMedicine \r\nPharma\r\nSurgery ', 'images/teachers/img_avatar.png', '53'),
(26, 'Muhammad Irfan', 'Accountancy', 'ACMA', '15 Years', 'SKANs school of Accountancy', '03458502010', 'Irfanacma79@gmail.com', 'He has a vast experience of teaching CA,CMA,ACCA,M.Com and PIPFA students throughout his Career. You can consult him for subjects like Taxation, Audit & Assurance, Mercantile & Company Law, Financial, Management and Cost Accounting.', 'images/teachers/WhatsApp Imag sir irfan Wahpublic.jpeg', '32');

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

--
-- Table structure for table `teachers_approve`
--

CREATE TABLE `teachers_approve` (
  `id` int(11) NOT NULL,
  `teacher_name` text NOT NULL,
  `teacher_subject` text NOT NULL,
  `teacher_qualifications` text NOT NULL,
  `teacher_experience` text NOT NULL,
  `teacher_current_tutoring` text NOT NULL,
  `teacher_cell_no` text NOT NULL,
  `teacher_email` text NOT NULL,
  `teacher_about` text NOT NULL,
  `teacher_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `teachers_approve`
--
ALTER TABLE `teachers_approve`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;
COMMIT;

