PHP 5/MySQL Programming- P86:computer programming has often been seen as a difficult and arcane skill. Programming languages are difficult and complicated, out of the typical person’s reach. However, the advent of the World Wide Web has changed that to some extent. It’s reasonably easy to build and post a Web page for the entire world to see. The language of the Web is reasonably simple, and numerous applications are available to assist in the preparation of static pages | 403 html head title Update Record title head body h2 Update Record h2 include dbConn connectToSpy fieldNames fieldValues foreach _REQUEST as fieldName value if fieldName tableName theTable value else fields fieldName values value end if end foreach Chapter 12 Building a Three-Tiered Data Application print updateRec theTable fields values print mainButton body html It is more convenient for the updateRec function if the field names and values are sent as arrays. Therefore the PHP code in converts the _REQUEST array to an array of fields and another array of values. These two arrays are passed to the updateRec function which processes them. 404 Viewing the Program PHP 5 MySQL Programming for the Absolute Beginner The program acts in a now-familiar manner. It mainly serves as a wrapper for a function in the spyLib library. In this particular case the program simply sends the name of the current table the name of the key field and the value of the current record s key to the delRec function. That function deletes the record and returns a message regarding the success or failure of the operation. html head title Delete Record title head body h2 Delete Record h2 include dbConn connectToSpy print delRec tableName keyName keyVal print mainButton body html Viewing the Program Adding a record which requires two distinctive steps is actually much like editing a record. The program calls the tToAdd function which builds a form allowing the user to add data to whichever table is currently selected. It isn t necessary to send any information except the name of the table to this function because tToAdd automatically generates the key value. html head title Add a Record title head body h2 Add Record h2 405 include dbConn connectToSpy print tToAdd tableName print mainButton body html Viewing the Program The tToAdd function called by the .
