database1.sql

-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 23, 2018 at 07:08 AM
-- Server version: 10.1.29-MariaDB
-- PHP Version: 7.2.0

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `database1`
--

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

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

CREATE TABLE `products` (
  `pid` int(11) NOT NULL,
  `pname` varchar(255) NOT NULL,
  `pfullname` varchar(255) NOT NULL,
  `p_type` varchar(255) NOT NULL,
  `p_des` longtext NOT NULL,
  `p_image` text NOT NULL,
  `p_link` text NOT NULL,
  `highlight` longtext NOT NULL,
  `price` float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`pid`, `pname`, `pfullname`, `p_type`, `p_des`, `p_image`, `p_link`, `highlight`, `price`) VALUES
(1, 'msj7', 'SAMSUNG GALAXY J7', 'mobile', '1) 13MP primary camera with auto mode, beauty face, continuous shot, interval shot, panorama mode and 5MP front facing camera with palm gesture selfie and 120 degree selfie mode<br>\r\n2) 13.86 centimeters (5.5-inch) TFT capacitive touchscreen with 720 x 1280 pixels HD display<br>\r\n3) Android v6.0 Marshmallow operating system with 1.2GHz QualComm Snapdragon quad core processor, 2GB RAM, 16GB internal memory expandable up to 128GB and dual SIM (micro+micro) dual-standby (4G+4G)<br>\r\n4) Removable Li-Ion 3000 mAh battery.<br>\r\n5) 1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 'mobile/samsung/galaxyj7.jpg', 'https://www.amazon.in/Samsung-G-600FY-On7-Pro-Gold/dp/B01DDP7D6W?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=480f29c5-70c9-4b37-a2bf-c3757695b9f1', '<br><br><li>6 GB RAM | 64 GB ROM | Expandable Upto 400 GB</li><br><br>\r\n	<li>6.2 inch Quad HD+ Display</li><br><br>\r\n	<li>12MP + 12MP Dual Rear Camera | 8MP Front Camera</li><br>\r\n	<li>3500 mAh Battery</li>', 7990),
(2, 'mss8', 'Samsung Galaxy S8', 'Mobile', 'Samsungs S8 series. The name says it all. The Samsung S8 is a stunner, with revolutionary design that features the very latest in technology - both hardware and software, so it is fast, powerful and intuitive. Samsung has aimed to make this phone larger-than-life, to be more than just smartphones', 'mobile/samsung/s8.jpg', 'https://www.amazon.in/Samsung-Galaxy-Midnight-Black-RAM/dp/B06Y3GYZKW/ref=sr_1_1?s=electronics&ie=UTF8&qid=1521133095&sr=1-1&keywords=samsung+s8', '<br><br>4 GB RAM | 64 GB ROM | Expandable Upto 256 GB <br><br>\r\n5.8 inch Quad HD+ Display<br><br>\r\n12MP Rear Camera | 8MP Front Camera<br><br>\r\n3000 mAh Battery\r\n<br><br>\r\nExynos 8895 Processor<br>', 45990),
(5, 'mss4', 'Samsung Galaxy S4', 'Mobile', 'Intelligent Interface and Super Processor The Samsung Galaxy GT-I9500 has a 1.6GHz Quad core plus 1.2GHz Quad core processor gives you unbelievable speeds. The 2GB RAM only adds to its efficiency. Featuring the Android 4.2.2 Jelly Bean operating system, this Samsung Galaxy S4 has a 16GB internal memory that is expandable up to 64GB. The 5-inch touch screen has a 1080p resolution, Camera: 13MP primary camera; 2MP front-facing camera Display: 5-inch super AMOLED scratch resistant screen Display Resolution: 1920 x 1280 pixels Operating System: Android Jelly Bean 4.2.2 Processor: 1.6GHz Quad Core + 1.2GHz Quad Core Processor Memory: 16GB internal memory, expandable up to 64GB Battery: 2,600mAh battery with 17 and 370 hours talk time and standby tim Technical Details OS	Android RAM	2 GB Item Weight	132 g Product Dimensions	13.7 x 7 x 0.8 cm Item model number	Galaxy S4 I9500 Wireless communication technologies Bluetooth, Wifi Hotspot Connectivity technologies	GSM, (850/900/1800/1900 MHz), GPRS, EDGE, 3G, HSPA, (850/900/1900/2100 MHz) Special features	Voice Calling, Video Calls, GPS, Music Player, Video Player, FM Radio, Accelerometer sensor, Geomagnetic sensor, Gyro sensor, Light sensor, Pressure sensor, Proximity sensor, Gesture sensor, E-mail Device interface - primary	Touch Screen Form factor	Touchscreen Phone Weight 130 Grams Colour	White Frost Battery Power Rating	2600.00 Phone Talk Time	1020 Minutes Phone Standby Time (with data)	370 Hours Whats in the box	Mobile Phone, Battery, Data Cable, Charger and Headset Warranty & Support Warranty', 'mobile/samsung/s4.jpg', 'https://www.ebay.in/itm/272920682611?aff_source=Sok-Goog', '<br> Sim Type:	Dual SIM<br><br>	Serviced In India:	Yes<br><br>\r\nBrand:	Samsung	Secondary <br><br>\r\nModel:	GALAXY S4 GT I9500	<br><br>Warranty Service:	Repair<br><br>\r\nColour:	Black	', 8486),
(6, 'msj3', 'Samsung Galaxy J3', 'Mobile', ' Certified Refurbished products on Amazon Renewed have been tested and certified to work and look like new by a qualified manufacturer or a specialized third-party refurbisher. The products are refurbished in India and the refurbishment process typically includes a full diagnostic test, replacement of any defective parts, a thorough cleaning and inspection process, and repackaging. The product comes with relevant accessories (headphones may not be included) and is backed by a minimum six month seller or brand warranty', 'mobile/samsung/j3.jpg', 'https://www.ebay.in/itm/273098942203?aff_source=Sok-Goog', '<br>                                                                                                               OS	Android<br><br>\r\nRAM	1.5 GB<br><br>\r\nItem Weight	136 g<br><br>\r\nProduct Dimensions	14.2 x 0.8 x 7.1 cm<br><br>\r\nBatteries:	1 Lithium Metal batteries required. (included<br><br>\r\nItem model number	Galaxy J3<br><br>\r\nWireless communication technologies	Bluetooth, WiFi Hotspot<br><br>\r\nConnectivity technologies	GSM, 2G, 3G, WCDMA, 4G LTE, WiFi<br><br>\r\nSpecial features	Dual SIM, Music Player, Video Player, Accelerometer, Proximity sensor, E-mail<br><br>\r\nOther camera features	5MP<br><br>\r\nForm factor	Touchscreen Phone<br><br>\r\nWeight	136 Grams', 6899),
(7, 'msn8', 'Samsung Galaxy Note 3', 'mobile', 'The Note 3 comes with a palette of 5 useful features that you can use with the S Pen – hover over the screen and click the pen button to access Action Memo, Scrapbook, S Finder, Pen Window and Screen Write every feature designed to make everyday actions simpler and easier to perform.<br>A phone designed to look every bit the performer that it is; the Note 3 sports a premium feel that is sure to garner more than just glances. But not at the cost of sturdiness - the phone is not delicate and does not get scratched easily either.<br>A quick peek just does not do justice to the 5.7 inch Super AMOLED screen to keep your eyes hooked, bringing visuals that are sharp, bright with astounding levels of clarity and upgrading everything you do to full HD resolution.', 'mobile/samsung/galaxynote3.jpg', 'https://www.flipkart.com/samsung-galaxy-note-3-classic-white-32-gb/p/itmebptbueecaxr2?pid=MOBDZQ2EZM3TAFBX&srno=s_1_1&otracker=search&lid=LSTMOBDZQ2EZM3TAFBXYOIGDT&fm=SEARCH&iid=2d84f51c-adea-47a5-9417-0e4146108471.MOBDZQ2EZM3TAFBX.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=vy0c5r7a9s0000001523278103920&qH=ea776ce547ae6aaa', '<br><br>3 GB RAM | 32 GB ROM | Expandable Upto 64 GB<br><br>\r\n5.7 inch Full HD Display<br><br>\r\n13MP Rear Camera | 2MP Front Camera.<br><br>\r\n3200 mAh Li-Ion Battery<br>', 37127),
(8, 'msc7', 'Samsung Galaxy C7', 'mobile', 'A social media manager or a blogger - no matter what profession you’re into, it’s important to stay connected throughout. Get your hands on the Samsung Galaxy C7 Pro and experience a glitch-free performance even when you use multiple apps, thanks to its 64-bit octa-core processor and 4 GB of RAM.<br>Slim yet Powerful<br>\r\nThis phone is as good looking as it’s functional - it features a full metal body with a powerful 2.5D glass and solid curves all packed inside a slim 7 mm frame.<br>You can switch between multiple apps, play games, browse the Internet and do much more without lag as it\'s powered by a 64-bit octa-core processor and 4 GB of RAM.', 'mobile/samsung/galaxyc7.jpg', 'https://www.flipkart.com/samsung-galaxy-c7-pro-navy-blue-64-gb/p/itmew8qbncvqfhh4?pid=MOBEW8QBJQYYDKKR&lid=LSTMOBEW8QBJQYYDKKRR5ZYHH&marketplace=FLIPKART&srno=s_1_1&otracker=search&fm=SEARCH&iid=de22fc5c-2ff9-4869-b5e7-e7cd592c77ba.MOBEW8QBJQYYDKKR.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=c01dbxyww00000001523278933067&qH=310b61e5d8ac99c1', '<br><br>4 GB RAM | 64 GB ROM | Expandable Upto 256 GB\r\n5.7 inch Full HD Display<br><br>\r\n16MP Rear Camera | 16MP Front Camera<br><br>\r\n3300 mAh Battery<br><br>\r\nQualcomm Snapdragon Octa-Core 2.2GHz Processor', 24990),
(9, 'mn8', 'Nokia 8', 'mobile', 'Dual SIM, GPS, Music Player, Video Player, Ambient light sensor, Proximity sensor, Accelerometer, eCompass, Gyroscope, Fingerprint sensor, Hall sensor, Barometer, E-mail<br>The Nokia 8 undergoes a rigorous 40-stage process of machining, anodizing and polishing to ensure its distinctive design pairs flawlessly with the polished aluminium unibody. The ultimate in seamless unibody construction, Nokia 8 is designed to nestle perfectly in the palm of your hand.<br>1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 'mobile/nokia/n8.jpeg', 'https://www.amazon.in/Nokia-Mobile-8-Steel-64GB/dp/B072LNNSQQ/ref=sr_1_1?s=electronics&ie=UTF8&qid=1523279190&sr=1-1&keywords=nokia+8', '<br><br>.13MP (Colour + OIS) + 13MP (Mono) primary camera and display flash<br><br>\r\n13.46 centimeters (5.3-inch) IPS QHD capacitive touchscreen with 2560 x 1440 pixels resolution and 2.5D Corning Gorilla Glass 5<br><br>\r\nAndroid v7.1.1 Nougat operating system with Qualcomm Snapdragon 835 Octa Core processor, 4GB RAM, 64GB internal memory expandable up to 256GB and dual SIM (nano+ nano) dual-standby (4G+4G); Hybrid Sim Slot', 27095),
(10, 'mn3', 'Nokia 3', 'mobile', 'Internal memory: 16 GB, RAM: 2 GB, Micro SD slot: Support for up to 128 GB, Operating system AndroidTM 7.0 Nougat CPU: MTK 6737, Quad-core 1.3Ghz, Size and type: 5.0 IPS LCD, Resolution HD (1280 x 720, 16:9) Primary camera: 8MP AF, 1.12um, f/2, LED flash, Front-facing camera: 8MP AF, 1.12um, f/2, FOV 84 degrees Network speed: LTE Cat. 4, 150Mbps DL/50Mbps UL, Networks GSM: 850/900/1800/1900, WCDMA: Band 1, 2, 5, 8, LTE: Band 1, 3, 5, 7, 8, 20, 28, 38, 40 Audio Connector: 3.5 mm headphone jack, Speakers: Single speaker Connectivity: Micro USB (USB 2.0), USB OTG, Bluetooth, Wi-Fi, Sensors Accelerometer (G-sensor), ambient light sensor, e-compass, gyroscope, proximity sensor, NFC for sharing Battery type: Integrated 2630 mAh battery', 'mobile/nokia/n3.jpg', 'https://www.amazon.in/Nokia-3-Matte-Black/dp/B072NCDTK9/ref=sr_1_1?s=electronics&ie=UTF8&qid=1523279772&sr=1-1&keywords=nokia+3', '<br><br>Operating system - Android 7.0 Nougat\r\nCPU - MTK 6737, Quad-core 1.3Ghz<br><br>\r\nRAM 2 GB<br><br>\r\nSize and type - 5.0 IPS LCD, Resolution HD - (1280 x 720, 16:9)<br><br>\r\nMaterial - 2.5D sculpted Corning Gorilla Glass<br><br>\r\nBattery type - Integrated 2630 mAh battery3<br><br>\r\nStorage: Internal memory - 16 GB, MicroSD slot Support for up to 128 GB', 8230),
(11, 'mn216d', 'Nokia 216 Dual', 'mobile', '0.3MP primary camera with LED flash and 0.3MP front facing camera 696 centimeters (2.4-inch) QVGA display with 230 x 320 pixels resolution Series 30+ operating system, 16MB RAM, 16MB internal memory expandable up to 32GB and dual SIM (2G+2G) 1020mAH lithium-ion<br>The Nokia 216 with the opera mini browser allows you access to popular web content. Discover and download more apps and games using the opera mobile store. Share your selfies and important moments withfriends and family through facebook. But the fun doesn’t stop there: we’ve also included one free gameloft game every month for a year. Game on.<br>Enjoy high quality voice calls, outstanding battery life, a built-in torchlight, FM Radio, MP3 and video player, up to 18 hours talk time, up to 24 days standby time, Bluetooth 3.0 and Bluetooth audio support for headsets. Space for up to 2000 contacts.', 'mobile/nokia/n216.jpg', 'https://www.amazon.in/Nokia-216-Black/dp/B01M69DXTB/ref=sr_1_1?s=electronics&ie=UTF8&qid=1523280204&sr=1-1&keywords=nokia+216+dual', '<br><br>0.3MP primary camera with LED flash and 0.3MP front facing camera<br><br>\r\n696 centimeters (2.4-inch) QVGA display with 230 x 320 pixels resolution<br><br>\r\nSeries 30+ operating system, 16MB RAM, 16MB internal memory expandable up to 32GB and dual SIM (2G+2G)\r\n1020mAH lithium-ion<br><br>\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 2317),
(12, 'mn2', 'Nokia 2', 'mobile', '\r\nNokia 2 comes with a 5.00-inch touchscreen display with a resolution of 720 pixels by 1280 pixels. The nokia 2 is powered by 1.3ghz quad-core qualcomm snapdragon 212 processor and it comes with 1gb of ram. The phone packs 8gb of internal storage that can be expanded up to 128gb via a micro SD card as far as the cameras are concerned, the nokia 2 packs a 8-megapixel primary camera on the rear and a 5-megapixel front shooter for selfies. the nokia 2 runs android 7.1.1 and is powered by a 4100mah non removable battery. it measures 143.50 x 71.30 x 9.30 (height x width x thickness),nokia 2 is a dual sim (gsm and gsm) smartphone that accepts nano-sim and nano-sim. Connectivity options include wi-fi, gps, bluetooth, usb otg, fm, 3g and 4g (with support for band 40 used by some lte networks in india). sensors on the phone include compass magnetometer, accelerometer and ambient light sensor.', 'mobile/nokia/n2.jpg', 'https://www.flipkart.com/nokia-2-copper-black-8-gb/p/itmff6mwdyg6fgdt?pid=MOBF27B4QFANGDSU&srno=s_1_1&otracker=search&lid=LSTMOBF27B4QFANGDSUSLDULL&fm=SEARCH&iid=cb6f77c7-c4e6-49ea-8c37-6633a39c7078.MOBF27B4QFANGDSU.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=3pe39zg0dc0000001523280534946&qH=55b71a3a5a327dc0', '<br><br>1 GB RAM | 8 GB ROM |\r\n5 HD Display<br><br>\r\n8MP Rear Camera | 5MP Front Camera<br><br>\r\n4100 Battery<br>', 6399),
(13, 'mnn130', 'Nokia N130', 'mobile', 'Beautifully made with a polycarbonate shell that keeps its colour even when scratched, the Nokia 130 is built to take on everyday life. Colour matching keys on the glossy front and a matte black finish perfectly round off this modern design<br>The Nokia 130 features an MP3 player and up to 32GB expandable storage, so your music collection is always close to hand. Link up to wireless speakers with Bluetooth connectivity to bring music to any occasion. If it\'s variety that you\'re looking for, simply plug in your headset and switch over to the FM radio.', 'mobile/nokia/n130.jpeg', 'https://www.amazon.in/Nokia-130-DS-Black/dp/B0751LW988/ref=sr_1_1?s=electronics&ie=UTF8&qid=1523280993&sr=1-1&keywords=nokia+130', '<br><br>0.3MP primary camera\r\n4.57 centimeters (1.8-inch) with 160 x 128 pixels resolution<br><br>\r\nS30+ operating system, 4MB RAM, 8MB internal memory expandable up to 32GB and dual SIM (mini+mini)<br>\r\n1020mAH lithium-ion battery<br><br>\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase<br><br>\r\nMP3/FM Radio/ Micro-USB-B', 1615),
(14, 'mn230d', 'Nokia 230 Dual', 'mobile', 'The Nokia 230 is the great combination of user-friendly function and exceptional build quality. The elegant dark silver colour, sand-blasted aluminium rear side and its slim profile give it an impressive look. To enhance its durability, this phone also comes with aluminium frame body. It is fitted with 2.8-inch display and has a resolution of 240x320 pixels, which enhances your viewing experience.<br>The phone comes fitted with 2MP rear camera and 2MP front-facing camera which allows you to capture your best moments. The Nokia 230 has an expandable storage space of 32 GB, enabling you to record quality videos with amazing sound capture.', 'mobile/nokia/n230.jpg', 'https://www.amazon.in/Nokia-230-Dual-Dark-Silver/dp/B019V4D7W8/ref=sr_1_1?s=electronics&ie=UTF8&qid=1523281333&sr=1-1&keywords=nokia+230+dual', '<br><br>2 MP Primary Camera, 240p@15fps Video, 2 MP Front Facing Camera<br><br>\r\nHas 2.8-Inch Display, Dual SIM, 16MB RAM, Maximum memory card size of 32 GB<br><br>\r\n1200 mAh Battery with Maximum standby time of 22 days and Maximum talk time (2G) of 23 h', 3949),
(15, 'mai5s', 'Apple iphone 5s', 'mobile', 'The iPhone 5S is a remarkable device from Apple. Featuring an all-new locking system, called Touch ID, and upgrades from the previous iPhone, the 5S has better hardware with the software and design to back it up.<br>Point-and-click photographers will love the iSight 8MP camera which comes with True Tone flash. With larger sensors and a larger aperture, the camera captures clear, detailed photos.<br>The iPhone 5S is also capable of capturing full HD videos. It can capture videos in slow motion and allows zooming in while recording a video. There\'s also a 1.2 megapixel secondary camera for FaceTime, with better illumination sensors and larger pixels to ensure you can also video chat in HD.', 'mobile/apple/ap1.png', 'https://www.flipkart.com/apple-iphone-5s-space-grey-16-gb/p/itmeuyd8ngnpzjg8?pid=MOBDPPZZPXVDJHSQ&lid=LSTMOBDPPZZPXVDJHSQT1J02P&marketplace=FLIPKART&srno=s_1_1&otracker=search&fm=SEARCH&iid=6b2d3a37-0728-4110-a211-0ce36b3d132b.MOBDPPZZPXVDJHSQ.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=wmus4gvqww0000001523281625215&qH=3f97ac7d49d8d9b4', '<br><br>16 GB ROM |\r\n4 inch Retina Display<br><br>\r\n8MP Rear Camera | 1.2MP Front Camera<br><br>\r\nLi-Ion Battery<br><br>\r\nApple A7 64-bit processor and M7 Motion Co-processor', 21195),
(16, 'mai6s', 'Apple iphone 6s', 'mobile', '\r\nRetina HD Display with 3D Touch, LED Backlit Widescreen, 326 PPI, 500 cd/m2 Maximum Brightness, Full sRGB Standard, Dual Domain Pixels for Wide Viewing Angles, Fingerprint Resistant Oleophobic Coating, Display Zoom, Reachability<br>720p HD Video Recording, Retina Flash, f/2.2 Aperture, Auto HDR for Photos and Videos, Backside Illumination Sensor, Exposure Control, Burst Mode, Timer Mode, Face Detection<br>Touch ID Fingerprint Sensor, Barometer, Three-axis Gyro Sensor, Accelerometer, Proximity Sensor, Ambient Light Sensor, Digital Compass', 'mobile/apple/ap2.jpg', 'https://www.flipkart.com/apple-iphone-6s-gold-32-gb/p/itmen2yynt6bz3gg?pid=MOBEN2YYQH8PSYXG&srno=s_1_1&otracker=search&lid=LSTMOBEN2YYQH8PSYXG4TGFKX&fm=SEARCH&iid=9366bf68-07df-4cd0-9b8f-9201e585f182.MOBEN2YYQH8PSYXG.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=uwlosykng00000001523283544774&qH=18a724b310838016', '<br><br>32 GB ROM |\r\n4.7 inch Retina HD Display\r\n12MP Rear Camera | 5MP Front Camera<br><br>\r\nLi-Ion Battery<br><br>\r\nApple A9 64-bit processor and Embedded M9 Motion Co-processor', 34999),
(17, 'mai7', 'Apple iphone 7', 'mobile', '\r\nTake your iPhone experience to the next level with iPhone 7. Featuring new camera systems, a better battery-life, an efficient processor and powerful stereo speakers, this smartphone will drastically enhance your iPhone experience. With a sharp and vibrant display, and a sleek water-resistant body, this phone is as powerful as it is attractive.<br>The iPhone 7, with its amazing features and drool-worthy design, looks every bit as efficient as it is. With a powerful processor and ample internal storage, this smartphone offers you a seamless performance.<br>The iPhone 7 features a unibody design that is easy to hold. Bead-blasted aluminum is used to give this phone’s body an elegant matte finish. The enclosure of the phone is water and splash resistant, so you don’t have to worry about spills, splashes and dust.', 'mobile/apple/ap3.png', 'https://www.flipkart.com/apple-iphone-7-black-32-gb/p/itmen6daftcqwzeg?pid=MOBEMK62PN2HU7EE&srno=s_1_1&otracker=search&lid=LSTMOBEMK62PN2HU7EEINTGNU&fm=SEARCH&iid=c22ffcdb-457d-4ee1-8f00-d2f228ad2935.MOBEMK62PN2HU7EE.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=46wjduescg0000001523283913954&qH=319971f613ef172d', '<br><br>32 GB ROM |\r\n4.7 inch Retina HD Display<br><br>\r\n12MP Rear Camera | 7MP Front Camera<br><br>\r\nLi-Ion Battery<br><br>\r\nApple A10 Fusion 64-bit processor and Embedded M10 Motion Co-processor', 41999),
(18, 'mai7p', 'Apple iphone 7 Plus', 'mobile', '\r\nTake your iPhone experience to the next level with iPhone 7. Featuring new camera systems, a better battery-life, an efficient processor and powerful stereo speakers, this smartphone will drastically enhance your iPhone experience. With a sharp and vibrant display, and a sleek water-resistant body, this phone is as powerful as it is attractive.<br>The iPhone 7, with its amazing features and drool-worthy design, looks every bit as efficient as it is. With a powerful processor and ample internal storage, this smartphone offers you a seamless performance.<br>The iPhone 7 features a unibody design that is easy to hold. Bead-blasted aluminum is used to give this phone’s body an elegant matte finish. The enclosure of the phone is water and splash resistant, so you don’t have to worry about spills, splashes and dust.', 'mobile/apple/ap4.jpg', 'https://www.flipkart.com/apple-iphone-7-black-32-gb/p/itmen6daftcqwzeg?pid=MOBEMK62PN2HU7EE&srno=s_1_1&otracker=search&lid=LSTMOBEMK62PN2HU7EEINTGNU&fm=SEARCH&iid=c22ffcdb-457d-4ee1-8f00-d2f228ad2935.MOBEMK62PN2HU7EE.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=46wjduescg0000001523283913954&qH=319971f613ef172d', '<br><br>32 GB ROM |\r\n4.7 inch Retina HD Display<br><br>\r\n12MP Rear Camera | 7MP Front Camera<br><br>\r\nLi-Ion Battery<br><br>\r\nApple A10 Fusion 64-bit processor and Embedded M10 Motion Co-processor', 41999),
(19, 'mai8', 'Apple iphone 8', 'mobile', 'An all-new glass design, an updated camera, and a powerful chip, there’s so much to love about the iPhone 8. This iPhone brings you an augmented reality experience that’s more immersive than before. What’s more? You can charge your iPhone wirelessly<br>Boasting a color-matched, aerospace-grade aluminium band, this phone is a stunner. The distinctive glass on its front and back is durable.<br>\r\nWater and Dust Resistant (IP67)\r\nIts body is precision-engineered to be splash, water, and dust resistant.', 'mobile/apple/ap5.jpg', 'https://www.flipkart.com/apple-iphone-8-space-grey-64-gb/p/itmexrgvkkvhjhuk?pid=MOBEXRGVPHW9QZ2S&srno=s_1_3&otracker=search&lid=LSTMOBEXRGVPHW9QZ2SXQ2WFU&fm=SEARCH&iid=51b14ab3-49ed-4fba-add0-d75ace81aa81.MOBEXRGVPHW9QZ2S.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=46wjduescg0000001523283913954&qH=de1adfd97685ac18', '<br><br>64 GB ROM |\r\n4.7 inch Retina HD Display<br><br>\r\n12MP Rear Camera | 7MP Front Camera<br><br>\r\nlithium-ion Battery<br><br>\r\nA11 Bionic Chip with 64-bit Architecture, Neural Engine, Embedded M11 Motion Coprocessor Processor', 57990),
(20, 'maix', 'Apple iphone X', 'mobile', 'Meet the iPhone X - the device that’s so smart that it responds to a tap, your voice, and even a glance. Elegantly designed with a large 14.73 cm (5.8) Super Retina screen and a durable front-and-back glass, this smartphone is designed to impress. What’s more, you can charge this iPhone wirelessly.<br>Movies or games - with its Super Retina screen, you can enjoy an immersive-viewing experience that dazzles the eyes.<br>The display, with new techniques and technology, follows the curves and its elegantly rounded corners.', 'mobile/apple/apx.jpg', 'https://www.flipkart.com/apple-iphone-x-space-gray-64-gb/p/itmexrgv6hctyrav?pid=MOBEXRGVCMGVCGGQ&lid=LSTMOBEXRGVCMGVCGGQFLD1LA&marketplace=FLIPKART&srno=s_1_1&otracker=search&fm=SEARCH&iid=68dffe92-709f-4338-a923-7af00c0fb251.MOBEXRGVCMGVCGGQ.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=46wjduescg0000001523283913954&qH=ca5aeb87b294fd30', '<br><br>64 GB ROM |<br><br>\r\n5.8 inch Super Retina HD Display<br><br>\r\n12MP + 12MP Dual Rear Camera | 7MP Front Camera<br><br>\r\nlithium-ion Battery<br><br>\r\nA11 Bionic Chip with 64-bit Architecture, Neural Engine, Embedded M11 Motion Coprocessor Processor', 82999),
(21, 'msxa1d', 'Sony Xperia XA1 Dual', 'mobile', '1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase<br>The edge to edge display and perfect size fits snugly in your hand. And its camera starts really quick, and fast hybrid auto focus is made for sharp-vivid photos. Sun goes down? The 23MP back and 8MP front cameras work great in low light with wide angle', 'mobile/sony/xa1.jpg', 'https://www.amazon.in/Sony-Xperia-XA1-Dual-Black/dp/B06Y3VRP78/ref=sr_1_1?s=electronics&ie=UTF8&qid=1521187441&sr=1-1&keywords=sony+phones', '<br><br>23MP primary camera with 1/2.3 exmor RS for mobile image sensor, hybrid auto focus, quick launch capture, low-light photo ISO6400, 24mm wide-angle F2 lens, 5x clear image zoom, steady shot, low-light video ISO 3200 and 8MP front facing camera<br><br>\r\n12.7 centimeters (5-inch) HD Image Enhance capacitive touchscreen with 720 x 1280 pixels resolution, 294 ppi pixel density and 16M color support<br><br>\r\nAndroid v7 Nougat operating system with 2.3GHz + 1.6GHz MediaTek Helio P20 octa core processor, Mali-T880MP2 GPU, 3GB RAM, 32GB internal memory expandable up to 256GB and dual SIM (nano+nano) dual-standby (4G+4G)', 16700),
(22, 'msr1p', 'Sony Xperia R1 Plus', 'mobile', 'Xperia R1 Plus is a perfect fit for your hand and features a 5.2-inch HD display, an octa-core processor with 4G VoLte. The R1 is made for India, with sturdy and premium design, crisp and powerful sound, smooth performance. Capture amazing images with strong 13MP Exmor R sensor camera, with 8MP wide angle front camera.<br><br>With a 13MP Predicitive Autofocus camera at hand, you’re always ready to catch and share life as it happens. In vivid, lifelike colours.<br><br>With 12 unique modes to capture your favourite images like Potrait, Landscape, Sports, Macro, Night mode etc. capture all the images with fine details in the best suited mode.', 'mobile/sony/r1.jpg', 'https://www.amazon.in/Sony-Xperia-R1-Plus-Dual/dp/B076HYJT12/ref=sr_1_3?s=electronics&ie=UTF8&qid=1521187441&sr=1-3&keywords=sony+phones', '<br><br>13MP primary camera and 8MP front facing camera<br><br>\r\n13.2 centimeters (5.2-inch) with 720 x 1280 pixels resolution<br><br>\r\nAndroid 8.0 Oreo operating system with 1.4GHz Qualcomm Snapdragon 430 octa core processor, 3GB RAM, 32GB internal memory expandable up to 256GB and dual SIM (nano+nano) dual-standby (4G+4G)<br><br>\r\n2620mAH lithium-ion battery<br><br>\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 12000),
(23, 'msl2d', 'Sony Xperia L2 Dual', 'mobile', 'Enjoy endless selfies with 8MP super wide angle front camera powered by 3300 mAH long lasting battery. Also, keep your smartphone safe with rear-mounted fingerprint sensor with auto-wake up feature. The large 5.5 inch HD display makes your viewing experience even better.<br>The Xperia L2 comes with an impressive 13MP camera. It will help you take better pictures with more detail and clarity than ever before.<br>The 5.5 inch HD screen is great for watching movies on the go. And if you want to operate it with one hand, you can simply shrink the view to mini display.<br>Qnovo Adaptive Charging checks your battery’s health as it charges, then adjusts current levels to help protect its capacity. Over time this prevents battery decline, keeping your battery healthier for longer.', 'mobile/sony/l2.jpg', 'https://www.amazon.in/Sony-Xperia-L2-Dual-Black/dp/B0794P3TJJ/ref=sr_1_9?s=electronics&ie=UTF8&qid=1521187441&sr=1-9&keywords=sony+phones', '<br><br>13MP primary camera with 3X clear image zoom, ISO 3200 and 120 degree super wide-angle lens and 8MP front facing camera<br><br>\r\n13.97 centimeters (5.5-inch) HD capacitive touchscreen with 720 x 1280 pixels resolution<br><br>\r\nAndroid v7.1 Nougat operating system with 1.5GHz Mediatek MT6737 quad core processor, Mali 720-MP2 450MHz, 3GB RAM, 32GB internal memory expandable up to 256GB and dual SIM (nano+nano) dual-standby (4G+4G)<br><br>\r\n3300mAH lithium-ion battery<br><br>\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 18130),
(24, 'msxz1d', 'Sony Xperia XZ1 Dual', 'mobile', 'Experience a smartphone beyond dimension and discover the new 3D creator, scan your favourite people and things. Capture 100 images at a stretch with Autofocus burst mode. The full HD HDR display let\'s you enjoy every detail with most immersive experience. The latest Snapdragon 835 Processor gives best and the fastest performance in the smartphone.<br><br>Capture your world in 3D, straight from your smartphone, and turn people and objects into high-resolution 3D avatars. With four scanning modes: face, head, freeform and food, you’ll get the best possible quality.<br><br>Discover ground-breaking innovation with 3D Creator. Make 3D memories, share them with friends or get them printed - the possibilities are endless.', 'mobile/sony/xz1.jpg', 'https://www.amazon.in/Sony-Xperia-XZ1-Dual-Black/dp/B075T5VD9S/ref=sr_1_12?s=electronics&ie=UTF8&qid=1521187441&sr=1-12&keywords=sony+phones', '<br><br>13.2 centimeters (5.2-inch) Full HD HDR Triluminos display with 1920 x 1080 pixels resolution<br><br>\r\nAndroid v8 Oreo operating system with 2.3GHz Qualcomm Snapdragon 835 octa core processor, Adreno 540 GPU, 4GB RAM, 32GB internal memory expandable up to 256GB and dual SIM (nano+nano) dual-standby (4G+4G)<br><br>\r\n2700mAH lithium-ion battery<br><br>\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 42450),
(25, 'msxzpd', 'Sony Xperia XZ Premium Dual', 'mobile', 'Performance and good looks - the Sony Xperia XZ offers you the best of both worlds. The Premium Glass Loop Surface adds a touch of sophistication to its overall look and feel. Visuals come to life on its 4K HDR Display. Capture stunning shots on its 19 MP rear camera and 13 MP front camera. 4 GB of RAM and the Qualcomm Snapdragon 835 processor let you multitask effortlessly.<br><br>Appealing to look at and gentle to touch, the Premium Glass Loop Surface reflects the world around you by creating a mirror effect. Made with Corning Gorilla Glass 5 (front and back of the handset), this mobile redefines beauty and durability.', 'mobile/sony/xz.jpg', 'https://www.amazon.in/Sony-Xperia-XZ-Premium-Dual/dp/B072PYGF2B/ref=sr_1_14?s=electronics&ie=UTF8&qid=1521187441&sr=1-14&keywords=sony+phones', '<br><br>4 GB RAM | 64 GB ROM | Expandable Upto 256 GB\r\n5.5 inch Display<br><br>\r\n19MP Rear Camera | 13MP Front Camera<br><br>\r\n3230 mAh Battery<br><br>\r\nQualcomm Snapdragon 835 64-bit Processor', 54990),
(26, 'msxad', 'Sony Xperia XA Dual', 'mobile', 'The edge to edge display and perfect size fits snugly in your hand. And its camera starts really quick, and fast hybrid auto focus is made for sharp-vivid photos. Sun goes down? The 13MP back and 8MP front cameras work great in low light with wide angle.<br><br>\r\nXperia XA’s display stretches the full width of the phone so there’s barely a frame visible. This means the screen is maximized without having to make the phone any bigger.<br><br>Xperia XA comes in four colors. Take it in Graphite Black, White, or in one of our stunning new gold hues - Lime Gold or Rose Gold. Your colorway not only covers the back, but also the phone’s front panels and the hue of the screen.', 'mobile/sony/xa.jpg', 'https://www.amazon.in/Sony-Xperia-XA-Dual-Lime/dp/B01H4U8348/ref=sr_1_18?s=electronics&ie=UTF8&qid=1521187441&sr=1-18&keywords=sony+phones', '<br><br>13MP primary camera with hybrid auto focus and 8MP front facing camera for low light selfies<br><br>12.7 centimeters (5-inch) HD capacitive touchscreen with 1280 x 720 pixels resolution, edge to edge design and mobile BRAVIA engine 2<br><br> Android v6.0.1 Marshmallow operating system with 2GHz MediaTek Helio octa core processor, 2GB RAM, 16GB internal memory expandable up to 200GB and dual SIM (nano+nano) dual-standby (4G+2G)', 11790),
(27, 'mlk8n', 'Lenovo K8 Note', 'mobile', 'The Lenovo K8 Note is the most power #KillerNote ever! Experience a new level of performance with a 10-core processor plus up to 4GB of RAM and 64GB of storage. K8 Note comes with 2 parallel rear cameras with 13MP and 5MP depth sensors to capture DSLR-like depth of field effect. Take amazing selfies with high resolution 13MP front camera with party flash. Enjoy an immersive multimedia experience with 13.97cm (5.5) Full HD Display with Dolby Atmos support. K8 Note ships with the stock Android 7.1.1 Nougat for a smooth and responsive experience.A new system update is available for Lenovo K8 Note. This update improves the overall stability and performance of the device. To install, please connect your Lenovo K8 Note to the internet and follow the following steps - Settings -> About Phone -> System Updates<br><br>\r\nRear Camera: Dual Camera, Pro-Mode, Panorama, Background blur, Selective B&W, Change Background, Front Camera: Wide Angle Selfie, Party Flash, Pro-Mode, Selfie-beautification & timer', 'mobile/lenovo/lenovo_k8.jpg', 'https://www.amazon.in/Lenovo-Venom-Black-System-Update/dp/B01LZKSUXF?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=c0eb971a-d93e-4833-b1a6-8503f50e0761s', '<br><br>13+5MP dual back camera and 13MP front facing camera with party flash<br><br>\r\nAndroid v7.1.1 Nougat operating system with 2.3GHz Helio X23 10-core processor<br><br>\r\n13.97 (5.5-inch) Full HD (1920 x 1080) IPS touchscreen with Gorilla Glass protection<br><br>\r\n4GB RAM and 64GB internal memory expandable up to 128GB<br><br>\r\nDual nano SIM with dual-standby (4G+4G)<br><br>\r\n4000mAH all day battery with 15W Turbo Charging', 12400),
(28, 'mlk6p', 'Lenovo K6 Power', 'mobile', 'With a 4000 mAh battery, a Qualcomm Snapdragon 430 octa-core processor, 3 GB RAM and 32 GB of internal memory, the Lenovo Vibe K6 smartphone is built to perform. The Adreno 505 GPU makes your graphics fluid and look stunning on the 12.7 cm FHD display. Smile to the 13 MP rear camera and the 8 MP front camera for portrait-worthy photos and selfies. And what keeps all your files, photos and other data safe is the fingerprint scanner.<br><br>\r\nWith a 4000 mAh battery, a Qualcomm Snapdragon 430 octa-core processor, 3 GB RAM and 32 GB of internal memory, the Lenovo Vibe K6 smartphone is built to perform. The Adreno 505 GPU makes your graphics fluid and look stunning on the 12.7 cm FHD display. Smile to the 13 MP rear camera and the 8 MP front camera for portrait-worthy photos and selfies. And what keeps all your files, photos and other data safe is the fingerprint scanner.', 'mobile/lenovo/lenovok6.jpg', 'https://www.flipkart.com/lenovo-k6-power-grey-dark-grey-32-gb/p/itmezenfhm4mvptw?pid=MOBEZENFZBPW8UMF&lid=LSTMOBEZENFZBPW8UMF5QHNFB&marketplace=FLIPKART&srno=s_1_1&otracker=search&fm=SEARCH&iid=39bdfc7b-44f7-48f6-83ef-298d73ba8248.MOBEZENFZBPW8UMF.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=jzk0286ubk0000001523289340851&qH=0799b532caa77096', '<br><br>3 GB RAM | 32 GB ROM | Expandable Upto 128 GB<br><br>\r\n5 inch Full HD Display<br><br>\r\n13MP Rear Camera | 8MP Front Camera<br><br>\r\n4000 mAh Li-Polymer Battery<br><br>\r\nQualcomm Snapdragon 430 Octa Core 1.4GHz Processor', 7985),
(29, 'mla66p', 'Lenovo A6600 Plus', 'mobile', 'Lenovo A6600 Plus brings amazing multimedia experience with 5.0\" HD IPS Screen. Enjoy HD calls and fast downloads with VOLTE. Pure android 6.0 experience with a smoother performance and more space. 64 Bit Quadcore processor. 2GB RAM + 16GB ROM. 8MP Camera with Flash, 2300 mAh (Li-polymer) battery.<br<br>\r\nWeighing just 142 grams, the sleek Lenovo A6600 Plus perfectly frames the vibrant 12.7cm (5) HD screen. Rich in color and sharp in resolution, this device is made for multimedia, and ensures that your video, games, and images all appear clearer and more vivid. In addition, with in-plane switching (IPS) offering nearly 180° of wide-angle viewing, the Lenovo A6600 Plus boasts a big, bright display, and is perfect for sharing with a crowd of friends.\r\n<br><br>\r\nAndroid 6.0, Marshmallow: The Lenovo A6600 Plus runs Android 6.0, Marshmallow the latest flavor of the world’s most popular mobile operating system. With new shortcuts between apps and enhancements that save battery power, it’s now more useful than ever.', 'mobile/lenovo/a6600.jpeg', 'https://www.amazon.in/Lenovo-A6600-Plus-Black/dp/B01M0OXV1V/ref=sr_1_3?s=electronics&ie=UTF8&qid=1521186935&sr=1-3&keywords=lenovo+phones', '<br><br>2 GB RAM | 16 GB ROM | Expandable Upto 32 GB<br><br>\r\n5 inch HD Display<br><br>\r\n8MP Rear Camera | 2MP Front Camera<br><br>\r\n2300 mAh Li-Polymer Battery<br><br>\r\nMediaTek MT6735P 64-bit Quad Core 1GHz Processor', 6168),
(30, 'mlk6n', 'Lenovo K6 Note', 'mobile', 'Capture and relive great moments perfectly with two outstanding cameras and a brilliant 13.97cm (5.5) FHD display. This eye-catching, all-metal Android smartphone boasts immersive Dolby Atmos audio, powerful octa-core processing, and a secure fingerprint reader for instant access to your favorite apps. The Lenovo K6 Note-outstanding in every sense.\r\n<br>\r\nTheaterMax 3.0 is the widescreen cinematic experience powered by Lenovo VR technology. It’s built into the Lenovo K6 Note. Partner the K6 Note with the VR headset and view movies and games on a super-size virtual screen. Turn up the volume on the K6 Note’s surround-sound audio system and get totally immersed in a sensational new world.\r\n<br>\r\n\r\nThe Lenovo K6 Note brings your photos, videos, and online world to life. Delivering everything in stunning, crystal clear detail, the 13.97cm (5.5) Full HD display has in-plane switching technology, enabling you to enjoy a richer range of colors and wider viewing angles.\r\n<br>\r\n\r\nPowerful octa-core processing and the latest Android operating system (6.0, Marshmallow) combine perfectly to give you smooth, fast performance. In addition, the Lenovo K6 Note boasts a large 4,000 mAh battery, with enough juice to keep you going through every challenge of the day.\r\n<br>\r\n\r\nLenovo K6 Note is equipped with Single rear speaker with Dolby Atmos. They deliver a rich, immersive sound experience. Videos and music in Dolby Atmos will be enhanced with audio that flows above and around you. You will enjoy a wider, elevated sound field with greater details, enhanced loudness without distortion, and crisper dialogue in movies and TV shows.\r\n<br>\r\n\r\nThe full-metal unibody design of the Lenovo K6 Note looks great, feels great. What\'s more, with Dolby Atmos audio enhancement, it also elevates your music and movies to another level.\r\n<br>\r\n\r\nThe Lenovo K6 Note supports dual micro-SIM cards and 4G LTE connectivity. So, you can have two phone numbers on one device and stay connected at super fast speeds.', 'mobile/lenovo/k6note.jpg', 'https://www.amazon.in/Lenovo-K6-Note-Gold/dp/B01MZ0NA27/ref=sr_1_4?s=electronics&ie=UTF8&qid=1521186935&sr=1-4&keywords=lenovo+phones', '<br><br>4 GB RAM | 32 GB ROM | Expandable Upto 128 GB<br><br>\r\n5.5 inch Display<br><br>\r\n16MP Rear Camera | 8MP Front Camera<br><br>\r\n4000 mAh Battery', 9799),
(31, 'mlz2p', 'Lenovo Z2 Plus', 'mobile', 'The Lenovo Z2 Plus is powered by a Qualcomm Snapdragon 820 processor and comes equipped with Pro-fitness Sensors and Professional Sensors which give you access to hundreds of health apps. Keep a track of your fitness levels and stay connected all the time with this Android smartphone.<br><br>\r\nFast and Powerful Processor\r\nWith the Lenovo Z2 Plus, you can take your mobile experience to the next level, thanks to its Qualcomm Snapdragon 820 processor, 3 GB RAM and 32 GB ROM. The sensor processing unit along with the powerful CPU & GPU gives a lag-free experience. The Android 6.0.1 OS also offers a friendly user interface.<br><br>\r\nThe flaunt-worthy Lenovo Z2 Plus isn\'t just a treat to the eye, it also comes with cutting-edge technologies which make it the perfect entertainment-companion, whether you\'re a cinephile, a gamer or a digital socialite.', 'mobile/lenovo/z2.png', 'https://www.flipkart.com/lenovo-z2-plus-black-32-gb/p/itmeq8593eyd5ukd?pid=MOBEMY7FPKHMRBQ5&srno=s_1_1&otracker=search&lid=LSTMOBEMY7FPKHMRBQ57OQYDV&fm=SEARCH&iid=a27b7c58-5bf8-4c3e-9c3b-1a1e070c9254.MOBEMY7FPKHMRBQ5.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=dq949q6qfk0000001523290364794&qH=de9005245c7a3728', '<br><br>3 GB RAM | 32 GB ROM |<br><br>\r\n5 inch Full HD Display<br><br>\r\n13MP Rear Camera | 8MP Front Camera<br><br>\r\n3500 mAh Li-Ion Battery<br><br>\r\nQualcomm Snapdragon 820 Quad Core 2.15GHz Processor', 11750),
(32, 'mlk3n', 'Lenovo K3 Note', 'mobile', 'If you love watching movies or gaming on your smartphone, this sleek and powerful Lenovo K3 Note features a mesmerizing 13.97 cm Full HD display and is backed by powerful Octa Core performance.<br><br>\r\nEnjoy watching videos, viewing high-resolution photos and gaming on the big 13.97 cm (5.5) Full HD IPS display of the K3 Note. With the 1920 x 1080 resolution, visuals come to life on this bright and vivid screen.<br><br>\r\nThanks to the 64-bit Octa Core processor, you can multitask effortlessly on this device. Apps, games and videos run smoothly and lag-free. This Lenovo device is powered by the faster and smoother Android Lollipop 5.0.', 'mobile/lenovo/k3.jpg', 'https://www.flipkart.com/lenovo-k3-note-yellow-16-gb/p/itmeuydazkswhfrr?pid=MOBE8AHAEG8GFCMX&srno=s_1_1&otracker=search&lid=LSTMOBE8AHAEG8GFCMXWKHHIW&fm=SEARCH&iid=9bf83515-a4dd-431e-b65b-1cfe1a3eb0b3.MOBE8AHAEG8GFCMX.SEARCH&ppt=Search%20Page&ppn=Search%20Page&ssid=dq949q6qfk0000001523290364794&qH=9bda8d7bf0334049', '<br><br>2 GB RAM | 16 GB ROM | Expandable Upto 32 GB<br><br>\r\n5.5 inch Full HD Display<br><br>\r\n13MP Rear Camera | 5MP Front Camera<br><br>\r\n2900 mAh Li-Ion Battery<br><br>\r\nCortex-A53 (MediaTek MT6752 64-bit 4G LTE) Processor', 8990),
(33, 'lsc3', 'Samsung ChromeBook 3', 'laptop', 'Key Features and Benefits: 11.6 LED backlight Display (1366 x 768) Newest Intel Celeron processor N3060 Long battery life- that gets up to 11 hours on a single charge Operating system: Google Chrome OS Display: 11.6 inch Widescreen LED backlight HD (1366 x 768) Display Screen Resolution: 1366 x 768 Processor: Intel Celeron N3060 Dual-Core processor, 1.6GHz Memory: 4GB system memory Hard drive: 32GB eMMC Ports: 1 x USB 3.0, 1 x USB 2.0, 1 x Headphone/microphone combo jack, 1x HDMI Video: Intel HD Graphics 400 Media Card Reader: yes Wireless connectivity: 802.11ac and Bluetooth Built-in HD webcam with microphone: YES Battery: lithium-ion Bluetooth: YES Dimensions(inches): 11.4 x 8 x 0.7 Weight(pounds): 2.54 pounds Color: Black<br><br>\r\nThe Chromebook 3 is a quality device. But then you’d expect nothing less from a leading technology brand like Samsung. <br><br>\r\n', 'laptop/samsung/chromebook3.jpg', 'https://www.amazon.in/Samsung-Chromebook-Flagship-Ultrabook-Bluetooth/dp/B0744GWBXC?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=c0eb971a-d93e-4833-b1a6-8503f50e0761', '<br><br>11.6 inch Widescreen LED backlight HD (1366 x 768) Display\r\n<br><br> Intel HD Graphics 400 Intel Celeron N3060 Dual-Core processor\r\n<br><br>\r\n1.6GHz, 4GB DDR3, 32GB eMMC 1 x USB 3.0, 1 x USB 2.0, 1 x Headphone/microphone combo jack\r\n<br><br> 1x HDMI 802.11ac, Media Card Reader, Bluetooth 4.0, webcam, Stereo speakers \r\n<br><br>\r\nGoogle Chrome OS, 0.7\" Thin, 2.54lbs Weight, Battery: Lithium-Ion, Color: Black\r\n<br><br> 1 Year Manufacturer\'s Warranty', 36610),
(34, 'lscp', 'Samsung Chromebook Plus', 'laptop', 'Whatever your day brings, the Samsung Chromebook Plus is up for it. With the power of a Chromebook and the versatility of a tablet, the 360° rotating screen helps you get things done or just kick back. Add a personal touch to your notes with the built-in pen. Access your favorite apps right on your Samsung Chromebook Plus. And keep watching, gaming, working, and creating anywhere, even when you’re offline.<br><br>\r\nThe Samsung Chromebook Plus adapts to whatever you’re doing. Use it like a laptop to reply to emails or to work on a paper. When you need a break, flip the screen so you can play games or catch up on your latest book.<br><br>\r\nMake your ideas personal and your notes clear with the built-in pen. Whether you’re doodling, sketching, or personalizing a photo, the built-in pen will help you get every detail just right. You can even use the pen to take a screenshot, magnify, or unlock the screen.', 'laptop/samsung/chromebookplus.jpg', 'https://www.amazon.com/Samsung-Chromebook-Convertible-Laptop-XE513C24-K01US/dp/B01LZ6XKS6', '<br><br>Flexible 360° profile. Enables you to use upright as a computer to reply to emails or finish a paper and recline for a tablet view ideal for surfing and viewing<br><br>\r\nThis Device comes with the pen out of the box. Power to personalize your communications by writing directly on screen. Take notes, make a sketch, capture part of the screen, etc<br><br>\r\nAll the apps you love on your phone are now available on your computer. Over a million apps are waiting for you. Find your favorites or explore what\'s new', 49900),
(35, 'lsn7', 'Samsung Notebook 7', 'laptop', 'With enough power to keep up with you now, the Samsung Notebook 7 spin is also up for tomorrow. Out of the box, it comes with an Intel® Core™ i7 Processor, an impressive 1 Terabyte hard drive, 16GB of RAM1 and an NVIDIA 940MX GPU that brings gaming to life. And when you need it, you can upgrade with an SSD to cut down on load time or additional RAM so you can do more at once.<br><br>\r\nNo matter what you’re doing, the Notebook 7 spin gives you the best view. Use it as a notebook when you post and email. Or rotate it all the way to tablet mode to browse easily on the touchscreen.', 'laptop/samsung/notebook7.jpg', 'https://www.amazon.in/Samsung-Notebook-Touch-Screen-NP740U3L-L02US-i5-6200U/dp/B01I4H1PSQ', '<br><br>13.3\" Full HD LED touch screen, 1920 x 1080 resolution, 360° flip-and-fold design<br><br>\r\n6th Gen Intel Core i5-6200U mobile processor (3M Cache, 2.30 GHz, turbo up to 2.80 GHz), Dual-core, four-way processing<br><br>\r\n8GB Memory, 1TB Hard Drive<br><br>\r\nIntel HD Graphics 520, HDMI output, 1 USB 3.0, 2 USB 2.0, built-in media reader\r\nWeighs 3.9 lbs. and measures 0.8\" thin', 72948),
(37, 'lsn9', 'Samsung NoteBook 9', 'laptop', 'Notebook 9 Pen ($1,399) arrives as a light, transformable laptop with a built-in stylus. It has a quick new processor and a vibrant display, but otherwise isn\'t a terribly remarkable machine compared with the competition. The Editors\' Choice Lenovo Yoga 920 offers a battery that lasts twice as long and a premium metal build for a little less money, making it difficult to look past as our top recommendation.<br><br>\r\nThe Notebook 9 Pen is a simple, sleek laptop, all metallic silver with a glistening Samsung logo on the lid. The whole notebook shares the silver color, including the keyboard. The material is a magnesium alloy named Metal12, but it unfortunately feels more like plastic, inexpensive for the price. It\'s not a particularly sturdy, and machines in this price range generally boast a more premium feel.', 'laptop/samsung/notebook9.jpg', 'https://www.amazon.in/Samsung-NP900X5L-K02US-Notebook-Laptop-Silver/dp/B01AWGXNH8', '<br><br>Newest 7th-gen Intel Core i7 processor. System Dimensions (L x W x H, Inch)-12.18\" x 8.19\" x 0.55\"<br><br>\r\n256GB SSD Storage, 8GB Memory<br><br>\r\n15\" Diagonal Full HD Display (1920x1080), Backlit Keyboard<br><br>\r\nFast Charging (20-min Charge for 2.1 Hours of Use) or USB-C charging for power on the go<br><br>\r\nFingerprint Sensor for Windows Hello', 128213),
(38, 'lso', 'Samsung Oddessey', 'laptop', 'Immerse yourself in new worlds with the phenomenal power of Samsung’s first PC designed exclusively for gamers. Take every quest and conquest to the next level, thanks to the stunningly smooth graphics of a NVIDIA GTX 1050 card and powerful performance of the Quad-Core Intel Core i7 Processor, and witness the speed and power of dual storage and 16GB of RAM.<br><br>\r\nThe best gaming computers are all about what’s under the hood, and Odyssey is a masterpiece. Play longer and harder with the top performance of a Quad-Core 7th Generation Intel Core i7 processor. Enjoy smoother game graphics on Full HD content with the NVIDIA GTX 1050. Get plenty of space for all your games with 1TB HDD. Games install and load faster with 128 GB SSD and and 16GB of RAM. And you can reconfigure to add more SSD and RAM anytime you need a boost.<br><br>\r\nOdyssey was boldly engineered with a formidable 15.6” frame and designed to keep up with your every mission. A uniquely ventilated bottom allows for cooling during your most intense matches, so play never slows down. And a LED-backlit keyboard makes core gaming keys stand out so WASD is unmistakable, even during late-night sessions.', 'laptop/samsung/odyessy.jpg', 'https://www.amazon.com/Samsung-NP800G5M-X01US-Notebook-Odyssey-Knights/dp/B01N5SK83S', '<br><br>Intel Core i7 7700HQ Quad-core Processor<br><br>\r\n16GB RAM, 128GB NVMe SSD + 1TB HDD Storage<br><br>\r\nNVIDIA GeForce GTX 1050, Dynamic Video HDR<br><br>\r\n15.6\" Diagonal Full HD Wide Angle Viewing Anti-glare Display (1920x1080), WASD Backlit Keyboard<br><br>\r\nHexaflow Cooling & Ventilation, Upgrade Door, Curved Crater Keycap', 139086),
(40, 'lsp12.3', 'Samsung Chromebook Pro', 'laptop', 'Unleash the power of modern computing with this Samsung Chromebook laptop. It has all the space you need with the 12.3-inch screen, which ensures portability, and 4GB of RAM and an Intel Celeron processor lets you complete basic office tasks all day long. The 32 GB storage capacity means this Samsung Chromebook laptop can store files and programs for offline use.', 'laptop/samsung/pro123.jpg', 'https://www.amazon.in/Samsung-Chromebook-XE510C24-K01US-12-3-inch-Laptop/dp/B071LB1GG4/ref=sr_1_1?s=computers&ie=UTF8&qid=1523298511&sr=1-1&keywords=samsung+pro+12.3', '<br><br>Screen size: 12.3 inches<br><br>\r\nRAM: 4 GB DDR3<br><br>\r\nROM: 32 GB', 58105);
INSERT INTO `products` (`pid`, `pname`, `pfullname`, `p_type`, `p_des`, `p_image`, `p_link`, `highlight`, `price`) VALUES
(41, 'tos1', 'Toshiba satellite L55-A5284 ', 'laptop', '<br><br>L55-A5284 15.6-Inch Laptop\r\n1.8 GHz Intel Core i5-3337U Processor<br><br>\r\n8GB DIMM, 750GB HDD<br><br>\r\nWindows 8 <br><br>\r\nMercury Silver', 'laptop/toshiba/ts6.jpg', 'https://www.amazon.in/Toshiba-Satellite-L15-B1330-11-6-Inches-Celeron/dp/B0118WY9QE/ref=sr_1_19?s=computers&ie=UTF8&qid=1523272291&sr=1-19&keywords=toshiba+laptop', '<br><br>L55-A5284 15.6-Inch Laptop <br><br>\r\n1.8 GHz Intel Core i5-3337U Processor<br><br>\r\n8GB DIMM, 750GB HDD<br><br>\r\nWindows 8 Mercury Silver', 83525),
(42, 'tos2', 'TOSHIBA Laptop tecra', 'laptop', '<br><br>Intel Core i7 7th Gen 7500U (2.70 GHz)<br><br>\r\n4 GB Ram 1TB HDD \r\nIntel HD Graphics 620 <br><br>\r\n15.6 Windows 10 Pro 64-Bi', 'laptop/toshiba/ts2.jpg', 'https://www.amazon.in/TOSHIBA-Tecra-A50-01R01S-Graphics-Windows/dp/B072LRRCDJ/ref=sr_1_22?s=computers&ie=UTF8&qid=1523276198&sr=1-22&keywords=toshiba+laptop', '<br><br>TOSHIBA Laptop Tecra A50-01R01S Intel Core i7 7th Gen 7500U (2.70 GHz) 4 GB Ram 1TB HDD Intel HD Graphics 620 15.6 Windows 10 Pro 64-Bi', 81402),
(43, 'tos3', '2016 Toshiba Satellite Fusion', 'laptop', '15.6\" Full HD 2-in-1 Touchscreen Convertible Laptop, Intel Core i5-6200U Processor, 6GB RAM, 1TB HDD, Webcam, WIFI, HDMI, Bluetooth, Windows 10', 'laptop/toshiba/ts5.jpg', 'https://www.amazon.in/dp/B01HDSN4EA/ref=sxts_sxwds-puwylo_rv_3?pf_rd_m=A1VBAL9TL5WCBF&pf_rd_p=1674013347&pd_rd_wg=uUSyU&pf_rd_r=3YRTY3EHQR67CTXRSMP7&pf_rd_s=desktop-sx-top-slot&pf_rd_t=301&pd_rd_i=B01HDSN4EA&pd_rd_w=fB9yL&pf_rd_i=toshiba+laptop&pd_rd_r=2a0fe187-e9ab-44fa-bb90-9094be722557&ie=UTF8&qid=1523347080&sr=3', '<br><br>15.6\" Full HD 2-in-1 Touchscreen Convertible Laptop<br><br>\r\nIntel Core i5-6200U Processor<br><br>\r\n6GB RAM<br><br>\r\n1TB HDD<br><br>\r\nWebcam, WIFI, HDMI, Bluetooth, Windows 10', 82024),
(44, 'tos7', 'Toshiba Satellite L15-B1330 ', 'laptop', 'Toshiba Satellite L15-B1330 11.6-Inches Laptop (Intel Celeron N2840 / 2.16 GHz, 2GB DDR3L , 128 GB mSATA, Windows 8.1)', 'laptop/toshiba/ts7.jpg', 'https://www.amazon.in/dp/B0118WY9QE/ref=sxts_sxwds-puwylo_rv_4?pf_rd_m=A1VBAL9TL5WCBF&pf_rd_p=1674013347&pd_rd_wg=uUSyU&pf_rd_r=3YRTY3EHQR67CTXRSMP7&pf_rd_s=desktop-sx-top-slot&pf_rd_t=301&pd_rd_i=B0118WY9QE&pd_rd_w=fB9yL&pf_rd_i=toshiba+laptop&pd_rd_r=2a0fe187-e9ab-44fa-bb90-9094be722557&ie=UTF8&qid=1523347080&sr=4', '<br><br>11.6-Inches Laptop<br><br> Intel Celeron N2840 / 2.16 GHz<br><br> 2GB DDR3L <br><br>128 GB mSATA<br><br> Windows 8.1', 162087),
(45, 'tos5', 'Toshiba Satellite Flagship ', 'laptop', 'Toshiba Satellite Flagship Model 12.5-Inch IPS HD Touchscreen 2 in 1 Convertible Touchscreen Ultrabook | Intel Core i5 | 128GB SSD | 4GB RAM | GPS | NFC | WIDI | LED-Backlit Keyboard | Windows 8', 'laptop/toshiba/ts3.jpg', 'https://www.amazon.in/dp/B01FNOUNCM/ref=sxts_sxwds-puwylo_rv_5?pf_rd_m=A1VBAL9TL5WCBF&pf_rd_p=1674013347&pd_rd_wg=uUSyU&pf_rd_r=3YRTY3EHQR67CTXRSMP7&pf_rd_s=desktop-sx-top-slot&pf_rd_t=301&pd_rd_i=B01FNOUNCM&pd_rd_w=fB9yL&pf_rd_i=toshiba+laptop&pd_rd_r=2a0fe187-e9ab-44fa-bb90-9094be722557&ie=UTF8&qid=1523347080&sr=5', '<br><br>Toshiba Satellite Flagship Model<br><br> 12.5-Inch IPS HD Touchscreen 2 in 1 Convertible Touchscreen <br><br>Ultrabook | Intel Core i5 <br><br> 128GB SSD | 4GB RAM | GPS | NFC | WIDI | LED-Backlit Keyboard | Windows 8', 70072),
(46, 'tos6', 'Toshiba P35W-B3226', 'laptop', 'this is the 2-1 laptop and touchscreen,can be rotated 360 degree.', 'laptop/toshiba/ts1.jpg', 'https://www.amazon.in/dp/B00RWKR6O4/ref=sxts_sxwds-puwylo_sim_7?pf_rd_m=A1VBAL9TL5WCBF&pf_rd_p=1674013347&pd_rd_wg=uUSyU&pf_rd_r=3YRTY3EHQR67CTXRSMP7&pf_rd_s=desktop-sx-top-slot&pf_rd_t=301&pd_rd_i=B00RWKR6O4&pd_rd_w=fB9yL&pf_rd_i=toshiba+laptop&pd_rd_r=2a0fe187-e9ab-44fa-bb90-9094be722557&ie=UTF8&qid=1523347080&sr=7', '<br><br>13.3 FHD Touch 2-In-1 Ultrabook Laptop <br><br>Intel i7-4510U<br><br> 8GB Memory 128GB<br><br> Solid State Drive Satin Gold', 76251),
(47, 'del1', 'Dell D-630', 'laptop', 'The Dell Latitude D630 Notebook PC comes with an Intel Core 2 Duo T7250 2GHz processor, 2GB DDR2 of memory, a 80GB hard drive, combo optical drive, wifi, and Windows XP Professional Operating System. The Dell Latitude D630 platform is designed for businesses that are focused on affordable pricing coupled with top-level performance. Professionals that require a reliable workhorse PC will find the Dell Latitude D630 Notebook PC to be a good fit with their IT strategy. Businesses looking for a reliable, managed, network ready PC that is ideally suited for office applications such as e-mail, word processing, spreadsheets and Web browsing, will find the Dell Latitude D630 Notebook PC to be an excellent solution. Whether you are in marketing, finance, sales or shipping, the Dell Latitude D630 Notebook PC stands ready to tackle your application and get the job done.It does have internal wireless 802.11 a/g', 'laptop/dell/d630.jpg', 'https://www.amazon.com/Dell-Latitude-D630-14-1-Inch-Notebook/dp/B004KZJ0UM', '<br><br>Intel Core 2 Duo Processor 2GHz<br><br>\r\n2GB DDR2 RAM<br><br>\r\n80GB Hard Drive<br><br>\r\n14.1-Inch Screen, Graphics Media Accelerator X3100<br><br>\r\nWindows XP Professional 32 bit', 65000),
(48, 'del2', 'Dell Inspiron 15', 'laptop', 'Features you can count on to power your day\r\nAwesome audio clarity: The superior sound of Waves MaxxAudio delivers impressive audio quality for the best music and video experience.\r\nTransfer photos and videos: The SD media card reader makes it easy to transfer files straight from your camera to your laptop.\r\nConnect in HD: Get in touch long-distance, record yourself for YouTube or web conference clearly with the HD webcam.\r\nCrisp display: The HD, TrueLife display delivers a clear, bright image that’s easy on the eyes.', 'laptop/dell/inspiron15.jpg', 'https://www.amazon.in/Dell-Inspiron-3567-15-inch-Graphics/dp/B07568CCSV?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=e611ec2c-7ba3-4cbe-87c0-41e4d88fc18b', '<br><br>Up to 3.2GHz Intel Core i5 7th Gen processor<br><br>\r\n4GB DDR4 RAM<br><br>\r\n1TB 5400rpm Serial ATA hard drive<br><br>\r\n15-inch screen, AMD Radeon M340 2GB Graphics<br><br>\r\nUbuntu Linux 16.04 operating system<br><br>\r\n2.3kg laptop\r\nCPU processor speed Up to 3.2 GHz<br><br>\r\nProcessor speed in technical details refers to the maximum processor speed. Base processor frequency may Integrated widescreen HD 720P webcam with single digital microphone', 36990),
(49, 'del3', 'Dell Inspiron 5567', 'laptop', 'Stylishly crafted: Add beauty to your desk the moment you open your laptop, showing off the stylish, brushed hairline palm rest. And the optional backlit, bottom-mount keyboard makes typing more comfortable. High-end features, exceptional extras. Whatever view suits you: Enjoy views on a sizeable 38.1cm(15) screen, with HD display, perfect for projects or streaming videos. Operating System: DOS Your backup plan: Increase storage as your libraries grow, saving music, movies and files on discs with your DVD drive. As powerful as you need it to be: With the latest Intel® 7th Gen processors, you can enjoy quick, responsive performance that keeps your music and videos playing smoothly while your other programs run in the background. Ports & Slots 1.SD Card Slot | 2.USB 2.0 port | 3.DVD drive | 4.Noble lock | 5.AC Power | 6.10/100 RJ-45 Ethernet Network | 7.HDMI | 8.USB 3.0 port (x2) | 9.Combo Jack (Headset/Mic) Dimensions & Weight 1. Height: 23.3mm (0.92) | 2. Width: 390mm (15.35) | 3. Depth: 259mm (10.20) | Non-touch : 2.36kg (5.20lb)', 'laptop/dell/inspiron5567.jpg', 'https://www.amazon.in/INSPIRON-5567-LAPTOP-i3-6006U-BLACK/dp/B078S44VMY?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=e611ec2c-7ba3-4cbe-87c0-41e4d88fc18b', '<br><br>Processor - Intel Core i3-6006U<br><br>\r\nSystem Memory - 4 GB DDR4 RAM<br><br>\r\nHDD Capacity - 1 TB HDD<br><br>\r\nOperating System - DOS<br><br>\r\nResolution - 1920 x 1080 pixel, English Backlit Keyboard', 30460),
(50, 'del4', 'Dell Inspiron Core i3 6th Gen', 'laptop', 'With a 6th generation Core i3 processor, this Dell laptop strikes a fine balance between performance and battery life. The 2.0 GHz dual-core processor, with multithreading support, offers ample computing power, while using minimal electricity.', 'laptop/dell/inspironcorei3.jpg', 'https://www.flipkart.com/dell-inspiron-core-i3-6th-gen-4-gb-1-tb-hdd-linux-3467-laptop/p/itmf3s32t9tyhkkj?gclid=Cj0KCQjwh7zWBRCiARIsAId9b4qDwhL2fMOmIcUfGBBmEc7rUQt90gqPNSbm2FuFzrlaWGHZRXymSXwaAkQNEALw_wcB&pid=COMEQG4WM2VF3GZC&lid=LSTCOMEQG4WM2VF3GZCZFT6DT&cmpid=content_computer_8965229628_gmc_pla&tgi=sem%2C1%2CG%2C11214002%2Cg%2Csearch%2C%2C49950237140%2C1o1%2C%2C%2Cc%2C%2C%2C%2C%2C%2C%2C&s_kwcid=AL%21739%213%2149950237140%21%21%21g%21304809783556%21&ef_id=Wrhj7gAAADuDGjsb%3A20180412151048%3As', '<br><br>Intel Core i3 Processor (6th Gen)<br><br>\r\n4 GB DDR4 RAM<br><br>\r\nLinux/Ubuntu Operating System<br><br>\r\n1 TB HDD<br><br>\r\n14 inch Display', 25990),
(51, 'del5', 'dell latitude', 'laptop', 'this laptop is i5 core 3rd generation with excellant features.\r\n\r\nHard Drive Capacity:	320 GB	Manufacturer/Packer/Importer Details:	Dell\r\n\r\nMemory:	4 GB	\r\n', 'laptop/dell/latitude.jpg', 'https://www.ebay.in/itm/273114350116?aff_source=Sok-Goog', '<br><br>Core i5 3rd gen <br><br>4gb Ram, 320GB hdd <br><br>14.1\" Led Screen Win 10', 14999),
(52, 'del6', 'Dell XPS 13', 'laptop', 'New XPS 13 9630, 13.3\", 8th Gen Corei5-8250U, 8GB RAM, 256GB SSD, Intel UHD Graphics, Win 10 Home, MS Office H & S 2016, 1 Year Premium Support, 1 year warranty provided by the manufacturer from date of purchase and Windows 10 Home.', 'laptop/dell/xps13.jpg', 'https://www.amazon.in/Dell-XPS-9360-13-3-inch-Laptop/dp/B07B4519PB?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=e611ec2c-7ba3-4cbe-87c0-41e4d88fc18b', '<br><br>Intel Core i5 - 8250 U processor<br><br>\r\n8GB DDR3 RAM<br><br>\r\n256GB hard drive<br><br>\r\n13.3-inch screen, Intel UHD graphics<br><br>\r\nWindows 10 Home operating system\r\n2kg laptop', 90447),
(53, 'len1', 'Lenovo G-50', 'laptop', 'this product has excellence features and very beautiful design,its new in the market with following features.\r\n\r\ndedicated Graphic Memory Type\r\nDDR3\r\nDedicated Graphic Memory Capacity\r\n2 GB\r\nProcessor Brand\r\nIntel\r\nProcessor Name\r\nCore i3\r\nProcessor Generation\r\n5th Gen\r\nSSD\r\nNo\r\nRAM\r\n4 GB\r\nRAM Type\r\nDDR3\r\nHDD Capacity\r\n1 TB\r\nProcessor Variant\r\n5005U\r\nClock Speed\r\n2 GHz\r\nMemory Slots\r\n2 Slots\r\nExpandable Memory\r\nUpto 16 GB\r\nCache\r\n3 MB\r\nRPM\r\n5400\r\nGraphic Processor\r\nAMD Radeon Exo Pro R5 M330\r\nOperating System\r\nOperating System\r\nDOS\r\nPort And Slot Features\r\nMic In\r\nYes\r\nRJ45\r\nYes\r\nVGA Port\r\nYes\r\nUSB Port\r\n1 x USB 3.0, 2 x USB 2.0\r\nHDMI Port\r\nYes\r\nMulti Card Slot\r\n2-in-1 Card Reader\r\nHardware Interface\r\nSATA\r\nDisplay And Audio Features\r\nTouchscreen\r\nNo\r\nScreen Size\r\n15.6 inch\r\nScreen Type\r\nHD TN Glare Flat Display\r\nSpeakers\r\nYes\r\nSound Properties\r\nStereo with Dolby Advanced Audio, 2 x 1.5 W Speakers\r\nConnectivity Features\r\nWireless LAN\r\nIEEE 802.11b/g/n\r\nBluetooth\r\nv4.0\r\nEthernet\r\n100/1000BASE-T\r\nDimensions\r\nDimensions\r\n384 x 265 x 25 mm\r\nWeight\r\n2.5 kg\r\nAdditional Features\r\nDisk Drive\r\nCD/DVD writer\r\nWeb Camera\r\n0.3 Megapixel Webcam\r\nRead/Write Speed\r\n8x\r\nKeyboard\r\nAccuType Keyboard\r\nPointer Device\r\nTouchpad with Multi-touch Gesture Support\r\nWarranty\r\nWarranty Summary\r\n1 Year Onsite Warranty', 'laptop/lenovo/g50.jpg', 'https://www.flipkart.com/lenovo-g50-80-core-i3-5th-gen-4-gb-1-tb-hdd-dos-2-gb-graphics-laptop/p/itmf3s3yjuf3fczg?gclid=Cj0KCQjwh7zWBRCiARIsAId9b4rpR-tc_U4qD5hYQdTRkKQzKqAD12t__b4mUg3EVID_xQvGoklOcWIaAlkHEALw_wcB&pid=COMECC3UZZZAXBRY&lid=LSTCOMECC3UZZZAXBRYEES7DD&cmpid=content_computer_8965229628_gmc_pla&tgi=sem%2C1%2CG%2C11214002%2Cg%2Csearch%2C%2C170219493259%2C1o1%2C%2C%2Cc%2C%2C%2C%2C%2C%2C%2C&s_kwcid=AL%21739%213%21170219493259%21%21%21g%21322269839008%21&ef_id=Wrhj7gAAADuDGjsb%3A20180412164230%3As', '<br><br>Intel Core i3 Processor (5th Gen)<br><br>\r\n4 GB DDR3 RAM<br><br>\r\nDOS Operating System<br><br>\r\n1 TB HDD<br><br>\r\n15.6 inch Display', 31000),
(54, 'len2', 'Lenovo IdeaPad 320', 'laptop', 'Powerful Laptop at an Affordable Price\r\n\r\nWith the 6th generation Intel Core i3 processor under the hood, the Lenovo Ideapad 320E 80XH01GKIN is an ideal laptop for everyday use. With 4GB DDR4 RAM, switch between multiple applications or browser tabs for a smooth multitasking experience. Perform productivity tasks at work or browse the internet with equal ease using this laptop. Depending on your specific requirements, you can load your own OS on this laptop.\r\n\r\nGreat Overall Multimedia Experience\r\nWith integrated Intel graphics and a bright 15.6-inch HD display, this is the perfect laptop for rich multimedia consumption. Enjoy watching movies, shows or viewing your photographs on this high resolution display. Its crystal clear audio lets you enjoy realistic and immersive sound. Store as many movies and media as you want on the 1TB HDD and play your external optical media using the DVD-RW drive.\r\n\r\nStylish Design in a Lightweight Package\r\nFeaturing an attractive design with a full-sized keyboard for the perfect combination of style and substance, the Lenovo Ideapad 320E 80XH01GKIN is a highly versatile solution for everyday use. Weighing only 2.2 kgs, encased in a sleek shell, this laptop is ideal to carry around and can fit inside most bags with ease. It is packed with connectivity options such as HDMI, USB 3.0, VGA, Bluetooth v4 and more.\r\n\r\n\"FAQ on touch pad : Please refer warranty PDF in technical specifications section for detailed steps from the brand to resolve this problem.\"', 'laptop/lenovo/ideapad320.jpg', 'https://www.amazon.in/Lenovo-80XH01GKIN-15-6-inch-i3-6006U-Integrated/dp/B074DYBT2K?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=e611ec2c-7ba3-4cbe-87c0-41e4d88fc18b', '<br><br>Up to 2GHz Intel Core i3-6006U 6th Gen processor<br><br>\r\n4GB DDR4 RAM<br><br>\r\n1TB 5400rpm Serial ATA hard drive<br><br>\r\n15.6-inch screen, Integrated Graphics<br><br>\r\nDOS operating system,\r\n2.2kg lapto', 25490),
(55, 'len3', 'lenovo ideapad A 10', 'laptop', 'The Lenovo IdeaPad A10 Slatebook is a budget laptop ideal for minimum usage. It uses an ARM Cortex-A9 processor with 1GB of RAM.This laptop has a 25.65 cm (10.1) 10-point multitouch display which lets you interact with your A10 through intuitive gestures. The hinge prevents the screen from moving when touched, allowing for more control while using touchscreen apps.', 'laptop/lenovo/ideapadA10.jpg', 'https://www.flipkart.com/lenovo-ideapad-a10-59-388639-slatebook-quad-core-a9-1gb-16gb-emmc-android-4-2-touch/p/itmf3s3fg3fjpyqf', '<br><br>AMD APU Dual Core A4 Processor<br><br>\r\n1 GB DDR3 RAM<br><br>\r\nAndroid Operating System<br><br>\r\n16 GB SSD<br><br>\r\n10 inch Touchscreen Display', 15890),
(56, 'len4', 'Lenovo Think Pad', 'laptop', 'This laptop is especially made for business purpose,contains excellant features.\r\nCore i3 (6th Generation) 4 GB 35.81cm(14.1)', 'laptop/lenovo/thinkpad.jpg', 'https://www.snapdeal.com/product/lenovo-thinkpad-e470-notebook-core/652786692375?supc=SDL939359587&utm_source=earth&utm_campaign=%7Bcampaignid%7D&utm_medium=57_34989&utm_content=652786692375&utm_term=%7Badgroupid%7D&vendorCode=S7e7cd&utm_campaign=Catchall_estimatedCM_New&utm_term=50431176612&utm_medium=50431176612&gclid=Cj0KCQjwh7zWBRCiARIsAId9b4rsHc3TMqY8igo9gNbxWpl5RXHojzw502tygutfOZ5Nlm8w2pS0L6IaAug2EALw_wcB', '<br><br>Warranty Period:1 Year	<br><br>	\r\nBase Clock Speed (in GHz):2.3	\r\nBacklit <br><br>Keyboard:No	\r\nOptical Drive:Not Available', 34989),
(57, 'len5', 'Lenovo V3 10', 'laptop', 'LENOVO V310-15ISK 80SY03E3IH LAPTOP ( INTEL CORE I3 - 6TH GENERATION / 6100U 2.3GHz / 4GB DDR4 RAM / 1TB HARDISK / 15.6 HD SCREEN / INTEGRATED INTEL GRAPHIC / WIFI / BLUETOOTH / WEBCAMERA / FINGERPRINT SENSOR / DOS / BLACK. WITH OUT BAG', 'laptop/lenovo/v310.jpg', 'https://www.amazon.in/80SY03E3IH-15-6-inch-i3-6100U-Integrated-Graphics/dp/B06VSSDTYQ', '<br><br>LENOVO V310-15ISK 80SY03E3IH LAPTOP\r\nINTEL CORE I3 - 6TH GENERATION / 6100U 2.3GHz<br><br>\r\n4GB DDR4 RAM / 1TB HARDISK <br><br> 15.6 HD SCREEN<br><br> /INTEGRATED INTEL GRAPHIC\r\n/ WIFI / BLUETOOTH / WEBCAMERA / FINGERPRINT SENSOR / DOS / BLACK COLOUR / WITHOUT BAG.<br><br>\r\n1 YEAR LENOVO MANUFACTURER WARRANT', 25400),
(58, 'len6', 'Lenovo Yoga 920', 'laptop', 'Built for Windows Ink. Lenovo\'s Active Pen 2 Stylus Included\r\n\r\n13.9\" touch screen for hands-on control. 1920 x 1080 native resolution. IPS technology. LED backlight.\r\n\r\n8th Gen Intel® Core™ i7-8550U mobile processor. Ultra-low-voltage platform. Quad-core processing performance.\r\n\r\n8GB system memory for intense multitasking and gaming\r\n\r\n256GB solid state drive (SSD)\r\n\r\n360° flip-and-fold design. Offers four versatile modes — laptop, tablet, tent and stand. Lenovo Transition automatically switches specific applications to full screen when changing from PC to tablet, tent or stand position.\r\n\r\nIntel® UHD Graphics 620\r\n\r\nOn-processor graphics with shared video memory provide everyday image quality for Internet use, basic photo editing and casual gaming.\r\n\r\nWeighs 3.02 lbs. and measures 0.5\" thin. Ultraportable design, featuring a smaller screen size and omitting the DVD/CD drive to achieve the compact form factor. 4-cell lithium-ion battery.\r\n\r\nBluetooth interface syncs with compatible devices\r\n\r\n2 USB Type-C ports\r\n\r\n1 USB 3.0 port maximizes the latest high-speed devices\r\n\r\nThunderbolt port for connecting advanced monitors and external drives\r\n\r\nNext-generation wireless connectivity, Connect to a Wireless-AC router for speed nearly 3x faster than Wireless-N.\r\n\r\nBuilt-in HD webcam with four microphones\r\n\r\nBuilt-in fingerprint reade\r\n\r\nWindows 10 Home operating system\r\n\r\nHeadphone/microphone combo jack.\r\n\r\nNote: This laptop does not include a built-in DVD/CD drive.\r\n\r\n', 'laptop/lenovo/yoga920.jpg', 'https://www.amazon.com/Lenovo-Yoga-920-i7-8550U-Bronze/dp/B07799BTX7', '<br><br>8th Gen Intel® Core™ i7-8550U mobile processor<br><br> 8GB system memory<br><br> 256GB solid state drive (SSD)<br><br>Intel® UHD Graphics 620\r\n13.9\" touch screen for hands-on control; 1920 x 1080 native resolution. IPS technology. LED backlight.<br><br>\r\nWindows 10 Home operating system; Built for Windows Ink<br><br>Lenovo\'s Active Pen 2 stylus included\r\n360° flip-and-fold design; Weighs 3.02 lbs. and measures 0.5\" thin; 4-cell lithium-ion battery; Bluetooth interface syncs with compatible devices;\r\n2 Thunderbolt USB Type-C ports; 1 USB 3.0 port; Wireless-AC.', 74750),
(59, 'ts1', 'Samsung galaxy tab A', 'Tablet', 'Samsung Galaxy Tab A SM-T355YZWA Tablet \r\nSmart features, faster performance\r\n\r\nArmed with the 1.20 GHz Qualcomm processor and 1.50 GB RAM, the Samsung A SM-T355YZWA Tablet delivers faster performance and allows you to complete your work quickly and efficiently. It has a sleek and stylish design along with a compact and slim body. Hence, it is highly portable and you get to carry it anywhere you want. It comes with the Android operating system that provides access to all Android services and apps. The 8 Inch display screen and effective speakers provide the ideal multimedia experience by enhancing the quality of audio and visuals of your favourite movie or game.\r\n\r\nImproved camera and better battery life\r\nThis Samsung Tablet has a couple of powerful cameras which are capable of taking high quality images with perfect clarity. You also get to click better selfies with this tablet as it is equipped with an effective front camera. The various shooting modes and camera options allow you to do more with your images. Along with clicking images, this camera is also effective when it comes to recording videos as well. With the Ultra Power Saving Mode, this tablet saves power during its functions and thus enhances the overall battery life.\r\n\r\nEffective multitasking tools and 16 GB storage\r\nWith the cutting edge multitasking tools of this tablet, you can run various programs simultaneously. The Multi Window feature of this tablet allows you to access two different apps side by side. The 16 GB storage capacity is effective in accommodating your data.\r\n\r\nMicrosoft Office feature for smart working\r\nMicrosoft Office offers an effective working platform. This Samsung Galaxy Tablet is equipped with the Microsoft Office feature which is ideal for working professionals. With the Microsoft Word, you can edit and review any document; while the Microsoft Excel makes data collection simple with its easy to use tables and charts. You can create impressive presentations that stand out with the Microsoft PowerPoint feature. Moreover, PowerPoint comes with various options and modes so that you get to do more with every presentation. The Microsoft OneDrive with its 100 GB storage keeps all your documents and data safe. With this OneDrive feature, you can access your files from anywhere by simply logging into your Microsoft account.', 'tablet/samtabs/samt1.jpg', 'https://www.amazon.in/Samsung-Tab-SM-T355YZAAINS-Calling-Titanium/dp/B010B6H7BM/ref=sr_1_1?s=electronics&ie=UTF8&qid=1521507967&sr=1-1&keywords=samsung+tabs+new', '<br><br>5 MP Primary Camera and 2 MP Front Camera<br><br>\r\n8 inch TFT display of the samsung galaxy Tab A, It renders 1024 x 768 pixels and 16 M colour depth<br><br>\r\nAndroid 5.0 lollipop operating system (OS)<br><br>1.2 GHz quad-core processor<br><br>\r\n16 GB internal memory<br><br>4200 mAh non-removable Li-Ion Battery\r\n', 16500),
(60, 'ts2', 'Samsung galaxy Tab s3', 'tablet', 'The new Galaxy Tab S3 Do what you want when you want with the new Galaxy Tab S3, the tablet that redefines what you can do with one device. Whether you’re working, playing, creating or gaming, the Galaxy Tab S3 is a blank canvas, a theater screen, and a productivity hub all in one.', 'tablet/samtabs/samt2.jpg', 'https://www.amazon.in/Samsung-Galaxy-SM-T825-Tablet-Calling/dp/B072K57X6J/ref=sr_1_1?s=electronics&ie=UTF8&qid=1521508944&sr=1-1&keywords=samsung+galaxy+tab+s3', '<br><br>13MP primary camera with flash LED, auto focus and 5MP front facing camera<br><br>\r\n24.638 centimeters (9.7-inch) Super AMOLED capacitive touchscreen with 2048 x 1536 pixels resolution and 16M color support<br><br>\r\nAndroid v7 Nougat operating system with 2.15GHz + 1.6GHz Snapdragon 820 quad core processor<br><br>4GB RAM, 32GB internal memory expandable up to 256GB and single nano SIM\r\n6000mAH lithium-ion battery providing talk-time of 36 hours on 3G', 34500),
(62, 'ts3', 'Samsung galaxy tab 8', 'tablet', 'The Samsung Galaxy Tab 3 V is powered by 1.2GHz quad-core and it comes with 2 GB of RAM. The tablet packs 16GB of internal storage that can be expanded up to 128GB via a microSD card. As far as the cameras are concerned, the Samsung Galaxy Tab 3 V packs a 5-megapixel primary camera on the rear.\r\n\r\nThe Samsung Galaxy Tab 3 V runs Android 4.4 and is powered by a 4200mAh non removable battery. It measures 193.40 x 116.40 x 9.70 (height x width x thickness) and weighs 322.00 grams.\r\n\r\nConnectivity options include Wi-Fi, GPS, Bluetooth, FM. Sensors on the tablet include Proximity sensor, Ambient light sensor, Accelerometer, and Gyroscope', 'tablet/samtabs/samt33.jpg', 'https://www.amazon.in/Samsung-Tab-SM-T355YZWA-Tablet-Calling/dp/B010B3Y86C/ref=sr_1_10?s=electronics&ie=UTF8&qid=1521511220&sr=1-10&keywords=samsung+galaxy+tab+8', '<br><br>5MP primary camera with autofocus,2 MP front facing camera<br><br>\r\n8.0 inch,TFT capacitive touchscreen, 16M colors,768 x 1024 pixels resolution<br><br>\r\nOS-Android OS, v5.0 (Lollipop),Quad-core 1.2 GHz,16 GB, 2 GB RAM (LTE)<br><br>\r\nNon-removable Li-Ion 4200 mAh battery', 16500),
(63, 'ts4', 'Samsung Galaxy SM', 'tablet', 'Stylish, ergonomic design: Impeccably portable at just 8.5 mm thick and 495 g, the Galaxy Tab E couples sleek-look design with incredible practicality. Its unique, non-slip fabric-style rear casing provides you with a secure and comfortable grip. Practical camera options: Capture the most unforgettable moments of your everyday life with the Galaxy Tab E’s advanced camera features – including a powerful 5 MP rear camera, as well as easy-to-use one-click photo and video controls. Toggle continuous shot mode by holding down the camera button. Enhanced multi-tasking: Maximise your time and productivity with the exciting multi-window feature – allowing you to work on two apps at the same time. Enter a split-screen mode to multitask with ease on a spacious 9.6\' display. Increased memory options: Expand your Galaxy Tab E’s capacity and take your favourite films, music and books with you wherever you go. With compatibility for up to 128 GB of micro SD card storage, turn your tablet into a mobile entertainment centre. Smart tutor: Having problems getting to grips with the many functions of your new Galaxy Tab E? No need to fret, thanks to the Samsung smart tutor app – remote-controlled assistance provided by a team of devoted technical experts. Child-friendly functions: Kids mode provides a wide range of fun, educational apps for your children, along with cute, adorable characters and icons – a boon for younger Tab E users. Monitor your children’s Tab E activities, block unsuitable apps and set time limits for their tablet usage.', 'tablet/samtabs/samt44.jpg', 'https://www.amazon.in/Samsung-Galaxy-SM-T561NZKAINS-Calling-Metallic/dp/B012MWF7II/ref=sr_1_5?s=electronics&ie=UTF8&qid=1521511220&sr=1-5&keywords=samsung+galaxy+tab+8', '<br><br>5MP primary camera and 2MP front facing camera<br><br>\r\n9.6-inch (24.34cm) TFT capacitive touchscreen with 1280 x 800 pixels resolution and 16M color support\r\n<br><br>Android operating system with 1.3GHz quad core processor, 1.5GB RAM, 8GB internal memory expandable up to 128GB and single micro SIM<br><br>\r\n5000mAH lithium-ion battery providing talk-time of 26 hours', 13899),
(64, 'ts5', 'Samsung Galaxy 7', 'tablet', 'Capture the most unforgettable moments of your everyday life with the Galaxy Tab E’s advanced camera features – including a powerful 5 MP rear camera, as well as easy-to-use one-click photo and video controls. Toggle continuous shot mode by holding down the camera button. Enhanced multi-tasking: Maximise your time and productivity with the exciting multi-window feature – allowing you to work on two apps at the same time. Enter a split-screen mode to multitask with ease on a spacious 9.6\' display. Increased memory options: Expand your Galaxy Tab E’s capacity and take your favourite films, music and books with you wherever you go. With compatibility for up to 128 GB of micro SD card storage, turn your tablet into a mobile entertainment centre. Smart tutor: Having problems getting to grips with the many functions of your new Galaxy Tab E? No need to fret, thanks to the Samsung smart tutor app – remote-controlled assistance provided by a team of devoted technical experts. Child-friendly functions: Kids mode provides a wide range of fun, educational apps for your children, along with cute, adorable characters and icons – a boon for younger Tab E users. Monitor your children’s Tab E activities, block unsuitable apps and set time limits for their tablet usage.', 'tablet/samtabs/samt6.jpg', 'https://www.amazon.in/Samsung-Galaxy-Tab-7-0-Calling/dp/B078LVWLJX/ref=sr_1_6?s=electronics&ie=UTF8&qid=1521511220&sr=1-6&keywords=samsung+galaxy+tab+8', '<br><br>5MP primary camera with auto focus and 2MP front facing camera<br><br>\r\n17.77 centimeters (7-inch) capacitive touchscreen with 1280 x 800 pixels resolution<br><br>\r\nAndroid v5.1 Lollipop operating system with 1.5GHz Spreadtrum quad core processor, 1.5GB, 8GB internal memory expandable up to 200GB and single SIM<br><br>\r\n4000mAH lithium-ion battery', 14687),
(65, 'ts6', 'Samsung Galaxy C7 pro ', 'tablet', 'NETWORKTechnologyGSM / HSPA / LTE2G bandsGSM 850 / 900 / 1800 / 1900 - SIM 1 & SIM 23G bandsHSDPA 850 / 900 / 1900 / 21004G bandsLTE band 1(2100), 3(1800), 5(850), 7(2600), 8(900), 38(2600), 39(1900), 40(2300), 41(2500)SpeedHSPA 42.2/5.76 Mbps, LTE-A (2CA) Cat6 300/50 MbpsGPRSYesEDGEYesLAUNCHAnnounced2017, JanuaryStatusAvailable. Released 2017, FebruaryBODYDimensions156.5 x 77.2 x 7 mm (6.16 x 3.04 x 0.28 in)Weight172 g (6.07 oz)BuildFront glass, aluminum bodySIMHybrid Dual SIM (Nano-SIM, dual stand-by)DISPLAYTypeSuper AMOLED capacitive touchscreen, 16M colorsSize5.7 inches, 89.6 cm2 (~74.1% screen-to-body ratio)Resolution1080 x 1920 pixels, 16:9 ratio (~386 ppi density)MultitouchYesPLATFORMOSAndroid 6.0.1 (Marshmallow), upgradable to 7.0 (Nougat)ChipsetQualcomm MSM8953-Pro Snapdragon 626CPUOcta-core 2.2 GHz Cortex-A53GPUAdreno 506MEMORYCard slotmicroSD, up to 256 GB (uses SIM 2 slot)Internal64 GB, 4 GB RAMCAMERAPrimary16 MP, f/1.9, autofocus, dual-LED dual-tone flashFeaturesGeo-tagging, touch focus, face detection, panorama, HDRVideo1080p@30fpsSecondary16 MP, f/1.9SOUNDAlert typesVibration; MP3, WAV ringtonesLoudspeakerYes3.5mm jackYes - Active noise cancellation with dedicated micCOMMSWLANWi-Fi 802.11 a/b/g/n/ac, dual-band, WiFi Direct, hotspotBluetooth4.2, A2DP, LEGPSYes, with A-GPS, GLONASSNFCYesRadioFM radioUSB2.0, Type-C 1.0 reversible connectorFEATURESSensorsFingerprint (front-mounted), accelerometer, gyro, proximity, compassMessagingSMS(threaded view), MMS, Email, Push Mail, IMBrowserHTML5 - Fast battery charging \r\n- ANT+ support \r\n- MP4/WMV/H.264 player \r\n- MP3/WAV/WMA/eAAC+/FLAC player \r\n- Photo/video editor \r\n- Document viewerBATTERY Non-removable Li-Ion 3300 mAh batteryMISCColorsGold, Pink Gold, Dark BluePriceAbout 370 EUR', 'tablet/samtabs/samt7.jpg', 'https://www.ebay.in/itm/152938012831?aff_source=Sok-Goog', '<br><br>Operating System:	Android Marshmallow 6.0<br><br>\r\nWarranty Service:	                Repair	Colour:	Gold\r\nBattery Capacity:	3300 mah	Type:	TouchSim Type:	Dual SIM(GSM + GSM)\r\nManufacturer/Packer/Importer Details:Does Not Apply	Operating System Version Name:	Android Marshmallow 6.0\r\nNet Quantity/Number of Units:	3	RAM:	4GB\r\nPackage/Unit Dimension:	Does Not Apply	Screen Size:	5.7 Inch\r\nDate of Packing, Import or Both:	jauary 2018	Storage Capacity (Internal):	64 GB\r\nContact Details for Consumer Complaints:	\r\nSamsung India private limited	Primary Camera:	13.0 MP\r\nCountry of Origin: india	\r\nSecondary Camera:	13.0 MP', 22999),
(66, 'htc1', 'HTC Google Nexus', 'tablet', 'This is the latest tablet with excellant feaures.', 'tablet/htctabs/htc1.jpg', 'https://www.ebay.in/itm/HTC-Google-Nexus-9-32GB-White-with-Android-Nougat-7-1-1-Wi-Fi-Only/322580830084?hash=item4b1b50d784:g:x7UAAOSwCtJagrff', '<br><br>\r\nOperating System:	Android 7.1.1<br><br>Screen Size:	9\"<br><br>	Serviced In India:	Yes<br><br>\r\nMPN:	0P82100-16-WHT	Voice Calling:	No<br><br>\r\nInternet Connectivity:	Wi-Fi	USB:	Yes<br><br>\r\nDisplay:	Full HD <br><br>Internal Memory:	32 GB<br><br> \r\nColour:	White', 22490),
(67, 'htc2', 'HTC nexus 9', 'tablet', 'Designed for work and play, the Nexus 9 features a just-right 8.9” screen with front-facing speakers for rich music and audio. 64-bit processor drives productivity and play to new levels, with intuitive voice commands and automatic Android updates that keep you on the cutting edge. Total device integration makes it mobile and access to over a million apps makes it amazing. Meet Nexus 9: For movers and makers.', 'tablet/htctabs/htc2.jpg', 'http://www.htc.com/in/tablets/nexus-9/', '<br><br>8.9” screen\r\nFront-facing stereo speakers\r\nAccess to over a million apps<br><br>\r\nAutomatic Android updates.<br><br>\r\nSeamless device integration', 17450),
(68, 'htc3', 'HTC flyer', 'tablet', 'Latest tablet in the market with excellent features.', 'tablet/htctabs/htc3.jpg', 'https://www.flipkart.com/htc-flyer/p/itmdmypfxphkmajn', '<br><br>1 GB RAM\r\nExpandable Upto 32 GB<br><br>\r\n5 MP Primary Camera | 1.3 MP Front<br><br>\r\nAndroid 2.3 (Gingerbread)<br><br>\r\nBattery: 4000 mAh Lithium - Ion<br><br>\r\nProcessor: Qualcomm Scorpion', 18000),
(69, 'htc4', 'HTC nexus', 'laptop', 'This tablet has some excellant features:\r\nInternet Connectivity:	Wi-Fi	USB:	Yes\r\nDisplay:	Full HD	Warranty Service:	Repair\r\nContact Details for Consumer Complaints:	1800-209-3229	Warranty Duration:	1 Year', 'tablet/htctabs/htc4.jpg', 'https://www.ebay.in/itm/HTC-Google-Nexus-9-32GB-White-with-Android-Nougat-7-1-1-Wi-Fi-Only/322580830084?hash=item4b1b50d784:g:x7UAAOSwCtJagrff', '<br><br>Operating System:	Android 7.1.1<br><br>\r\nScreen Size:	9\"<br><br>\r\nMPN:	0P82100-16-WHT	Voice Calling:	No<br><br>	RAM:	2 GB<br><br>Internal Memory:	32 GB (*Actual Free space will be less)', 22490),
(70, 'htc5', 'HTC low end tablet', 'tablet', 'Product Details\r\nDisplay Size\r\n7 inch\r\nSales Package\r\nTablet, Battery, Charger, Data Cable, Pouch, Pen, Quick Start Quide\r\nDisplay Resolution\r\n1024 x 600 pixels\r\nPrimary Camera\r\n5 megapixels\r\nInternal Storage\r\n32 GB\r\nProcessor Speed\r\n1.5 GHz\r\nUSP\r\nAndroid v2.3 OS, 7 inch TFT Touchscreen, 5 MP Primary Camera, 1.5 GHz Processor\r\nGraphics Processors\r\nAdreno 205\r\nSensors\r\nAmbient Light Sensor, G-Sensor, Digital Compass\r\nSim Type\r\nSingle Sim\r\nBattery Features\r\nBattery Capacity\r\n4000 mAh\r\nBattery Type\r\nLithium - Ion\r\nStand By Time\r\n320 (3G), 480 (Over Wi-Fi)\r\nInternet Browsing Time\r\n6.5 hrs (Over Wi-Fi), 6.5 hrs (3G)\r\nPlay Time\r\nVideo: 8 hrs (3G), 8 hrs (Over Wi-Fi)\r\nBusiness Features\r\nE-mail\r\nYes\r\nPushmail\r\nYes\r\nOther Business Features\r\nWi-Fi Printing\r\nCamera Features\r\nSecondary Camera\r\n1.3 megapixels\r\nVideo Recording Resolution\r\n1280 x 720 pixels\r\nVideo Recording\r\nYes\r\nHD Recording\r\nYes\r\nOther Camera Features\r\nGeo-tagging, Auto Focus\r\nConnectivity Features\r\n2G\r\nYes\r\n3G\r\nYes\r\n3G via Dongle\r\nNo\r\n3G Speed\r\nHSDPA 14.4 Mbps, HSUPA 5.76 Mbps\r\nEdge\r\nYes\r\nGPRS\r\nYes\r\nBluetooth Version\r\n3\r\nUSB\r\nYes, USB 2.0\r\nBluetooth Profiles\r\nA2DP\r\nHDMI\r\nNo\r\nHeadphone Jack\r\n3.5 mm\r\nWi-fi Version\r\n802.11 b/g/n\r\nDisplay Features\r\nTouch Screen Type\r\nCapacitive\r\nOther Display Features\r\nHandwriting Support\r\nDisplay Colors\r\n16 M\r\nDisplay Type\r\nTFT\r\nMultimedia Features\r\nVideo Formats Supported\r\n3GP, 3G2, MP4, WMV, AVI, XviD, H.263, H.264\r\nHD Playback\r\nYes\r\nVideo Playback\r\nYes\r\nAudio Formats Supported\r\nMP3, WAV\r\nNavigation Features\r\nGPS Support\r\nYes\r\nGPS Type\r\nA-GPS\r\nMap Support\r\nGoogle Maps\r\nStorage Features\r\nExpandable Storage Capacity\r\n32 GB\r\nMemory Card Slot Type\r\nmicroSD Card\r\nMemory Card Support\r\nYes', 'tablet/htctabs/htc5.jpg', 'https://www.flipkart.com/htc-flyer/p/itmdmypfxphkmajn', '<br><br>1 GB RAM\r\nExpandable Upto 32 GB<br><br>\r\n5 MP Primary Camera | 1.3 MP Front<br><br>\r\nAndroid 2.3 (Gingerbread)<br><br>\r\nBattery: 4000 mAh Lithium - Ion<br><br>\r\nProcessor: Qualcomm Scorpion', 15000),
(71, 'htc6', 'HTC flyer 7', 'tablet', 'General\r\nModel Number\r\nFlyer\r\nModel Name\r\nFlyer\r\nColor\r\nSilver\r\nConnectivity\r\nWi-Fi+3G\r\nOS\r\nAndroid\r\nOperating System Version\r\n2.3 (Gingerbread)\r\nRAM\r\n1 GB\r\nVoice Call\r\nNo\r\nDisplay Resolution Type\r\nSD\r\nSupported Network\r\nUMTS\r\nBattery Features\r\n4000 mAh\r\nProcessor Type\r\nQualcomm Scorpion\r\nUser Interface\r\nHTC Sense\r\nAdditional Features\r\nSNS Integration, Adobe Flash 10.1 Player, Predictive Text Input\r\nProduct Details\r\nDisplay Size\r\n7 inch\r\nSales Package\r\nTablet, Battery, Charger, Data Cable, Pouch, Pen, Quick Start Quide\r\nDisplay Resolution\r\n1024 x 600 pixels\r\nPrimary Camera\r\n5 megapixels\r\nInternal Storage\r\n32 GB\r\nProcessor Speed\r\n1.5 GHz\r\nUSP\r\nAndroid v2.3 OS, 7 inch TFT Touchscreen, 5 MP Primary Camera, 1.5 GHz Processor\r\nGraphics Processors\r\nAdreno 205\r\nSensors\r\nAmbient Light Sensor, G-Sensor, Digital Compass\r\nSim Type\r\nSingle Sim\r\nBattery Features\r\nBattery Capacity\r\n4000 mAh\r\nBattery Type\r\nLithium - Ion\r\nStand By Time\r\n320 (3G), 480 (Over Wi-Fi)\r\nInternet Browsing Time\r\n6.5 hrs (Over Wi-Fi), 6.5 hrs (3G)\r\nPlay Time\r\nVideo: 8 hrs (3G), 8 hrs (Over Wi-Fi)\r\nBusiness Features\r\nE-mail\r\nYes\r\nPushmail\r\nYes\r\nOther Business Features\r\nWi-Fi Printing\r\nCamera Features\r\nSecondary Camera\r\n1.3 megapixels\r\nVideo Recording Resolution\r\n1280 x 720 pixels\r\nVideo Recording\r\nYes\r\nHD Recording\r\nYes\r\nOther Camera Features\r\nGeo-tagging, Auto Focus\r\nConnectivity Features\r\n2G\r\nYes\r\n3G\r\nYes\r\n3G via Dongle\r\nNo\r\n3G Speed\r\nHSDPA 14.4 Mbps, HSUPA 5.76 Mbps\r\nEdge\r\nYes\r\nGPRS\r\nYes\r\nBluetooth Version\r\n3\r\nUSB\r\nYes, USB 2.0\r\nBluetooth Profiles\r\nA2DP\r\nHDMI\r\nNo\r\nHeadphone Jack\r\n3.5 mm\r\nWi-fi Version\r\n802.11 b/g/n\r\nDisplay Features\r\nTouch Screen Type\r\nCapacitive\r\nOther Display Features\r\nHandwriting Support\r\nDisplay Colors\r\n16 M\r\nDisplay Type\r\nTFT\r\nMultimedia Features\r\nVideo Formats Supported\r\n3GP, 3G2, MP4, WMV, AVI, XviD, H.263, H.264\r\nHD Playback\r\nYes\r\nVideo Playback\r\nYes\r\nAudio Formats Supported\r\nMP3, WAV\r\nNavigation Features\r\nGPS Support\r\nYes\r\nGPS Type\r\nA-GPS\r\nMap Support\r\nGoogle Maps\r\nStorage Features\r\nExpandable Storage Capacity\r\n32 GB\r\nMemory Card Slot Type\r\nmicroSD Card\r\nMemory Card Support\r\nYes', 'tablet/htctabs/htc6.jpg', 'https://www.flipkart.com/htc-flyer/p/itmdmypfxphkmajn', '<br><br>1 GB RAM\r\nExpandable Upto 32 GB<br><br>\r\n5 MP Primary Camera | 1.3 MP Front<br><br>\r\nAndroid 2.3 (Gingerbread)<br><br>\r\nBattery: 4000 mAh Lithium - Ion<br><br>\r\nProcessor: Qualcomm Scorpion', 18500),
(72, 'app1', 'Apple ipad tablet gold', 'tablet', 'Learn, play, surf, create. iPad gives you the incredible display, performance and apps to do what you love to do. Anywhere. Easily. Magically. The 64-bit A9 chip delivers performance that makes every app feel fast and fluid. Explore rich learning apps, play graphics-intensive games or even use two apps at once. All while enjoying up to 10 hours of battery life. iOS 10 is the most advanced, intuitive and secure mobile operating system in the world. It\'s so capable, you can work and play using two apps at once. 8-megapixel camera with 1080p HD video.', 'tablet/applet/ap1.jpg', 'https://www.amazon.in/Apple-iPad-Tablet-inch-Wi-Fi/dp/B06Y6744LJ/ref=sr_1_1?s=computers&ie=UTF8&qid=1521514523&sr=1-1&refinements=p_89%3AApple', '<br><br>8MP primary camera with auto focus, panorama, HDR, exposure control, burst mode, tap to focus, timer mode, f/2.4 aperture, five-element lens, hybrid IR filter, backside illumination, auto image stabilisation, face detection, photo geotagging, video image stabilisation, slow motion (120 fps), 3X video zoom, video geotagging and 1.2MP front facing camera\r\n24.64 centimeters (9.7-inch) LED Backlit Display with IPS Technology, Fingerprint-resistant Oleophobic Coating with 2048 x 1536 pixels resolution and 264 ppi pixel density\r\niOS v10 operating system with A9 Chip with 64-bit Architecture with Embedded M9 Co-processor processor, 32GB internal memory\r\n32.4mAH lithium-polymer battery', 25900),
(73, 'app2', 'Apple ipad tablet grey', 'tablet', 'Learn, play, surf, create. iPad gives you the incredible display, performance and apps to do what you love to do. Anywhere. Easily. Magically. The 64-bit A9 chip delivers performance that makes every app feel fast and fluid. Explore rich learning apps, play graphics-intensive games or even use two apps at once. All while enjoying up to 10 hours of battery life. iOS 10 is the most advanced, intuitive and secure mobile operating system in the world. It\'s so capable, you can work and play using two apps at once. 8-megapixel camera with 1080p HD video.', 'tablet/applet/ap2.jpg', 'https://www.amazon.in/Apple-Tablet-128GB-Wi-Fi-Space/dp/B06ZYMFFMH/ref=sr_1_2?s=computers&ie=UTF8&qid=1521514523&sr=1-2&refinements=p_89%3AApple', '<br><br>8MP primary camera with auto focus, panorama, HDR, exposure control, burst mode, tap to focus, timer mode, f/2.4 aperture, five-element lens, hybrid IR filter, backside illumination, auto image stabilisation, face detection, photo geotagging, video image stabilisation, slow motion (120 fps), 3X video zoom, video geotagging and 1.2MP front facing camera\r\n24.64 centimeters (9.7-inch) LED Backlit Display with IPS Technology, Fingerprint-resistant Oleophobic Coating with 2048 x 1536 pixels resolution and 264 ppi pixel density\r\niOS v10 operating system with A9 Chip with 64-bit Architecture with Embedded M9 Co-processor processor, 128GB internal memory\r\n32.4mAH lithium-polymer battery\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 35555),
(74, 'app3', 'Apple ipad pro 12HN/A Tablet', 'tablet', 'No matter the task, the new iPad Pro is up to it - and then some. It offers far more power than most PC laptops, yet is delightfully SIMple to use. Pad has always offered the ultimate Multi-Touch experience. The new iPad Pro Retina display now supports a 120Hz refresh rate. So, movies and videos look spectacular, while games play smoothly without distracting artefacts. With a wide P3 colour gamut, you get more vibrant greens and reds for truer-to-life images and videos. Doing more than ever will soon be easier than ever. In iOS 11, an all-new Dock makes it SIMple to open recently used apps and files. The A10X Fusion chip with 64-bit architecture and six cores puts incredible power in your hands. So, you can edit a 4K video on the go. Render an elaborate 3D model.', 'tablet/applet/ap3.jpg', 'https://www.amazon.in/Apple-iPad-MQF12HN-Tablet-Wi-Fi/dp/B072KHF6Y3/ref=sr_1_9?s=computers&ie=UTF8&qid=1521514523&sr=1-9&refinements=p_89%3AApple', '<br><br>12MP primary camera with auto focus with focus pixels and 7MP front facing camera<br><br>\r\n26.67 centimeters (10.5-inch) LED-backlit with multi-touch capacitive touchscreen with 2224 x 1668 pixels resolution<br><br>\r\niOS v10 operating system with 2.38 GHz A10X Fusion chip with 64-bit architecture<br><br> Embedded M10 hexa core processor<br><br>4GB RAM, 64GB internal memory and single nano SIM\r\n8135mAH lithium-ion battery', 59979),
(75, 'app4', 'Apple iPad Mini 4 Tablet', 'tablet', 'No matter the task, the new iPad Pro is up to it - and then some. It offers far more power than most PC laptops, yet is delightfully SIMple to use. Pad has always offered the ultimate Multi-Touch experience. The new iPad Pro Retina display now supports a 120Hz refresh rate. So, movies and videos look spectacular, while games play smoothly without distracting artefacts. With a wide P3 colour gamut, you get more vibrant greens and reds for truer-to-life images and videos. Doing more than ever will soon be easier than ever. In iOS 11, an all-new Dock makes it SIMple to open recently used apps and files. The A10X Fusion chip with 64-bit architecture and six cores puts incredible power in your hands. So, you can edit a 4K video on the go. Render an elaborate 3D model.\r\n\r\n', 'tablet/applet/ap4.jpg', 'https://www.amazon.in/Apple-iPad-MQF12HN-Tablet-Wi-Fi/dp/B072KHF6Y3/ref=sr_1_9?s=computers&ie=UTF8&qid=1521514523&sr=1-9&refinements=p_89%3AApple', '<br><br>12MP primary camera with auto focus with focus pixels and 7MP front facing camera<br><br>\r\n26.67 centimeters (10.5-inch) LED-backlit with multi-touch capacitive touchscreen with 2224 x 1668 pixels resolution<br><br>\r\niOS v10 operating system with 2.38 GHz A10X Fusion chip with 64-bit architecture<br><br> Embedded M10 hexa core processor<br><br>4GB RAM, 64GB internal memory.', 59979),
(76, 'app5', 'Apple iPad Pro Tablet ', 'tablet', 'Latest iOS opetating system\r\nA9X chip with 64?bit architecture M9 coprocessor\r\nRetina display 9.7-inch (diagonal) LED-backlit Multi-Touch display 2048-by-1536 resolution at 264 pixels per inch (ppi)\r\n32GB Memory and 2 GB RAM with 12-megapixel iSight camera Live Photos Autofocus with Focus Pixels True Tone flash Panorama (up to 63 megapixels) Auto HDR for photos Exposure control Burst mode Timer mode\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories from the date of purchase', 'tablet/applet/ap5.jpg', 'https://www.amazon.in/Apple-iPad-Tablet-inch-Wi-Fi/dp/B01ELBFGR0/ref=sr_1_12?s=computers&ie=UTF8&qid=1521514523&sr=1-12&refinements=p_89%3AApple', '<br><br>Bluetooth_tethering; E-Mail; GPS; Internet;<br><br> MP3; music_player;<br><br> Camera; secondary_camera; Touchscreen; USB;<br><br> Wifi; wifi_hotspot', 40999),
(77, 'app6', 'Apple iPad Pro MPGH2HN/A ', 'tablet', 'No matter the task, the new iPad Pro is up to it - and then some. It offers far more power than most PC laptops, yet is delightfully simple to use. Pad has always offered the ultimate Multi-Touch experience. The new iPad Pro Retina display now supports a 120Hz refresh rate. So movies and videos look spectacular, while games play smoothly without distracting artifacts. With a wide P3 color gamut, you get more vibrant greens and reds for truer-to-life images and videos. Doing more than ever will soon be easier than ever. In iOS 11, an all-new Dock makes it simple to open recently used apps and files. The A10X Fusion chip with 64?bit architecture and six cores puts incredible power in your hands. So you can edit a 4K video on the go. Render an elaborate 3D model.12MP primary camera with auto focus with focus pixels and 7MP front facing camera\r\n26.67 centimeters (10.5-inch) LED-backlit with multi-touch capacitive touchscreen with 2224 x 1668 pixels resolution\r\niOS v10 operating system with 2.38GHz A10X Fusion chip with 64?bit architecture Embedded M10 hexa core processor, 4GB RAM and 512GB internal memory\r\n8135mAH lithium-ion battery\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 'tablet/applet/ap6.jpg', 'https://www.amazon.in/Apple-MPGH2HN-Tablet-512GB-Wi-Fi/dp/B071X4JR36/ref=sr_1_15?s=computers&ie=UTF8&qid=1521514523&sr=1-15&refinements=p_89%3AApple', '<br><br>12MP primary camera with auto focus with focus pixels and 7MP front facing camera<br><br>\r\n26.67 centimeters (10.5-inch) LED-backlit with multi-touch capacitive touchscreen with 2224 x 1668 pixels resolution<br><br>\r\niOS v10 operating system with 2.38GHz<br><br> A10X Fusion chip with 64?bit architecture<br><br> Embedded M10 hexa core processor<br><br>4GB RAM and 512GB internal memory', 73560),
(78, 'tasz', 'ASUS Zenpad Z500M-C1-SL ', 'tablet', '\r\nAll products are imported from the USA. All electronic products must be used with a step down/up converter for Indian voltage compatibility.', 'tablet/asustabs/as1.jpg', 'https://www.amazon.in/Zenpad-Z500M-C1-SL-9-7-Inch-Tablet-Glacier/dp/B01M3MYPOO?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=aa8c1483-0008-48ad-97c9-3b588c6c3cd6', '<br><br>Item Height	7 Millimeters<br><br>\r\nItem Width	16.4 Centimeters<br><br>\r\nScreen Size	9.7 Inches<br><br>\r\nItem Weight: 431 g<br><br>\r\nProduct Dimensions: 24.1 x 16.4 x 0.7 cm\r\n<br><br>Batteries: 1 Lithium Polymer batteries required.', 37407),
(79, 'tasf', 'Asus FE380CG Tablet', 'tablet', 'All products are imported from the USA. All electronic products must be used with a step down/up converter for Indian voltage compatibility.\r\n\r\n', 'tablet/asustabs/as2.jpg', 'https://www.amazon.in/Zenpad-Z500M-C1-SL-9-7-Inch-Tablet-Glacier/dp/B01M3MYPOO?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=aa8c1483-0008-48ad-97c9-3b588c6c3cd6', '<br><br>Brand	Asus<br><br>\r\nItem Height	7 Millimeters<br><br>\r\nItem Width	16.4 Centimeters\r\n<br><br>Screen Size	9.7 Inches<br><br>\r\nItem Weight	431 g<br><br>\r\nProduct Dimensions	24.1 x 16.4 x 0.7 cm\r\nBatteries:	1 Lithium Polymer batteries required. (included)\r\nItem model number	Z500M-C1-SL\r\nProcessor Count	6\r\nRAM Size	4 GB\r\nWireless Type	802.11n\r\nRear Webcam Resolution	8 Megapixels\r\nCard Reader	SDXC\r\nLithiu', 37407),
(80, 'asus3', 'Asus Z170CG Tablet', 'tablet', 'Asus\r\nItem Height	7 Millimeters\r\nItem Width	16.4 Centimeters\r\nScreen Size	9.7 Inches\r\nItem Weight	431 g\r\nProduct Dimensions	24.1 x 16.4 x 0.7 cm\r\nBatteries:	1 Lithium Polymer batteries required. (included)\r\nItem model number	Z500M-C1-SL\r\nProcessor Count	6\r\nRAM Size	4 GB\r\nWireless Type	802.11n\r\nRear Webcam Resolution	8 Megapixels\r\nCard Reader	SDXC\r\nLithium Battery Energy Content	22 Watt Hours\r\nLithium battery Voltage	5 Volts\r\nLithium battery Weight	3 Grams\r\nNumber of Lithium Ion Cells	6', 'tablet/asustabs/as3.jpg', 'www.amazon.in/Zenpad-Z500M-C1-SL-9-7-Inch-Tablet-Glacier/dp/B01M3MYPOO?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=aa8c1483-0008-48ad-97c9-3b588c6c3cd6', '<br><br>7 inch, <br><br>8GB<br><br> Wi-Fi+3G+Voice Calling<br><br>\r\nAurora Metallic', 36606),
(81, 'asus4', 'ASUS Zenpad Z500M-C1-GR ', 'tablet', 'Brand	Asus\r\nItem Height	7.6 Centimeters\r\nItem Width	10.9 Centimeters\r\nScreen Size	7 Inches\r\nItem Weight	45.4 g\r\nProduct Dimensions	22.1 x 10.9 x 7.6 cm\r\nItem model number	90XB01JP-BDS000', 'tablet/asustabs/as4.jpg', 'https://www.amazon.in/Asus-90XB01JP-BDS000-Nexus-Tablet-Black/dp/B00IAAD0MW/ref=sr_1_7?ie=UTF8&qid=1521533531&sr=8-7&keywords=asus+tablet', '<br><br>Brand	Asus\r\nItem Height	7.6 Centimeters\r\nItem Width	10.9 Centimeters\r\nScreen Size	7 Inches\r\nItem Weight	45.4 g\r\nProduct Dimensions	22.1 x 10.9 x 7.6 cm\r\nItem model number	90XB01JP-BDS000', 5282);
INSERT INTO `products` (`pid`, `pname`, `pfullname`, `p_type`, `p_des`, `p_image`, `p_link`, `highlight`, `price`) VALUES
(83, 'asus5', '\r\nAsus 90XB01JP-BDS000 Nexus 7', 'tablet', 'Brand	Asus\r\nItem Height	7.6 Centimeters\r\nItem Width	10.9 Centimeters\r\nScreen Size	7 Inches\r\nItem Weight	45.4 g\r\nProduct Dimensions	22.1 x 10.9 x 7.6 cm\r\nItem model number	90XB01JP-BDS000\r\n 	 \r\n', 'tablet/asustabs/as5.jpg', 'https://www.amazon.in/Asus-90XB01JP-BDS000-Nexus-Tablet-Black/dp/B00IAAD0MW/ref=sr_1_7?ie=UTF8&qid=1521533531&sr=8-7&keywords=asus+tablet', '<br><br>Brand	Asus\r\nItem Height	7.6 Centimeters,\r\nItem Width	10.9 Centimeters,\r\nScreen Size	7 Inches<br><br>\r\nItem Weight	45.4 g<br><br>\r\nProduct Dimensions	22.1 x 10.9 x 7.6 cm<br><br>\r\nItem model number	90XB01JP-BDS000', 52820),
(84, 'asus6', 'Asus Z370CG Tablet', 'tablet', '16 GB ROM, 2 GB\r\nIntel Atom x3-C3230 Quad Core Processor, 64 bit support 3D graphics\r\nBattery : 3450 mAh, Li-polymer Battery(8 Hour Battery Life)\r\nCamera: Front 2MP/ Rear 8MP\r\nDisplay 17.7 cm (7 inch)', 'tablet/asustabs/as6.jpg', 'https://www.amazon.in/Asus-Z370CG-Tablet-Calling-Obsidian/dp/B017WQ3IQW/ref=sr_1_6?ie=UTF8&qid=1521533531&sr=8-6&keywords=asus+tablet', '<br><br>16 GB ROM, 2 GB\r\nIntel Atom x3-C3230 Quad Core Processor, 64 bit support 3D graphics<br><br>\r\nBattery : 3450 mAh, Li-polymer Battery(8 Hour Battery Life)<br><br>\r\nCamera: Front 2MP/ Rear 8MP\r\nDisplay 17.7 cm (7 inch)', 10559),
(85, 'ls1', 'Sony VAIO S Laptop', 'laptop', 'AIO engineers specifically designed this laptop with durability in mind. They subjected the VAIO S to a series of stress, pressure and impact tests ensuring there are no areas of weakness.<br>\r\nDespite having a full suite of connectivity ports and features, the VAIO S is still incredibly thin (0.52 inch-0.71 inch) and impossibly light (2.34 pounds) while providing up to 9 hrs* of battery life.<br>\r\nNo dongles required. The VAIO S provides all the functionality that you could need in a business laptop.', 'laptop/sony/ss1.jpg', 'https://www.amazon.com/Laptop-i5-6200U-Memory-Display-Windows/dp/B01AZC3DLU', '<br><br>Up to Intel Core i7<br><br>\r\nWindows 10 Signature Edition<br><br>\r\n13.3\" Full HD Display<br><br>\r\n8GB Memory<br><br>\r\nUp to 256GB PCIe SSD<br><br>\r\nApprox. 0.52-0.71\" Thick<br><br>\r\n2.34 lbs.', 42450),
(86, 'ls2', 'Sony VAIO Fit', 'laptop', 'Choosing an entertainment laptop is not as difficult as many thing it to be. The Sony Vaio series is well known to have models that cater to the everyday user, as well as the power user. The Sony Vaio FIT 15E laptop is a great example of an entertainment system that can also be used as an everyday work-horse.<br>\r\nThis system is primed to sound good in terms of music quality, as is the case with the overall sound quality that it delivers. This laptop is also equipped with a subwoofer apart from the standard stereo speakers that come with it. It also comes with the xLoud sound enhancement which is quite similar to the technology found in smartphones by Sony, notably in the Xperia phones. This enhancement greatly increases the clarity and makes the speakers more dynamic.<br>\r\nBeing an entertainment system, it is only natural to expect a high capacity hard disk that can be used to store most if not all of your important files, movies and songs that you would frequently listen to. This laptop is equipped with a 500 GB SATA disk that is also quite stable.', 'laptop/sony/ss2.jpeg', 'https://www.flipkart.com/sony-vaio-fit-15e-f15218sn-b-laptop-3rd-gen-ci5-4gb-500gb-win8-1gb-graph/p/itmdm6swknyszaew', '<br><br>Intel Core i5 Processor<br><br>\r\n4 GB DDR3 RAM<br><br>\r\n64 bit Windows 8 Operating System<br><br>\r\n500 GB HDD<br><br>\r\n15.35 inch Display', 43500),
(87, 'ls3', 'Sony VAIO T-Series\r\n', 'laptop', 'Sony Vaio\'s latest designs were released during a period of low PC sales and included models with innovations such as magnetized stands and the Vaio Tap, which was designed with a completely separate keyboard. The latest models were complemented by the Windows 8 operating system.\r\n<br>\r\nSleek, responsive performance and extreme mobility meets the power of a touchscreen. Designed without compromise, it’s the ultimate travel companion and workhorse for purely business or simply pleasure. With a brushed aluminum shell, the latest storage technologies and long battery life, the only thing missing is you behind it.', 'laptop/sony/ss3.jpg', 'https://www.amazon.com/Sony-SVT13134CXS-13-3-Inch-Touchscreen-Ultrabook/dp/B00AW4OD6G/ref=as_at?creativeASIN=B00AW4OD6G&imprToken=wdD4RL2OKk871SV3.eqhqQ&slotNum=1&_encoding=UTF8&camp=1789&creative=9325&linkCode=ur2&tag=reinfisc-20&linkId=O3MNV7HB34KQAAQ5', '<br><br>Intel Core i3-3227U Processor (1.9 GHz)<br><br>\r\n4 GB DDR3 RAM<br><br>\r\n500 GB 5400 rpm Hard Drive<br><br>\r\n13.3-Inch Screen, Intel HD Graphics 4000\r\n<br><br>Windows 8, 5-hour battery life\r\n', 40000),
(88, 'tl1', 'Lenovo Tab 2 A10-30 Tablet', 'tablet', 'The TAB 2 A10-30\'s HO multi-touch display offers a sharp and colorful viewing experience, and the in-plane switching (IPS) technology delivers a wider viewing angle, perfect for sharing content with friends.<br><br>\r\nThe Tab 2 A10-30\'s awesome 7000mAh battery will last for up to 10 days on standby, or up to 10 hours of viewing enjoyment.<br><br>\r\nThe tablet\'s ultra-slim design will fit comfortably in your hand, whether its for you or your child.<br><br>\r\nWhen it comes to taking photos, the Tab 2 A10-30 has you covered, with one 5 megapixel rear-facing camera to capture all your special moments on photo or video, and a front-facing 2 megapixel one to help you master the art of the selfie.<br><br>\r\n16GB of internal storage space lets you keep even more of your music, games, and photos.The Tab 2 A10-30 will come with Android Lollipop, the latest and most advanced Android operating system.', 'tablet\\lentabs\\len1.jpg', 'https://www.amazon.in/Lenovo-Tab-10-Tablet-Pearl/dp/B078K4K39P/ref=sr_1_17?s=computers&ie=UTF8&qid=1521534428&sr=1-17&keywords=tablets', '<br><br>5MP primary camera with auto focus and 2MP front facing camera<br>\r\n25.654 centimeters (10.1-inch) HD capacitive touchscreen with 1280 x 800 pixels resolution<br>\r\nAndroid v5.1 Lollipop operating system with 1.3GHz Qualcomm MSM8909 32-bit octa core processor, 1GB RAM and 16GB internal memory<br>\r\n7000mAH lithium-ion battery<br>\r\n1 year manufacturer warranty for device and 6 months manufacturer warranty for in-box accessories including batteries from the date of purchase', 11990),
(89, 'tl2', 'Lenovo Tab 3 Essential Tablet', 'tablet', 'Extraordinary tablet. Incredible price. The best value tablet out there. Enjoy all the fun and convenience of a go-everywhere tablet at a surprisingly affordable price. Behind the cool TAB3 design and vibrant 7\" IPS display is a powerful 1.3 GHz Quad-Core processor, 1GB RAM, 8GB Internal memory and expandable up to 64GB, microSD storage, built-in GPS and WiFi1 and rear and front cameras for instant photo-sharing and fabulous selfies. Socialize, shop, shoot and share all-day without recharging.<br><br>\r\nThe best value tablet out there. Enjoy all the fun and convenience of a go-everywhere tablet at a surprisingly affordable price. Behind the cool TAB3 design and vibrant 7 inch IPS display is a powerful 1.3 GHz Quad-Core processor, 8 GB memory, microSD storage, built-in GPS and WiFi1 and rear and front cameras for instant photo-sharing and fabulous selfies. Socialize, shop, shoot and share all-day without recharging.\r\n<br><br>\r\nThe 7 inch (1024 x 600) IPS display ensures photos, movies, TV and websites come alive with exceptional colour and clarity.\r\n', 'tablet\\lentabs\\len2.jpg', 'https://www.amazon.in/Lenovo-Essential-Tablet-Wi-Fi-Black/dp/B01IHIZIXA/ref=sr_1_11?s=computers&ie=UTF8&qid=1521534428&sr=1-11&keywords=tablets', '<br><br>Vibrant 7 inch IPS display makes your content come alive\r\n<br><br>\r\nFront and rear cameras for instant photo-sharing<br><br>\r\nBuilt-in satellite GPS for easy offline navigation<br><br>\r\nEnhanced Dolby Audio for a crisper sound<br><br>\r\nLightweight with all-day battery power<br><br>\r\nPowerful processor for smooth and responsive experience', 8999),
(90, 'tl3', 'Lenovo Tab3 7 Essential Tablet', 'tablet', 'The best value tablet out there. Enjoy all the fun and convenience of a go-everywhere tablet at a surprisingly affordable price. Behind the cool TAB3 design and vibrant 7\" IPS display is a powerful 1.3 GHz Quad-Core processor, up to 16 GB memory, microSD storage, built-in GPS and WiFi1 and rear and front cameras for instant photo-sharing and fabulous selfies. Socialize, shop, shoot and share all-day without recharging.<br><br>\r\nUse the Visio front camera for perfect selfies you can share instantly and the 2MP rear camera to capture brilliant images and videos.<br><br>\r\nThe 7\" (1024 x 600) IPS display ensures photos, movies, TV and websites come alive with exceptional colour and clarity.<br><br>', 'tablet\\lentabs\\len3.jpg', 'https://www.amazon.in/Lenovo-Tab3-Essential-Tablet-Calling/dp/B01J1EOVQO/ref=sr_1_10?s=computers&ie=UTF8&qid=1521534428&sr=1-10&keywords=tablets', '<br><br>Vibrant 7” IPS display makes your content come alive<br><br>\r\nFront and rear cameras for instant photo-sharing<br><br>\r\nBuilt-in satellite GPS for easy offline navigation<br><br>\r\nEnhanced Dolby audio for a crisper sound<br><br>\r\nLightweight with all-day battery power<br><br>\r\nPowerful processor for smooth and responsive experience', 9990),
(91, 'tl4', 'Lenovo Tab4 8 Plus Tablet ', 'tablet', 'Beautifully designed, powerfully built, the Tab 4 8 Plus is a premium Android slate tablet made for the power users in the family. The Tab 4 comes in sleek dual-glass casings that protects against scratches and bumps. And best of all, you can specialize them: The Tab 4 8 Plus offers an optional pack to transform the Lenovo Tab 4 series into dedicated kid’s tablets.<br><br>\r\nYou can now have the perfect tablet for kids, with an add-on kid’s package, featuring a shock-resistant bumper, a blue-light screen filter and fun 3M stickers. The kid’s pack integrated with a dedicated and secure Kid’s account, which features up-to-date and curated kid’s content and browsers that allow for only whitelisted websites and scheduling tools for parents that limit daily use to “ontimes” and “down-times.”<br><br>\r\nAs a dual-glass tablet, the Tab 4 8 Plus is shielded on the front and back with dual layers of protective glass to prevent scratches and bumps, and to give off an aurora-like reflection. This combines with its ultra-slim and light profile -7 mm in thickness and 300 grams - for stunning aesthetics.', 'tablet\\lentabs\\len6.jpg', 'https://www.amazon.in/Lenovo-Tab4-Plus-Tablet-Calling/dp/B075T11S9G/ref=sr_1_7?s=computers&ie=UTF8&qid=1521534428&sr=1-7&keywords=tablets', '<br><br>8 inch FHD display and dolby atoms audio, perfect for immersive entertainment<br><br>\r\nQualcomm Snapdragon 625 Octa-Core processor, up to 4GB of RAM and 64GB of storage\r\n<br><br>Full HD display<br><br>Ultra thin and light, elegant dual-glass design\r\n', 21990),
(92, 'tl5', 'Lenovo Yoga Tab 3 8 Tablet', 'tablet', 'Scroll through recipes while you cook, check your social feeds while you eat, and watch movies while you work out. Yoga Tablet 3 8’s innovative design places a battery cylinder and kickstand on the side of the device, shifting the center of gravity and opening up multiple ways to use it: hold, tilt, stand, and hang.<br><br>\r\nThe Yoga Tab 3 8 delivers rich home theater sound that you won’t experience on any other tablet. The two integrated front-facing speakers and powerfully immersive Dolby Atmos sound give louder, clearer and dynamic audio even without headphones.<br><br>\r\nThe Yoga Tab 3 8’s HD resolution is perfect for casual gaming and intense web browsing. It delivers incredible brightness for a great viewing experience under all angles and ambient lights. Your games are crisp and your videos simply beautiful to watch.<br><br>\r\nThe Yoga Tab 3 8 keeps going and going with its outstanding battery life. With up to 20 hours* on one charge, it’s enough to watch two seasons of your favorite TV show back to back. Battery life is an estimated maximum. Actual battery life may vary based on many factors.', 'tablet\\lentabs\\len5.jpg', 'https://www.amazon.in/Lenovo-Yoga-Tab-Tablet-Amazon/dp/B01JZ8Z5XE/ref=sr_1_1?s=computers&ie=UTF8&qid=1521534428&sr=1-1&keywords=tablets', '<br><br>8MP primary camera with auto focus and 8MP front facing camera<br><br>\r\n20.32 centimeters (8-inch) HD IPS capacitive touchscreen with 1280 x 800 pixels resolution<br><br>\r\n6200mAH lithium-ion battery providing talk-time of 20 hours and standby time of 95 hours<br><br>\r\nAndroid v6.0 Marshmallow operating system with 1.3GHz Qualcomm APQ8009/MSM8909 quad core processor, 1GB RAM, 16GB internal memory and single micro SIM.', 11999),
(93, 'tl6', 'Lenovo Tab4 10 Tablet', 'tablet', 'Beautifully designed, powerfully built, the Tab 4 10 is the quintessential family tablet made for sharing in the modern household. multiple users can open their own accounts for their own customized space within the tablet. And best of all, you can specialize them. The Tab 4 10 offers optional packs to transform the Lenovo Tab 4 series into dedicated kid’s tablets or productivity tablets.<br><br>\r\nTransform your Tab 4 10 into a 2-in-1 convertible with a Productivity Pack that features a bluetooth keyboard which doubles as a stand and productive sleeve. This optional accessory pack integrates with the built-in productivity interface, which features a taskbar and instant app switching, support for multiple windows and optimization for keyboard operations.<br><br>\r\nYou can now have the perfect tablet for kids, with an add-on kid’s package, featuring a shock-resistant bumper, a blue-light screen filter and fun 3M stickers. The kid’s pack integrated with a dedicated and secure kid’s account, which features up-todate and curated kid’s content and browsers that allow for only whitelisted websites and scheduling tools for parents that limit daily use to “on-times” and “down-times.”<br><br>\r\nThe tab 4 10’s ultra-slim and light profile - 8.5 mm in thickness and 506 grams - offer a unique sleek design you won’t find in your run-of-the-mill family tablet.', 'tablet\\lentabs\\len6.jpg', 'https://www.amazon.in/Lenovo-Tab4-10-Tablet-Wi-Fi/dp/B075T1YTR9?tag=googinhydr18418-21&tag=googinkenshoo-21&ascsubtag=aa8c1483-0008-48ad-97c9-3b588c6c3cd6', '<br><br>10.1” HD display and dolby atoms audio, perfect for immersive entertainment<br><br>\r\nQualcomm snapdragon quad-core 64-bit, up to 1.4 GHz<br><br>\r\nUp to 2GB of RAM and 16GB of storage<br><br>\r\nMulti-account Android tablet<br><br>\r\nUp to 20 hours battery<br><br>\r\nTransform to productivity tablet or kid’s tablet with Lenovo packs', 15990),
(94, 'ls4', 'Sony Vaio E Series SVE14117GNB', 'laptop', 'This Sony Vaio E Series SVE14117GNB (Black) notebook is an attractive combination of form and functionality. Packing in a host of connectivity features, this laptop is run by a Core i7 processor. The 35.56cm (14) screen size makes for easy travelling while the slick black colour and slim design makes a solid style statement. Design With its robust design, this Sony laptop allows for easy portability. The attractive black colour and the textured design enhance the visual appeal of this stylish 35.56cm (14) laptop. Sturdy screen bezel fortifies durability while the rounded edges make it compact for easy travelling. With its 2.4 kg weight, this laptop can be easily moved around and is perfect for use at home or at work. The standard keyboard has chicklet style keys that offer ultimate comfort over prolonged use and also increases the accuracy and speed during typing. The palm rest in this laptop is wide for added comfort whereas the touchpad is extremely responsive with multi-touch gesture supported mechanism. Performance Powered by the Intel 3rd Generation Core i7 3520M processor, this laptop has a 2.90GHz clock speed and 3 MB cache memory that not only offers lag-free processing but also makes internet browsing quick and convenient. The 4 GB DDR3 RAM of this VAIO E Series laptop complements the efficiency of the processor to give superb multitasking capabilities and powers daily computing with high performance. This DDR3 internal memory can be upgraded to 8 GB via the unused memory slot. The Internal HD Graphics 4000 GPU offers superb gaming performance and is sure to please ardent music lovers. The laptop\'s 500GB SATA HDD makes it easy to carry your entire collection of multimedia and data files while the DVD SuperMulti Drive offers great ease to play, burn and create DVDs. The Li-Ion battery gives up to 4.5 hours of power backup on a single complete charge. Multimedia Configuration and Connectivity With 1366 x 768 pixel resolution and LED Backlight VAIO Display, this laptop has 35.56cm (14) screen with TFT colour display. The powerful speakers are backed by Intel High Definition Audio system and the sound quality is enhanced by Clear Phase Audio and xLOUD Audio technology to make movies fun and all the more entertaining. Wi-Fi and LAN port give quick internet access so that you can work at your desktop or move around with your laptop as you surf the Web. Bluetooth 4.0 with HS gives quick wireless file transfer and connectivity with supported devices like mice, headsets and other media devices. The HDMI port connects the laptop to your HDTV while multi-format card-reader adds to the overall functionality. The 1.3MP webcam and integrated monaural mic make video calls loud and clear. Four USB ports make it easy to connect multiple hardware devices and also power data transfer with faster speeds/. Operating System Windows 7 Professional edition OS running this VAIO notebook brings great ease to manage files and other work related data easily.', 'laptop\\sony\\son3.jpg', 'https://www.snapdeal.com/product/sony-vaio-sve14117gnb-laptop-3rd/198710', '<br><br>500 GB HDD<br><br>	\r\n4 GB DDR3 RAM	<br><br>\r\n35.56cm (14) Screen<br><br>	Windows 7 Professional	Intel 3rd Generation Core i7 3520M Processor	<br><br>\r\n', 48500),
(95, 'ls5', 'Sony Vaio Laptop/Core i5 3rd gen', 'laptop', 'Sony’s SV-E series was introduced in Q3 2012 as a replacement for the VPC-E budget series. It consists of notebooks from 11.6 to 17.3 inch with a price range from 800 Euro to 1000 Euro depending on the configuration. The 800 euro entry level model houses a Sandy bridge processor and an on-board graphic Intel HD3000. The more expensive 1000 euro model uses a Sandy Bridge quad-core processor and mid-range AMD Radeon graphics.<br><br>\r\nSince the E series is a series of budget notebooks aiming at average consumers, it does not has the beautiful design or state-of-the-art hardware of Sony’s high end models. But the E-series still has some ace up its sleeves: Its price is comparable to other manufacturer’s mid-range laptop, while having a much better matte display and a somewhat better backlit keyboard, not to mention a timeless design which is similar to other Sony premium notebooks.<br><br>\r\nBased on the same chip as the Radeon HD 6650M but with slower core clock. 480 Shader and 128 bit DDR3 interface.  Non demanding games should be playable with these graphics cards. » Further information can be found in our Comparison of Mobile Graphics Cards and the corresponding Benchmark List.\r\n2450M: Dual-core processor based on the Sandy Bridge architecture with an integrated graphics card and dual-channel DDR3 memory controller. The CPU is clocked at 2.5 GHz (Turbo Boost 2.8-3.1 GHz) and the GPU at 650 (1300 MHz Turbo).» Further information can be found in our Comparison of Mobile Processsors.', 'laptop/sony/son4.jpg', 'https://www.hilaptop.com/in/p/Sony-Vaio-LaptopCore-i5-3rd-gen-8Gb-RAM-1000gb-1tb-Gb-graphic-dedicatedUSED/226?gclid=CjwKCAjwwuvWBRBZEiwALXqjw23SUnK3WYGYMhon1A7perEG6Ylvwv-1BRzOZGHipHSwlOokYM2tCRoCC9MQAvD_BwE', '<br><br>Pointer Device	Touchpad with Gesture Support<br><br>\r\nResolution	1366 x 768 pixels<br><br>\r\n15.5 inch 16:9<br><br>\r\nCPU is clocked at 2.5 GHz', 60000),
(96, 'ls6', 'Sony VAIO VGN-NW240F', 'laptop', 'Say hello to the touchscreen laptop that\'s the perfect blend of features, speed and style. Smartly designed with a thin, aluminum body, you\'ll also be wowed with options like Full HD displays.<br>,br>\r\nThis enhancement greatly increases the clarity and makes the speakers more dynamic.\r\nBeing an entertainment system, it is only natural to expect a high capacity hard disk that can be used to store most if not all of your important files, movies and songs that you would frequently listen to. This laptop is equipped with a 500 GB SATA disk that is also quite stable.', 'laptop\\lenovo\\yoga920.jpg', 'https://www.amazon.com/Sony-VGN-NW240F-15-5-Inch-Windows-Premium/dp/B002PHM0L8/ref=cm_cr_arp_d_product_top?ie=UTF8', '<br><br>2.2GHz Intel Core 2 Duo T6600 Processor<br><br>\r\n4GB DDR2 800MHz Memory<br><br>\r\n320GB Serial ATA 5400RPM Hard Drive, DVD±R/RW Optical Drive<br><br>\r\n15.5\" (1366x768) Widescreen LCD Display, Intel Graphics Media Accelerator 4500MHD<br><br>\r\nWindows 7 Home Premium (64-bit)\r\n', 39000);

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `review` text NOT NULL,
  `ratings` int(11) NOT NULL,
  `sentiment` float NOT NULL,
  `Suspected` int(11) NOT NULL DEFAULT '0',
  `EndLine` char(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reviews`
--

INSERT INTO `reviews` (`id`, `pid`, `uid`, `review`, `ratings`, `sentiment`, `Suspected`, `EndLine`) VALUES
(41, 1, 21, 'We should not compare this model with Galaxy J7 at all, as it has lot of drawbacks compared to it. Rear Camera, though it is 13MP, not impressive and the same with the TFT display. Not an effective display. Otherwise the remaining things are OK.', 0, 0.15, 0, ''),
(1, 1, 36, 'A must buy', 0, 0, 1, ''),
(103, 1, 37, 'nice mobile', 0, 0.6, 0, ''),
(8, 1, 39, 'This is the first phone i have bought online and i am quite satisfied with the features.', 0, 0.375, 0, ''),
(120, 1, 42, 'With these features this product was a good choice for me.', 0, 0.7, 0, ''),
(122, 1, 43, 'This phone is a nice buy with good memory backup and ram.', 0, 0.65, 0, ''),
(123, 1, 54, 'Impressive. never bought something like this.', 0, 1, 1, ''),
(42, 2, 21, 'Awsome phone. But once u purchase this phone, u dont need to keep press at home coz this phone becomes iron hot after few minutes of video call.', 0, 0.025, 0, ''),
(73, 2, 36, 'Amazing OLED screen..Phone is fragile but with cost comes responsibility..mine is the American version ..It does not get hot while charging ..Battery last a full day...Supercharging is fast..Camera superb..It even shows your pimples which are difficult to see through naked eye. Not for ugly faces lol Just kidding.', 0, 0.08, 0, ''),
(4, 2, 37, 'Dont buy this product', 0, 0, 0, ''),
(121, 2, 42, 'This was an ok ok phone but would not suggest anyone to buy it.', 0, 0.5, 0, ''),
(146, 2, 50, 'This was a fine buy.', 0, 0.416667, 0, ''),
(124, 2, 54, 'One should try this once in their life time.', 0, 0, 0, ''),
(5, 5, 21, 'Its worth its price', 0, 0.3, 0, ''),
(6, 5, 36, 'Best product in the market right now', 0, 0.642857, 0, ''),
(7, 5, 37, 'Worth the money', 0, 0.3, 0, ''),
(10, 5, 39, 'wowwwwwww...best phone..even better than iphone.', 0, 0.5, 0, ''),
(125, 5, 54, 'Good processor, average ram, an average buy.', 0, 0.133333, 0, ''),
(43, 6, 21, 'best phone.', 0, 1, 1, ''),
(74, 6, 36, 'excellent camera quality', 0, 1, 1, ''),
(106, 6, 37, 'not good..i hate it', 0, -0.8, 1, ''),
(11, 6, 39, 'woww...best phone.', 0, 0, 0, ''),
(44, 7, 21, 'With a spate of manufacturers launching high-end devices, the focus has fallen on the pricing policy followed by them. While part of it could be attributed to the rupees weak health but what really justifies buying a phone worth Rs. 50,000?With most high-end devices costing north of the 40k mark, does it really make sense to invest such hefty amount on just a phone?Samsung Galaxy Note 3 : Rs. 49, 990 .Sony Xperia Z1 : Rs 43, 000.iPhone 5S : Rs 50, 000', 0, 0.1375, 0, ''),
(108, 7, 37, 'Its been a day since I have this phone and this is what I think of the product.When playing games on the device it tends to get HOT after 15 min of game play, the volume button and power get really hot after 30 min of play time.The phone with 100% change got switched off in just 5 hours of usage.Every time before switching the screen off.I have to end all tasks just to keep it working as the RAM usage was showing 1.78 GB all the time.Even when I have nothing on except the power saver.', 0, 0.0333333, 0, ''),
(14, 7, 39, 'This mobile has the latest features just like what i wanted.', 0, 0.5, 0, ''),
(45, 8, 21, 'Best one so for ....go for it ...its more than worth...excellent display ...functions normally', 0, 0.55, 0, ''),
(76, 8, 36, 'best one ever..m in love with this mobile', 0, 0.75, 0, ''),
(109, 8, 37, 'best one i ever used', 0, 1, 0, ''),
(13, 8, 39, 'My dream was to buy this phone.so i cried for 10 days,asked my dad..he refused..so i found a job..earned and bought this phone..m so much in love and not regretting at all.', 0, 0.5, 0, ''),
(46, 9, 21, 'So far it is giving fantastic service.Superb display, superior build quality and striking look. And till now performance is excellent with so many apps loaded. The issues faced are - slips in hand while holding the phone lightly during video watching. Sometime the swipe seems to give a miss. The earphone seems to be tangle free which is good but slips off ear often.', 0, 0.522222, 0, ''),
(77, 9, 36, 'it was not good..i hav already replaced this mobile.bad decision', 0, 0, 0, ''),
(110, 9, 37, 'Loving the experience of good old Nokia brand again. First time loved the Andriod experience with no hanging or slowing of phone problem. It receives regular updates from google.', 0, 0.391667, 0, ''),
(15, 9, 39, 'camera quality is good,but i cant find any good features other than this.', 0, 0.2875, 0, ''),
(47, 10, 21, 'Guys dont buy this its a big disappointment i have bought this fr my dad but its not good after few days its just started to reject calls automatically even there is no number in the block list n it looks also very bad', 0, -0.412, 1, ''),
(78, 10, 36, 'best phone ever', 0, 1, 1, ''),
(111, 10, 37, 'i hate this phone.', 0, -0.8, 1, ''),
(16, 10, 39, 'This is the best phone i have ever seen.satisfied.', 0, 1, 1, ''),
(147, 10, 50, 'Never expected this from a company like Nokia', 0, 0.05, 0, ''),
(81, 11, 36, 'not good phone..so less features', 0, -0.258333, 0, ''),
(112, 11, 37, 'love this phone', 0, 0.5, 1, ''),
(17, 11, 39, 'very poor camera quality.other features are also just okay.', 0, -0.01, 0, ''),
(48, 12, 21, 'Average,product,,,but I am nokia lover', 0, 0, 0, ''),
(82, 12, 36, 'it met my expectations very well', 0, 0.2, 0, ''),
(113, 12, 37, 'nokia is back :-)', 0, 0.25, 0, ''),
(18, 12, 39, 'I am liking this this phone,it contains excellent features.', 0, 1, 1, ''),
(49, 13, 21, 'The phone was worked beautifully up to warranty time, after that warranty time the phone is giving lot problems like sound. Last few days back the sounding system is gone.', 0, 0.21, 0, ''),
(83, 13, 36, 'best fon ever', 0, 1, 1, ''),
(114, 13, 37, 'beautiful phone.i love it', 0, 0.675, 0, ''),
(19, 13, 39, 'This fon is so so good.i mean the camera quality is also nice.', 0, 0.14375, 0, ''),
(50, 14, 21, 'Received an defective product. Faced lot of problems to get it resolved from Both Nokia and Amazon.Nokia Service center denied and said they stopped service for these Handsets. please make sure from amazon or Seller before you buy this product.', 0, 0.2, 0, ''),
(85, 14, 36, 'not good fon..features so bad', 0, -0.525, 1, ''),
(115, 14, 37, 'i love this phone..its so good', 0, 0.6, 1, ''),
(20, 14, 39, 'It has everything like i wanted,good picture quality,pleasant sound quality and many more.', 0, 0.466667, 0, ''),
(51, 15, 21, 'My first iphone ... no need to say about the design, performance... of an \"Apple\" product.A complete value for money product.Superb delivery by ekart ... received the product with 1.5 days of placing order.As it was my first online smartphone purchase and price quoted was concerned so as to how much old stock product will i receive as the phone was launched 3 years ago. No issues as to same ... received August 2016 batch product with ios 9.0.3. Updated to ios 10.1 within an hour of receipt of delivery.', 0, 0.14, 0, ''),
(86, 15, 36, 'this phone is excellent', 0, 1, 1, ''),
(21, 15, 39, 'After detailed study, thought to buy this phone for my uncle. For Rs.7590 I think its worthy phone.. My uncle using this mobile for last 1 week and dont see any issues so far.', 0, 0.208333, 0, ''),
(87, 16, 36, 'there is some reason why apple is apple', 0, 0, 0, ''),
(52, 17, 21, 'Voice reception is very feeble. Product packaging does not seem to be original. Seems like meddled and repacked using small small cello tapes at corners and stickers.', 0, -0.19375, 0, ''),
(88, 17, 36, 'just apple product and people are mad about it.not good', 0, 0.0375, 0, ''),
(22, 17, 39, 'PlZzz take it from Apple store it was not sealed n earphone r replaced n stickers r missing n it is opened n used set ....', 0, -0.2, 0, ''),
(53, 18, 21, 'The phone - It feels great. I personally chose the iPhone 7 over 7+ because of the size. Moving from iPhone 5 to 7 was absolutely no downer in terms of size, the size suited me well. Specifications wise - still exploring. ;)', 0, 0.33, 0, ''),
(89, 18, 36, 'excellent product', 0, 1, 1, ''),
(23, 18, 39, 'First to Flipkart delivery service - Thanks a lot, I received it earlier than promised. I also received a chocolate from you guys, it felt really nice. Multiplied my joys of receiving my new phone.Now to the iPhone.Packaging - As always - neat & superior!The phone - It feels great. I personally chose the iPhone 7 over 7+ because of the size. Moving from iPhone 5 to 7 was absolutely no downer in terms of size, the size suited me well.Specifications wise - still exploring.', 0, 0.287374, 0, ''),
(54, 19, 21, 'working in an E-comm company, i know the value of delivery timing.Got the product just 1 hour after the product release.Excellent product as I am upgrading it from 5s', 0, 0, 1, ''),
(90, 19, 36, 'best product ever.there is something about apple wat i like..it feels good with iphone in my hand', 0, 0.85, 0, ''),
(24, 19, 39, 'Nice product from Apple as always but not much of a difference.Make sense if someone is upgrading his/her phone from iPhone 6 or below versions.Overall its a good phon!!!', 0, 0.5, 0, ''),
(55, 20, 21, 'The offer said 10000 cash back for citi credit and debit cards and I used a debit card for full payment and never got the cash back. Please guide me here with the procedure', 0, 0.116667, 0, ''),
(91, 20, 36, 'so so good..m loving it', 0, 0.6, 0, ''),
(25, 20, 39, 'the phone is everything that apple promised', 0, 0, 0, ''),
(56, 21, 21, 'disaster product', 0, 0, 0, ''),
(92, 21, 36, 'worst product ever', 0, -1, 1, ''),
(26, 21, 39, 'i loved all the features.excellent camera quality.', 0, 0.7, 1, ''),
(79, 22, 36, 'best phone', 0, 1, 0, ''),
(148, 22, 54, 'Nice product. Would like to recommend to all.', 0, 0.6, 0, ''),
(57, 23, 21, 'not good mobile.', 0, -0.35, 0, ''),
(80, 23, 36, 'worst mobile ever', 0, -1, 1, ''),
(27, 23, 39, 'Its been a while since i laughed for such an hilarious joke!!Phone of the century.Guess XA2 will be competing the XZ1.', 0, 0.4, 1, ''),
(58, 24, 21, 'best phone ever', 0, 1, 0, ''),
(94, 24, 36, 'wow..so good phone', 0, 0.7, 0, ''),
(28, 24, 39, 'Extraordinary Phone. Even better than Iphone 8.960fps and 3d creator are next level experience.Android 8 is providing supersonic speed. Faster than iphone 8 or even X.No phone can beat its speed or performance rather than Xperia XZ Premium.Triluminos Display gives you beautiful colors.Little curved display with corning gorilla glass 5 feels you richer experience.', 0, 0.420833, 0, ''),
(59, 25, 21, 'satisfied with the product.', 0, 0.5, 0, ''),
(95, 25, 36, 'i love this phone.', 0, 0.5, 0, ''),
(29, 25, 39, 'Expected a top class Android handset.Disappointed because experienced lots of signal issues.I used this for a month in Delhi along with iPhone 7 because I needed an Android apps.While iPhone 7 was ok for signals of voice, data and GPS, this handset often had problems to catch the signals.Before the colourful features of camera, display and other things, I needed the basic features.Now, I use this expensive handset only for limited situations.', 0, 0.111508, 0, ''),
(60, 26, 21, 'great to see such fon in my life', 0, 0.4, 1, ''),
(96, 26, 36, 'design not good with worst features', 0, -0.675, 0, ''),
(30, 26, 39, 'worst mobile.', 0, -1, 1, ''),
(61, 27, 21, 'so bad phone', 0, -0.7, 1, ''),
(97, 27, 36, 'so good phone..i loved this', 0, 0.7, 0, ''),
(31, 27, 39, 'i loved all the features of this mobile.', 0, 0.7, 0, ''),
(142, 27, 55, 'a good phone', 0, 0.7, 0, ''),
(62, 28, 21, 'i never expected such worst phone', 0, -0.316667, 1, ''),
(98, 28, 36, 'i loved this phone', 0, 0.7, 1, ''),
(63, 29, 21, 'worst phone ever.', 0, -1, 1, ''),
(99, 29, 36, 'worst phone ever', 0, -1, 1, ''),
(12, 29, 39, 'Not good phone..i m regretting.', 0, -0.35, 0, ''),
(64, 30, 21, 'Heating issue. camera is not like 16mp. 2 days back i brought this product Rs. 11760/-. Today,s price is 10220/- why did Rs. 1540 more collected from me? Request for return me Rs. 1540/-.This phone is not good. after 1 month touch is not working. what should i do? unnecessary i spent money. Dabba phone.', 0, -0.07, 0, ''),
(100, 30, 36, 'not good phone', 0, -0.35, 0, ''),
(65, 31, 21, 'money spended on wrong phone i guess.', 0, -0.5, 0, ''),
(101, 31, 36, 'dabba phone', 0, 0, 0, ''),
(66, 32, 21, 'best phone ever', 0, 1, 0, ''),
(102, 32, 36, 'i love this phone more than my life.', 0, 0.5, 0, ''),
(67, 33, 21, 'this laptop is not good', 0, -0.35, 0, ''),
(68, 34, 21, 'wow..touch..2 in 1..m in love wid dis', 0, 0.5, 0, ''),
(69, 35, 21, 'best product..m satisfied completely.', 0, 0.533333, 0, ''),
(32, 35, 39, 'best laptop ever', 0, 1, 0, ''),
(33, 37, 39, 'So light you have to hold it to believe it. – Really. It is a liberating experience. Put this in a bag or backpack and you have to get used to the unnerving feeling that you forgot your laptop! My previous laptop was a Sony Vaio Z13 – no slouch itself in the slim and light department, weighing in at 2.5 pounds. But the half a pound really makes this laptop a different ergonomic experience. For fun I handed it to my wife whose main charge is a surface pro 4. She was stunned at how light it feels. By comparison her surface (with keyboard cover) feels like a brick! Not what we expected.It is not a tablet, but I have found that it is so light that you can hand it to people to view a photo or document in an easy way that I couldn’t do with my previous laptop. The screen can be positioned 100% flat and built in software allows the image to be reversed for viewing. A neat trick and very easy to execute with the function key control.Incredible Keyboard Experience. I am typing this review on the Samsung right now. I write a lot and want to concentrate on what I am writing and NOT what I am writing with. Finally, I have a laptop that doesn’t make me miss my desktop keyboard! The size, spacing, tactile feel, travel of this keyboard works perfectly for me.', 0, 0.246971, 0, ''),
(71, 38, 21, 'just good for game purpose', 0, 0.15, 0, ''),
(70, 40, 21, 'worst product', 0, -1, 0, ''),
(116, 44, 21, 'It is a good product in terms of display', 0, 0.7, 0, ''),
(117, 54, 36, 'Hahahah. never gonna buy things like this.', 0, 0, 0, ''),
(118, 60, 36, 'bad product', 0, -0.7, 0, ''),
(119, 79, 36, 'Using this tablet was a nice experience and I would suggest everyone to buy it.', 0, 0.6, 0, '');

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

--
-- Table structure for table `user1`
--

CREATE TABLE `user1` (
  `id` int(11) NOT NULL,
  `fname` varchar(255) DEFAULT NULL,
  `lname` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `pass` varchar(255) DEFAULT NULL,
  `sex` char(1) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `photo` varchar(255) NOT NULL DEFAULT 'icon.png',
  `phone` varchar(10) NOT NULL,
  `ip` varchar(32) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user1`
--

INSERT INTO `user1` (`id`, `fname`, `lname`, `email`, `pass`, `sex`, `dob`, `photo`, `phone`, `ip`) VALUES
(21, 'Komal', 'Agarwal', 'komalagrl12@gmail.com', 'komalgarg', 'F', '2000-06-09', 'upload/photo.jpg', '7088693374', '::1'),
(36, 'Akanksha', 'Kumari', 'abc@gmail.com', 'abc', 'F', '2018-04-05', 'upload/thumb-1920-108092.jpg', '7088223435', '::1'),
(37, 'pooja', 'singh', 'pooja@gmail.com', 'pooja', 'F', '2018-04-13', 'icon.png', '', '::1'),
(38, 'abc', 'xyz', 'abcxyz@gmail.com', 'abc', 'M', '1998-12-12', 'icon.png', '', NULL),
(39, 'parul', 'choudhary', 'parul@gmail.com', 'parul', 'F', '1988-05-11', 'upload/image-4e1abf41295d903eb1924a34b61c83669010cf56523b2565049e16ff790a825a-V-1.jpg', '', NULL),
(40, 'Komal', 'Garg', 'komalagrl@gmail.com', 'komal', 'F', '0000-00-00', 'icon.png', '', '127.0.0.1'),
(41, 'Divyanshi', 'dixit', 'divi@gmail.com', 'divi', 'F', '2018-04-11', 'icon.png', '', '172.31.100.14'),
(42, 'Rachana', 'Saxena', 'rachana@gmail.com', 'rachana', 'F', '1995-02-10', 'upload/2.jpg', '', '172.31.153.43'),
(43, 'Sheeba', 'Parveen', 'sheeba@gmail.com', 'sheeba', 'F', '1994-09-09', 'upload/6.jpg', '', '172.31.153.43'),
(44, 'Anukriti', 'Kushwaha', 'anukriti@gmail.com', 'anukriti', 'F', '1995-02-03', 'upload/4.jpg', '', '172.31.153.43'),
(45, 'Vishesh', 'bajpai', 'vishesh@gmail.com', 'vishesh', 'M', '1994-12-12', 'upload/1370fd63ade24652337907e2749a76a3.jpg', '7008220022', '172.31.153.43'),
(46, 'Anuj', 'Gangwar', 'anuj@gmail.com', 'anuj', 'M', '1994-12-06', 'upload/389243.jpg', '', '172.31.153.43'),
(47, 'Raj', 'Kapoor', 'raj@gmail.com', 'raj', 'M', '1887-12-12', 'upload/papa.jpg', '', '172.31.153.43'),
(48, 'Albert', 'Einstein', 'albert@gmail.com', 'albert', 'M', '1917-10-01', 'upload/albert.jpg', '', '172.31.153.43'),
(49, 'Nikola', 'Tesla', 'nikola@gmail.com', 'nikola', 'M', '1856-10-07', 'upload/N.Tesla.JPG', '', '172.31.153.43'),
(50, 'Issac', 'Newton', 'newton@gmail.com', 'newton', 'M', '1643-04-01', 'upload/220px-GodfreyKneller-IsaacNewton-1689.jpg', '221213', '172.31.153.43'),
(51, 'Leonhard', 'Euler', 'euler@gmail.com', 'euler', 'M', '1707-12-04', 'upload/220px-Leonhard_Euler.jpg', '', '172.31.153.43'),
(52, 'Mark', 'Zuckerbrg', 'mark@facebook.com', 'mark', 'M', '1984-12-05', 'upload/416x416.jpg', '', '172.31.153.43'),
(53, 'pooja ', 'singh', 'pooja13insco@gmail.com', 'pooja', 'F', '1996-07-26', 'icon.png', '', '172.31.152.116'),
(54, 'Larry', 'Page', 'larry@gmail.com', 'larry', 'M', '1973-02-06', 'upload/Larry_Page_in_the_European_Parliament,_17.06.2009_(cropped).jpg', '', '172.31.152.116'),
(55, 'charu', 'gupta', 'charu@gmail.com', 'charu', '', '2018-04-01', 'icon.png', '', '172.31.153.43'),
(56, 'Bill', 'Gates', 'bill@gmail.com', 'bill', 'M', '1955-02-08', 'upload/ioSgz49P_400x400.jpg', '', '172.31.152.116'),
(57, 'Sneh', 'Tiwari', 'sneh@gmail.com', 'sneh', 'F', '1994-02-20', 'icon.png', '', '127.0.0.1');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`pid`),
  ADD UNIQUE KEY `pid` (`pid`),
  ADD UNIQUE KEY `pname` (`pname`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`pid`,`uid`),
  ADD UNIQUE KEY `id` (`id`),
  ADD KEY `fk_user` (`uid`);

--
-- Indexes for table `user1`
--
ALTER TABLE `user1`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

--
-- Constraints for dumped tables
--

--
-- Constraints for table `reviews`
--
ALTER TABLE `reviews`
  ADD CONSTRAINT `fk_product` FOREIGN KEY (`pid`) REFERENCES `products` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_user` FOREIGN KEY (`uid`) REFERENCES `user1` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;