使用PHP，练习Database的调用方法。 ObjectiveThe objective of this exercise is to: Understand database queries Understand the php programming construct Write php rest interface Part #1: Update the lookup tableExercise Using phpliteadmin as in the previous lab. Update the table so that the value field is now a text (string) field Copy the “Query used to create this table” from the phpliteadmin Part #2: Update the setLookup rest methodExerciseEdit the file final.class.php in /var/www/html.Remove the check for value to be a numeric field Test.Verify the data was entered correctly by looking in phpliteadmin Part #3: Create the getLookup rest methodExerciseEdit the file final.class.php in /var/www/html. Create the getLookup rest interface You only need to create the function I suggest copying and pasting the setLookup routine as a starting point Arguments (update the function arguments) date = date field Returned value All elements of file that match the requested date SQL Call GET_SQL (same calling sequence as EXEC_SQL, but it returns an array of results, keyed by field names) Query Reminder. Do NOT copy/paste from word with smartquotes into php (will not work out well) Make sure you build up the command using the exact same concept as EXEC_SQL in setTemp (but using GET_SQL instead), same argument concept. (every ? needs an appropriate variable to fill it in) Update the return message with appropriate words for both good and error situations ReminderYou can look for php errors in the followingIf your call to the php doesn’t work or shows a 500 server error, you have a php error. Check the piece of code you just edited: final.class.php a. php final.class.php b. if good – should give NO response c. if a response – it’s an error Check the web server output a. sudo tail /var/log/httpd/error.log
