PRG_BASI_DATI

This repository contains a university project developed for the Database Systems course. It implements a complete web platform based on the assignment provided by the professor, with:

• a PHP backend with multiple API endpoints;
• a static HTML/CSS/JavaScript frontend;
• an SQL script to create and populate the relational database.

Project Overview

The platform is designed to manage projects, user profiles, applications, rewards, comments, financing, and user statistics. It includes features such as:

• user registration and login;
• project creation and search;
• funding and rewards management;
• profile skills and competencies;
• comments and replies;
• rankings and statistics.

Tech Stack

• Backend: PHP
• Frontend: HTML, CSS, JavaScript
• Database: SQL (schema + seed script)

Repository Structure

• backend/ - PHP endpoints for authentication, projects, skills, comments, funding, rankings, and admin operations.
• frontend/ - HTML pages, JavaScript logic, and CSS styles for the user interface.
• img/ - static image assets.
• script_db_progetto_basi.sql - SQL script to create and populate the database.
• composer.json - PHP dependencies and project metadata.

Setup (Local)

1. Clone this repository.
2. Import and execute script_db_progetto_basi.sql in your DBMS.
3. Configure database connection settings in backend/config.php.
4. Serve the project using a local web server (for example Apache + PHP).
5. Open the frontend pages from the frontend/ folder.

Test Credentials Note

For testing, the default password is:

• 11111 for all test accounts.

Notes

• This project was built for academic purposes.
• Endpoint and page names follow the original course assignment structure.