Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself PHP, MySQL and Apache All in One

by: Meloni, Julie C.

Sams Teach Yourself PHP, MySQL and Apache All in One

by: Meloni, Julie C.

ISBN 13:
9780672327254
ISBN 10:
0672327252
Edition: 2nd
Format: Paperback w/CD
Copyright: 01/01/2005
Publisher: Sams
Newer Edition

Rent

Sorry, this item is currently unavailable.

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Extend or Purchase Your Rental at Any Time

Need to keep your rental past your due date? At any time before your due date you can extend or purchase your rental through your account.

Summary

A new edition of the best-selling book that covers three popular open-source tools in one complete Starter Kit package.

Introduction

(1)

Who Should Read This Book?

(1)

How This Book Is Organized

(1)

Conventions Used in This Book

(4)

Part I: Laying the Groundwork

Installation QuickStart Guide

(18)

Linux/Unix Installation

(4)

Installing MySQL

(2)

Installing Apache

(1)

Installing PHP

(2)

Windows Installation

(7)

Installing MySQL

(1)

Installing Apache

(3)

Installing PHP

(2)

Mac OS X Installation

(5)

Installing MySQL

(1)

Installing PHP

(3)

Troubleshooting

(2)

Installing and Configuring MySQL

(20)

Current and Future Versions of MySQL

(1)

How to Get MySQL

(1)

Installing MySQL on Linux/Unix

(1)

Installing MySQL on Mac OS X

(3)

Installing MySQL on Windows

(5)

Troubleshooting Your Installation

(1)

Basic Security Guidelines

(2)

Starting MySQL

(1)

Securing Your MySQL Connection

(1)

Introducing the MySQL Privilege System

(2)

The Two-Step Authentication Process

(2)

Working with User Privileges

(3)

Adding Users

(2)

Removing Privileges

(1)

Summary

(1)

Q&A

(1)

Workshop

(1)

Quiz

(1)

Answers

(1)

Activities

(1)

Installing and Configuring Apache

(22)

Current and Future Versions of Apache

(1)

Choosing the Appropriate Installation Method

(1)

Building from Source

(1)

Installing a Binary

(1)

Installing Apache on Linux/Unix

(3)

Downloading the Apache Source Code

(1)

Uncompressing the Source Code

(1)

Preparing to Build Apache

(1)

Building and Installing Apache

(1)

Installing Apache on Mac OS X

(1)

Installing Apache on Windows

(3)

Apache Configuration File Structure

(6)

Directives

(2)

Containers

(1)

Conditional Evaluation

(1)

ServerRoot

(1)

Per-Directory Configuration Files

(1)

Apache Log Files

(1)

access_log

(1)

error_log

(1)

Additional Files

(1)

Apache-Related Commands

(2)

Apache Server Binary

(1)

Apache Control Script

(1)

Starting Apache for the First Time

(2)

Check Your Configuration File

(1)

Starting Apache

(1)

Troubleshooting

(1)

Already an Existing Web Server

(1)

No Permission to Bind to Port

(1)

Access Denied

(1)

Wrong Group Settings

(1)

Summary

(1)

Q&A

(1)

Workshop

(1)

Quiz

(1)

Answers

(1)

Activities

(1)

Installing and Configuring PHP

(22)

Current and Future Versions of PHP

(1)

Building PHP on Linux/Unix with Apache

(2)

Additional Configuration Options

(1)

Integrating PHP with Apache on Linux/Unix

(1)

Installing PHP on Mac OS X

(2)

Installing PHP on Windows

(2)

Integrating PHP with Apache on Windows

(1)

php.ini Basics

(1)

Testing Your Installation

(2)

Getting Installation Help

(1)

The Basics of PHP Scripts

(6)

Beginning and Ending a Block of PHP Statements

(2)

The echo Statement and print ( ) Function

(1)

Combining HTML and PHP

(1)

Adding Comments to PHP Code

(1)

Summary

(1)

Q&A

(1)

Workshop

(5)

Quiz

(1)

Answers

(1)

Activities

(4)

Part II: PHP Language Structure

The Building Blocks of PHP

(24)

Variables

(3)

Globals and Superglobals

(1)

Data Types

(6)

Changing Type with settype ( )

(1)

Changing Type by Casting

(3)

Why Test Type?

(1)

Operators and Expressions

(9)

The Assignment Operator

(1)

Arithmetic Operators

100

(1)

The Concatenation Operator

100

(1)

Combined Assignment Operators

101

(1)

Automatically Incrementing and Decrementing an Integer Variable

102

(1)

Comparison Operators

103

(1)

Creating Complex Test Expressions with the Logical Operators

104

(1)

Operator Precedence

105

(2)

Constants

107

(2)

Predefined Constants

108

(1)

Summary

109

(1)

Q&A

109

(1)

Workshop

110

(3)

Quiz

110

(1)

Answers

111

(1)

Activities

111

(2)

Flow Control Functions in PHP

113

(20)

Switching Flow

113

(6)

The if Statement

114

(1)

Using the else Clause with the if Statement

114

(1)

Using the else if Clause with the if Statement

115

(2)

The switch Statement

117

(2)

Using the ? Operator

119

(1)

Loops

119

(9)

The while Statement

120

(1)

The do . . . while Statement

121

(1)

The for Statement

122

(1)

Breaking Out of Loops with the break Statement

123

(2)

Skipping an Iteration with the continue Statement

125

(1)

Nesting Loops

126

(2)

Code Blocks and Browser Output

128

(2)

Summary

130

(1)

Q&A

130

(1)

Workshop

131

(2)

Quiz

131

(1)

Answers

131

(1)

Activity

132

(1)

Working with Functions

133

(20)

What Is a Function?

133

(1)

Calling Functions

134

(1)

Defining a Function

135

(3)

Returning Values from User-Defined Functions

138

(1)

Variable Scope

139

(3)

Accessing Variables with the global Statement

140

(2)

Saving State Between Function Calls with the static Statement

142

(2)

More About Arguments

144

(3)

Setting Default Values for Arguments

144

(2)

Passing Variable References to Functions

146

(1)

Testing for the Existence of a Function

147

(2)

Summary

149

(1)

Q&A

150

(1)

Workshop

150

(3)

Quiz

150

(1)

Answers

151

(1)

Activity

151

(2)

Working with Arrays and Objects

153

(18)

What Is an Array?

153

(1)

Creating Arrays

154

(4)

Creating Associative Arrays

155

(1)

Creating Multidimensional Arrays

156

(2)

Some Array-Related Functions

158

(2)

Creating an Object

160

(4)

Properties of Objects

161

(1)

Object Methods

162

(2)

Constructors

164

(1)

Object Inheritance

164

(3)

Summary

167

(1)

Q&A

167

(1)

Workshop

168

(3)

Quiz

168

(1)

Answers

168

(1)

Activities

168

(3)

Part III: Getting Involved with the Code

Working with Strings, Dates, and Times

171

(30)

Formatting Strings with PHP

172

(9)

Working with printf ( )

172

(4)

Specifying a Field Width

176

(3)

Argument Swapping

179

(1)

Storing a Formatted String

180

(1)

Investigating Strings in PHP

181

(4)

A Note About Indexing Strings

181

(1)

Finding the Length of a String with strlen ( )

181

(1)

Finding a Substring Within a String with strstr ( )

182

(1)

Finding the Position of a Substring with strpos ( )

182

(1)

Extracting Part of a String with substr ( )

183

(1)

Tokenizing a String with strtok ( )

183

(2)

Manipulating Strings with PHP

185

(7)

Cleaning Up a String with trim ( ), Itrim ( ), and strip_tags ( )

185

(2)

Replacing a Portion of a String Using substr_replace ( )

187

(1)

Replacing Substrings Using str_replace

187

(1)

Converting Case

188

(1)

Wrapping Text with wordwrap ( ) and n12br ( )

189

(2)

Breaking Strings into Arrays with explode ( )

191

(1)

Using Date and Time Functions in PHP

192

(6)

Getting the Date with time ( )

192

(1)

Converting a Timestamp with getdate ( )

192

(2)

Converting a Timestamp with date ( )

194

(2)

Creating Timestamps with mktime ( )

196

(1)

Testing a Date with checkdate ( )

197

(1)

Summary

198

(1)

Q&A

198

(1)

Workshop

198

(3)

Quiz

198

(1)

Answers

199

(1)

Activities

200

(1)

Working with Forms

201

(22)

Creating a Simple Input Form

201

(2)

Accessing Form Input with User-Defined Arrays

203

(3)

Combining HTML and PHP Code on a Single Page

206

(2)

Using Hidden Fields to Save State

208

(2)

Redirecting the User

210

(1)

Sending Mail on Form Submission

211

(6)

System Configuration for the mail ( ) Function

212

(1)

Creating the Form

213

(1)

Creating the Script to Send the Mail

214

(2)

Formatting Your Mail with HTML

216

(1)

Working with File Uploads

217

(4)

Creating the File Upload Form

218

(1)

Creating the File Upload Script

219

(2)

Summary

221

(1)

Workshop

221

(2)

Quiz

221

(1)

Answers

222

(1)

Activities

222

(1)

Working with Cookies and User Sessions

223

(14)

Introducing Cookies

223

(2)

The Anatomy of a Cookie

224

(1)

Setting a Cookie with PHP

225

(2)

Deleting a Cookie

226

(1)

Session Function Overview

227

(1)

Starting a Session

227

(1)

Working with Session Variables

228

(5)

Passing Session IDs in the Query String

233

(1)

Destroying Sessions and Unsetting Variables

233

(1)

Using Sessions in an Environment with Registered Users

234

(1)

Working with Registered Users

234

(1)

Working with User Preferences

235

(1)

Summary

235

(1)

Q&A

236

(1)

Workshop

236

(1)

Quiz

236

(1)

Answers

236

(1)

Activity

236

(1)

Working with Files and Directories

237

(24)

Including Files with include ( )

237

(5)

Returning a Value from an Included Document

239

(1)

Using include ( ) Within Control Structures

239

(2)

Using include_once ( )

241

(1)

The include_path Directive

241

(1)

Validating Files

242

(4)

Checking for Existence with file_exists ( )

242

(1)

A File or a Directory?

242

(1)

Checking the Status of a File

243

(1)

Determining File Size with filesize ( )

243

(1)

Getting Date Information About a File

244

(1)

Creating a Function That Performs Multiple File Tests

245

(1)

Creating and Deleting Files

246

(1)

Opening a File for Writing, Reading, or Appending

247

(1)

Reading from Files

248

(4)

Reading Lines from a File with fgets ( ) and feof ( )

248

(1)

Reading Arbitrary Amounts of Data from a File with fread ( )

249

(2)

Reading Characters from a File with fgetc ( )

251

(1)

Writing or Appending to a File

252

(3)

Writing to a File with fwrite ( ) or fputs ( )

253

(1)

Locking Files with flock ( )

254

(1)

Working with Directories

255

(3)

Creating Directories with mkdir ( )

255

(1)

Removing a Directory with rmdir ( )

255

(1)

Opening a Directory for Reading with opendir ( )

255

(1)

Reading the Contents of a Directory with readdir ( )

256

(2)

Summary

258

(1)

Q&A

258

(1)

Workshop

258

(3)

Quiz

259

(1)

Answers

259

(1)

Activities

260

(1)

Working with the Server Environment

261

(8)

Opening Pipes to and from Processes Using popen ( )

261

(3)

Running Commands with exec ( )

264

(1)

Running Commands with system ( ) or passthru ( )

265

(1)

Summary

266

(1)

Q&A

267

(1)

Workshop

267

(2)

Quiz

267

(1)

Answers

268

(1)

Working with Images

269

(22)

Understanding the Image-Creation Process

269

(1)

A Word About Color

269

(1)

Necessary Modifications to PHP

270

(1)

Obtaining Additional Libraries

270

(1)

Drawing a New Image

271

(4)

Drawing Shapes and Lines

272

(1)

Using a Color Fill

273

(2)

Getting Fancy with Pie Charts

275

(4)

Modifying Existing Images

279

(3)

Image Creation from User Input

282

(3)

Summary

285

(1)

Q&A

286

(1)

Workshop

286

(5)

Quiz

286

(1)

Answers

287

(1)

Activity

287

(4)

Part IV: PHP and MySQL Integration

Understanding the Database Design Process

291

(12)

The Importance of Good Database Design

291

(1)

Types of Table Relationships

292

(4)

One-to-One Relationships

292

(2)

One-to-Many Relationships

294

(1)

Many-to-Many Relationships

294

(2)

Understanding Normalization

296

(3)

Problems with the Flat Table

296

(1)

First Normal Form

297

(1)

Second Normal Form

298

(1)

Third Normal Form

298

(1)

Following the Design Process

299

(1)

Summary

300

(1)

Q&A

301

(1)

Workshop

301

(2)

Quiz

301

(1)

Answers

301

(1)

Activity

301

(2)

Learning Basic SQL Commands

303

(46)

Learning the MySQL Data Types

303

(4)

Numeric Data Types

304

(1)

Date and Time Types

305

(1)

String Types

306

(1)

Learning the Table Creation Syntax

307

(1)

Using the Insert Command

308

(2)

A Closer Look at Insert

309

(1)

Using the Select Command

310

(3)

Ordering Select Results

311

(1)

Limiting Your Results

312

(1)

Using Where in Your Queries

313

(2)

Using Operators in Where Clauses

314

(1)

String Comparison Using Like

314

(1)

Selecting from Multiple Tables

315

(5)

Using Join

317

(3)

Using the Update Command to Modify Records

320

(3)

Conditional Updates

321

(1)

Using Existing Column Values with Update

322

(1)

Using the Replace Command

323

(1)

Using the Delete Command

324

(2)

Conditional Delete

324

(2)

Frequently Used String Functions in MySQL

326

(7)

Length and Concatenation Functions

326

(2)

Trimming and Padding Functions

328

(2)

Location and Position Functions

330

(1)

Substring Functions

331

(1)

String Modification Functions

332

(1)

Using Date and Time Functions in MySQL

333

(12)

Working with Days

333

(3)

Working with Months and Years

336

(1)

Working with Weeks

337

(1)

Working with Hours, Minutes, and Seconds

338

(1)

Formatting Dates and Times with MySQL

339

(2)

Performing Date Arithmetic with MySQL

341

(2)

Special Functions and Conversion Features

343

(2)

Summary

345

(1)

Q&A

346

(1)

Workshop

347

(2)

Quiz

348

(1)

Answers

348

(1)

Activity

348

(1)

Interacting with MySQL Using PHP

349

(14)

Connecting to MySQL with PHP

349

(4)

Using mysql_connect ( )

350

(1)

Executing Queries

351

(2)

Retrieving Error Messages

353

(1)

Working with MySQL Data

353

(6)

Inserting Data with PHP

354

(3)

Retrieving Data with PHP

357

(2)

Additional MySQL Functions in PHP

359

(1)

Summary

359

(1)

Workshop

360

(3)

Quiz

360

(1)

Answers

360

(3)

Part V: Basic Projects

Managing a Simple Mailing List

363

(12)

Developing the Subscription Mechanism

363

(7)

Creating the subscribers Table

364

(1)

Creating the Subscription Form

364

(6)

Developing the Mailing Mechanism

370

(3)

Summary

373

(1)

Q&A

373

(1)

Workshop

374

(1)

Quiz

374

(1)

Answers

374

(1)

Creating an Online Address Book

375

(24)

Planning and Creating the Database Tables

375

(3)

Creating a Menu

378

(1)

Creating the Record Addition Mechanism

379

(4)

Viewing Records

383

(7)

Creating the Record Deletion Mechanism

390

(1)

Adding Subentries to a Record

391

(6)

Summary

397

(1)

Workshop

397

(2)

Quiz

397

(1)

Answers

398

(1)

Activities

398

(1)

Creating a Simple Discussion Forum

399

(18)

Designing the Database Tables

399

(1)

Creating the Input Forms and Scripts

400

(4)

Displaying the Topic List

404

(4)

Displaying the Posts in a Topic

408

(3)

Adding Posts to a Topic

411

(4)

Summary

415

(1)

Q&A

415

(1)

Workshop

415

(2)

Quiz

415

(1)

Answers

416

(1)

Activity

416

(1)

Creating an Online Storefront

417

(12)

Planning and Creating the Database Tables

417

(4)

Inserting Records into the store_categories Table

419

(1)

Inserting Records into the store_items Table

420

(1)

Inserting Records into the store_item_size Table

420

(1)

Inserting Records into the store_item_color Table

421

(1)

Displaying Categories of Items

421

(4)

Displaying Items

425

(3)

Summary

428

(1)

Workshop

428

(1)

Quiz

428

(1)

Answers

428

(1)

Creating a Shopping Cart Mechanism

429

(14)

Planning and Creating the Database Tables

429

(2)

Integrating the Cart with Your Storefront

431

(8)

Adding Items to Your Cart

434

(1)

Viewing the Cart

435

(3)

Removing Items from Your Cart

438

(1)

Payment Methods and the Checkout Sequence

439

(2)

Creating the Checkout Form

439

(1)

Performing the Checkout Actions

440

(1)

Summary

441

(1)

Workshop

441

(2)

Quiz

441

(1)

Answers

442

(1)

Creating a Simple Calendar

443

(22)

Building a Simple Display Calendar

443

(14)

Checking User Input

443

(1)

Building the HTML Form

444

(3)

Creating the Calendar Table

447

(3)

Adding Events to the Calendar

450

(7)

Creating a Calendar Library

457

(6)

Summary

463

(1)

Q&A

464

(1)

Workshop

464

(1)

Quiz

464

(1)

Answers

464

(1)

Activity

464

(1)

Restricting Access to Your Applications

465

(20)

Authentication Overview

465

(2)

Client Authentication

466

(1)

Apache Authentication Module Functionality

467

(5)

File-Based Authentication

468

(2)

Database File-Based Access Control

470

(2)

Using Apache for Access Control

472

(3)

Implementing Access Rules

472

(1)

Evaluating Access Rules

473

(2)

Combining Apache Access Methods

475

(1)

Limiting Access Based on HTTP Methods

475

(1)

Restricting Access Based on Cookie Values

476

(6)

Creating the Authorized Users Table

477

(1)

Creating the Login Form and Script

478

(3)

Testing for the auth Cookie

481

(1)

Summary

482

(1)

Q&A

482

(1)

Workshop

483

(2)

Quiz

483

(1)

Answers

483

(1)

Activity

483

(2)

Logging and Monitoring Web Server Activity

485

(18)

Standard Apache Access Logging

485

(6)

Deciding What to Log

486

(3)

Logging Accesses to Files

489

(1)

Logging Accesses to a Program

490

(1)

Standard Apache Error Logging

491

(2)

Logging Errors to a File

491

(1)

Logging Errors to a Program

492

(1)

The syslog Daemon Argument

492

(1)

The Log Level Directive

492

(1)

Managing Apache Logs

493

(3)

Resolving Hostnames

493

(1)

Log Rotation

494

(1)

Merging and Splitting Logs

494

(1)

Log Analysis

495

(1)

Monitoring Error Logs

495

(1)

Logging Custom Information to a Database

496

(4)

Creating the Database Table

496

(1)

Creating the PHP Code Snippet

496

(1)

Creating Sample Reports

497

(3)

Summary

500

(1)

Q&A

500

(1)

Workshop

500

(3)

Quiz

500

(1)

Answers

501

(2)

Application Localization

503

(14)

About Internationalization and Localization

503

(1)

About Character Sets

504

(1)

Environment Modifications

505

(2)

Configuration Changes to Apache

506

(1)

Configuration Changes to PHP

506

(1)

Configuration Changes to MySQL

507

(1)

Creating a Localized Page Structure

507

(5)

Summary

512

(1)

Q&A

513

(1)

Workshop

513

(4)

Quiz

513

(1)

Answers

513

(4)

Part VI: Administration and Fine-Tuning

Apache Performance Tuning and Virtual Hosting

517

(18)

Scalability Issues

517

(4)

Operating System Limits

518

(1)

Performance-Related Apache Settings

519

(2)

Load Testing with ApacheBench

521

(2)

Proactive Performance Tuning

523

(2)

Mapping Files to Memory

523

(1)

Distributing the Load

524

(1)

Caching

524

(1)

Reduce Transmitted Data

524

(1)

Network Settings

525

(1)

Preventing Abuse

525

(1)

Robots

525

(1)

Implementing Virtual Hosting

526

(5)

IP-Based Virtual Hosting

527

(1)

Name-Based Virtual Hosts

528

(2)

Mass Virtual Hosting

530

(1)

Summary

531

(1)

Q&A

532

(1)

Workshop

533

(2)

Quiz

533

(1)

Answers

533

(2)

Setting Up a Secure Web Server

535

(16)

The Need for Security

535

(1)

The SSL Protocol

535

(6)

Addressing the Need for Confidentiality

536

(2)

Addressing the Need for Integrity

538

(1)

Addressing the Need for Authentication

538

(3)

Obtaining and Installing SSL Tools

541

(3)

OpenSSL

541

(1)

The mod_ssl Apache Module

542

(2)

Managing Certificates

544

(3)

Creating a Key Pair

544

(1)

Creating a Certificate Signing Request

545

(1)

Creating a Self-Signed Certificate

546

(1)

SSL Configuration

547

(1)

Starting the Server

547

(1)

Summary

548

(1)

Q&A

548

(1)

Workshop

549

(2)

Quiz

549

(1)

Answers

549

(2)

Optimizing and Tuning MySQL

551

(16)

Building an Optimized Platform

551

(2)

Using the benchmark ( ) Function

552

(1)

MySQL Startup Options

553

(2)

Key Startup Parameters

554

(1)

Optimizing Your Table Structure

555

(1)

Optimizing Your Queries

556

(1)

Using the FLUSH Command

557

(2)

Using the SHOW Command

559

(5)

Retrieving Information About Databases and Tables

560

(1)

Retrieving Table Structure Information

561

(2)

Retrieving System Status

563

(1)

Summary

564

(1)

Q&A

565

(1)

Workshop

566

(1)

Quiz

566

(1)

Answers

566

(1)

Activities

566

(1)

Software Upgrades

567

(8)

Staying in the Loop

567

(2)

When to Upgrade

568

(1)

Upgrading MySQL

569

(1)

Upgrading Apache

569

(2)

Modifying Apache Without Upgrading

570

(1)

Upgrading PHP

571

(1)

Summary

571

(1)

Workshop

572

(3)

Quiz

572

(1)

Answers

572

(3)

Part VII: Looking Toward the Future

Features and Backward Compatibility of PHP 5.0

575

(6)

What was Wrong with PHP 4?

575

(1)

The New Object Model

576

(2)

Additional New Features

578

(1)

SQLite

578

(1)

XML Support

579

(1)

So, When Should I Install PHP 5?

579

(1)

Backward Compatibility

579

(1)

Summary

580

(1)

Q&A

580

(1)

Features and Backward Compatibility of MySQL

581

(8)

Using Subqueries

581

(4)

Subquery Examples for Time Tracking

582

(3)

Internationalization Enhancements

585

(1)

Additional New Functionality

585

(1)

Looking Further Ahead to MySQL 5.0

586

(1)

Summary

587

(1)

Q&A

587

(1)

Workshop

587

(2)

Quiz

587

(1)

Answers

587

(2)

Index

589

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself PHP, MySQL and Apache All in One

Sams Teach Yourself PHP, MySQL and Apache All in One

9780672327254

0672327252

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Sams Teach Yourself PHP, MySQL and Apache All in One

Sams Teach Yourself PHP, MySQL and Apache All in One

9780672327254

0672327252

Summary

Author Biography

Table of Contents

Supplemental Materials

Write a Review

Related Products