Page 473 - Beginning PHP 5.3
P. 473

Chapter 14: Manipulating MySQL Data with PHP
                                 $errorMessages[] = ‘ < p class=”error” > A member with that username already
                             exists in the database. Please choose another username. < /p > ’;
                               }

                               if ( $existingMember = Member::getByEmailAddress( $member- > getValue(
                             “emailAddress” ) ) and $existingMember- > getValue( “id” ) !=
                             $member- > getValue( “id” ) ) {
                                 $errorMessages[] = ‘ < p class=”error” > A member with that email address
                             already exists in the database. Please choose another email address. < /p > ’;
                               }

                               if ( $errorMessages ) {
                                 displayForm( $errorMessages, $missingFields, $member );
                               } else {
                                 $member- > update();
                                 displaySuccess();
                               }
                             }

                             function deleteMember() {
                               $member = new Member( array(
                                 “id” = >  isset( $_POST[“memberId”] ) ? (int) $_POST[“memberId”] : “”,
                               ) );
                               LogEntry::deleteAllForMember( $member- > getValue( “id” ) );
                               $member- > delete();
                               displaySuccess();
                             }

                             function displaySuccess() {
                               $start = isset( $_REQUEST[“start”] ) ? (int)$_REQUEST[“start”] : 0;
                               $order = isset( $_REQUEST[“order”] ) ? preg_replace( “/[^ a-zA-Z]/”, “”,
                             $_REQUEST[“order”] ) : “username”;
                               displayPageHeader( “Changes saved” );
                             ? >
                                  < p > Your changes have been saved.  < a href=”view_members.php?start= < ?php

                             echo $start ? > & amp;order= < ?php echo $order ? > ” > Return to member list < /a > < /p >

                               < ?php
                               displayPageFooter();
                             }

                             ? >

                           The script starts off much as before. It retrieves the supplied member ID from either the query string or
                         form post, then looks up the member in the database by calling   Member::getMember() . If the member
                          couldn ’ t be found, an error is displayed and the script exits. Otherwise, the member is stored in
                            $member .











                                                                                                         435





                                                                                                      9/21/09   9:14:15 AM
          c14.indd   435                                                                              9/21/09   9:14:15 AM
          c14.indd   435
   468   469   470   471   472   473   474   475   476   477   478