Use snipping tool to capture

1. Use phpMyAdmin to create two tables for artists.txt and arts.txt. The sample records follow:

"artists.txt": (artistID, artistName)

2 Ames

"arts.txt": (artID, artName, artistID, artValue)

1042 Coffee on the Trail 2 7544

2. Write a PHP program called read.php to read artists.txt and arts.txt file into the corresponding tables.

3. Write two PHP programs to display the contents of the two tables. One is called displayarts.php and the other displayartists.php. Display the contents in an html table with a table header row to indicated the column names. (i.e. artistID, artistName, etc).

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

artists.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