Web Developper

แชร์

this page created for all learner to be success in web developper and Design.

Learn how to create web site in WordPress using many built-in template.I can provide web domain and hosting also learn how to SEO Plugin with your site.Traffic,Monitize.

03/05/2026

មានទទួលបង្កើតវេបសាយនិងប្រព័ន្ធគ្រប់គ្រងសាលារៀន,ហាងកាហ្វេ

07/11/2025

ខាងខ្ញុំមានសេវាបង្កើតWebsite និង ប្រព័ន្ធគ្រប់គ្រងផ្សេងៗសម្រាប់អជីវកម្មលោកអ្នក។បើមានចំណាប់អារម្មណ៏អាចទាក់ទងតាមឆាត,តំលៃសមរម្យ ,ធានាគុណភាព

30/09/2025

បង្កើតE-commerce websiteប្រើPHP & Mysql

Overview and prerequisites

You want something real, not a toy. Let’s build a clean, responsive e‑commerce MVP in PHP and MySQL that you can actually grow: user auth, product catalog, cart, checkout, and an admin back office. We’ll use PDO, sessions, and Bootstrap for responsive UI.

- Stack: PHP 8+, MySQL 5.7/8.0, Composer (optional), Bootstrap 5.
- **Approach:** Simple MVC-ish structure, secure queries, session-based cart, and a clear upgrade path to payments and admin features.
- **Outcome:** A working skeleton you can deploy and extend without fighting a framework.

---
Database schema

Keep it normalized but practical. Start with these tables.

```sql
-- users
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
email VARCHAR(255) NOT NULL UNIQUE,
password_hash VARCHAR(255) NOT NULL,
role ENUM('customer','admin') DEFAULT 'customer',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- categories
CREATE TABLE categories (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100) NOT NULL,
slug VARCHAR(120) NOT NULL UNIQUE
);

-- products
CREATE TABLE products (
id INT AUTO_INCREMENT PRIMARY KEY,
category_id INT,
name VARCHAR(150) NOT NULL,
slug VARCHAR(180) NOT NULL UNIQUE,
description TEXT,
price DECIMAL(10,2) NOT NULL,
stock INT NOT NULL DEFAULT 0,
image_url VARCHAR(255),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (category_id) REFERENCES categories(id)
);

-- orders
CREATE TABLE orders (
id INT AUTO_INCREMENT PRIMARY KEY,
user_id INT NOT NULL,
total DECIMAL(10,2) NOT NULL,
status ENUM('pending','paid','shipped','cancelled') DEFAULT 'pending',
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (user_id) REFERENCES users(id)
);

-- order_items
CREATE TABLE order_items (
id INT AUTO_INCREMENT PRIMARY KEY,
order_id INT NOT NULL,
product_id INT NOT NULL,
quantity INT NOT NULL,
unit_price DECIMAL(10,2) NOT NULL,
FOREIGN KEY (order_id) REFERENCES orders(id),
FOREIGN KEY (product_id) REFERENCES products(id)
);
```

---
Project structure and configuration

Keep files predictable and separated
ecommerce/
├─ public/
│ ├─ index.php
│ ├─ product.php
│ ├─ cart.php
│ ├─ checkout.php
│ ├─ login.php
│ ├─ register.php
│ ├─ logout.php
│ ├─ admin/
│ │ ├─ index.php
│ │ ├─ products.php
│ │ └─ orders.php
│ └─ assets/
│ ├─ css/styles.css
│ └─ img/
├─ src/
│ ├─ config.php
│ ├─ db.php
│ ├─ auth.php
│ ├─ Cart.php
│ ├─ ProductRepository.php
│ ├─ OrderRepository.php
│ └─ helpers.php
└─ vendor/ (optional if using Composer)
`` Configuration and DB connection (PDO)

```php
// src/config.php

```

```php
// public/login.php

```

# # Products list and detail

```php
// src/ProductRepository.php

Store

Latest products