filmbibliotek-0.4

Film Library.
Allows Create Update Read Update library films index.

• Each film have Title, Director, Category and Production Year.
• There is a form to save new films in the library.
• Every film can be updated and removed from the database..

Technologies

• Bootstrap 4
• PHP 7
• MySQL 8
• Html
• Css

Database

Database communication would be with prepared statements, for reject SQL injections.

2 Related tables:

• films (id, title, director, cat_id, year)
• categories (cat_id, cat_name)

Prerequisites

Before you begin, ensure you have met the following requirements:

• You have a webserver.
• You have installed Apache and MySQL.

Installing filmbibliotek

To install filmbibliotek, follow these steps:

• Upload files to your htcdocs directory server.
• Inport database located in the SQL folder (erase folder when installation is accomplished).

  Edit config.php with your login server values.
  > define('DB_SERVER', 'your_host');
  > define('DB_USERNAME', 'DB_username');
  > define('DB_PASSWORD', 'DB_password');

Pages

Index.php

Home page.
List of the movies in the library.

skapa.php

Create page.
POST FORM Worm Where you can add new movies to your library.

film.php

Read page.
Where you can view more in detail a selected film from your library.

andra.php

Update page.
POST FORM Where you can update movies from your library.

radera.php

Delete page.
Where you can delete movies from your library.

config.php

Setup connection database.
(server, db_user, db_password, db_name).

fel.php

Error page.
If something goes wrong.

readme.md

Project Documentation.

Images

Folder with images documentation.

SQL/filmbibliotek.sql

Database for instalation. ERASE AFTER INSTALLATION

SQL

Folder with SQL commmands examples. ERASE AFTER INSTALLATION

CSS/style.css

Customs web styles.

---

Tree

filmbibliotek-0.4
├─ Images
│  ├─ andra.gif
│  ├─ film.gif
│  ├─ filmbibliotek.gif
│  ├─ index.gif
│  ├─ radera.gif
│  └─ skapa.gif
├─ LICENSE.md
├─ README.md
├─ SQL
│  ├─ Dumping_data_for_table.sql
│  ├─ Table_structure_for_table.sql
│  └─ films.sql
├─ andra.php
├─ config.php
├─ css
│  └─ style.css
├─ fel.php
├─ film.php
├─ index.php
├─ radera.php
├─ skapa.php
└─ templates
   ├─ footer.php
   ├─ header.php
   └─ menu_draft.php

Contact

If you want to contact me you can reach me at me@xavidiaz.com.

License

This project uses the following license: LICENSE.md.