🚀 PHP + Supabase Project

A simple and lightweight PHP-based web application integrated with Supabase (PostgreSQL) for database management.
This project demonstrates how to connect a PHP backend with Supabase using environment-based configuration.

---

📖 Table of Contents

• 📸 UI Preview
• ✨ Features
• 🛠 Tech Stack
• ⚙️ Prerequisites
• 🚀 Getting Started
• 📡 API Endpoints
• 🗄️ Database Structure
• 📄 License

---

📸 UI Preview

---

✨ Features

• PHP backend with Supabase PostgreSQL
• Environment variable–based configuration
• Simple frontend using HTML, CSS, and JavaScript
• Easy local development setup
• Clean project separation (client & server)

---

🛠 Tech Stack

• Frontend: HTML, CSS, JavaScript
• Backend: PHP
• Database: Supabase (PostgreSQL)
• Server: PHP Built-in Development Server

---

Follow the steps below to run the project locally.

📁 Project Structure

• project_folder/
  • GlobeReport-client/
  • GlobeReport-server/

🚀 Getting Started

1️⃣ Clone the Repositories

1️⃣ Clone the Repositories

➜ Clone the client repository: git clone https://github.com/MehadiWirtesCode/GlobeReport-client.git
➜ Clone the server repository: git clone https://github.com/MehadiWirtesCode/GlobeReport-server.git

2️⃣ Set Up Supabase

Create an account at https://supabase.com

Create a new project

Create the required database tables as shown below:

Database Tables

3️⃣ Environment Configuration ➜ From your Supabase dashboard, copy the following database credentials: SUPA_HOST= SUPA_PORT= SUPA_DB= SUPA_USER= SUPA_POOL_MODE= SUPA_PASS=

➜ Create a .env file inside the server directory and paste the values: SUPA_HOST=your_host SUPA_PORT=your_port SUPA_DB=your_database SUPA_USER=your_user SUPA_POOL_MODE=transaction SUPA_PASS=your_password

4️⃣ Run the Server ➜ Navigate to the root project folder and run: php -S localhost:8000 -t server server/index.php

✅ Notes Make sure PHP is installed (php -v) Keep Supabase credentials private Use the PHP built-in server for local development only

📡 API Endpoints

Authentication

Method	Endpoint	Description
POST	/api/signup	Register a new user
POST	/api/login	Authenticate an existing user

Posts

Method	Endpoint	Description
GET	/api/getAllPosts	Retrieve all posts (Admin view)
POST	/api/posts	Create a new post (Admin only)
POST	/api/addToWatchLater	Add a post to the "Watch Later" list
POST	/api/deletePost	Delete a post (Admin only)

News

Method	Endpoint	Description
GET	/api/getAllNews	Retrieve all news articles
GET	/api/getBusinessNews	Retrieve business-related news
GET	/api/getNationalNews	Retrieve national news
GET	/api/getInternationalNews	Retrieve international news
GET	/api/getLifestyleNews	Retrieve lifestyle-related news
GET	/api/getSportsNews	Retrieve sports news
GET	/api/getPoliticsNews	Retrieve politics-related news

Users (Admin)

Method	Endpoint	Description
GET	/api/users	Retrieve all registered users (Admin)

👤 Author Mehadi Wirtes Code GitHub: https://github.com/MehadiWirtesCode

📄 License

This project is open-source and available under the MIT License.
See the LICENSE file for details.