Dashboard Overview
Storefront Performance & Inventory
Total Catalog Products
48
● All Active in shop
Active Orders & Inquiries
2
● 1 Pending review
Registered Customers
1
Verified Bangladesh accounts
Hostinger MySQL
Active
Schema ready in phpMyAdmin
Recent Customer Inquiries
Store Quick Actions
Jewellery Catalogue
Product Management
| Image | Product & SKU | Category | Price (BDT) | Stock Status | Material | Actions |
|---|
Customer Orders
Orders & WhatsApp Inquiries
| Order Ref | Date | Customer Info | Items Requested | Est. Total | Status | Update Status |
|---|
Client Base
Registered Customers
| Customer Name | Phone Number | District / City | Registered Date | Role |
|---|
Hosting & Infrastructure
Hostinger MySQL Database Integration
Hostinger MySQL Connection Settings
Enter the database details from your Hostinger hPanel (Databases → Management). These are saved in api/config.php and synchronized with the frontend.
Hostinger phpMyAdmin Schema
Execute this SQL schema in your Hostinger phpMyAdmin (SQL tab or Import tab) to create the tables instantly.
-- 1. Users Table
CREATE TABLE IF NOT EXISTS `emk_users` (...);
-- 2. Products Table
CREATE TABLE IF NOT EXISTS `emk_products` (...);
-- 3. Orders & Inquiries Table
CREATE TABLE IF NOT EXISTS `emk_orders` (...);
-- 4. Settings Table
CREATE TABLE IF NOT EXISTS `emk_settings` (...);Deployment Steps to Hostinger:
- Create MySQL Database in Hostinger hPanel.
- Click Enter phpMyAdmin and import
database.sql. - Upload the site files to your
public_html/directory. - Verify
public_html/api/config.phpmatches your DB user and password.
General Preferences