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

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.