Question: Create a database named cis224_midterm with an addresses table with the following: AddressNo (auto-increment, primary key) First (25 characters, not null) Last (30 characters,

Create a database named cis224_midterm with an addresses table with the following:  AddressNo 

Create a database named cis224_midterm with an addresses table with the following: AddressNo (auto-increment, primary key) First (25 characters, not null) Last (30 characters, not null) Street (100 characters, not null) . City (25 characters, not null) State (2 characters, not null) Zip (10 characters, not null) The ecpi_user should have access to the database. Add at least 2 records to the database, one including your name. Create a PHP web application that does the following: Displays a table with all fields in the database Provides the ability to Add new addresses Provides the ability to Update existing addresses Provides the ability to Delete existing addresses For your submission, take screen captures of the following and place them in a Word document: .phpMyAdmin showing the updated database table and columns Demonstration of the application running, including: Successful addition of a record Successful update of a record Successful deletion of a record

Step by Step Solution

3.33 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Database Queries Database input your database name Table structure for table addresses CREATE TABLE ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!