Sams Teach Yourself PHP, MySQL and Apache All in One

Content: Introduction --
Part 1: Getting Up And Running: --
Installation QuickStart guide with XAMPP: --
Using third-party installation packages --
Installing XAMPP on Linux/UNIX --
Installing XAMPP on Windows --
Installing XAMPP on Mac OS X --
Securing SAMPP --
Troubleshooting --
Installing And Configuring MySQL: --
Current and future versions of MySQL --
How to get MySQL --
Installing MySQL on Linux/UNIX --
Installing MySQL on Mac OS X --
Installing MYSQL on Windows --
Troubleshooting your installation --
Basic security guidelines --
Introducing the MySQL Privilege System --
Summary --
Q & A --
Workshop --
Installing and configuring Apache: --
Current and future version of Apache --
Choosing the appropriate installation method --
Installing Apache on Linux/UNIX --
Installing Apache on Mac OS X --
Installing Apache on Windows --
Apache configuration file structure --
Apache log files --
Apache-related commands --
Starting Apache for the first time --
Troubleshooting --
Summary --
Q & A --
Workshop --
Installing and configuring PHP: --
Current and future versions of PHP --
Building PHP on Linux/UNIX with Apache --
Installing PHP on Mac OS X --
Installing PHP on Windows --
php-ini basics --
Testing your installation --
Getting installation help --
Basics of PHP scripts --
Summary --
Q & A --
Workshop --
Part 2: PHP Language Structure: --
Building blocks of PHP --
Variables --
Data types --
Operators and expressions --
Constants --
Summary --
Q & A --
Workshop --
Flow control functions in PHP: --
Switching flow --
Loops --
Code blocks and browser output --
Summary --
Q & A --
Workshop --
Working with functions: --
What is a function? --
Calling functions --
Defining a function --
Returning values from user-defined functions --
Variable scope --
Saving state between function calls with the static statement --
More about arguments --
Testing for the existence of a function --
Summary --
Q & A --
Workshop --
Working with arrays: --
What are arrays? --
Creating arrays --
Some array-related constructs and functions --
Summary --
Q & A --
Workshop --
Working with objects: --
Creating an object --
Object inheritance --
Summary --
Q & A --
Workshop --
Part 3: Getting Involved With The Code: --
Working with strings, dates, and time: --
Formatting strings with PHP --
Investigating strings in PHP --
Manipulating strings with PHP --
Using date and time functions in PHP --
Other string, date, and time functions --
Summary --
Workshop --
Working with forms: --
Creating a simple input form --
Accessing form input with user-defined arrays --
Combining HTML and PHP code on a single page --
Using hidden fields to save state --
Redirecting the user --
Sending mail on form submission --
Creating the form --
Creating the script to send them mail --
Working with file uploads --
Summary --
Q & A --
Workshop --
Working with cookies and user sessions: --
Introducing cookies --
Setting a cookie with PHP --
Deleting a cookie with PHP --
Session function overview --
Starting a session --
Working with session variables --
Destroying sessions and unsetting variables --
Using sessions in an environment with registered users --
Summary --
Q & A --
Workshop --
Working with files and directories: --
Including files --
Using include_once --
Validating files --
Creating and deleting files --
Opening a file for writing, reading, or appending --
Reading from files --
Writing or appending to a file --
Working with directories --
Opening pipes to and from processes using popen() --
Running commands with exec() --
Running commands with system() or passthru() --
Summary --
Q & A --
Workshop --
Working with images: --
Understanding the image-creation process --
Necessary modifications to PHP --
Drawing a new image --
Modifying existing images --
Image creation from user input --
Using images created by scripts --
Summary --
Q & A --
Workshop. Part 4: PHP And MySQL Integration: --
Understanding the database design process: --
Importance of good database design --
Types of table relationships --
Understanding normalization --
Following the design process --
Summary --
Q & A --
Workshop --
Learning basic SQL commands: --
Learning the MySQL data types --
Learning the table-creation syntax --
Using the INSERT command --
Using the SELECT command --
Using WHERE in your queries --
Selecting from multiple tables --
Using the UPDATE command to modify records --
Using the REPLACE command --
Using the DELETE command --
Frequently used string functions in MySQL --
Using date and time functions in MySQL --
Summary --
Q & A --
Workshop --
Using transactions and stored procedures in MySQL: --
What are transactions? --
What are stored procedures? --
Summary --
Q & A --
Workshop --
Interacting with MySQL using PHP: --
MySQL or MySQLi functions? --
Connecting to MySQL with PHP --
Working with MySQL data --
Summary --
Q & A --
Workshop --
Part 5: Basic Projects: --
Managing a simple mailing list: --
Developing the subscription mechanism --
Developing the mailing mechanism --
Summary --
Q & A --
Workshop --
Creating an online address book: --
Planning and creating the database tables --
Creating an include file for common functions --
Creating a menu --
Creating the record-addition mechanism --
Viewing records --
Creating the record-deletion mechanism --
Adding subentries to a record --
Summary --
Q & A --
Workshop --
Creating a simple discussion forum: --
Designing the database tables --
Creating an include file for common functions --
Creating the input forms and scripts --
Displaying the topic list --
Displaying the posts in a topic --
Adding posts to a topic --
Summary --
Q & A --
Workshop --
Creating an online storefront: --
Planning and creating the database tables --
Displaying categories of items --
Displaying items --
Summary --
Q & A --
Workshop --
Creating a shopping cart mechanism: --
Planning and creating the database tables --
Integrating the cart with your storefront --
Payment methods and the checkout sequence --
Summary --
Q & A --
Workshop --
Creating a simple calendar: --
Building a simple display calendar --
Creating a calendar library --
Summary --
Q & A --
Workshop --
Restricting access to your applications --
Authentication overview --
Apache authentication module functionality --
Using Apache for Access control --
Combining Apache access methods --
Limiting access based on HTTP methods --
Restricting access based on cookie values --
Summary --
Q & A --
Workshop --
Logging and monitoring web server activity: --
Standard Apache access logging --
Standard Apache error logging --
Managing Apache logs --
Logging custom information to a database --
Summary --
Q & A --
Workshop --
Application localization: --
About internationalization and localization --
About character sets --
Environment modifications --
Crating a localized page structure --
Localizing your application with gettext() --
Summary --
Q & A --
Workshop --
Working with XML and JSON: --
What is XML? --
Accessing XML in PHP using DOM functions --
Accessing XML in PHP using simple XML functions --
Working with JSON --
Summary --
Q & A --
Workshop --
Part 6: Administration And Fine-Tuning: --
Apache performance tuning and virtual hosting: --
Performance and scalability issues --
Load testing with ApacheBench --
Proactive performance tuning --
Preventing abuse --
Implementing virtual hosting --
Summary --
Q & A --
Workshop --
Setting up a secure web server: --
Need for security --
SSL protocol --
Obtaining and installing SSL tools --
Managing certificates --
SSL configuration --
Summary --
Q & A --
Workshop --
Optimizing and tuning MySQL: --
Building an optimized platform --
Benchmarking your database server --
MySQL startup options --
Optimizing your table structure --
Optimizing your queries --
Using the FLUSH command --
Using the SHOW command --
Summary --
Q & A --
Workshop --
Performing software upgrades: --
Staying in the loop --
Upgrading MySQL --
Upgrading Apache --
Upgrading PHP --
Summary --
Workshop --
Using application frameworks: --
Understanding application frameworks --
Using the MVC pattern --
Installing and using PHP application frameworks --
Summary --
Q & A --
Workshop --
Activities --
Index.