Web Data Management Chapters 4-6

To execute a SELECT statement, you use the _____________________ method of the PDO object that connects to the database.

To make a variable that’s declared outside a function available to the function, you must code the _________________________ keyword.

As you ____________________ an application, you try to make it fail.

When you’re using NetBeans, you can step through the execution of an application one statement at a time by clicking on the Step __________________ button.

When you code a function in pHP, you start with the keyword __________________.  

To pass data back to the statement that calls a function, the function can use the _________________________ statement.  

When you use the MVC pattern, the ___________________ consists of the pHP files that make up the user interface of the application.

To call a function in pHP, you code the function name followed by a list of any _________________________ that are required.

When you test an application, you start by using ____________________ data.

A __________________ error violates the rules for how pHP statements must be written.

To access one of the elements in an array, you code the array name and a set of brackets that contains the _______________________ of the element you want to access.

A simple way to trace the execution of an application is to insert __________________ statements at appropriate points within the code.

When a breakpoint is reached while you’re testing an application with NetBeans, you can view the values of the available __________________.

When you use the MVC pattern, the model consists of the pHP files that work with and represent the _________________________ of the application.  

When you code a function in pHP, you can list one or more ____________________ that must be passed to the function.

When you _______________________ an HTTP request, all processing takes place on the server before the response is returned to the browser.

To execute an INSERT statement, you use the _____________________ method of the PDO object that connects to the database.

To handle the PDO exceptions that can occur when database methods are executed, you use a _____________________ statement.

To access the data for all of the rows in a result set that’s returned by a SELECT statement, you can use a _____________________________ loop.

Code example 5-1   function get_product($product_id) {     global $db;     $query = "SELECT * FROM products               WHERE productID = '$product_id'";     $product = $db->query($query);     $product = $product->fetch();     return $product; } (Refer to code example 5-1) Which of the following is a proper pHP statement for calling the function in this example and storing the returned result in a variable named $product.  

• $product = get_product($product_id);

• $product = get_product(product_id);

• $product = $get_product($product_id);

• $product = $get_product(product_id);

An error that occurs after an application is running is known as a

• Runtime error

• User error

• Logic error

• Syntax error

Which of the following is the correct way to code a pHP statement that returns the result set for a SELECT statement that’s stored in $statement if the PDO object is $db?  

• $results = $db->query($statement);

• $results = $db->exec($statement);

• $results = query->$db($statement);

• $results = exec->$db($statement);

When you create a PDO object, you have to pass all but one of these arguments to it: Which one is it?  

• Data source name

• Server name

• User name

• Password

When you click on the Continue button while you’re debugging with NetBeans, the application

• Runs to the next breakpoint

• Executes the next statement in sequence

• Lets you step through the statements

• Removes the breakpoint

When you use the MVC pattern, you   

• Make each layer as independent as possible

• Perform all data validation on the client

• Use the pattern for every page in the application

• Put all of the PHP code in the controller

An error that lets the application run but produces the wrong results is known as a

• Runtime error

• User error

• Logic error

• Syntax error

One reason for using the header function to redirect a request

• Is that it’s more efficient than forwarding a request

• Is to have a PHP file run itself again

• Is to reduce the number of round trips that are required

• Is to do all processing for the request on the server

The goal of testing is to

• Fix all errors in the application

• Find all errors in the application

• Make sure the application works with valid data

• Make sure the application works with invalid data

In the catch block of a try/catch statement for handling PDO exceptions, you can get a message that describes the exception by using the getMessage method of the 

• PDO object

• PDOStatement object

• PDOException object

• Result set array

  Code example 4-1 The starting code for the index.php file which is the first page of an application (Refer to code example 4-1) What does routine 2 store in the variable named $products?

• A PDOStatement object for all rows in the products table

• A PDOStatement object for the columns in the first row in the products table

• A PDOStatement object for the rows in the products table that have a category ID equal to the value in $category_id

• A PDOStatement object for the rows in the products table that have a category ID equal to 1

When you use the header function to redirect a request,

• A response is sent to the web server so it requests another page

• The web server returns a new page to the browser

• A response is returned to the browser that tells it to request another page

• The web server returns a new page to the controller of the MVC pattern

Code example 4-1 The starting code for the index.php file which is the first page of an application <?php     require 'database.php';     $category_id = $_GET['category_id'];     if (!isset($category_id)) {         $category_id = 1;     }       // Routine 1     $query = "SELECT * FROM categories               WHERE categoryID = $category_id";     $category = $db->query($query);     $category = $category->fetch();     $category_name = $category['categoryName'];       // Routine 2     $query = "SELECT * FROM products               WHERE categoryID = $category_id               ORDER BY productID";     $products = $db->query($query); ?> (Refer to code example 4-1) What does routine 1 store in the variable named $category_name?  

• The category name for the first row in the categories table of the database

• The category name for the row in categories table that corresponds to the value in $category_id

• The category name for the row in categories table that has a category ID of 1

• An array of the category names in the categories table

When you use the MVC pattern, the controller gets the HTTP requests and then directs the use of the files that represent  

• The model, the view, and the database

• The database and the view

• The model, the view, and the user interface

• The model and the view

Code example 4-1 The starting code for the index.php file which is the first page of an application (Refer to code example 4-1) The first statement in this example gets and runs a file named database.php. What must this code do for the rest of the statements in this example to work?

• Create a PDOStatement object named $db that connects to the right database

• Create a PDOStatement object named $db-> that connects to the right database

• Create a PDO object named $db that connects to the right database

• Create a PDO object named $db-> that connects to the right database

Which of the following is the correct way to code a pHP statement that puts the first row of PDOStatement object named $products in an array named $product?  

• $product = $db->query($products);

• $product = $db->fetch($products);

• $product = $products->query();

• $product = $products->fetch();

Which of the following is not a benefit of using the MVC pattern for an application? 

• It’s easier to make changes to the application

• Web designers can work independently on the view

• There’s less repetition of code

• It’s easier to test and debug the application

• The application runs more efficiently

Code example 5-1   function get_product($product_id) {     global $db;     $query = "SELECT * FROM products               WHERE productID = '$product_id'";     $product = $db->query($query);     $product = $product->fetch();     return $product; } (Refer to code example 5-1) What does this function return when it is called?

• An array of all the rows in the products table

• An array of all the rows with the specified category ID

• An array of the columns in the first row of the products table

• An array of the columns in the row with the specified product ID

To return an array for the first row of a result set that’s returned by a SELECT statement, you use the fetch method of the _____________________________ object that represents the result set.

What date did you complete this worksheet _____________________________ .