Lesson 1
Data Access using Web Programming
There is more than one way to display data in a Web page. This is especially true when using PHP.
With very little effort, you can use a combination of Design Time Controls to retrieve and display data.
You can also use DTCs to retrieve the data, and then use script to bind the data to standard HTML controls, such as text boxes and tables.
For control authors, the .NET Framework provides a wealth of control authoring technology.
Authors are no longer limited to designing composite controls that act as a collection of preexisting controls.
Through inheritance, you can create your own controls from preexisting composite controls or preexisting Windows Forms controls. You can also design your own controls that implement custom painting. These options enable a great deal of flexibility to the design and functionality of the visual interface. To take advantage of these features, you should be familiar with object-based programming concepts.
Module Objectives
This module discusses how to use some of PHP's features to retrieve, display, and manage data on the Web, including how to:
- Bind the recordset object to controls to display data
- Use the command object to retrieve data
- Use the command object to add data-bound controls to a page
- Bind navigation and data-bound controls to navigate in the data
- Use parameterized queries to select data meeting specified criteria
- Handle errors to make the application stable
- Use script with the recordset object to access data
In the next lesson, you will use data-bound Design Time controls to access and display data.