Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted,
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
