Apache, MySQL, and PHP Weekend Crash Course

Get up to speed on Apache, MySQL, and PHP – in a weekend!

The big day is Monday. The day you get to show off what you know about Apache Web server, MySQL database, and PHP scripting. The problem is, you're not really up to speed. Maybe it's been a while since you installed all three of these technologies. Perhaps you've never used Apache, MySQL, and PHP together. Or maybe you just like a challenge. In any event, we've got a solution for you – Apache, MySQL, and PHP Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to dive right in and begin building dynamic, data-driven sites on either Windows® or Linux® with all three integrated technologies.

The Curriculum

Friday

Evening: 4 Sessions, 2 Hours

• Installing Apache
• Installing PHP
• Installing MySQL
• Apache Basics

Saturday

Morning: 6 Sessions, 3 Hours

• Configuring Apache
• Apache Security Concerns
• The Basics of MySQL
• MySQL Security
• Working with Data
• Queries

Afternoon: 6 Sessions, 3 Hours

• Troubleshooting MySQL Commands and Queries
• Advanced MySQL Concepts
• PHP Basics
• Program Flow
• PHP Functions

Saturday, cont.

Evening: 4 Sessions, 2 Hours

• Working with Files
• HTML Constructs
• Working with Forms
• Multiple-User Considerations in PHP

Sunday

Morning: 6 Sessions, 3 Hours

• Good Coding Practices
• Debugging and Troubleshooting PHP
• MySQL Through PHP
• Debugging and Troubleshooting MySQL in PHP
• Odds and Ends
• Project: Calendar I

Afternoon: 4 Sessions, 2 Hours

• Project: Calendar II
• Project: Content Publishing I
• Project: Content Publishing II
• Project: Building an RSS Feed

Get up to speed on Apache, MySQL, and PHP - in a weekend

The big day is Monday. The day you get to show off what you know about Apache Web server, MySQL database, and PHP scripting. The problem is, you're not really up to speed. Maybe it's been a while since you installed all three of these technologies. Perhaps you've never used Apache, MySQL, and PHP together. Or maybe you just like a challenge. In any event, we've got a solution for you - Apache, MySQL, and PHP Weekend Crash Course. Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused sessions, you'll be able to dive right in and begin building dynamic, data-driven sites on either Windows or Linux with all three integrated technologies.

The Curriculum

Friday

Evening: 4 Sessions, 2 Hours

* Installing Apache

* Installing PHP

* Installing MySQL

* Apache Basics

Saturday

Morning: 6 Sessions, 3 Hours

* Configuring Apache

* Apache Security Concerns

* The Basics of MySQL

* MySQL Security

* Working with Data

* Queries

Afternoon: 6 Sessions, 3 Hours

* Troubleshooting MySQL Commands and Queries

* Advanced MySQL Concepts

* PHP Basics

* Program Flow

* PHP Functions

Saturday, cont.

Evening: 4 Sessions, 2 Hours

* Working with Files

* HTML Constructs

* Working with Forms

* Multiple-User Considerations in PHP

Sunday

Morning: 6 Sessions, 3 Hours

* Good Coding Practices

* Debugging and Troubleshooting PHP

* MySQL Through PHP

* Debugging and Troubleshooting MySQL in PHP

* Odds and Ends

* Project: Calendar I

Afternoon: 4 Sessions, 2Hours

* Project: Calendar II

* Project: Content Publishing I

* Project: Content Publishing II

* Project: Building an RSS Feed

Provides thirty focused, half-hour sessions that can be completed in fifteen hours, giving the reader a thorough working knowledge of Apache Web server, MySQL relational database management system, and PHP scripting languageThe ideal book for the Web developer who is ready to begin building dynamic, data-driven sites with these three integrated open source technologies Begins by teaching readers to install all three technologies and proceeds through building applications that use all three together Covers platform peculiarities of both Windows and Linux servers After completing the lessons, readers can test their skills through an online self-assessment exam

These three key open source technologies are the basis for a large majority of the Web servers on the internet today. Apache is the world's favorite Web server, responsible for serving up approximately 700f the content on the Web. MySQL is a powerful, flexible, and affordable open source database server. PHP is an open source scripting language that enables dynamic data to be reconfigured and custom delivered at request time for the specific Web visitor. All three technologies work well together and run on both Linux and Windows servers.

audit directors, auditors, controllers, CFOs

Preface.

Acknowledgments.

FRIDAY.

Part I—Friday Evening.

Session 1–Installing Apache.

Session 2–Installing PHP.

Session 3–Installing MySQL.

Session 4–Apache Basics.

SATURDAY.

Part II—Saturday Morning.

Session 5–Configuring Apache.

Session 6–Apache Security Concerns.

Session 7–The Basics of MySQL.

Session 8–MySQL Security.

Session 9–Working with Data.

Session 10–Queries.

Part III—Saturday Afternoon.

Session 11–Troubleshooting MySQL Commands and Queries.

Session 12–Advanced MySQL Concepts.

Session 13–Getting Ready to Use PHP.

Session 14–PHP Basics.

Session 15–Program Flow.

Session 16–PHP Functions.

Part IV—Saturday Evening.

Session 17–Working with Files.

Session 18–HTML Constructs.

Session 19–Working with Forms.

Session 20–Multiple-User Considerations in PHP.

SUNDAY.

Part V—Sunday Morning.

Session 21–Good Coding Practices.

Session 22–Debugging and Troubleshooting PHP.

Session 23–MySQL Through PHP.

Session 24–Debugging and Troubleshooting MySQL in PHP.

Session 25–Odds and Ends.

Session 26–Project: Calendar I.

Part VI—Sunday Afternoon.

Session 27–Project: Calendar II.

Session 28–Project: Content Publishing I.

Session 29–Project: Content Publishing II.

Session 30–Project: Building an RSS Feed.

Appendix A–Answers to Part Review Questions.

Appendix B–What’s on the Companion Web Site.

Index.