Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can u write it in Atom text editor so i can understand in wich page i can write the code 1. Create a database using

can u write it in Atom text editor so i can understand in wich page i can write the code
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions