im creating an program, which allows the user to search for movies. The Movies are stored in a database, while the actors are stored in another database.
Each Movie has a unique id and a 1 to n relationship with actors. The Database movie looks like this:
| movieid | Moviename | Kategory | year | movieid |
|---|---|---|---|---|
| x | test | action | 2023 | 69 |
| y | random | thriller | 1995 | 420 |
The actor database looks like this:
| actorid | name |
|---|---|
| 1 | Person1 |
| 2 | Person2 |
| 3 | Person3 |
and the relationship Database looks like this:
| movieid | actor id |
|---|---|
| x | 1 |
| x | 2 |
| y | 3 |
I I want to create a open search function which allows the user to search for the criteria: movieid, moviename, kategory and Actors.
The field can be empty or have value and u should be able to search for any combination.
Does anybody have an Idea?