Sams teach yourself PHP, MySQL and Apache all in one / Julie Meloni.

By:

Meloni, Julie C

Material type: Text

TextPublication details: Indianapolis, Ind. : Sams ; London : Pearson Education [distributor], 2011.Edition: 5th edDescription: 1 v. : ill. ; 24 cm. + 1 computer optical discISBN:

9780672335433 (pbk.)
0672335433 (pbk.)

Other title:

Teach yourself PHP, MySQL and Apache all in one

Subject(s):

No physical items for this record

Enhanced descriptions from Syndetics:

In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up.

Regardless of whether you run Linux, Windows, or Mac OS X, the enclosed CD includes a complete starter kit that lets you install all the software you need to set up a stable environment for learning, testing, and production.

Learn how to...

* Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server

* Get these technologies to work together to create a dynamic, database-backed website

* Interact with MySQL using PHP

* Work with forms and files

* Create a web-based discussion forum or mailing list

* Add a storefront and shopping cart to your site

* Optimize your MySQL databases

* Fine-tune the Apache server's performance

* Restrict access to your applications

* Set up a secure web server

CD-ROM Includes

A complete PHP, MySQL, and
Apache starter kit for Windows®, Linux®, or Mac® OS X.

Previous ed.: 2008.

CD-ROM.

Includes index.

Table of contents provided by Syndetics

Introduction (p. 1)
Part I Getting Up and Running
Chapter 1 Installation QuickStart Guide with XAMPP (p. 5)
Using Third-Party Installation Packages (p. 5)
Installing XAMPP on Linux/UNIX (p. 6)
Installing XAMPP on Windows (p. 8)
Installing XAMPP on Mac OS X (p. 11)
Securing XAMPP (p. 13)
Troubleshooting (p. 14)
Chapter 2 Installing and Configuring MySQL (p. 15)
Current and Future Versions of MySQL (p. 15)
How to Get MySQL (p. 16)
Installing MySQL on Linux/UNIX (p. 16)
Installing MySQL on Mac OS X (p. 18)
Installing MySQL on Windows (p. 20)
Troubleshooting Your Installation (p. 26)
Basic Security Guidelines (p. 27)
Introducing the MySQL Privilege System (p. 28)
Summary (p. 33)
Q&A (p. 34)
Workshop (p. 34)
Chapter 3 Installing and Configuring Apache (p. 37)
Current and Future Versions of Apache (p. 37)
Choosing the Appropriate Installation Method (p. 38)
Installing Apache on Linux/UNIX (p. 39)
Installing Apache on Mac OS X (p. 42)
Installing Apache on Windows (p. 42)
Apache Configuration File Structure (p. 45)
Apache Log Files (p. 50)
Apache-Related Commands (p. 51)
Starting Apache for the First Time (p. 53)
Troubleshooting (p. 55)
Summary (p. 56)
Q&A (p. 56)
Workshop (p. 57)
Chapter 4 Installing and Configuring PHP (p. 59)
Current and Future Versions of PHP (p. 59)
Building PHP on Linux/UNIX with Apache (p. 60)
Installing PHP on Mac OS X (p. 63)
Installing PHP on Windows (p. 63)
Php.ini Basics (p. 65)
Testing Your Installation (p. 65)
Getting Installation Help (p. 66)
The Basics of PHP Scripts (p. 67)
Summary (p. 73)
Q&A (p. 73)
Workshop (p. 74)
Part II PHP Language Structure
Chapter 5 The Building Blocks of PHP (p. 75)
Variables (p. 75)
Data Types (p. 78)
Operators and Expressions (p. 85)
Constants (p. 94)
Summary (p. 96)
Q&A (p. 96)
Workshop (p. 96)
Chapter 6 Flow Control Functions in PHP (p. 99)
Switching Flow (p. 99)
Loops (p. 105)
Code Blocks and Browser Output (p. 114)
Summary (p. 116)
Q&A (p. 116)
Workshop (p. 116)
Chapter 7 Working with Functions (p. 119)
What Is a Function? (p. 119)
Calling Functions (p. 120)
Defining a Function (p. 121)
Returning Values from User-Defined Functions (p. 124)
Variable Scope (p. 125)
Saving State Between Function Calls with the static Statement (p. 128)
More About Arguments (p. 130)
Testing for the Existence of a Function (p. 133)
Summary (p. 135)
Q&A (p. 135)
Workshop (p. 136)
Chapter 8 Working with Arrays (p. 139)
What Are Arrays? (p. 139)
Creating Arrays (p. 140)
Some Array-Related Constructs and Functions (p. 144)
Summary (p. 146)
Q&A (p. 146)
Workshop (p. 147)
Chapter 9 Working with Objects (p. 149)
Creating an Object (p. 150)
Object Inheritance (p. 155)
Summary (p. 157)
Q&A (p. 157)
Workshop (p. 157)
Part III Getting Involved with the Code
Chapter 10 Working with Strings, Dates, and Time (p. 159)
Formatting Strings with PHP (p. 160)
Investigating Strings in PHP (p. 169)
Manipulating Strings with PHP (p. 173)
Using Date and Time Functions in PHP (p. 179)
Other String, Date, and Time Functions (p. 186)
Summary (p. 186)
Workshop (p. 186)
Chapter 11 Working with Forms (p. 189)
Creating a Simple Input Form (p. 189)
Accessing Form Input with User-Defined Arrays (p. 191)
Combining HTML and PHP Code on a Single Page (p. 194)
Using Hidden Fields to Save State (p. 197)
Redirecting the User (p. 198)
Sending Mail on Form Submission (p. 200)
Creating the Form (p. 201)
Creating the Script to Send the Mail (p. 202)
Working with File Uploads (p. 206)
Summary (p. 210)
Q&A (p. 210)
Workshop (p. 211)
Chapter 12 Working with Cookies and User Sessions (p. 213)
Introducing Cookies (p. 213)
Setting a Cookie with PHP (p. 215)
Deleting a Cookie with PHP (p. 217)
Session Function Overview (p. 217)
Starting a Session (p. 218)
Working with Session Variables (p. 219)
Destroying Sessions and Unsetting Variables (p. 223)
Using Sessions in an Environment with Registered Users (p. 224)
Summary (p. 225)
Q&A (p. 226)
Workshop (p. 226)
Chapter 13 Working with Files and Directories (p. 229)
Including Files (p. 229)
Using include_once (p. 233)
Validating Files (p. 234)
Creating and Deleting Files (p. 238)
Opening a File for Writing, Reading, or Appending (p. 238)
Reading from Files (p. 239)
Writing or Appending to a File (p. 245)
Working with Directories (p. 248)
Opening Pipes to and from Processes Using popen() (p. 251)
Running Commands with exec() (p. 254)
Running Commands with system() or passthru() (p. 255)
Summary (p. 257)
Q&A (p. 257)
Workshop (p. 258)
Chapter 14 Working with Images (p. 261)
Understanding the Image-Creation Process (p. 261)
Necessary Modifications to PHP (p. 262)
Drawing a New Image (p. 263)
Modifying Existing Images (p. 271)
Image Creation from User Input (p. 273)
Using Images Created by Scripts (p. 278)
Summary (p. 280)
Q&A (p. 281)
Workshop (p. 281)
Part IV PHP and MySQL Integration
Chapter 15 Understanding the Database Design Process (p. 283)
The Importance of Good Database Design (p. 283)
Types of Table Relationships (p. 284)
Understanding Normalization (p. 289)
Following the Design Process (p. 292)
Summary (p. 293)
Q&A (p. 294)
Workshop (p. 294)
Chapter 16 Learning Basic SQL Commands (p. 297)
Learning the MySQL Data Types (p. 298)
Learning the Table-Creation Syntax (p. 301)
Using the INSERT Command (p. 302)
Using the SELECT Command (p. 304)
Using WHERE in Your Queries (p. 308)
Selecting from Multiple Tables (p. 310)
Using the UPDATE Command to Modify Records (p. 316)
Using the REPLACE Command (p. 319)
Using the DELETE Command (p. 320)
Frequently Used String Functions in MySQL (p. 322)
Using Date and Time Functions in MySQL (p. 331)
Summary (p. 343)
Q&A (p. 345)
Workshop (p. 346)
Chapter 17 Using Transactions and Stored Procedures in MySQL (p. 349)
What Are Transactions? (p. 349)
What Are Stored Procedures? (p. 353)
Summary (p. 355)
Q&A (p. 355)
Workshop (p. 356)
Chapter 18 Interacting with MySQL Using PHP (p. 357)
MySQL or MySQLi Functions? (p. 357)
Connecting to MySQL with PHP (p. 358)
Working with MySQL Data (p. 361)
Summary (p. 369)
Q&A (p. 370)
Workshop (p. 370)
Part V Basic Projects
Chapter 19 Managing a Simple Mailing List (p. 373)
Developing the Subscription Mechanism (p. 374)
Developing the Mailing Mechanism (p. 381)
Summary (p. 384)
Q&A (p. 385)
Workshop (p. 385)
Chapter 20 Creating an Online Address Book (p. 387)
Planning and Creating the Database Tables (p. 387)
Creating an Include File for Common Functions (p. 390)
Creating a Menu (p. 391)
Creating the Record-Addition Mechanism (p. 392)
Viewing Records (p. 398)
Creating the Record-Deletion Mechanism (p. 404)
Adding Subentries to a Record (p. 406)
Summary (p. 414)
Q&A (p. 414)
Workshop (p. 414)
Chapter 21 Creating a Simple Discussion Forum (p. 417)
Designing the Database Tables (p. 417)
Creating an Include File for Common Functions (p. 418)
Creating the Input Forms and Scripts (p. 419)
Displaying the Topic List (p. 423)
Displaying the Posts in a Topic (p. 426)
Adding Posts to a Topic (p. 430)
Summary (p. 433)
Q&A (p. 434)
Workshop (p. 434)
Chapter 22 Creating an Online Storefront (p. 437)
Planning and Creating the Database Tables (p. 437)
Displaying Categories of Items (p. 441)
Displaying Items (p. 445)
Summary (p. 448)
Q&A (p. 448)
Workshop (p. 448)
Chapter 23 Creating a Shopping Cart Mechanism (p. 451)
Planning and Creating the Database Tables (p. 451)
Integrating the Cart with Your Storefront (p. 453)
Payment Methods and the Checkout Sequence (p. 462)
Summary (p. 465)
Q&A (p. 465)
Workshop (p. 465)
Chapter 24 Creating a Simple Calendar (p. 467)
Building a Simple Display Calendar (p. 467)
Creating a Calendar Library (p. 483)
Summary (p. 489)
Q&A (p. 489)
Workshop (p. 489)
Chapter 25 Restricting Access to Your Applications (p. 491)
Authentication Overview (p. 491)
Apache Authentication Module Functionality (p. 493)
Using Apache for Access Control (p. 497)
Combining Apache Access Methods (p. 500)
Limiting Access Based on HTTP Methods (p. 501)
Restricting Access Based on Cookie Values (p. 501)
Summary (p. 507)
Q&A (p. 507)
Workshop (p. 508)
Chapter 26 Logging and Monitoring Web Server Activity (p. 509)
Standard Apache Access Logging (p. 509)
Standard Apache Error Logging (p. 515)
Managing Apache Logs (p. 517)
Logging Custom Information to a Database (p. 519)
Summary (p. 523)
Q&A (p. 524)
Workshop (p. 524)
Chapter 27 Application Localization (p. 527)
About Internationalization and Localization (p. 527)
About Character Sets (p. 528)
Environment Modifications (p. 529)
Creating a Localized Page Structure (p. 531)
Localizing Your Application with gettext() (p. 536)
Summary (p. 537)
Q&A (p. 538)
Workshop (p. 538)
Chapter 28 Working with XML and JSON (p. 541)
What Is XML? (p. 541)
Accessing XML in PHP Using DOM Functions (p. 544)
Accessing XML in PHP Using SimpleXML Functions (p. 546)
Working with JSON (p. 549)
Summary (p. 553)
Q&A (p. 553)
Workshop (p. 554)
Part VI Administration and Fine-Tuning
Chapter 29 Apache Performance Tuning and Virtual Hosting (p. 555)
Performance and Scalability Issues (p. 555)
Load Testing with ApacheBench (p. 559)
Proactive Performance Tuning (p. 561)
Preventing Abuse (p. 563)
Implementing Virtual Hosting (p. 564)
Summary (p. 569)
Q&A (p. 570)
Workshop (p. 571)
Chapter 30 Setting Up a Secure Web Server (p. 573)
The Need for Security (p. 573)
The SSL Protocol (p. 574)
Obtaining and Installing SSL Tools (p. 579)
Managing Certificates (p. 582)
SSL Configuration (p. 585)
Summary (p. 586)
Q&A (p. 586)
Workshop (p. 586)
Chapter 31 Optimizing and Tuning MySQL (p. 589)
Building an Optimized Platform (p. 589)
Benchmarking Your Database Server (p. 590)
MySQL Startup Options (p. 591)
Optimizing Your Table Structure (p. 593)
Optimizing Your Queries (p. 594)
Using the FLUSH Command (p. 595)
Using the SHOW Command (p. 596)
Summary (p. 603)
Q&A (p. 603)
Workshop (p. 604)
Chapter 32 Performing Software Upgrades (p. 605)
Staying in the Loop (p. 605)
Upgrading MySQL (p. 607)
Upgrading Apache (p. 608)
Upgrading PHP (p. 609)
Summary (p. 610)
Workshop (p. 610)
Chapter 33 Using Application Frameworks (p. 611)
Understanding Application Frameworks (p. 611)
Using the MVC Pattern (p. 612)
Installing and Using PHP Application Frameworks (p. 614)
Summary (p. 617)
Workshop (p. 617)
Activities (p. 618)
TOC, 9780672335433, 5/2/2012

Author notes provided by Syndetics

Julie C. Meloni is a technical consultant who has been developing web-based applications since the Web first saw the light of day. She has authored numerous books and articles on web-based programming and scripting languages and database topics, and you can find translations of her work in 18 different languages. She blogs at thickbook.com and nerdtripping.com--the latter reserved for tips and tricks for traveling while nerdy.