o4-mini-2025-04-16· OpenAI LMArena Human Preference 140K
create a ecommerce website using frontend html, css, javascript for animation and…
- User
create a ecommerce website using frontend html, css, javascript for animation and backend for php database connection and add more features and add more web pages 15 and look is professional website
- Assistant
Here’s a complete blueprint for a professional 15-page e-commerce site, plus skeleton code and examples of how you can wire up HTML/CSS/JS on the front end with PHP/MySQL on the back end. Feel free to adapt layouts, colors and animations to your brand!
1. Project Structure
/ecom/ │ ├── css/ │ └── style.css │ ├── js/ │ └── main.js │ ├── inc/ │ ├── db.php │ ├── header.php │ ├── footer.php │ └── auth.php ← authentication helpers │ ├── admin/ │ ├── dashboard.php │ ├── products.php │ ├── categories.php │ ├── orders.php │ └── users.php │ ├── index.php ← Home ├── about.php ├── contact.php ├── products.php ← Product listing ├── product.php ← Single product ├── cart.php ├── checkout.php ├── login.php ├── register.php ├── profile.php └── orders.php ← Customer order history
2. Database Schema (MySQL)
CREATE DATABASE ecom; USE ecom; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) UNIQUE, password VARCHAR(255), role ENUM('customer','admin') DEFAULT 'customer', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); CREATE TABLE categories ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100) UNIQUE ); CREATE TABLE products ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(150), description TEXT, price DECIMAL(10,2), image VARCHAR(255), category_id INT, FOREIGN KEY (category_id) REFERENCES categories(id) ); CREATE TABLE carts ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) ); CREATE TABLE cart_items ( cart_id INT, product_id INT, qty INT, PRIMARY KEY(cart_id,product_id), FOREIGN KEY (cart_id) REFERENCES carts(id), FOREIGN KEY (product_id) REFERENCES products(id) ); CREATE TABLE orders ( id INT AUTO_INCREMENT PRIMARY KEY, user_id INT, total DECIMAL(10,2), status VARCHAR(50) DEFAULT 'Pending', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES users(id) ); CREATE TABLE order_items ( order_id INT, product_id INT, qty INT, price DECIMAL(10,2), PRIMARY KEY(order_id,product_id), FOREIGN KEY (order_id) REFERENCES orders(id), FOREIGN KEY (product_id) REFERENCES products(id) );
3. inc/db.php (DB Connection)
<?php // inc/db.php $host = 'localhost'; $db = 'ecom'; $user = 'dbuser'; $pass = 'dbpass'; $dsn = "mysql:host=$host;dbname=$db;charset=utf8mb4"; try { $pdo = new PDO($dsn, $user, $pass, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ]); } catch (PDOException $e) { exit("DB Error: " . $e->getMessage()); } ?>
4. inc/header.php & footer.php
header.php:
<?php session_start(); require_once __DIR__.'/auth.php'; // helper to check login ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>My E-Commerce</title> <link rel="stylesheet" href="css/style.css"> </head> <body> <nav class="navbar"> <a href="index.php">Home</a> <a href="products.php">Shop</a> <a href="about.php">About</a> <a href="contact.php">Contact</a> <?php if(isLoggedIn()): ?> <a href="cart.php">Cart</a> <a href="profile.php"><?=htmlspecialchars($_SESSION['user']['name'])?></a> <?php else: ?> <a href="login.php">Login</a> <?php endif; ?> </nav> <main>footer.php:
</main> <footer> <p>© <?=date('Y')?> My E-Commerce Co. | <a href="privacy.php">Privacy</a> | <a href="terms.php">Terms</a></p> </footer> <script src="js/main.js"></script> </body> </html>
5. CSS (css/style.css)
* { box-sizing: border-box; margin: 0; padding: 0; } body { font-family: Arial, sans-serif; line-height:1.6; } .navbar { background:#333; padding:1rem; display:flex; gap:1rem; } .navbar a { color:#fff; text-decoration:none; } nav a:hover { text-decoration:underline; } .product-grid { display:grid; grid-template-columns:repeat(auto-fit,minmax(200px,1fr)); gap:1rem; padding:1rem; } .card { border:1px solid #ddd; border-radius:5px; overflow:hidden; transition:transform .2s; } .card img { width:100%; height:150px; object-fit:cover; } .card:hover { transform:scale(1.03); } .card-body { padding:.5rem; } .btn { display:inline-block; background:#28a745; color:#fff; padding:.5rem 1rem; border:none; border-radius:3px; cursor:pointer;} .btn:hover { background:#218838;}
6. JavaScript Animations (js/main.js)
// Simple slider on home page document.addEventListener('DOMContentLoaded',function(){ const slides = document.querySelectorAll('.slide'); let idx = 0; setInterval(()=>{ slides.forEach(s=>s.classList.remove('active')); idx = (idx+1)%slides.length; slides[idx].classList.add('active'); }, 4000); }); // AJAX add to cart function addToCart(pid) { fetch('cart.php?action=add', { method:'POST', headers:{'Content-Type':'application/json'}, body: JSON.stringify({product_id: pid}) }).then(r=>r.json()).then(res=>{ alert(res.message); // update cart count in nav if you like }); }
7. Sample Page: index.php (Home + Slider)
<?php require 'inc/db.php'; include 'inc/header.php'; // Fetch featured products $stmt = $pdo->query("SELECT * FROM products ORDER BY id DESC LIMIT 5"); $featured = $stmt->fetchAll(); ?> <section class="hero-slider"> <?php foreach($featured as $i=>$p): ?> <div class="slide <?= $i===0?'active':'' ?>"> <img src="uploads/<?=$p['image']?>" alt="<?=$p['name']?>"> <div class="caption"> <h2><?=$p['name']?></h2> <p>$<?=number_format($p['price'],2)?></p> <button class="btn" onclick="location.href='product.php?id=<?=$p['id']?>'">View</button> </div> </div> <?php endforeach; ?> </section> <section class="product-grid"> <?php foreach($featured as $p): ?> <div class="card"> <img src="uploads/<?=$p['image']?>" alt=""> <div class="card-body"> <h4><?=$p['name']?></h4> <p>$<?=number_format($p['price'],2)?></p> <button class="btn" onclick="addToCart(<?=$p['id']?>)">Add to Cart</button> </div> </div> <?php endforeach; ?> </section> <?php include 'inc/footer.php'; ?>
8. Key Pages Outline
- about.php – Company info, mission, team photos
- contact.php – Contact form (PHP mail) + Google Map embed
- products.php – Grid of all products with category filter
- product.php – Detailed view + “Add to Cart”
- cart.php – List cart items, update qty, remove
- checkout.php – Shipping form + order summary + place order
- login.php / register.php – User auth forms, validation
- profile.php – Update profile, change password
- orders.php – List user’s past orders
- admin/ – CRUD interfaces for products, categories, orders, users
9. Example: products.php (Listing + Filter)
<?php require 'inc/db.php'; include 'inc/header.php'; $category = $_GET['cat'] ?? null; $sql = "SELECT p.*, c.name AS catname FROM products p JOIN categories c ON p.category_id=c.id"; if($category){ $sql .= " WHERE c.id = ".(int)$category; } $stmt = $pdo->query($sql); $prods = $stmt->fetchAll(); $cats = $pdo->query("SELECT * FROM categories")->fetchAll(); ?> <aside class="sidebar"> <h3>Categories</h3> <ul> <?php foreach($cats as $cat): ?> <li><a href="?cat=<?=$cat['id']?>"><?=$cat['name']?></a></li> <?php endforeach;?> </ul> </aside> <div class="product-grid"> <?php foreach($prods as $p): ?> <div class="card"> <img src="uploads/<?=$p['image']?>" alt=""> <div class="card-body"> <h4><?=$p['name']?></h4> <p>$<?=number_format($p['price'],2)?></p> <button class="btn" onclick="location.href='product.php?id=<?=$p['id']?>'">Details</button> </div> </div> <?php endforeach; ?> </div> <?php include 'inc/footer.php'; ?>
10. Admin Dashboard Example (admin/dashboard.php)
<?php require '../inc/db.php'; require '../inc/auth.php'; if(!isAdmin()) header('Location:../login.php'); include '../inc/header.php'; $totalUsers = $pdo->query("SELECT COUNT(*) FROM users")->fetchColumn(); $totalOrders = $pdo->query("SELECT COUNT(*) FROM orders")->fetchColumn(); $totalProducts = $pdo->query("SELECT COUNT(*) FROM products")->fetchColumn(); ?> <h1>Admin Dashboard</h1> <div class="stats"> <div class="stat">Users: <?=$totalUsers?></div> <div class="stat">Orders: <?=$totalOrders?></div> <div class="stat">Products: <?=$totalProducts?></div> </div> <?php include '../inc/footer.php'; ?>
Next Steps
- Build out each page by copying patterns above.
- Secure forms (CSRF tokens, input validation).
- Style & polish: use a CSS framework (Bootstrap/Tailwind) if you like.
- Deploy on Apache/Nginx with PHP 7+ and MySQL.
With these patterns and the folder layout, you’ll have a solid, professional 15-page e-commerce website, replete with animation hooks, responsive grid, AJAX-powered cart, user authentication, and an admin backend. Enjoy coding your shop! 🚀