How to Do Everything with PHP and MySQL

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

ISBN: 9780072257953 | 0072257954
Cover: Paperback
Copyright: 4/21/2005

Buy New

In Stock Usually Ships in 24-48 Hours

$31.11
eBook

Available Instantly

Online: 1825 Days

Downloadable: Lifetime Access

$29.00

This new release in the popularHow to Do Everythingseries explains how to build open source web applications with MySQL and PHP 5. Using these two tools, you'll be able to create highly functional, interactive web sites easily. Follow along with a step-by-step sample application and, as a bonus, download three full-length case studies complete with code trees.

Acknowledgments

Introduction

xiii

PART I Learning the Basics

Introducing PHP and MySQL

(20)

Server-Side Applications

(1)

... And the Databases That Love Them

(2)

The PHP Story

(4)

History

(1)

Features

(2)

The MySQL Story

(5)

History

(1)

Features

(4)

PHP and MySQL: The Well-Matched Couple

(4)

Architecture

(2)

Sample Applications

(1)

Summary

(3)

Setting Up a PHP-MySQL Development Environment

(36)

Obtaining the Software

(2)

Installing and Configuring the Software

(24)

Installing on UNIX

(9)

Installing on Windows

(15)

Testing the Software

(3)

Testing MySQL

(1)

Testing Apache

(1)

Testing Apache and PHP

(2)

Performing Postinstallation Steps

(2)

Setting the MySQL Super-User Password

(1)

Configuring MySQL and Apache to Start Automatically

(1)

Summary

(4)

PART II Learning PHP

Using Variables, Statements, and Operators

(20)

Embedding PHP in HTML

(3)

Writing Statements and Comments

(1)

Storing Values in Variables

(3)

Assigning and Using Variable Values

(1)

Saving Form Input in Variables

(1)

Understanding Simple Data Types

(4)

Detecting the Data Type of a Variable

(3)

Using Operators to Manipulate and Compare Variables

(6)

Using Arithmetic Operators

(2)

Using String Operators

(1)

Using Comparison Operators

(2)

Using Logical Operators

(1)

Using the Auto-Increment and Auto-Decrement Operators

(1)

Understanding Operator Precedence

(1)

Summary

(3)

Using Conditional Statements and Loops

(16)

Adding Decision-Making Capabilities with Conditional Statements

(6)

Using the if ( ) Statement

(3)

Using the switch ( ) Statement

(2)

Nesting Conditional Statements

(1)

Merging Forms and Their Result Pages with Conditional Statements

(2)

Repeating Actions with Loops

(5)

Using the while ( ) Loop

(1)

Using the do ( ) Loop

(1)

Using the for ( ) Loop

(2)

Controlling Loop Iteration with break and continue

(1)

Summary

(2)

Using Arrays and Custom Functions

(20)

Using Arrays to Group Related Values

(10)

Creating an Array

(1)

Modifying Array Elements

(1)

Processing Arrays with Loops

100

(2)

Grouping Form Selections with Arrays

102

(2)

Using Array Functions

104

(2)

Creating User-Defined Functions

106

(7)

Defining and Invoking Functions

107

(1)

Using Arguments and Return Values

108

(2)

Defining Global and Local Variables

110

(2)

Importing Function Definitions

112

(1)

Summary

113

(2)

Using Files, Sessions, Cookies, and External Programs

115

(18)

Reading and Writing Files

116

(7)

Reading Data from a File

116

(3)

Writing Data to a File

119

(1)

Testing File Attributes

120

(2)

Obtaining Directory Listings

122

(1)

Managing Sessions and Using Session Variables

123

(3)

Creating a Session and Registering Session Variables

124

(1)

Destroying a Session

125

(1)

Storing Data in Cookies

126

(4)

Setting Cookies

127

(1)

Retrieving Cookie Data

128

(1)

Deleting Cookies

128

(1)

Dealing with Dates and Times

129

(1)

Executing External Programs

130

(1)

Summary

131

(2)

Sample Application: Session-Based Shopping Cart

133

(16)

Understanding Requirements

134

(1)

Retrieving Catalog Data

134

(2)

Creating the Shopping Cart

136

(1)

Calculating Costs

137

(1)

Handling Cart Updates

138

(1)

Putting It All Together

139

(5)

Summary

144

(5)

PART III Learning MySQL

Understanding an RDBMS

149

(12)

Understanding a Relational Database

150

(4)

Understanding Tables, Records, and Fields

151

(1)

Understanding Primary and Foreign Keys

151

(3)

Understanding SQL and SQL Queries

154

(2)

Understanding Database Normalization

156

(1)

Using the MySQL Command-Line Client

156

(3)

Interacting with MySQL Through a Graphical Client

159

(1)

Summary

160

(1)

Working with Databases and Tables

161

(20)

Creating Databases

163

(1)

Creating Tables

163

(10)

Specifying Field Data Types

164

(4)

Selecting the Most Appropriate Data Type

168

(1)

Adding Field Modifiers and Keys

168

(2)

Selecting a Table Type

170

(3)

Altering Tables

173

(2)

Altering Table and Field Names

173

(1)

Altering Field Properties

173

(1)

Adding and Removing Fields and Keys

174

(1)

Altering Table Types

175

(1)

Backing Up and Restoring Databases and Tables

175

(2)

Backing Up Databases and Tables

175

(1)

Restoring Databases and Tables from Backup

176

(1)

Dropping Databases and Tables

177

(1)

Viewing Database, Table, and Field Information

178

(2)

Summary

180

(1)

Editing Records and Performing Queries

181

(26)

Inserting Records

182

(2)

Editing and Deleting Records

184

(2)

Performing Queries

186

(18)

Retrieving Specific Columns

187

(1)

Filtering Records with a Where Clause

187

(1)

Using Operators

188

(3)

Sorting Records and Eliminating Duplicates

191

(1)

Limiting Results

192

(1)

Using Built-In Functions

193

(1)

Grouping Records

194

(2)

Joining Tables

196

(5)

Using Subqueries

201

(2)

Using Table and Column Aliases

203

(1)

Summary

204

(3)

Using the MySQL Security System

207

(12)

Understanding the Need for Access Control

208

(1)

Understanding How MySQL Access Control Works

209

(1)

Assigning, Revoking, and Viewing User Privileges

210

(3)

Working with User Accounts and Password

213

(4)

Creating and Removing User Accounts

214

(1)

Altering User Passwords

215

(2)

Summary

217

(2)

Sample Application: Order Tracking System

219

(20)

Understanding Requirements

220

(1)

Creating an Optimized Database Design

221

(4)

Designing the Customer Tables

221

(1)

Designing the Product Tables

222

(2)

Designing the Order Table

224

(1)

Creating and Populating the Tables

225

(3)

Querying the Database

228

(8)

Summary

236

(3)

PART IV Using PHP with MySQL

Querying a MySQL Database with PHP

239

(20)

Using MySQL and PHP Together

240

(4)

Managing Database Connections

244

(3)

Performing Queries

247

(1)

Processing Result Sets

248

(6)

Queries Which Return Data

248

(4)

Queries That Alter Data

252

(2)

Handling Errors

254

(1)

Using Ancillary Functions

254

(3)

Summary

257

(2)

Validating User Input

259

(28)

Setting Input Constraints at the Database Layer

260

(4)

Using the Null Modifier

260

(2)

Using the Unique Modifier

262

(1)

Using Field Data Types

263

(1)

Validating Input at the Application Layer

264

(22)

Checking for Required Values

264

(2)

Restricting the Size of Input Data

266

(2)

Checking the Type of Input Data

268

(6)

Checking for Illegal Input Values

274

(3)

Validating Dates

277

(2)

Validating Multiple-Choice Input

279

(2)

Matching Patterns

281

(5)

Summary

286

(1)

Formatting Query Output

287

(44)

Formatting Character Data

288

(18)

Concatenating String Values

289

(4)

Padding String Values

293

(4)

Altering String Case

297

(3)

Dealing with Special Characters

300

(6)

Formatting Numeric Data

306

(10)

Using Decimal and Comma Separators

306

(6)

Formatting Currency Values

312

(4)

Formatting Dates and Times

316

(9)

Paginating Large Result Sets

325

(3)

Summary

328

(3)

Sample Application: News Publishing System

331

(32)

Understanding Requirements

332

(1)

Designing the Database

333

(1)

Listing and Displaying News Items

334

(8)

Listing News Items

335

(4)

Displaying Story Content

339

(3)

Manipulating News Items

342

(16)

Listing News Items

342

(2)

Adding News Items

344

(5)

Deleting News Items

349

(2)

Editing News Items

351

(7)

Protecting the Administration Module

358

(3)

Summary

361

(2)

Index

363

Please wait while the item is added to your bag...

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

How to Do Everything with PHP and MySQL

Summary

Author Biography

Table of Contents

Supplemental Materials