One Hat Cyber Team
Your IP :
216.73.216.186
Server IP :
88.222.243.1
Server :
Linux in-mum-web1837.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64
Server Software :
LiteSpeed
PHP Version :
8.2.28
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
u322583024
/
domains
/
awaha.in
/
public_html
/
Edit File:
u263698360_awahasoap_17-03_2025.sql
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1:3306 -- Generation Time: Mar 17, 2025 at 07:11 AM -- Server version: 10.11.10-MariaDB -- PHP Version: 7.2.34 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; 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: `u263698360_awahasoap` -- -- -------------------------------------------------------- -- -- Table structure for table `blogs` -- CREATE TABLE `blogs` ( `id` int(11) NOT NULL, `blog_name` varchar(255) NOT NULL, `blog_title` varchar(255) NOT NULL, `blog_description` varchar(255) NOT NULL, `blog_keywords` varchar(255) NOT NULL, `blog_img` varchar(255) NOT NULL, `blog_information` text NOT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `blogs` -- INSERT INTO `blogs` (`id`, `blog_name`, `blog_title`, `blog_description`, `blog_keywords`, `blog_img`, `blog_information`, `created_at`) VALUES (4, '5 Reasons Why Awaha Soap Stands Out Among Organic Skincare Brands', 'test t', 'test d2', 'test keyword', '../uploads/blogs/67ce9a77530d7_blog4.webp', '<p>In the world of organic skincare, finding a brand that truly delivers on its promises can be challenging. However, <strong>Awaha Soap</strong> has emerged as a leader in natural skincare, offering products that are not only organic but also highly effective. Here are five reasons why <strong>Awaha Soap</strong> stands out among organic skincare brands.</p>\r\n<h3><strong>Skin-Friendly and Dermatologically Tested</strong></h3>\r\n<p>Many organic soaps can be harsh or drying, but Awaha Soap is <strong>dermatologically tested</strong> to be gentle on the skin. It helps with:</p>\r\n<p>🌿 Acne-prone and sensitive skin<br />🌿 Hydration for dry skin<br />🌿 Balancing the skin’s natural pH</p>\r\n<p>The soap works in harmony with your skin, making it safe for <strong>daily use</strong> without irritation.</p>', '2025-03-10'), (5, 'Awaha’s Variant Guide: Find the Perfect Soap for Your Skin Type', 'test t', 'test d2', 'test keyword', '../uploads/blogs/67ce9b2080c6e_blog2.webp', '<p>Choosing the right soap for your skin type is essential for maintaining healthy, radiant skin. Awaha offers a variety of organic soaps, each crafted with natural ingredients to suit different skin needs. Whether you have dry, oily, sensitive, or combination skin, there’s a perfect <strong>Awaha Soap</strong> for you!</p>\r\n<p>Let’s explore Awaha’s soap variants and find the best match for your skin.</p>\r\n<p><strong>For Dry Skin – Awaha Moisture Rich Almond & Honey Soap</strong></p>\r\n<p><strong>Key Ingredients:</strong> Almond Oil, Honey, Shea Butter<br />âś… Deeply hydrates and nourishes dry, flaky skin<br />âś… Honey acts as a natural humectant, locking in moisture<br />âś… Almond oil soothes irritation and boosts elasticity</p>\r\n<p><strong>Best For:</strong> Those experiencing dryness, rough patches, or winter skin concerns.</p>', '2025-03-10'), (6, 'Why Switching to Soaps Like Awaha Is the Best Skincare Decision', 'test t2', 'test d2', 'test keyword', '../uploads/blogs/67ce9b289f5c3_blog1.webp', '<p>In a world filled with chemical-laden skincare products, making the switch to natural and organic soaps is one of the best things you can do for your skin. Awaha, an all-natural soap brand, offers <strong>pure, chemical-free, and skin-loving</strong> soaps that nourish and protect your skin without harmful additives.</p>\r\n<p>If you’ve been using commercial soaps packed with artificial fragrances and harsh detergents, here’s why switching to <strong>Awaha</strong> is the best skincare decision you’ll ever make!</p>\r\n<p><strong>1. Free from Harsh Chemicals & Artificial Ingredients</strong></p>\r\n<p>Many commercial soaps contain <strong>sulfates, parabens, synthetic fragrances, and preservatives</strong> that strip your skin of its natural oils, leaving it dry, irritated, and prone to breakouts.</p>\r\n<p>âś… <strong>Awaha Soaps are 100% free from:</strong></p>\r\n<ul>\r\n<li>Sulfates (harsh foaming agents that cause dryness)</li>\r\n<li>Parabens (harmful preservatives linked to skin issues)</li>\r\n<li>Artificial fragrances (known to trigger allergies)</li>\r\n</ul>\r\n<p>Instead, Awaha uses <strong>pure essential oils, herbs, and plant-based extracts</strong> to keep your skin healthy and nourished.</p>\r\n<p><strong>2. Packed with Natural Ingredients That Your Skin Loves</strong></p>\r\n<p>Every Awaha soap is enriched with <strong>nutrient-rich botanicals, oils, and extracts</strong> that benefit your skin.</p>\r\n<p><strong>Some hero ingredients in Awaha soaps include:</strong><br /><strong>Neem & Tea Tree</strong> – Fights acne and breakouts naturally<br /><strong>Turmeric & Sandalwood</strong> – Brightens skin and evens tone<br /><strong>Coconut & Shea Butter</strong> – Deeply moisturizes dry skin<br /><strong>Goat Milk & Saffron</strong> – Boosts collagen and reduces aging signs</p>\r\n<p>Unlike commercial soaps that just cleanse, Awaha <strong>nourishes and heals</strong> your skin from within!</p>', '2025-03-10'), (7, 'The Benefits of Using Soap: Awaha’s Promise for Healthier Skin', 'test t2', 'test desc', 'test keyword', '../uploads/blogs/67ce9b314bb33_blog5.webp', '<p>In a world filled with chemical-laden skincare products, making the switch to a natural soap like <strong>Awaha</strong> can be a game-changer for your skin. Awaha’s soaps are crafted with pure, nourishing ingredients that cleanse, hydrate, and protect your skin without the use of harmful chemicals.</p>\r\n<p>If you\'re looking for <strong>healthier, glowing skin</strong>, here’s why choosing <strong>Awaha soap</strong> is the best decision for your skincare routine!</p>\r\n<p> </p>\r\n<p><strong>1. Deep Cleansing Without Harsh Chemicals</strong></p>\r\n<p>Many commercial soaps contain <strong>harsh detergents and synthetic ingredients</strong> that strip the skin of its natural oils, leaving it dry and irritated.</p>\r\n<p><strong>Awaha Soaps are 100% free from:</strong></p>\r\n<ul>\r\n<li>Sulfates (foaming agents that cause dryness)</li>\r\n<li>Parabens (harmful preservatives linked to skin irritation)</li>\r\n<li>Artificial fragrances (which may trigger allergies)</li>\r\n</ul>\r\n<p>Instead, Awaha soaps use <strong>botanical extracts, essential oils, and natural butters</strong> to cleanse your skin gently while maintaining its moisture balance.</p>\r\n<p><strong>2. Hydrates and Nourishes the Skin</strong></p>\r\n<p>Unlike ordinary soaps that leave your skin feeling tight, Awaha soaps are formulated with <strong>moisturizing ingredients</strong> that <strong>lock in hydration</strong> and prevent dryness.</p>\r\n<p><strong>Hydrating Ingredients in Awaha Soaps:</strong><br /><strong>Coconut Oil & Shea Butter</strong> – Deeply nourish and soften skin<br /><strong>Honey & Goat Milk</strong> – Restore moisture and promote healing<br /><strong>Aloe Vera & Cucumber</strong> – Soothe and refresh the skin</p>\r\n<p>Switching to Awaha means <strong>no more dry, flaky skin—just lasting hydration!</strong></p>', '2025-03-10'); -- -------------------------------------------------------- -- -- Table structure for table `cart` -- CREATE TABLE `cart` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `quantity` int(11) DEFAULT 1, `added_on` timestamp NULL DEFAULT current_timestamp(), `deleted_at` date DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `cart` -- INSERT INTO `cart` (`id`, `user_id`, `product_id`, `quantity`, `added_on`, `deleted_at`) VALUES (37, 2, 8, 1, '2025-03-17 05:35:41', NULL); -- -------------------------------------------------------- -- -- Table structure for table `categories` -- CREATE TABLE `categories` ( `id` int(11) NOT NULL, `category_name` varchar(255) NOT NULL, `category_image` varchar(1000) DEFAULT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `categories` -- INSERT INTO `categories` (`id`, `category_name`, `category_image`, `created_at`) VALUES (6, 'Dyota - cleaning agent', 'assets/categoryuploads/cleaning%20agent.jpeg', '2025-01-28'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` int(255) NOT NULL, `order_id` varchar(20) NOT NULL, `user_id` int(11) NOT NULL, `total_amount` decimal(10,2) NOT NULL, `billing_name` varchar(100) NOT NULL, `billing_address` text NOT NULL, `billing_city` varchar(50) NOT NULL, `billing_country` varchar(100) NOT NULL DEFAULT 'India', `billing_state` varchar(50) NOT NULL, `billing_zip` varchar(20) NOT NULL, `billing_phone` bigint(20) NOT NULL, `company_name` varchar(255) DEFAULT NULL, `payment_method` varchar(20) NOT NULL, `razorpay_payment_id` varchar(255) DEFAULT NULL, `payment_done_on` datetime DEFAULT NULL, `order_status` varchar(20) DEFAULT 'Pending', `shipped_date` date DEFAULT NULL, `delivered_date` date DEFAULT NULL, `created_at` timestamp NULL DEFAULT current_timestamp(), `cart_ids` text DEFAULT NULL, `products` text DEFAULT NULL, `awb_number` int(11) DEFAULT NULL, `shiprocket_token` longtext DEFAULT NULL, `pickup_location` varchar(100) NOT NULL DEFAULT 'Home' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `order_id`, `user_id`, `total_amount`, `billing_name`, `billing_address`, `billing_city`, `billing_country`, `billing_state`, `billing_zip`, `billing_phone`, `company_name`, `payment_method`, `razorpay_payment_id`, `payment_done_on`, `order_status`, `shipped_date`, `delivered_date`, `created_at`, `cart_ids`, `products`, `awb_number`, `shiprocket_token`, `pickup_location`) VALUES (1, 'AWAHA1', 2, 203.00, 'Vaishnavi Patil', 'Panvel', 'Mumbai', 'India', 'Andhra Pradesh', '410206', 7896541230, '', 'prepaid', 'pay_Q4F1Ma4BzVre5o', '2025-03-08 14:38:44', 'Pending', NULL, NULL, '2025-03-08 14:38:44', '8', '[{\"product_id\":8,\"quantity\":1,\"product_discount_price\":\"153\"}]', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjU5OTY2MDAsInNvdXJjZSI6InNyLWF1dGgtaW50IiwiZXhwIjoxNzQyMjg4OTI0LCJqdGkiOiJYdVF3bFRJak9BTFNScVpiIiwiaWF0IjoxNzQxNDI0OTI0LCJpc3MiOiJodHRwczovL3NyLWF1dGguc2hpcHJvY2tldC5pbi9hdXRob3JpemUvdXNlciIsIm5iZiI6MTc0MTQyNDkyNCwiY2lkIjo1NzgzNDEyLCJ0YyI6MzYwLCJ2ZXJib3NlIjpmYWxzZSwidmVuZG9yX2lkIjowLCJ2ZW5kb3JfY29kZSI6IiJ9.iYS0lK3eF4tB-reDs6CUYCnmF99XGhEjocyQj_IWtz0', 'Home'), (2, 'AWAHA2', 2, 223.00, 'Vaishnavi Patil', 'Panvel', 'Bangalore', 'India', 'Maharashtra', '410206', 7896541230, 'hs', 'prepaid', 'pay_Q4F3DU1Ijy9YdT', '2025-03-08 14:40:29', 'Pending', NULL, NULL, '2025-03-08 14:40:29', '8', '[{\"product_id\":8,\"quantity\":1,\"product_discount_price\":\"153\"}]', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjU5OTY2MDAsInNvdXJjZSI6InNyLWF1dGgtaW50IiwiZXhwIjoxNzQyMjg5MDI5LCJqdGkiOiJ1UTVtY3FqWWJ2WGdOcVdmIiwiaWF0IjoxNzQxNDI1MDI5LCJpc3MiOiJodHRwczovL3NyLWF1dGguc2hpcHJvY2tldC5pbi9hdXRob3JpemUvdXNlciIsIm5iZiI6MTc0MTQyNTAyOSwiY2lkIjo1NzgzNDEyLCJ0YyI6MzYwLCJ2ZXJib3NlIjpmYWxzZSwidmVuZG9yX2lkIjowLCJ2ZW5kb3JfY29kZSI6IiJ9.A8wrMZr7ABlcAzXIoBJjAAxqNy5WC9XApxcLLsWWkDI', 'Home'), (3, 'AWAHA3', 2, 203.00, 'Vaishnavi Patil', 'Panvel', 'Mumbai', 'India', 'Andhra Pradesh', '410206', 7896541230, 'hs', 'cod', NULL, '2025-03-08 15:13:33', 'Pending', NULL, NULL, '2025-03-08 15:13:33', '[33]', '[{\"product_id\":8,\"quantity\":1,\"product_discount_price\":\"153\"}]', NULL, 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjYwMDQ3NzQsInNvdXJjZSI6InNyLWF1dGgtaW50IiwiZXhwIjoxNzQyMjkxMDE1LCJqdGkiOiJaTlVXcnpWY1pTSjVxSTdtIiwiaWF0IjoxNzQxNDI3MDE1LCJpc3MiOiJodHRwczovL3NyLWF1dGguc2hpcHJvY2tldC5pbi9hdXRob3JpemUvdXNlciIsIm5iZiI6MTc0MTQyNzAxNSwiY2lkIjo1NzgzNDEyLCJ0YyI6MzYwLCJ2ZXJib3NlIjpmYWxzZSwidmVuZG9yX2lkIjowLCJ2ZW5kb3JfY29kZSI6IiJ9.4gtw5limd14Ipf86uq0KkxTOWM3wDk4yFxV_x9BZFFk', 'Home'), (4, 'AWAHA4', 2, 203.00, 'Vaishnavi Patil', 'Panvel', 'Mumbai', 'India', 'Andhra Pradesh', '410206', 7896541230, 'hs', 'cod', NULL, '2025-03-15 18:30:55', 'Pending', NULL, NULL, '2025-03-15 18:30:55', '[34]', '[{\"product_id\":8,\"quantity\":1,\"product_discount_price\":\"153\"}]', NULL, NULL, 'Home'), (5, 'AWAHA5', 2, 358.00, 'Vaishnavi Patil', 'Panvel', 'Mumbai', 'India', 'Arunachal Pradesh', '410206', 7896541230, 'hs', 'prepaid', 'pay_Q755ADQY2qFiQi', '2025-03-15 18:52:25', 'Pending', NULL, NULL, '2025-03-15 18:52:25', '8,18', '[{\"product_id\":8,\"quantity\":1,\"product_discount_price\":\"153\"},{\"product_id\":18,\"quantity\":1,\"product_discount_price\":\"155\"}]', NULL, NULL, 'Home'); -- -------------------------------------------------------- -- -- Table structure for table `other_products` -- CREATE TABLE `other_products` ( `id` int(11) NOT NULL, `sku_id` int(11) NOT NULL, `category_id` int(11) NOT NULL, `product_name` varchar(255) NOT NULL, `product_details` text NOT NULL, `product_stock` varchar(255) NOT NULL, `product_price` varchar(255) NOT NULL, `product_discount_price` varchar(255) NOT NULL, `product_discount` varchar(500) DEFAULT NULL, `product_weight` varchar(500) DEFAULT NULL, `product_img` varchar(255) NOT NULL, `product_img1` varchar(255) DEFAULT NULL, `product_img2` varchar(255) DEFAULT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `other_products` -- INSERT INTO `other_products` (`id`, `sku_id`, `category_id`, `product_name`, `product_details`, `product_stock`, `product_price`, `product_discount_price`, `product_discount`, `product_weight`, `product_img`, `product_img1`, `product_img2`, `created_at`) VALUES (101, 1, 6, 'Lavendar Dyota - Sprakling Clean Floor', '<p>Awaha\'s <strong data-start=\"8\" data-end=\"26\">cleaning agent</strong> is a high-quality solution designed to effectively remove dirt, stains, and impurities, ensuring superior hygiene and cleanliness.</p>', '1', '200', '180', '10% off', '1000 gms', '../uploads/67b96c96e134f_cleaning agent.jpeg', '../uploads/67b96c96e1580_WhatsApp Image 2025-02-15 at 2.23.18 PM.jpeg', '', '0000-00-00'), (105, 2, 6, 'Lemon Dyota - Dishwasher Antibacterial', '<p>Dishwasher detergent, dishwash liquid, Dyota Dishwashing Liquid Gel dishwashing liquid dishwasher detergent dishwasher liquid.</p>\r\n<p><strong>Why Dyota Dishwasher Liquid:</strong></p>\r\n<p>1.Dyota DIshwash Gel is unlike the other Dishwash bars does not leave white residue which is visible after the utensils have dried and does not damage or scratch your expensive cookware’s delicate surfaces such as non stick or ceramic too.</p>\r\n<p>2.Dyota Dishwashing Liquid Gel is all you need to remove the toughest of grease from your utensils.</p>\r\n<p>3. Its ensures that the toughest of grease is removed with ease without damaging your precious cookware. So whether it is mum’s burnt Halwa or your experimental Dal Makhani, sparkling clean utensils is something you will get everytime. Pleasent Fragrance Dyota Dishwashing Liquid has Lemon Concentrate Elements which will give mild Fragrance of Lemon and Zero Irritative. Proudly Made in India for the World.</p>', '1', '200', '180', '10% off', '1000 gms', '../uploads/67c1693fd032f_WhatsApp Image 2025-02-15 at 2.29.19 PM.jpeg', '../uploads/67c1693fd04b5_WhatsApp Image 2025-02-15 at 2.29.30 PM.jpeg', NULL, '0000-00-00'), (106, 106, 6, 'Rose Dyota - Sprakling Clean Floor', '<p>Awaha\'s <strong data-start=\"8\" data-end=\"26\">cleaning agent</strong> is a high-quality solution designed to effectively remove dirt, stains, and impurities, ensuring superior hygiene and cleanliness.</p>', '1', '200', '180', '10% off', '1000 gms', '../uploads/67c6e6ca9f62e_WhatsApp Image 2025-03-04 at 1.05.02 PM.jpeg', '../uploads/67c6e6ca9f783_WhatsApp Image 2025-02-15 at 2.23.18 PM.jpeg', NULL, '0000-00-00'), (107, 1007, 6, 'Lemon Dyota - Sprakling Clean Floor', '<p>Awaha\'s <strong data-start=\"8\" data-end=\"26\">cleaning agent</strong> is a high-quality solution designed to effectively remove dirt, stains, and impurities, ensuring superior hygiene and cleanliness.</p>', '1', '200', '180', '10% off', '1000 gms', '../uploads/67c6e6f920344_WhatsApp Image 2025-03-04 at 1.05.03 PM.jpeg', '../uploads/67c6e6f920443_WhatsApp Image 2025-02-15 at 2.23.17 PM.jpeg', '../uploads/67c6e6f920580_WhatsApp Image 2025-02-15 at 2.23.19 PM.jpeg', '0000-00-00'); -- -------------------------------------------------------- -- -- Table structure for table `products` -- CREATE TABLE `products` ( `id` int(11) NOT NULL, `sku_id` int(11) NOT NULL, `product_name` varchar(1000) NOT NULL, `product_details` longtext NOT NULL, `product_stock` varchar(255) NOT NULL, `product_price` varchar(255) NOT NULL, `product_discount_price` varchar(255) DEFAULT NULL, `product_discount` varchar(255) DEFAULT NULL, `product_weight` varchar(500) DEFAULT NULL, `product_img` varchar(255) DEFAULT NULL, `product_img1` varchar(255) DEFAULT NULL, `product_img2` varchar(255) DEFAULT NULL, `product_img3` varchar(255) DEFAULT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `products` -- INSERT INTO `products` (`id`, `sku_id`, `product_name`, `product_details`, `product_stock`, `product_price`, `product_discount_price`, `product_discount`, `product_weight`, `product_img`, `product_img1`, `product_img2`, `product_img3`, `created_at`) VALUES (7, 1001, 'Rose : Soothing and hydrating.', '<p>Our Rose soap is a timeless indulgence. beautifully yours to cherish. Immerse yourself in the delicate fragrance of roses as it caresses your skin, leaving it soft, radiant, and delicately scented.</p>', '0', '170', '153', '10% off', '500 gms', '../uploads/678a54e6a977f_0P9A3729.JPG', '../uploads/678a54e6a9d3f_0P9A3668.JPG', '../uploads/678a54e6aa3e9_0P9A3752.JPG', '../uploads/678a54e6aa8a6_0P9A3691.JPG', '2025-01-17'), (8, 1002, 'Fresh Lemon: Energizing and brightening.', '<p>This soap is your daily dose of freshness. Infused with the invigorating zest of lime, it revitalnes your senses and leaves your skin feeling refreshed, energiard, and trady to take on the day</p>', '1', '170', '153', '10% off', '500 gms', '../uploads/678a547d0f506_0P9A3628.JPG', '../uploads/678a547d0faaf_0P9A3627.JPG', '../uploads/678a547d0ff5c_0P9A3611.JPG', '../uploads/678a547d10322_0P9A3532.JPG', '2025-01-17'), (9, 1003, 'Sandalwood: Pure and anti-inflammatory.', '<p>Experience purity in its simplest form with our Sandalwood snap Let the calming essence of sandalwood soothe your senses and envelop you in a cocoon of tranquillity leaving your skin feeling cleansed, refreshed, and simply pure.</p>', '1', '170', '153', '10% off', '500 gms', '../uploads/678a55473891f_0P9A3606.JPG', '../uploads/678a554738e52_0P9A3580.JPG', '../uploads/678a554739263_0P9A3610.JPG', '../uploads/678a55473973a_0P9A3585 - Copy.JPG', '2025-01-17'), (10, 1004, 'Jasmine : Nourishing and rejuvenating.', '<p>The Jasmine soup in a beauty bar for everybody It transports you to a garden of blooming flowers, while gently nourishing and pampering your skin, leaving it soft. mooth, and beautifully fragrant</p>', '1', '170', '153', '10% off', '500 gms', '../uploads/678a55b495321_0P9A3974.JPG', '../uploads/678a55b495899_0P9A3945.JPG', '../uploads/678a55b495e1e_0P9A3972.JPG', '../uploads/678a55b49637f_0P9A3975.JPG', '2025-01-17'), (11, 1005, 'Avocado: Relaxing and stress-relieving', '<p>Pamper yourself in pure luxury with our Avocado soap. Enriched with the essence of creamy avocado, it nourishes and rejuvenates your skin, leaving it irresistibly smooth .</p>', '1', '185', '166', '10% off', '500 gms', '../uploads/678a56261ce52_0P9A3773.JPG', '../uploads/678a56261d4b1_0P9A3781.JPG', '../uploads/678a56261dab5_0P9A3767.JPG', '../uploads/678a56261e000_0P9A3756.JPG', '2025-01-17'), (18, 1006, 'Pack of 5 Soaps: Ultimate Luxury Bathing Experience', '<p>Indulge in a complete bathing ritual with our <strong>Pack of 5 Soaps</strong>, featuring a carefully curated selection of our most exquisite handmade soaps. Each bar is crafted with premium ingredients to nourish, hydrate, and rejuvenate your skin while offering a unique sensory experience.</p>\r\n<h4><strong>What\'s Inside the Pack?</strong></h4>\r\n<p>âś… <strong>Rose Soap</strong> – Soothing & Hydrating: A timeless floral indulgence that refreshes and revitalizes your skin.<br>âś… <strong>Fresh Lemon Soap</strong> – Energizing & Brightening: Infused with citrus freshness, this soap awakens your senses and gives a natural glow.<br>âś… <strong>Sandalwood Soap</strong> – Pure & Anti-Inflammatory: A luxurious bar that calms the skin and promotes deep nourishment.<br>âś… <strong>Jasmine Soap</strong> – Nourishing & Rejuvenating: A beauty bar enriched with natural extracts to leave your skin soft and radiant.<br>âś… <strong>Avocado Soap</strong> – Relaxing & Stress-Relieving: Packed with essential oils to deeply moisturize and soothe your skin.</p>\r\n<h4><strong>Why Choose Our Pack of 5?</strong></h4>\r\n<p>✨ <strong>Perfect for Gifting</strong> – A thoughtful present for loved ones who appreciate self-care.<br>✨ <strong>Complete Skin Care</strong> – A variety of benefits in one pack, catering to different skin needs.<br>✨ <strong>Handmade & Natural</strong> – Free from harsh chemicals, our soaps are gentle yet effective.<br>✨ <strong>Value for Money</strong> – Get a premium bathing experience with 5 luxurious soaps in one pack.</p>\r\n<p>Elevate your skincare routine and enjoy the best of nature with our <strong>Pack of 5 Soaps</strong>—your skin will thank you! </p>', '1', '173', '155', '10', '500 gms', '../uploads/67c977f482fba_0P9A3813.JPG', '../uploads/67c977f482a10_0P9A3805.JPG', '../uploads/67c977f4825d8_0P9A3806.JPG', '../uploads/67c977f483367_0P9A3923.JPG', '2025-03-06'); -- -------------------------------------------------------- -- -- Table structure for table `reviews` -- CREATE TABLE `reviews` ( `id` int(11) NOT NULL, `user_name` varchar(255) DEFAULT NULL, `email` varchar(255) NOT NULL, `product_name` varchar(255) DEFAULT NULL, `product_id` int(255) DEFAULT NULL, `rating` int(11) DEFAULT NULL, `review_content` text DEFAULT NULL, `review_date` datetime DEFAULT NULL, `status` enum('Approved','Rejected') DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `reviews` -- INSERT INTO `reviews` (`id`, `user_name`, `email`, `product_name`, `product_id`, `rating`, `review_content`, `review_date`, `status`) VALUES (57, 'aayushi', 'gaundaayushi@gmail.com', 'Rose : Soothing and hydrating.', 7, 2, 'noice product...this is a demo review to check how long review can be uploaded ...\r\n\r\nThis rose-scented soap is a delight! The fragrance is fresh and long-lasting, leaving a subtle floral scent on the skin. It lathers well, providing a rich, creamy foam that feels luxurious. My skin feels soft, smooth, and hydrated after every use. The natural ingredients make it gentle and perfect for daily use. The scent isn't overpowering but lingers beautifully. If you love roses, this soap is a must-try! Great for relaxation and self-care. Highly recommended!', '2025-02-11 04:57:52', ''), (85, 'Rutuja', 'rutuja@gmail.com', 'Rose : Soothing and hydrating.', 7, 4, 'I recently tried the Rose: Soothing and Hydrating soap, and I must say, it’s been a delightful experience! The moment I unwrapped it, the gentle, natural rose fragrance instantly lifted my mood—it’s not overpowering but just the right amount of floral freshness. The soap lathers beautifully, leaving my skin feeling incredibly soft and hydrated. I have dry skin, and this soap didn’t strip away moisture like some others do. Instead, it felt like it was nourishing my skin with every use.', '2025-02-15 09:22:14', ''), (86, 'Rutuja', 'rutuja@gmail.com', 'Avocado: Relaxing and stress-relievi', 11, 3, 'I’ve been using the Avocado Relaxing and Stress-Relieving soap, and it’s such a treat! The texture is so creamy, and it has this mild, soothing scent that really helps me relax after a long day. My skin feels super soft and hydrated every time I use it—it’s like a mini spa moment at home. If you’re into calming, natural soaps, this one’s definitely worth trying!', '2025-02-15 09:29:30', ''), (87, 'Krishan', 'krishan@gmail.com', 'Fresh Lemon: Invigorating and brightening.', 8, 5, 'I absolutely love this Fresh Lemon soap! 🍋✨ The invigorating citrus scent is so refreshing—it instantly wakes me up in the morning and leaves my skin feeling clean and energized. The formula is gentle yet effective, giving my skin a nice, fresh glow without drying it out. Plus, the natural lemon fragrance lingers just enough to feel fresh without being overpowering. If you love bright, zesty scents, this soap is a must-try! Will definitely be repurchasing. 💛💦', '2025-02-15 09:33:41', ''), (88, 'Krishan', 'krishan@gmail.com', 'Jasmine : Nourishing and rejuvenating.', 10, 5, 'This jasmine soap is an absolute delight! It smells incredibly refreshing and leaves my skin feeling clean, soft, and bright. Perfect for a morning boost—love it! ', '2025-02-15 09:36:11', ''), (89, 'Krishan', 'krishan@gmail.com', 'Jasmine : Nourishing and rejuvenating.', 10, 5, 'The Jasmine soap is pure luxury! Its soothing floral scent is so calming, and it leaves my skin feeling soft, nourished, and refreshed. Perfect for a relaxing shower after a long day! ', '2025-02-15 09:42:31', ''), (90, 'Vaishali', 'Vaishali@gmail.com', 'Sandalwood: Pure and anti-inflammatory.', 9, 4, 'This Sandalwood soap is amazing! Its warm, earthy scent is so soothing, and it gently cleanses while calming my skin. Perfect for a refreshing and relaxing bath!', '2025-02-15 09:47:29', ''), (91, 'Vaishali', 'Vaishali@gmail.com', 'Fresh Lemon: Invigorating and brightening.', 8, 5, 'The Fresh Lemon soap is like a burst of sunshine! Its crisp, citrusy scent instantly refreshes my senses, while the gentle lather leaves my skin feeling bright, smooth, and rejuvenated. A perfect pick-me-up for any day!', '2025-02-15 09:59:46', ''); -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` int(11) NOT NULL, `name` varchar(1000) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `role` varchar(255) DEFAULT 'user' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `users` -- INSERT INTO `users` (`id`, `name`, `email`, `password`, `role`) VALUES (2, 'Vaishnavi Patil', 'patil.vaishnavi2053@gmail.com', '$2y$10$6wrn5Y1pUBoeSXnd77cnt.8zRPvK2tTlzInLnpC9gAhbGlLdHAzRu', 'Customer'), (12, 'admin', 'admin@gmail.com', '$2y$10$aikxnBs/foueV/m5lyJsb.wAXJiZrVy0jGaQ/BG11A9BjHsSbqwVe', 'Admin'), (46, 'Tejas Pajave', 'tpajave@gmail.com', '$2y$10$ajED58lU544WWpXj2jIkZuc37AFZlKjmscQM.nqZM/8ufMpC8ww72', 'Customer'), (47, 'soni jaiswal', 'jaiswalsoni2703@gmail.com', '$2y$10$LOEl3rWlyIy6OU9C6V2ZAuHuS2rGdwLI.T6DOyQiyeXiGXC6xoO26', 'Customer'), (48, 'Aayushi', 'a@gmail.com', '$2y$10$Pq6QoDQiycypJ7U3J9AWdebY1iUVzF5WYItZAzrMrEWC1x0suPl1.', 'Customer'), (49, 'Test', 'hsdigital30@gmail.com', '$2y$10$xgqKlOLAE0xWpfyUxTgfOuGV0h4BBUFVVWI2K4ZHn5hY8HoPCRPb2', 'Customer'); -- -------------------------------------------------------- -- -- Table structure for table `wishlist` -- CREATE TABLE `wishlist` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `added_on` timestamp NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `wishlist` -- INSERT INTO `wishlist` (`id`, `user_id`, `product_id`, `added_on`) VALUES (1, 2, 101, '2025-02-28 07:03:13'), (2, 2, 105, '2025-02-28 07:44:59'), (4, 2, 14, '2025-03-06 09:56:44'), (5, 2, 10, '2025-03-07 09:41:12'), (6, 2, 8, '2025-03-08 09:34:04'), (7, 2, 9, '2025-03-08 10:41:06'), (8, 2, 18, '2025-03-08 10:41:29'); -- -- Indexes for dumped tables -- -- -- Indexes for table `blogs` -- ALTER TABLE `blogs` ADD PRIMARY KEY (`id`); -- -- Indexes for table `cart` -- ALTER TABLE `cart` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `unique_user_product` (`user_id`,`product_id`); -- -- Indexes for table `categories` -- ALTER TABLE `categories` ADD PRIMARY KEY (`id`); -- -- Indexes for table `orders` -- ALTER TABLE `orders` ADD PRIMARY KEY (`id`); -- -- Indexes for table `other_products` -- ALTER TABLE `other_products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `products` -- ALTER TABLE `products` ADD PRIMARY KEY (`id`); -- -- Indexes for table `reviews` -- ALTER TABLE `reviews` ADD PRIMARY KEY (`id`); -- -- Indexes for table `users` -- ALTER TABLE `users` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `email` (`email`); -- -- Indexes for table `wishlist` -- ALTER TABLE `wishlist` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blogs` -- ALTER TABLE `blogs` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `cart` -- ALTER TABLE `cart` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38; -- -- AUTO_INCREMENT for table `categories` -- ALTER TABLE `categories` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `orders` -- ALTER TABLE `orders` MODIFY `id` int(255) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `other_products` -- ALTER TABLE `other_products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114; -- -- AUTO_INCREMENT for table `products` -- ALTER TABLE `products` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `reviews` -- ALTER TABLE `reviews` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92; -- -- AUTO_INCREMENT for table `users` -- ALTER TABLE `users` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50; -- -- AUTO_INCREMENT for table `wishlist` -- ALTER TABLE `wishlist` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; 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 */;
Simpan