Table of contents for Web application design and implementation: Apache 2, PHP5, MySQL, JavaScript, and Linux/Unix / by Steven A. Gabarrãao.

Bibliographic record and links to related information available from the Library of Congress catalog.

Note: Contents data are machine generated based on pre-publication provided by the publisher. Contents may have variations from the printed book or be incomplete or contain other coding.


Counter
TABLE OF CONTENTS
TABLE OF CONTENTS	iv
PREFACE	x
About the Author	x
Before We Get Started	x
Who Should Read this book?	xi
About The Examples	xi
How to read this book	xii
CHAPTER 0: Web Application Recipe	13
Overview	13
Step 1 - Understanding the problem and finding the solution	13
Step 2 - Designing the database	13
Step 3 - Major functionalities	14
Step 4 - Back side	14
Step 5 - Improvements on functionality	15
Step 6 - Improvements on looks	15
Step 7 - Thorough testing, hacking attempts	15
Step 8 - Presentation	16
Step 9 - Publication	16
Step 10 - Celebration (and maintenance)	16
CHAPTER 1: FUNDAMENTALS	17
The origins of the Internet	17
The World Wide Web	18
The Web Browsers	19
The Web Servers	19
TCP/IP BASICS	20
The Internet Layer	21
The Transport Layer	24
The Application Layer	25
The Toolbox	25
Browsers	26
FTP	27
E-Mail Clients	28
Programming Tools	29
Other Useful Tools	30
CHAPTER 2: THE DIFFERENT APPROACHES OF WEB PROGRAMMING	31
Before We Get Started	31
The Basics ? HTML	31
The Creator ? SGML	33
Other SGML-based languages ? XML / XSL	33
The good old Java	36
Something different ? JavaScript	37
The Savior ? PHP	38
The rival ? ASP.NET	39
The Myth ? CGI	39
Another Big Option ? Perl	40
The Future? ? C#	41
Client-side versus Server-side ? Which side to pick?	41
My Choices ? PHP, MySQL, JavaScript	43
CHAPTER 3: INTRODUCTION TO HTML	45
What do you need to get started?	45
How does HTML work?	45
Syntax basics	45
File Structure	46
Tags Parameters	49
Basic Text Formatting	49
External References	52
Links	52
Images	53
Organizing Data	55
Lists	56
Tables	57
Frames	62
Special Characters	67
CHAPTER 4 ? WORK ENVIRONMENT	68
Introduction	68
Downloading the Software	68
Installing the Apache Server	69
Installation Steps	69
Checking the Installation	70
Possible Errors	71
Configuring Apache	71
Installing PHP5	73
Testing PHP	75
Installing MySQL	75
Adding a MySQL user	76
How do I know if MySQL is running?	76
Installing phpMyAdmin	77
Installing a Bulletin Board: phpBB	78
Installation Steps	78
Basic Security things to consider!	80
Conclusion	82
CHAPTER 5: PHP - A server Side Scripting Language (Step 1)	83
How does it work?	83
Some ?new? words on PHP	83
Syntax Generalities	83
Instructions	84
Operators	88
Mathematical Functions	90
Data Types	91
Constants	93
Variables	94
CHAPTER 6 - PHP Arrays and Flow of Control	99
Arrays	99
Basic Arrays	99
Associative Arrays	100
Multidimensional Arrays	101
Arrays Functions	106
PHP Program Structure and Flow of control	110
Conditions	110
Loops	115
Functions	116
CHAPTER 7 - Using files, folders and Strings in PHP	119
Using Files	119
Folder Manipulation	125
Basic String Manipulation	126
Changing a string	126
Finding and Comparing	130
Formatting Strings	132
Manipulating HTML files	133
PHP Information Functions	136
Closing Remarks	137
Writing a basic File Explorer	137
Requirements	137
HINTS	138
Case Study: An Indexer/Searcher STEP 1	138
Overview	138
The Indexer ? Step 1	139
CHAPTER 8: PHP5 and Object Oriented Programming	142
Overview	142
Classes and Objects	142
Classes in php	143
Constructors and Destructors	144
Visibility	145
The scope resolution operator	147
The Static Keyword	148
Class Constants	149
Class Abstraction	149
Object Interfaces	150
Copying and Cloning objects	151
Comparing Objects	153
Type Hinting	153
Exceptions	154
Final words	156
CHAPTER 9: Creating Some Interactivity	157
Overview	157
Forms	157
Writing a form in HTML	157
GET vs. POST	162
Retrieving the form info on a PHP script	162
Dynamically creating forms	164
Transferring data between PHP scripts	164
Cookies	165
Sessions	168
One last useful function and design techniques	173
Assignments	174
File explorer step 2	174
Case study: Indexer/Searcher - Step 2	175
CHAPTER 10: Making Cleaner Code and Output	177
Cleaning up your code	177
What you need	177
How to use it? ? HTML side	178
How to use it? ? PHP side	179
Cleaning up your output	183
The CSS file	183
Useful tools	188
Assignment	188
CHAPTER 11: Using Databases	189
Overview	189
Database Basics	189
The entity-relationship model	189
More Practical Example	190
Typical sources of Errors	192
Simplifying the Diagrams	192
Using MySQL	193
MySQL Syntax	194
Data Types	195
MySQL numeric data types	196
Date and Time data types	197
String Data types	198
MySQL Operators	199
MySQL Instructions	200
Using Functions in MySQL	207
CHAPTER 12: Using PhpMyAdmin	208
Overview	208
Creating a Database	208
Creating tables	209
Accessing an existing table	211
Exporting/Importing a database structure and content	211
Assignment - Final Project	213
CHAPTER 13: Creating database-driven websites with PHP/MySQL	216
Overview	216
Connecting to your MySQL server with PHP	216
Submitting SQL queries	217
Processing the results of a query	219
Example of login procedure	220
Other useful functions	221
Grouping our Methods in a class	222
Indexer/Searcher - Steps 3 and 4	230
CHAPTER 14: JAVASCRIPT - A client side scripting language	233
Introduction	233
JavaScript syntax	235
Types of Data and Variables	235
Operations and calculations	236
Arrays	238
Decisions	239
Loops	241
Using Functions	242
Using Objects	243
The String Objects	243
The Math class	245
The Array objects	247
CHAPTER 15: Programming the browser	251
Overview	251
The Window Object	251
The Location Object	252
The History Object	252
The Navigator Object	252
The Screen Object	253
The Document Object	254
Using Events	259
Timers	263
Time to practice!	264
CHAPTER 16: Windows and Frames	265
Frames and JavaScript	265
Windows and JavaScript	270
Assignments	278
One Last Funny Example	278
CHAPTER 17: String Manipulations Revisited	282
Overview	282
New Basic String methods	282
Regular Expressions in JavaScript	283
Regular Expressions in PHP	287
The set of PCRE	288
CHAPTER 18: JavaScript and DHTML	292
Overview	292
Positioning Elements	292
Writing dynamic menus in DHTML	300
You turn!!	304
CHAPTER 19: Putting it all together!	305
Overview	305
Step 1 - Understanding the problem and finding the solution	305
Step 2 - Designing the database	306
Step 3 - Main functionalities	309
Step 4 - Back side	311
Step 5 - Improvements on functionality	311
Step 6 - Improvements on looks	312
Step 7 - Thorough testing, hacking attempts	312
Step 8 - Presentation	314
Step 9 - Publication	314
Step 10 - Celebration :) (and maintenance)	314
What language to use?	315
APPENDIX A: Special characters	318
APPENDIX B: Installing on UNIX	321
Overview	321
Installing Apache and PHP	321
Installing MySQL	323
APPENDIX C: Advanced phpBB	328
APPENDIX D: class.FastTemplate.php	330
APPENDIX E - File Upload Script	348
REFERENCES	350

Library of Congress Subject Headings for this publication:

Web site development.
Web sites -- Design.
Application software -- Development.