-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 12, 2024 at 09:48 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `arab`
--
-- --------------------------------------------------------
--
-- Table structure for table `aboutfirst`
--
CREATE TABLE IF NOT EXISTS `aboutfirst` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`images` varchar(100) NOT NULL,
`subtitle` text NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `aboutfirst`
--
INSERT INTO `aboutfirst` (`id`, `images`, `subtitle`, `title`, `description`, `message`) VALUES
(17, '1720769320.jpg', '', 'Arab Gate ', 'we specialize in a diverse range of topquality services to meet your varied needs. our premier photography studio is the heart of our business, offering professional photo and video services that capture your most cherished moments with creativity and precision. whether it''s portraits, events, commercial shoots, or videography, our experienced team is dedicated to delivering stunning results. In addition to our studio work, we provide efficient Qatar government services, ensuring seamless processing of all your official documentation and visa needs. our trading division connects you with the best suppliers, while our comprehensive typing and printing services cater to all your documentation requirements with accuracy and speed
\r\nAt Arab gate , our team of experienced photographers, designers, and editors collaborates closely to tailor solutions to meet each client''s specific needs. supported by a large network of trusted professionals, we ensure that every project is executed with precision and creativity. By working closely with our clients, we deliver the highest quality outcomes promptly and professionally. \r\n\r\n', '');
-- --------------------------------------------------------
--
-- Table structure for table `banner`
--
CREATE TABLE IF NOT EXISTS `banner` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`image` varchar(100) NOT NULL,
`title` text NOT NULL,
`description` text NOT NULL,
`description2` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
--
-- Dumping data for table `banner`
--
INSERT INTO `banner` (`id`, `image`, `title`, `description`, `description2`) VALUES
(29, 'photo29.jpg', 'Welcome To', 'Arab Gate', 'STUDIO \r\nTYPING SERVICES \r\nTRADING '),
(31, 'simg31.png', 'Welcome To', 'Arab Gate', 'STUDIO \r\nTYPING SERVICES \r\nTRADING '),
(32, 'photo32.webp', 'Welcome To', 'Arab Gate', 'STUDIO \r\nTYPING SERVICES \r\nTRADING');
-- --------------------------------------------------------
--
-- Table structure for table `contact`
--
CREATE TABLE IF NOT EXISTS `contact` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`email` text NOT NULL,
`number` text NOT NULL,
`subject` text NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=90 ;
--
-- Dumping data for table `contact`
--
-- --------------------------------------------------------
--
-- Table structure for table `contactinfo`
--
CREATE TABLE IF NOT EXISTS `contactinfo` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`customer` text NOT NULL,
`customer2` text NOT NULL,
`email` text NOT NULL,
`email2` text NOT NULL,
`address1` text NOT NULL,
`address` text NOT NULL,
`whatsapp` text NOT NULL,
`opening` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `contactinfo`
--
INSERT INTO `contactinfo` (`id`, `title`, `customer`, `customer2`, `email`, `email2`, `address1`, `address`, `whatsapp`, `opening`) VALUES
(5, ' +974 40170937', '+974 71979709', '+974 71927959', 'arabgateqatar@gmail.com ', 'arabgatestudio@gmail.com', '', 'Unit 01, Building number 08, Area, Al Kharaitiyat, Umm Salal Muhammed, 71 Street 445, Doha, Qatar', '+97471927959', '');
-- --------------------------------------------------------
--
-- Table structure for table `gallery`
--
CREATE TABLE IF NOT EXISTS `gallery` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`image` varchar(300) NOT NULL,
`title` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;
--
-- Dumping data for table `gallery`
--
INSERT INTO `gallery` (`id`, `image`, `title`) VALUES
(20, 'photo20.webp', 'MUG PRINTING'),
(21, 'photo21.png', 'modern'),
(22, 'photo22.png', 'Granite Stones With Hand Made'),
(23, 'photo23.png', 'Food Photography'),
(24, 'photo24.png', 'Food Photography'),
(25, 'photo25.png', 'Food Photography'),
(26, 'photo26.png', 'Kids photoshoot'),
(27, 'photo27.png', 'portrait'),
(28, 'photo28.png', 'Birthday photoshoot');
-- --------------------------------------------------------
--
-- Table structure for table `login`
--
CREATE TABLE IF NOT EXISTS `login` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uname` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `login`
--
INSERT INTO `login` (`id`, `uname`, `password`) VALUES
(1, 'admin', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `mission`
--
CREATE TABLE IF NOT EXISTS `mission` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `mission`
--
INSERT INTO `mission` (`id`, `title`, `description`) VALUES
(11, '', 'Our team of experienced photographers, designers, and editors collaborates closely to tailor solutions to meet each client''s specific needs. supported by a large network of trusted professionals, we ensure that every project is executed with precision and creativity. !\r\n');
-- --------------------------------------------------------
--
-- Table structure for table `project`
--
CREATE TABLE IF NOT EXISTS `project` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`category` text NOT NULL,
`image` varchar(200) NOT NULL,
`title` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;
--
-- Dumping data for table `project`
--
INSERT INTO `project` (`id`, `category`, `image`, `title`) VALUES
(34, 'On Going', '00IMG-20210812-WA0007.jpg', 'Building and Constructions'),
(41, 'On Going', '73IMG-20210812-WA0010.jpg', 'Building and Constructions'),
(42, 'On Going', '84IMG-20210812-WA0017.jpg', 'Building and Constructions'),
(44, 'On Going', '106IMG-20210812-WA0019.jpg', 'Building and Constructions'),
(47, 'Completed', '0project-2-370x245.jpg', 'Building and Constructions '),
(48, 'Completed', '0project-7-440x280.jpg', 'Building and Constructions '),
(49, 'Completed', '0project-4-370x245.jpg', 'Building and Constructions ');
-- --------------------------------------------------------
--
-- Table structure for table `projects`
--
CREATE TABLE IF NOT EXISTS `projects` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `projects`
--
INSERT INTO `projects` (`id`, `title`, `description`) VALUES
(6, 'On-going Projects', '• Mr. Vedayasapai, Residence, Thammanam
\r\n• Dr.Hema Residence, Thrissur
\r\n• Mrs. InduRajn’s Residence, Thrissur
\r\n• Mr. Vijayachandran Residence, Perumbavoor
\r\n• Dr.Honey Residence, Nadikkara, Thrissur
\r\n• Mr.Satheesan Residence, West Kadungaloor'),
(7, 'Completed projects', '• Mr. Deepak, Residential Apartment, Kottai, Nedumbassery
\r\n• Mr.Vidhyadharan, Residence, Pavarty
\r\n• Dr. Venugopal, Residence, Patturakkal
\r\n• Mr.Roy Varghese, Residence, Thripunithura
\r\n• Mr. Biju Thomas, Residence, UC collage
\r\n• Mr. Rajesh Cheriyan, Residence, UC collage
\r\n• Dr. Narayanamenaon, Residence, Sreemoolanagaram
\r\n• Mr. Ganeshpai, Residence, Thammanam');
-- --------------------------------------------------------
--
-- Table structure for table `ser`
--
CREATE TABLE IF NOT EXISTS `ser` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `ser`
--
INSERT INTO `ser` (`id`, `title`) VALUES
(4, 'On Going'),
(5, 'Up Coming'),
(6, 'Completed');
-- --------------------------------------------------------
--
-- Table structure for table `services`
--
CREATE TABLE IF NOT EXISTS `services` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
`images` varchar(100) NOT NULL,
`description` text NOT NULL,
`description2` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;
--
-- Dumping data for table `services`
--
INSERT INTO `services` (`id`, `title`, `images`, `description`, `description2`) VALUES
(29, 'Digital Albums', '1720771803.png', 'Light Weight & High Quality\r\n
\r\nArab Gate studio Offers the full range of print services\r\nand customised solutions to a diverse set of client\r\nacross all business segments and PhotoBooks/ Albums.\r\nOur passion for innovation and reserch in new print\r\ntechniques has enabled us to make value additions\r\nin several areas of print.', ''),
(30, 'Gift And Frames', '1720771878.jpg', '\r\n\r\nWe have successfully made our presence known globally by delivering products without compromising the quality. Our products have been finding a wide range of consumers in commercial complexes and residential villas because of their well-finished and uncompromised strength and durability. Coupled with environment-enhancing modern and classic design, with our expert technicians developing and designing frames into exquisite designs. Our main focus is our customers'' satisfaction as well as good and long-lasting relationships. Our entire operations have been supported by a qualified and experienced team to satisfy client demand and provide the best services and solutions.\r\n\r\n \r\n ', 'Our services include
\r\n \r\n \r\n\r\n\r\n- Granite Stones\r\nWith Hand Made
\r\n- modern
\r\n- MUG PRINTING
\r\n\r\n- ID PRINTING
\r\n- T SHERT PRINTING
\r\n- MEMENTOS
\r\n - OFFICE BOARD
\r\n\r\n\r\n\r\n\r\n\r\n \r\n '),
(31, 'Print Media', '1720772048.webp', 'Arab Gate in wedding photography/cinematography, event coverage, fashion photography, portfolios, add shoots, maternity shoots, baby shoots, baptism shoots, and more. Arab Gate, one of the leading professional wedding photographers based in kharaitiyat, Doha - Qatar will tell the beautiful story of your special day. When it comes to planning your wedding there are a lot of things to think about, it is very difficult to choose the best wedding photography in Doha and also if it comes to all over Doha. We work hard to be the best wedding photography in kharaitiyat, Doha - Qatar. We avail our services around the globe. We ensure to make your big day unique and the most memorable ones in your life with our excellent service, best quality outputs, and products. Our services make your memories immortal. Professional excellence has made Arb GAte the best candid wedding photography around the globe.\r\n\r\n \r\n', ''),
(32, 'Photography And Videography', '11720772341.webp', 'Arab Gate in wedding photography/cinematography, event coverage, fashion photography, portfolios, add shoots, maternity shoots, baby shoots, baptism shoots, and more. Arab Gate, one of the leading professional wedding photographers based in kharaitiyat, Doha - Qatar will tell the beautiful story of your special day. When it comes to planning your wedding there are a lot of things to think about, it is very difficult to choose the best wedding photography in Doha and also if it comes to all over Doha. We work hard to be the best wedding photography in kharaitiyat, Doha - Qatar. We avail our services around the globe. We ensure to make your big day unique and the most memorable ones in your life with our excellent service, best quality outputs, and products. Our services make your memories immortal. Professional excellence has made Arb GAte the best candid wedding photography around the globe.\r\n\r\n\r\n', 'Our services include
\r\n \r\n \r\n\r\n\r\n- wedding
\r\n- Birthday
\r\n- Documentary Film
\r\n\r\n- Ad Film
\r\n- short Film
\r\n- Interview
\r\n - company video Profile
\r\n - Personal
\r\n\r\n- PRODUCT
\r\n- FOOD PHOTOGRAPHY
\r\n- WEDDING
\r\n- NEWBORN PHOTOGRAPHY
\r\n - PHOTO DOCUMENTARY
\r\n - PHOTO COMMERCIAL
\r\n - CREATIVE PHOTO BOOK
\r\n\r\n');
-- --------------------------------------------------------
--
-- Table structure for table `servicesother`
--
CREATE TABLE IF NOT EXISTS `servicesother` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`description` text NOT NULL,
`images` text NOT NULL,
`description2` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `servicesother`
--
INSERT INTO `servicesother` (`id`, `title`, `description`, `images`, `description2`) VALUES
(5, 'Typing & Government Service', 'Our services include
\r\n \r\n \r\n\r\n\r\n\r\n- Company Registration and Licensing
\r\n- Company Bank Acounut Opening
\r\n- Government Liaison Services
\r\n- Legal Compliance and Advisory
\r\n - Labour and Immigration Services
\r\n- Work Permits : Assistance with obtaining and renewing
\r\n- work permits for employees.
Labour Contracts : Preparation and submission of \r\n- labour contracts as per Qatari regulations. NOC Processing : Facilitation of No Objection Certificates (...
\r\n- Visa Application Assistance
\r\n- Visa Renewal and Extension
\r\n- Visa Cancellation
\r\n- Document Attestation
\r\n- Legalization : Attestation of documents required for visa applications, including educational certificates,
\r\n- marriage certificates, and more. (MOFA) attestation services for various documents
\r\n \r\n\r\n\r\n', '1720773323.webp', '');
-- --------------------------------------------------------
--
-- Table structure for table `socialmedia`
--
CREATE TABLE IF NOT EXISTS `socialmedia` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`link` text NOT NULL,
`insta` text NOT NULL,
`twitter` text NOT NULL,
`linkedin` text NOT NULL,
`youtube` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `socialmedia`
--
INSERT INTO `socialmedia` (`id`, `link`, `insta`, `twitter`, `linkedin`, `youtube`) VALUES
(7, '', '', '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `testimonial`
--
CREATE TABLE IF NOT EXISTS `testimonial` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`images` varchar(200) NOT NULL,
`name` varchar(200) NOT NULL,
`msg` text NOT NULL,
`status` text NOT NULL,
`designation` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=89 ;
--
-- Dumping data for table `testimonial`
--
INSERT INTO `testimonial` (`id`, `images`, `name`, `msg`, `status`, `designation`) VALUES
(85, '1710234550.jpg', 'JERRY SKINNER', '“ I have worked with AKSA BUILDERS Construction Services for years, they have consistently delivered fair pricing, quality workmanship and complete projects on schedule. I appreciate the level of customer service they deliver by going above and beyond expectations. â€
', '1', 'Kerala'),
(86, '1710234678.jpg', 'NITHIN', 'I Have to choose for the home interior and from what was present to me, it looks like Atlas was the most professional and well-experienced organization.
', '1', 'Kerala'),
(87, '1710234740.jpg', 'SONU', 'We are proud to appreciate AKSA Engineers and Builders for their time bound and quality completion of the project and would render more projects to them.
', '1', 'Kerala'),
(88, '1710234800.jpg', 'JOSEPH', 'It was a great feeling to be a part of Atlas Construction. We wish them all success in future and looking toward their future plans.
', '1', 'Kerala');
-- --------------------------------------------------------
--
-- Table structure for table `video`
--
CREATE TABLE IF NOT EXISTS `video` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`url1` text NOT NULL,
`type1` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
--
-- Dumping data for table `video`
--