INSTRUCTOR’S MANUAL
TO ACCOMPANY
40th Anniversary Edition
DATABASE PROCESSING
Fundamentals, Design, and Implementation
15th Edition
Appendix H
Getting Started with Web Servers, PHP, and the NetBeans IDE
David M. Kroenke | David J. Auer | Scott L. Vandenberg | Robert C. Yoder
Appendix H – Getting Started with Web Servers, PHP, and the NetBeans IDE
Page H-2
❖ CHAPTER OBJECTIVES
• Know how to install and manage the Microsoft IIS Web server
• Understand the file system structure used by IIS
• Know how to use the Microsoft Edge Web browser
❖ ERRATA
There are no known errors at this time. Any errors that are discovered in the future will
❖ TEACHING SUGGESTIONS
• This material is extremely important—it shows in a step by step process exactly how
to set up and test all the software tools that are needed to build and use the Web
database application Web pages in Chapter 11. This appendix should be covered
before discussing the Web database application Web pages in Chapter 11.
Appendix H – Getting Started with Web Servers, PHP, and the NetBeans IDE
Page H-3
❖ ANSWERS TO REVIEW QUESTIONS
H.1 Why is the material in this appendix important?
In order to complete the work in Chapter 11—The Web Server Environment, we must have:
• The Microsoft Internet Information Service (IIS) Web Server installed.
• File system permissions correctly set in the \inetpub\wwwroot folder.
This appendix covers the needed installation, configuration and operation steps to make sure all
the needed components are working correctly for use in Chapter 11.
H.2 What Web server is typically used with the Windows operating systems? What Web
server is typically used with the Linux operating system?
The Microsoft Internet Information Service (IIS) Web server is typically used with the Windows
H.3 Briefly describe how to install IIS on the Windows 10 operating system.
The Microsoft Internet Information Service (IIS) Web server is already installed on the Windows 10
operating system—we simply enable the Web server functionality by doing the following:
1. On the Windows Desktop, type the words control panel into the search text box
H.4 What utility is used to manage IIS?
After IIS is installed, it is managed using the Internet Information Service (IIS) Manager.
H.5 What utility is used to manage ODBC?
The ODBC Data Source Administrator is used to manage ODBC.
It is important to note that, as discussed in the 32-Bit Versus 64-Bit Programs box on page H-9
Appendix H – Getting Started with Web Servers, PHP, and the NetBeans IDE
Page H-4
H.6 How do you add a program icon to the Windows 10 Taskbar?
H.7 How is the file system that supports IIS structured?
H.8 Briefly describe how to view a Web page that has been created in the IIS Web server.
Type the URL for the Web page into a Web browser and press the Enter key. To display the
H.9 What are Windows security permissions?
H.10 Briefly describe how to manage Windows security permissions.
To manage Windows security permission for a specific folder in the Windows file system, right-
H.11 What is an IDE?
An IDE is an Integrated Development Environment (IDE). An IDE gives you the most robust
H.12 What is the NetBeans IDE?
NetBeans allows software developers to create applications in Java, PHP, and other languages. It
H.13 What is the Java Software Development Kit (JDK)? Why is it needed for the NetBeans
IDE?
The JDK is a collection of programs that includes the Java Runtime Environment (JRE) needed to
H.14 Briefly describe how to install the JDK.
Appendix H – Getting Started with Web Servers, PHP, and the NetBeans IDE
Page H-5
H.15 Briefly describe how to install the NetBeans IDE.
To install the NetBeans IDE:
• Download then run the program, allow it to make changes to your computer.
• Accept the Junit license agreement, then accept or change the folder where the JDK is
installed. The defaults work fine for most situations.
• The NetBeans icon will appear on the Taskbar.
H.16 What is PHP? Is PHP a popular Web site development language?
PHP, which is an abbreviation for PHP: Hypertext Processor (and which was previously known
as the Personal Hypertext Processor), is a scripting language that can be embedded in Web
H.17 What are the three options for installing PHP described in this appendix? Which option
do the authors recommend using? The three options for installing PHP include:
• Download and install PHP manually
Appendix H – Getting Started with Web Servers, PHP, and the NetBeans IDE
Page H-6
H.18 Briefly describe how to install PHP.
To install PHP using WebPI:
• Open the Edge web browser and go to:
H.19 Briefly describe how to create a PHP Web page using the NetBeans.
To create a PHP Web page using NetBeans:
• Launch NetBeans from the Taskbar, then close the Start Page using the Start Page X tab.
H.20 What is the purpose of the phptest.php Web page created in this chapter?
The purpose of the phptest.php Web page is to make sure that PHP is correctly installed. It also
H.21 What is the purpose of PHP dynamic extension *.dll files?
PHP uses PHP dynamic extension *.dll files to extend PHP functionality to various DBMS
Appendix H – Getting Started with Web Servers, PHP, and the NetBeans IDE
Page H-7
H.22 What are the Microsoft Drivers 4.0 for PHP for SQL Server?
The Microsoft SQL Drivers 4.0 for PHP for SQL Server are the updated set of PHP dynamic
H.23 Using the Microsoft Drivers 4.0 for PHP for SQL Server as an example, briefly describe
how to install and enable additional PHP dynamic extension *.dll files to an existing PHP
installation.
To install the WebPI:
H.24 Why must the php_pdo_odbc.dll and php_pdo_odbc.dll extensions be activated in the
PHP installation?
The PDO extensions allow PHP to have an object-oriented interface to database
❖ ANSWERS TO EXERCISES
There are no separate exercises for this appendix—just work completely through the appendix
and make sure everything is setup correctly and ready for use for Chapter 11.