Create a database called "gallery" to set up a database user accordingly....

Output Screenshots:

Files that should be created

read.php

search.html

display.php

add.html

add.php

edit.php

delete.php

artists.txt

2 Ames 3 Aserty 4 Baron 7 Blain 8 Blum 9 Budd 12 Chico 14 Cox 16 Curtis 17 Dawson 19 Dill 22 Fratt 23 Garber 24 Garin 25 Giama 28 Guys 29 Hamend 32 Ibe 35 Irvin 38 Kritz 40 Long 43 Lutes 48 Metz 49 Miller 50 Mogan 52 Novarre 54 Ortega 55 Parker 56 Penn 59 Quiroz 60 Rath

arts.txt

1042 Coffee on the Trail 2 7544 1013 Superstitions 3 78000 1021 Bead Wall 3 14000 1034 Beaver Pole Jumble 3 28000 1063 Asleep in the Garden 3 110000 1070 Beginnings 4 27500 1049 Buttercup with Red Lip 7 400 1018 Mountain Scene 8 2500 1055 Starlit Evening 9 9500 1003 Spring Flowers 12 2400 1039 Treachery 14 20000 1102 Crying Hats 14 10000 1052 American Rodeo 16 3500 1059 Dwelling 17 16000 1011 Eve 19 975 1109 Friends 22 16000 1084 Crossing the Platt River 23 2200 1072 Funnel 24 4500 1115 Starry Night 25 8500 1009 Amen 28 3000 1030 Ash Bench 28 13000 1043 Creosote Bushes 28 18000 1078 Chuckwagon 28 32000 1041 Night Version 29 3800 1082 Spring Flowers 29 20000 1006 House Remembered 32 700 1107 Striking It Rich 35 1750 1045 Leaf Patterns 38 2100 1100 Hungry Cowboys 38 750 1106 Horse Corral 40 12500 1044 Mexican Fiesta 43 14000 1024 Spirit and Nature 48 592 1067 Owl in Flight 49 7000 1001 Red Rock Mountain 50 18000 1028 Tired Cowboy 50 4700 1054 Snake Charmer 50 4500 1068 Moonlight 50 9750 1069 Renaissance 50 5500 1113 Shadow House 50 5500 1114 Storytelling at the Campfire 50 18000 1002 Offerings 52 10000 1091 Stone Palette 54 11500 1074 Storm on the Rise 55 8000 1098 Sweet Project 56 592 1080 The Dust Behind 59 18000 1058 The Gathering 60 250

1. Create a database called "gallery" to setup a database user accordingly; Grant all privileges to "dealer" on the "gallery" database. "dealer" must be able to perform operations on the "gallery" database from localhost. USER: dealer, PASSWORD: dealer123 2. Construct two tables: one is called "artists" and the other is called "arts". The names of the fields should be the same as specified above You will choose the appropriate data type for each field iii.artID is the primary key for "arts" table. artistID is the primary key for the "artists" table. Since "arts" table will rely on "artists" table for the artist name, so make sure that to limit deletion of the artist entry only when that particular "artistID" no longer exists in the "arts" table. Based on this, set your foreign key constraint accordingly Do not auto-increment your primary keys. iv. vi. Create the database with all lowercase characters - gallery vii. Create the tables with all lowercase characters - arts& artists vii. Name the columns exactly as described above. This format is called camel case. ix. Create the database user and password with all lower case characters. 3. Write a PHP program called "read.php" to read "artists.txt" and "arts.txt" into the corresponding tables and then design and implement a web page called "search.html" according to the following criteria Create a search input that can independently accept these search criteria artist ID partial artist name complete artist name Display all artist ID and artist name pair Display all art works for a given artist. Display the value of each art work for a given artist. Calculate and updated the total value of all art works for a given artist as necessary 4. Write a PHP program called "display.php" to display the above search results in an html table "display.php" will handle the form processing for "search.html". In the table footer, include both hyperlink back to "search.html" and "add.html". (Search | Add). See Part 7 Add an "Update" column to the end of the html table. This update column must include "Edit" and "Delete" hyperlinks (Edit | Delete) "edit.php" is the URL for the Edit hyperlink. See Part 5 "delete.php" is the URL for Delete hyperlink. See Part 6. These hyperlinks will allow you to edit or delete the respective values in from record displayed. When creating these links, include Artist ID and Art ID as query string variable to the hyperlinks. . . . 1. Create a database called "gallery" to setup a database user accordingly; Grant all privileges to "dealer" on the "gallery" database. "dealer" must be able to perform operations on the "gallery" database from localhost. USER: dealer, PASSWORD: dealer123 2. Construct two tables: one is called "artists" and the other is called "arts". The names of the fields should be the same as specified above You will choose the appropriate data type for each field iii.artID is the primary key for "arts" table. artistID is the primary key for the "artists" table. Since "arts" table will rely on "artists" table for the artist name, so make sure that to limit deletion of the artist entry only when that particular "artistID" no longer exists in the "arts" table. Based on this, set your foreign key constraint accordingly Do not auto-increment your primary keys. iv. vi. Create the database with all lowercase characters - gallery vii. Create the tables with all lowercase characters - arts& artists vii. Name the columns exactly as described above. This format is called camel case. ix. Create the database user and password with all lower case characters. 3. Write a PHP program called "read.php" to read "artists.txt" and "arts.txt" into the corresponding tables and then design and implement a web page called "search.html" according to the following criteria Create a search input that can independently accept these search criteria artist ID partial artist name complete artist name Display all artist ID and artist name pair Display all art works for a given artist. Display the value of each art work for a given artist. Calculate and updated the total value of all art works for a given artist as necessary 4. Write a PHP program called "display.php" to display the above search results in an html table "display.php" will handle the form processing for "search.html". In the table footer, include both hyperlink back to "search.html" and "add.html". (Search | Add). See Part 7 Add an "Update" column to the end of the html table. This update column must include "Edit" and "Delete" hyperlinks (Edit | Delete) "edit.php" is the URL for the Edit hyperlink. See Part 5 "delete.php" is the URL for Delete hyperlink. See Part 6. These hyperlinks will allow you to edit or delete the respective values in from record displayed. When creating these links, include Artist ID and Art ID as query string variable to the hyperlinks