Interior-Design-Blog-website

A PHP-based social networking website for interior designers and architects, built with XAMPP and phpMyAdmin. The platform allows users to register, upload designs, like, comment, and share posts. The project focuses on database engineering, ensuring secure authentication and scalable data storage for user interactions.

---

Key Features

• User Authentication: Secure registration and login system.

• Post Uploading: Users can upload design images and descriptions.

• Likes & Comments: Users can interact with posts via likes and comments.

• Post Sharing: Users can share interesting designs with their network.

• Database-Driven Content: All user interactions are stored in a MySQL database for persistent storage.

---

Installation and Setup

1. Install XAMPP

Download and install XAMPP to run the local server.

2. Clone the Repository

git clone https://github.com/yourusername/Interior-Design-Network.git
cd Interior-Design-Network

3. Start Apache & MySQL

Run XAMPP and start the Apache and MySQL services.

4. Import the Database

• Open phpMyAdmin (http://localhost/phpmyadmin/).
• Create a new database called DBPROJECT.
• Import the SQL Scripts.txt file.

5. Configure PHP Files

Ensure the database connection is properly set up in your PHP files:

$servername = "localhost";
$username = "root";
$password = "";
$database = "DBPROJECT";
$conn = new mysqli($servername, $username, $password, $database);

6. Run the Website

• Place the project files in htdocs inside the XAMPP installation directory.
• Open your browser and go to:

  http://localhost/Interior-Design-Network/
  

---

Database Schema

Users Table (Authentication System)

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL UNIQUE,
    role VARCHAR(50) NOT NULL,
    gender VARCHAR(10) NOT NULL,
    age INT NOT NULL,
    qualification VARCHAR(255),
    password VARCHAR(255) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Blogs Table (Post Management)

CREATE TABLE BLOGS (
    blog_id INT AUTO_INCREMENT PRIMARY KEY,
    date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    user_id INT,
    images JSON,
    upvotes INT DEFAULT 0,
    downvotes INT DEFAULT 0,
    comments TEXT, 
    FOREIGN KEY (user_id) REFERENCES USERS(id)
);

User Votes Table (Likes System)

CREATE TABLE USER_VOTES (
    id INT AUTO_INCREMENT PRIMARY KEY,
    blog_id INT,
    user_id INT,
    vote_type ENUM('upvote', 'downvote'),
    FOREIGN KEY (blog_id) REFERENCES BLOGS(blog_id),
    FOREIGN KEY (user_id) REFERENCES USERS(id)
);

User Comments Table (Comment System)

CREATE TABLE USER_COMMENTS (
    id INT AUTO_INCREMENT PRIMARY KEY,
    blog_id INT,
    user_id INT,
    comment TEXT,
    date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (blog_id) REFERENCES BLOGS(blog_id),
    FOREIGN KEY (user_id) REFERENCES USERS(id)
);

Favorites Table (Saved Posts)

CREATE TABLE favourites (
    favourite_id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    blog_id INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id),
    FOREIGN KEY (blog_id) REFERENCES blogs(blog_id)
);

---

Project Motivation

This project was developed as a Database Engineering semester project with a focus on integrating a scalable and structured MySQL database into a social networking platform. The future goal of this project is to create a competitive space where designers can participate in contests and showcase the best interior designs for public view.

---