Database Storage & Design Appendix I Database Concepts Edition David Kroenke David Auer Scott Vandenberg Robert Yoder Instructors

Unlock access to all the studying documents.

View Full Document

Database Concepts

8th Edition

David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder

Instructor’s Manual

Prepared by David J. Auer

Appendix I

Getting Started with Web Servers, PHP, and the NetBeans IDE

in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without the prior

written permission of the publisher. Printed in the United States of America.

Instructor’s Manual to accompany:

Database Concepts (8th Edition)

David M. Kroenke • David J. Auer • Scott L. Vandenberg • Robert C. Yoder

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-3

 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 Internet Explorer Web browser

• Know how to download and store files from Web sites

• Know how to download and install the Java Software Development Kit (JDK)

• Know how to download, install, and use the NetBeans IDE

• Know how to download, install, and use PHP

 CHAPTER ERRATA

These are no known errors at this time. Any errors that are discovered in the future will

be reported and corrected in the online DBC e08 Errata document, which will be

available at http://www.pearsonhighered.com/kroenke.

 THE ACCESS WORKBENCH

Solutions to the Access Workbench exercises may be found in Solutions to all Sections:

The Access Workbench, which is a separate document within the Instructor’s Manual.

There is no section of The Access Workbench associated with this appendix.

 NOTES ON MICROSOFT WINDOWS 10

This book uses the Microsoft Windows 10 operating system as the basis for screenshots

and step-by-step instructions. However, with Windows 10, Microsoft has introduced a

continuous update system that has already resulted in some fundamental differences in

how different versions of Windows 10 look and operate.

For example, in the original version of Microsoft Windows 10, clicking the Windows Start

button (or pressing the Windows key on the keyboard) displayed the menu shown in

Figure 1. In this menu, we need to click the All Apps button in order to see the Apps

menu shown in Figure 2.

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-4

Figure 1 – Windows 10 Main Menu

Figure 2 – Windows 10 All Apps Menu

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-5

Figure 3 – Windows 10 Anniversary Update Main Menu with All Apps Included

Microsoft then released the Windows 10 Anniversary Update (Feature update to

Windows 10, version 1607) (see the blog discussion at

https://blogs.windows.com/windowsexperience/2016/08/02/how-to-get-the-windows-10–

anniversary-update/#K1CZuiw4auiuE9A5.97 ). One of the changes introduced in the

Anniversary Update was a major change to the menu system. Now, as shown in

Figure 3, the Apps menu is immediately available when the Start button is used (or when

the keyboard Windows key is pressed).

Therefore, note that the step by step instructions in this book may need to be altered for

your use depending upon which version of Microsoft Windows 10 you or your students

are using!

We recommend that you update Windows 10 to the Windows 10 Anniversary Update

(Feature update to Windows 10, version 1607), and make sure it is patched with all

updates to that version (at a minimum patched to Windows 10 Version 1607 update for

August 23, 2016 (KB3176936), and the Windows 10 Version 1607 cumulative update for

September 29, 2016 (KB3194496). We also recommend using the 32-bit version of

Microsoft Office. This insures that all the examples discussed in this book will function

properly.

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-6

 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 7. This appendix should be

covered before discussing the Web database application Web pages in

Chapter 7.

• All software used in this appendix and Chapter 7 is freely downloadable for the

indicated Web sites. Further, the software will run well on a laptop, notebook, or

desktop computer owned by the student, so each student should have these

tools available.

• It is important to point out, as discussed in the By The Way box on page I-9, that

there are two versions of the Windows ODBC Data Sources Administrator

program—a 32-bit and a 64-bit version. The default version in Windows is the 64-

bit version, but I have had numerous occasions where I had to use the 32-bit

version to get the Web pages to work correctly. This is a very common problem

and needs to be thoroughly discussed.

 ANSWERS TO REVIEW QUESTIONS

I.1 Why is the material in this appendix important?

In order to complete the work in Chapter 7—Database Processing Applications, we must have:

I.2 What Web server is typically used with the Windows operating systems? What Web

server is typically used with the Linux operating system?

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-7

I.3 Briefly describe how to install IIS on the Windows 10 operating system.

I.4 What utility is used to manage IIS?

I.5 What utility is used to manage ODBC?

The ODBC Data Source Administrator is used to manage ODBC.

I.6 How do you add a program icon to the Windows 10 Taskbar?

I.7 How is the file system that supports IIS structured?

I.8 Briefly describe how to view a Web page that has been created in the IIS Web server.

I.9 What are Windows security permissions?

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-8

I.10 Briefly describe how to manage Windows security permissions.

I.11 What is an IDE?

I.12 What is the NetBeans IDE?

I.13 What is the Java Software Development Kit (JDK)? Why is it needed for the NetBeans

IDE?

I.14 Briefly describe how to install the JDK.

I.15 Briefly describe how to install the NetBeans IDE.

I.16 What is PHP? Is PHP a popular Web site development language?

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-9

I.17 What are the four options for installing PHP described in this appendix? Which option do

the authors recommend using?

The only disadvantage is making sure that the correct set of *.dll driver extensions is

downloaded and installed separately as discussed in the section How Do I Manage the PHP

Configuration?

I.18 Briefly describe how to install PHP.

To install PHP using the Microsoft Web Platform Installer version:

• When the What do you want to do with wpilauncher.exe? From:

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-10

I.19 Briefly describe how to create a PHP Web page using the NetBeans IDE.

To create a PHP Web page using the NetBeans IDE:

Create a NetBeans PHP Project:

Create a NetBeans PHP Web Page:

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-11

I.20 What is the purpose of the phptest.php Web page created in this chapter?

I.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

I.22 What are the Microsoft Drivers 3.2 for PHP for SQL Server?

I.23 Using the Microsoft Drivers 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 Drivers:

Appendix I – Getting Started with Web Servers, PHP, and the NetBeans IDE

Page I-12

I.24 Why must the php_pdo_odbc.dll extension be activated in the PHP installation?

 ANSWERS TO REVIEW EXERCISES