Page 434 - Beginning PHP 5.3

Part III: Using PHP in Practice
First, the member list. Save the following code as view_members.php in your book_club folder:

< ?php

require_once( “common.inc.php” );
require_once( “config.php” );
require_once( “Member.class.php” );

$start = isset( $_GET[“start”] ) ? (int)$_GET[“start”] : 0;
$order = isset( $_GET[“order”] ) ? preg_replace( “/[^a-zA-Z]/”, “”,
$_GET[“order”] ) : “username”;
list( $members, $totalRows ) = Member::getMembers( $start, PAGE_SIZE,
$order );
displayPageHeader( “View book club members” );

? >
< h2 > Displaying members < ?php echo $start + 1 ? > - < ?php echo min( $start +

PAGE_SIZE, $totalRows ) ? > of < ?php echo $totalRows ? > < /h2 >

< table cellspacing=”0” style=”width: 30em; border: 1px solid #666;” >
< tr >

< th > < ?php if ( $order != “username” ) { ? > < a href=”view_members.php?
order=username” > < ?php } ? > Username < ?php if ( $order != “username” )

{ ? > < /a > < ?php } ? > < /th >
< th > < ?php if ( $order != “firstName” ) { ? > < a href=”view_members.php?

order=firstName” > < ?php } ? > First name < ?php if ( $order != “firstName” )

{ ? > < /a > < ?php } ? > < /th >

< th > < ?php if ( $order != “lastName” ) { ? > < a href=”view_members.php?

order=lastName” > < ?php } ? > Last name < ?php if ( $order != “lastName” )

{ ? > < /a > < ?php } ? > < /th >
< /tr >
< ?php
$rowCount = 0;

foreach ( $members as $member ) {
$rowCount++;
? >

< tr < ?php if ( $rowCount % 2 == 0 ) echo ‘ class=”alt”’ ? > >

< td > < a href=”view_member.php?memberId= < ?php echo $member- >
getValueEncoded( “id” ) ? > ” > < ?php echo $member- > getValueEncoded( “username” )

? > < /a > < /td >

< td > < ?php echo $member- > getValueEncoded( “firstName” ) ? > < /td >

< td > < ?php echo $member- > getValueEncoded( “lastName” ) ? > < /td >
< /tr >
< ?php
}
? >
< /table >

< div style=”width: 30em; margin-top: 20px; text-align: center;” >
< ?php if ( $start > 0 ) { ? >
< a href=”view_members.php?start= < ?php echo max( $start - PAGE_SIZE, 0 )

? > & amp;order= < ?php echo $order ? > ” > Previous page < /a >
< ?php } ? >
396
9/21/09 9:12:05 AM
c13.indd 396 9/21/09 9:12:05 AM
c13.indd 396