• Is called from an HTML page.
• Creates an HTML form which the customer can use to order a book.
• Creates an array and a hash to define a set of books that can be ordered.
• This list is completely arbitrary and does not use the real title table at all.

Tasks to Do for this Lab

• connects to the Nile database
• reads all the rows from the title table
• uses the ->fetchrow_array method

Solution

• Source code
  
• Run it (from a form)

Extra for Experts #1

Extra for Experts #2

• Inserting a call to bind_columns between the calls to prepare and execute, passing undef as the first argument and references to the variables which will hold the returned column data.
• Changing the call from fetchrow_array to fetch, and not using the return value from fetch.

Thus, the calling sequence looks like this:

prepare( <SQL statement> );
bind_columns( undef, (\$col1, \$col2, \$col3) );
execute( );
while ( ->fetch() ) {
   do something with $col1, $col2, $col3;
}

• Source code
• Call it from a form