Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 (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
Step: 1
Database Queries Database input your database name Table structure for table addresses CREATE TABLE ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started