Hostinger + phpMyAdmin Ready

PHP Blog Admin Panel for Hostinger & phpMyAdmin

A complete, production-ready PHP administration panel with local server image upload (uploads/), two-way phpMyAdmin synchronization, SEO meta tags, rich HTML editor, and secure credentials authentication.

Real-time phpMyAdmin Sync• Local Image Upload to uploads/• Meta Title, Desc & Keywords• Rich HTML Summernote Editor

Default Admin Credentials

Admin ID & Password

Pre-configured inside the admins table in MySQL

Bcrypt Hashed Security

Username / Email

admin

or admin@shreeshyamhousekeepingservices.in

Default Password

Admin@12345

Changeable anytime in phpMyAdmin or database

Hostinger Setup Guide

How to Deploy on Hostinger in 5 Minutes

Step-by-step instructions for Hostinger hPanel, phpMyAdmin import, and File Manager.

Create Hostinger MySQL Database

Import database.sql in phpMyAdmin

Click Enter phpMyAdmin in Hostinger. Go to the Import tab, choose database.sql, and click Go.

Upload Files to public_html/admin/

In Hostinger File Manager, create folder admin in public_html. Upload all files from /public/php-blog-admin/.

phpMyAdmin Ready SQL Schema

database.sql Table Structure

You can copy this SQL and paste it directly into Hostinger phpMyAdmin > SQL tab and click Go to instantly create both tables!

-- SHREE SHYAM HOUSEKEEPING - BLOG ADMIN PANEL DATABASE
-- For Hostinger phpMyAdmin (MySQL / MariaDB)

CREATE TABLE IF NOT EXISTS `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(60) NOT NULL UNIQUE,
  `email` varchar(120) NOT NULL,
  `password` varchar(255) NOT NULL,
  `full_name` varchar(100) NOT NULL DEFAULT 'Super Admin',
  `role` varchar(30) NOT NULL DEFAULT 'administrator',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_login` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Default Login: admin / Admin@12345
INSERT INTO `admins` (`id`, `username`, `email`, `password`, `full_name`, `role`, `created_at`) VALUES
(1, 'admin', 'admin@shreeshyamhousekeepingservices.in', '$2y$10$eE40M9oYyVwXQeR0c.0V9eS1o9Xp6Q5Z3BqK4N4V2R1.Gj6lC1.kS', 'Shree Shyam Admin', 'administrator', NOW())
ON DUPLICATE KEY UPDATE `username` = `username`;

CREATE TABLE IF NOT EXISTS `blogs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL UNIQUE,
  `category` varchar(100) NOT NULL DEFAULT 'General Cleaning',
  `author` varchar(100) NOT NULL DEFAULT 'Shree Shyam Team',
  `read_time` varchar(50) NOT NULL DEFAULT '5 min read',
  `image` varchar(255) DEFAULT NULL,
  `excerpt` text DEFAULT NULL,
  `content` longtext NOT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `meta_keywords` text DEFAULT NULL,
  `status` enum('published','draft') NOT NULL DEFAULT 'published',
  `views` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_slug` (`slug`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

PHP Admin Panel File Tree

Core Pages

📄 login.php: ID/Pass login with password_verify()

📄 logout.php: Session destroy handler

📄 index.php: Dashboard with search, filter, post list

📄 add-blog.php: Auto-slug, local image upload, Summernote HTML

📄 edit-blog.php: Live update with MySQL data

📄 delete-blog.php: Removes post & deletes local image

📄 api-blogs.php: JSON REST API for frontend

Folders & Config

📁 config/db.php: Hostinger PDO MySQL connection

📁 config/auth.php: Authentication session guard

📁 uploads/: Local server storage for uploaded images

📄 uploads/.htaccess: Prevents execution of malicious scripts

📄 database.sql: Ready to import into phpMyAdmin

📄 README.md: Complete Hostinger documentation

Loading Shree Shyam Housekeeping...

PHP Blog Admin Panel for Hostinger & phpMyAdmin

Real-time phpMyAdmin Sync• Local Image Upload to uploads/• Meta Title, Desc & Keywords• Rich HTML Summernote Editor

-- SHREE SHYAM HOUSEKEEPING - BLOG ADMIN PANEL DATABASE -- For Hostinger phpMyAdmin (MySQL / MariaDB) CREATE TABLE IF NOT EXISTS `admins` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(60) NOT NULL UNIQUE, `email` varchar(120) NOT NULL, `password` varchar(255) NOT NULL, `full_name` varchar(100) NOT NULL DEFAULT 'Super Admin', `role` varchar(30) NOT NULL DEFAULT 'administrator', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_login` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- Default Login: admin / Admin@12345 INSERT INTO `admins` (`id`, `username`, `email`, `password`, `full_name`, `role`, `created_at`) VALUES (1, 'admin', 'admin@shreeshyamhousekeepingservices.in', '$2y$10$eE40M9oYyVwXQeR0c.0V9eS1o9Xp6Q5Z3BqK4N4V2R1.Gj6lC1.kS', 'Shree Shyam Admin', 'administrator', NOW()) ON DUPLICATE KEY UPDATE `username` = `username`; CREATE TABLE IF NOT EXISTS `blogs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `slug` varchar(255) NOT NULL UNIQUE, `category` varchar(100) NOT NULL DEFAULT 'General Cleaning', `author` varchar(100) NOT NULL DEFAULT 'Shree Shyam Team', `read_time` varchar(50) NOT NULL DEFAULT '5 min read', `image` varchar(255) DEFAULT NULL, `excerpt` text DEFAULT NULL, `content` longtext NOT NULL, `meta_title` varchar(255) DEFAULT NULL, `meta_description` text DEFAULT NULL, `meta_keywords` text DEFAULT NULL, `status` enum('published','draft') NOT NULL DEFAULT 'published', `views` int(11) NOT NULL DEFAULT 0, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `idx_slug` (`slug`), KEY `idx_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;