Web Application Design and Implementation: Apache 2, PHP5, MySQL, JavaScript, and Linux/UNIX / Edition 1 by Steven A. Gabarro | 9780471773917 | Hardcover | Barnes & Noble
Web Application Design and Implementation: Apache 2, PHP5, MySQL, JavaScript, and Linux/UNIX / Edition 1

Web Application Design and Implementation: Apache 2, PHP5, MySQL, JavaScript, and Linux/UNIX / Edition 1

by Steven A. Gabarro
     
 

ISBN-10: 0471773913

ISBN-13: 9780471773917

Pub. Date: 12/26/2006

Publisher: Wiley

Learn how to combine different technologies to create sophisticated, database-driven Web sites

This text allows readers to gain the core programming knowledge needed to build a database-driven Web site using a step-by-step approach. Each stage of Web site development is carefully explained, from installation to production of the site. The book, based on a

Overview

Learn how to combine different technologies to create sophisticated, database-driven Web sites

This text allows readers to gain the core programming knowledge needed to build a database-driven Web site using a step-by-step approach. Each stage of Web site development is carefully explained, from installation to production of the site. The book, based on a course developed by the author, features a carefully constructed organization that shows readers how to begin creating Web pages, and then incrementally add greater functionality as they progress through the text.

A key strength of this book is its use of multiple programming languages and applications. By selecting among the best options from HTML, JavaScript, MySQL, PHP, Apache, and Linux/UNIX, readers learn to develop Web sites that are specifically tailored to meet their needs.

Brief chapters, each focusing on one core theme, are designed to allow readers to learn at their own pace. Among the key chapters is one dedicated to teaching how to install a Web server with all the required modules to run the scripts presented in the book.

  • Examples are used extensively throughout, illustrating key concepts and techniques
  • Author draws from his own extensive experience to offer expert tips and point out pitfalls to avoid
  • Exercises help readers put their knowledge into practice
  • The examples, as well as sample solutions to the exercises, are posted online to give readers more opportunity to work with the scripts

With its step-by-step approach, this book is ideally suited for anyone who wants to learn how to create complete Web sites. No previous knowledge of any programming language is needed. For experienced Web designers, the book will bring their programming skills to a higher level by enabling them to create dynamic pages linked to a database.

Product Details

ISBN-13:
9780471773917
Publisher:
Wiley
Publication date:
12/26/2006
Series:
Quantitative Software Engineering Series, #4
Edition description:
New Edition
Pages:
295
Product dimensions:
6.46(w) x 9.35(h) x 0.99(d)

Table of Contents

PREFACE.

About the Author.

Before We Get Started.

Who Should Read this book?

About The Examples.

How to read this book.

Acknowledgments.

Introduction: Web Application Recipe.

Overview.

Step 1 - Understanding the problem and finding the solution.

Step 2 - Designing the database.

Step 3 - Major functionalities.

Step 4 - Back side.

Step 5 - Improvements on functionality.

Step 6 - Improvements on looks.

Step 7 - Thorough testing, hacking attempts.

Step 8 - Presentation.

Step 9 - Publication.

Step 10 - Celebration (and maintenance).

Chapter 1. Fundamentals.

The origins of the Internet.

The World Wide Web.

The Web Browsers.

The Web Servers.

TCP/IP BASICS.

The Internet Layer.

The Transport Layer.

The Application Layer.

The Toolbox.

Browsers.

FTP.

E-Mail Clients.

Programming Tools.

Other Useful Tools.

Chapter 2. The Different Approaches of Web Programming.

Before We Get Started.

The Basics - HTML.

The Creator - SGML.

Other SGML-based languages - XML / XSL.

The good old Java.

Something different - JavaScript.

The Savior - PHP.

The rival - ASP.NET.

The Myth - CGI.

Another Big Option - Perl.

The Future? - C#.

Client-side versus Server-side - Which side to pick?

My Choices - PHP, MySQL, JavaScript.

Chapter 3. Introduction To HTML.

What do you need to get started?

How does HTML work?

Syntax basics.

File Structure.

Tags Parameters.

Basic Text Formatting.

External References.

Links.

Images.

Organizing Data.

Lists.

Tables.

Frames.

Special Characters.

Chapter 4. Work Environment.

Introduction.

Downloading the Software.

Installing the Apache Server.

Installation Steps.

Checking the Installation.

Possible Errors.

Configuring Apache.

Installing PHP5.

Testing PHP.

Installing MySQL.

Adding a MySQL user.

How do I know if MySQL is running?

Installing phpMyAdmin.

Installing a Bulletin Board: phpBB.

Installation Steps.

Basic Security things to consider!

Conclusion.

Chapter 5. PHP - A server Side Scripting Language.

How does it work?

Some “new” words on PHP.

Syntax Generalities.

Instructions.

Operators.

Mathematical Functions.

Data Types.

Constants.

Variables.

Chapter 6. PHP Arrays and Flow of Control.

Arrays.

Basic Arrays.

Associative Arrays.

Multidimensional Arrays.

Arrays Functions.

PHP Program Structure and Flow of control.

Conditions.

Loops.

Functions.

Chapter 7. Using files, folders and Strings in PHP.

Using Files.

Folder Manipulation.

Basic String Manipulation.

Changing a string.

Finding and Comparing.

Formatting Strings.

Manipulating HTML files.

PHP Information Functions.

Closing Remarks.

Writing a basic File Explorer.

Requirements.

HINTS.

Case Study: An Indexer/Searcher STEP 1.

Overview.

The Indexer - Step 1.

Chapter 8. PHP5 and Object-Oriented Programming.

Overview.

Classes and Objects.

Classes in PHP.

Constructors and Destructors.

Visibility.

The scope resolution operator.

The Static Keyword.

Class Constants.

Class Abstraction.

Object Interfaces.

Copying and Cloning objects.

Comparing Objects.

Type Hinting.

Exceptions.

Final words.

Chapter 9. Creating Some Interactivity.

Overview.

Forms.

Writing a form in HTML.

GET vs. POST.

Retrieving the form info on a PHP script.

Dynamically creating forms.

Transferring data between PHP scripts.

Cookies.

Sessions.

One last useful function and design techniques.

Assignments.

File explorer step 2.

Case study: Indexer/Searcher - Step 2.

Chapter 10: Making Cleaner Code and Output.

Cleaning up your code.

What you need.

How to use it? - HTML side.

How to use it? - PHP side.

Cleaning up your output.

The CSS file.

Useful tools.

Assignment.

Chapter 11. Using Databases.

Overview.

Database Basics.

The entity-relationship model.

More Practical Example.

Typical sources of Errors.

Simplifying the Diagrams.

Using MySQL.

MySQL Syntax.

Data Types.

MySQL numeric data types.

Date and Time data types.

String Data types.

MySQL Operators.

MySQL Instructions.

Using Functions in MySQL.

Chapter 12. Using PhpMyAdmin.

Overview.

Creating a Database.

Creating tables.

Accessing an existing table.

Exporting/Importing a database structure and content.

Assignment - Final Project.

Chapter 13. Creating Database-Driven Websites with PHP/MySQL.

Overview.

Connecting to your MySQL server with PHP.

Submitting SQL queries.

Processing the results of a query.

Example of login procedure.

Other useful functions.

Grouping our Methods in a class.

Indexer/Searcher - Steps 3 and 4.

Chapter 14: JavaScript - A client side scripting language.

Introduction.

JavaScript syntax.

Types of Data and Variables.

Operations and calculations.

Arrays.

Decisions.

Loops.

Using Functions.

Using Objects.

The String Objects.

The Math class.

The Array objects.

Chapter 15. Programming the Browser.

Overview.

The Window Object.

The Location Object.

The History Object.

The Navigator Object.

The Screen Object.

The Document Object.

Using Events.

Timers.

Time to practice!

Chapter 16. Windows and Frames.

Frames and JavaScript.

Windows and JavaScript.

Assignments.

One Last Funny Example.

Chapter 17: String Manipulations Revisited.

Overview.

New Basic String methods.

Regular Expressions in JavaScript.

Regular Expressions in PHP.

The set of PCRE.

Chapter 18. JavaScript and DHTML.

Overview.

Positioning Elements.

Writing dynamic menus in DHTML.

You turn!! .

Chapter 19. Putting it All Together!

Overview.

Step 1 - Understanding the problem and finding the solution.

Step 2 - Designing the database.

Step 3 - Main functionalities.

Step 4 - Back side.

Step 5 - Improvements on functionality.

Step 6 - Improvements on looks.

Step 7 - Thorough testing, hacking attempts.

Step 8 - Presentation.

Step 9 - Publication.

Step 10 - Celebration :) (and maintenance).

What language to use?

Appendix A: Special Characters.

Appendix B: Installing on UNIX.

Overview.

Installing Apache and PHP.

Installing MySQL.

Appendix C: Advanced phpBB.

Appendix D: class.FastTemplate.PHP.

Appendix E - File Upload Script.

Bibliography.

Index.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >