write it using pdo class and html

can u write it in the app pls so it's easy to understand in wich page i should write the code

1. Create a database using PHP MyAdmin 2. Write php code to connect to this database, then create the following table using php code Where: - Id is the primary key and should be auto-increment. - Name, Genre, and your opinion should be string and not null - Year of production should be of type year 3. Using php code Enter 3 rows into your table 4. Retrieve all the data you've entered in your table and display it in the browser. Write a PHP code to do the following: 1) A Check your movie page (page1): a user can enter the name of the movie if the movie was found in the database. Then, it will display the movie name its genre and your opinion. 2) If the the movie was not found, then he should add the movie in his database using a form page (page2). 3) On this page (page2), you will have a form. - This form will allow you to ADD a new record to the database. - After you click submit, this page should reload - And you should see all filled fields are displayed 4) Because you are adding records (data) to your database, you should make sure the data is correct! 5) So you MUST use validation - You must use PHP (server-side) validation