success error

Form Is Invalid!

Buy Best MIS582 Lab 7-New(4th Lab)

Buy Best MIS582 Lab 7-New 4th Lab


Name your MySQL database Lab4_xxxx where XXXX is your user. Create and save your MySQL database file. You will be required to submit a web link to your index.php file, along with 6 PHP script files and a SQL file that will be executed from the Omnymbus public Web page from your Omnymbus account. Please note that your PHP and SQL files will be based upon the templates provided in the zip file titled located in the folder titled iLab Documents in Doc Sharing.
You will need to modify the following PHP scripts and SQL file from the file.
• index.php
• insert.php
• insert_data.php
• update.php
• update_data.php
• delete.php
• MyAddressBook_CreateTable.sql
When you are done, submit your index.php link and zip file to the Week 7 Course Dropbox.
Required Software
Omnymbus – MySQL
Access the software at
Steps 1-7
Lab Steps
STEP 1: Review the Data Dictionary
Review the provided data dictionary below to understand the entity, attributes, and primary key that you will create in your MySQL database.
Addressbook id Contact ID Number Auto-Increment
Int(3) 999 000-999 Y PK
f_name Contact First Name VCHAR(25) Xxxxxx Y
L_name Contact Last Name VCHAR(25) Xxxxxx Y
ADDRESS Contact Address VCHAR(25) Xxxxxx Y
City Contact City VCHAR(25) Xxxxxx 0-9 Y
State Contact State CHAR(2) Xxxxxx Y
zip Contact Zip Code NUMBER(5) 99999 Y
phone Contact Phone NUMBER(10) 9999999999 Y

STEP 2: Create Table, Insert Statement
• Run MySQL via Omnymbus.
• Modify the table creation script that will be used to create the database with the outlined attributes from the Data Dictionary.
• Provide one Insert Statement that will add your contact information to the newly created table.
• Save the file with a name containing Lab7_, your first initial, and your last name (e.g.,Lab7_JSmith.sql).
• Execute your script and ensure that the database is created.
STEP 3: Build Index PHP Page
Building Your index.php Web Page
In this step, you will complete your PHP script page to connect to the Lab7 database and display the MyAddressbook table on the Web page.
• Complete the MySQL connection for the index.php page. Be sure to fill in the appropriate host (, username, password, and database information in the MySQL field.
• Modify the provided PHP code to display each attribute of your MyAddressbook table. Note that initially, only 1 entry should be present in your table.
• Save your index.php file in your public_html folder in Omnymbus file manager.
• Please note that you will find your public_html folder down the path disk/USERID/public HTML
• Direct your Web browser to your site URL (ex.
• Note that you’ll replace XXXX with your Omnymbus login ID.
• Ensure that your file executes and the database table displays on the screen.
• If you have a correct connect command but you get the error message “MySQL ERROR 1045 (28000): Access denied for user” you will have to create a new password with the box “Change password in other modules?” checked.
• The following image provides an example of how your index.php page should look with no entries provided in the database. Note: Feel free to add any additional formatting or images to your index.php page.

STEP 5: Build Update PHP Pages
Building Your update.php and update_data.php Pages
In this step, you will complete two PHP HTML pages. Your update.php page will provide a form for users to submit data to the database that will be updated. The update_data.php page will provide the actual queries in PHP to update the data in your database. When this process is complete, your page will redirect the user back to the index.php page.
• Review the update_data.php page template.
• You will need to modify the PHP code to add additional input forms for the user to enter all appropriate attributes that will need to be updated.
• In the update_data.php file, ensure that your

tag is set equal to update.php
• Character data should have a character data type.
• When the action is complete, your page should redirect back to index.php.
STEP 6: Build Delete PHP Page
Building Your delete.php Page
In this step, you will complete the delete.php page. Your delete.php page will process the query that will remove the necessary data for the database. When this process is complete, your page will redirect the user back to the index.php page.
• Review the delete.php page template.
• You will need to modify the PHP code to delete the provided entry based on the address id.
• When the action is complete, your page should redirect back to index.php.
STEP 7: Test Links to Update, Delete, and Insert Pages. Submit Deliverables.
Finishing Your Web-Enabled Database
Before submitting, ensure that you have added at least 5 entries to your Addressbook database.
Ensure that all links for the update, delete, and insert work properly.
When you are done, submit your web link to your index.php (e.g., along with the zip file titled which should contain your six PHP code pages and your database script.
Points will be awarded according to the following rubrics.
• 10 points: Script and Table created for the MyAddressbook entity as described in the Data Dictionary.
• 10 points: index.php created that correctly displays the contents of the database.
• 10 points: insert.php and insert_data.php pages created that correctly add data to the database.
• 10 points: update.php and update_data.php pages created that correctly update the data in the database.
• 10 Points: delete.php page created that correctly removes an entry from the database.
For a more advanced optional lab experience you can add error checking and comments and a better appearance to the code. Use Chapter 11 as a guide.

Please follow the instructions below or we may charge you an ADDITIONAL 10$ for configuration and running on your side:

1- Update file Lab7_FirstInitialLastName.sql
a- rename the file and include your name
b- update variable “Lab7_xxxx” and include your user id. It appears at 3 places in the same file

2- I have centralized the following variables and you need to change them only ONE TIME at the beginning of the following files: index.php, update.php, Delete.php, insert.php. PLEASE NOTE THAT NO FURTHER CHANGES ARE REQUIRED TO BE MADE IN THE FILES:

$servername = “”;
$username = “[your username]”;
$password = “[your password]”;
$dbname = “Lab7_xxxx”; //replace XXXX with your your user id
$url = “”; replace XXXX with with your userid

Place all the files within the downloaded folder on this path: disk/USERID/public HTML (RELACE USERID with your user id) and make sure the following link works:

Need Assistance with the Labs?

Our online test-taking assistants are professionals who are graduates of top universities with effective subjective knowledge. Our specialists can contend with the problems you are coping with about taking my exam for me queries. Everything ranges from smooth subjects to complicated ones, we cover all of them underneath a single platform. In case you have enrolled for more than one issue together along with your online universities assessments and you do now no longer have the time to awareness of every one of them simultaneously then, you can join up for our effective high-quality services, and then genuinely you can get desired help withinside the form of hiring for our specialists for doing my exam online for me at no hesitation. For custom, help email us at [email protected] or WhatsApp us at +1(657)366-7486

Placeholder $3.99
Buy Best MIS582 Lab 7-New(4th Lab)
  • 200+ Downloads