Skip to content

This Film Wiki project is a web application designed to manage information about movies, actors/actresses, movie directors, roles and film genres.

Notifications You must be signed in to change notification settings

Flibouche/SQL_Cinema

Repository files navigation

SQL_Cinema

This Film Wiki project is a fully responsive web application designed to manage information about movies, actors/actresses, movie directors, roles and film genres.

Project Contents

  • Conceptual Data Model (CDM): Designing the structure of the database by modeling entities such as films, actors/actresses, movie directors, roles and film genres.
  • Mockups: Contains mockups and wireframes created using Figma for the user interface of the application.
  • Database: Setting up a MySQL database using tools like HeidiSQL and PHPMyAdmin to store and manage the project's data.
  • SQL Queries: Includes SQL queries for performing various tasks such as fetching movie details, listing films by duration, counting movies by genre, etc.
  • User Interface (UI): Developing the user interface using HTML, CSS, JavaScript and PHP to enable users to interact with and perform actions like viewing, adding, modifying, and deleting films, actors, directors, and other entities.
  • Docker: Implementing Docker to containerize the MySQL database and development environment, ensuring a portable configuration that can be easily deployed across different systems.

Technologies Used

  • PHP
  • HTML, CSS and JavaScript for the User Interface (UI)
  • MySQL with HeidiSQL for the database
  • Figma for the mockups
  • Looping (Conceptual Data Modeling)
  • Docker

More illustrations

About

This Film Wiki project is a web application designed to manage information about movies, actors/actresses, movie directors, roles and film genres.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published