Amazon no longer offers textbook rentals. We do!

Php Programming with MySQL

by: Gosselin, Don

Php Programming with MySQL

by: Gosselin, Don

ISBN 13:
9780619216870
ISBN 10:
0619216875
Edition: 1st
Format: Paperback
Copyright: 12/26/2005
Publisher: Course Technology
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

PHP Programming with MySQL, by Don Gosselin is the first true academic textbook in the market to combine PHP with MySQL. This book covers one of the fastest growing technology combinations for developing interactive Web sites. With growth attributed to its open-source nature and usability amongst non-programmers, this text is accessible to users with little programming or database experience and suits personal Web development projects, as well as small to medium business Web development needs.

Preface

xix

Introduction to Web Development

(50)

The World Wide Web

(14)

HTML Documents

(1)

Basic HTML Syntax

(3)

Creating an HTML Document

(3)

Web Communication Protocols

(2)

Publishing Your Web Site

(4)

Working with Well-Formed Web Pages

(16)

XHTML Document Type Definitions (DTDs)

(3)

Writing Well-Formed Documents

(2)

Cascading Style Sheets

(7)

The Content-Type <meta> Element

(1)

Validating Web Pages

(2)

Understanding Web Development

(7)

Client/Server Architecture

(2)

JavaScript and Client-Side Scripting

(2)

Server-Side Scripting and PHP

(2)

Should You Use Client-Side or Server-Side Scripting?

(1)

Chapter Summary

(1)

Review Questions

(4)

Hands-On Projects

(5)

Case Projects

(2)

Getting Started with PHP

(56)

Building a Web Development Environment

(4)

Understanding Binary and Source Code Installations

(1)

Getting Help

(2)

Installing and Configuring a Web Server

(12)

Installing and Running Apache on UNIX and Linux

(1)

Installing and Running Apache on Windows

(2)

Installing and Running Internet Information Services on Windows

(1)

Testing Your Web Server

(3)

Configuring Apache

(2)

Configuring Internet Information Services

(2)

Installing PHP

(5)

Installing PHP on UNIX and Linux Systems Running Apache

(1)

Installing PHP on Windows Running Apache or IIS

(1)

Configuring Apache for PHP

(1)

Configuring PHP

(1)

Installing and Running MySQL

(6)

Installing and Running MySQL on UNIX and Linux

(3)

Installing MySQL on Windows

(2)

Testing the MySQL Server

(1)

Creating Basic PHP Scripts

(20)

Creating PHP Code Blocks

(8)

Understanding Functions

(1)

Displaying Script Results

(5)

Creating Multiple Code Declaration Blocks

(3)

Case Sensitivity in PHP

(1)

Adding Comments to a PHP Script

(1)

Chapter Summary

(1)

Review Questions

100

(2)

Hands-On Projects

102

(3)

Case Projects

105

(2)

Working with Data Types and Operators

107

(50)

Using Variables and Constants

108

(7)

Naming Variables

108

(1)

Declaring and Initializing Variables

108

(1)

Displaying Variables

109

(2)

Modifying Variables

111

(2)

Defining Constants

113

(2)

Working with Data Types

115

(10)

Numeric Data Types

117

(1)

Boolean Values

118

(1)

Arrays

119

(6)

Building Expressions

125

(19)

Arithmetic Operators

126

(8)

Assignment Operators

134

(3)

Comparison and Conditional Operators

137

(4)

Logical Operators

141

(3)

Special Operators

144

(1)

Type Casting

144

(3)

Understanding Operator Precedence

147

(1)

Chapter Summary

148

(1)

Review Questions

149

(3)

Hands-On Projects

152

(3)

Case Projects

155

(2)

Functions and Control Structures

157

(50)

Working with Functions

158

(4)

Defining Functions

158

(1)

Calling Functions

159

(1)

Returning Values

160

(2)

Understanding Variable Scope

162

(8)

The global Keyword

163

(1)

Using Autoglobals

164

(6)

Making Decisions

170

(13)

if Statements

171

(3)

if...else Statements

174

(2)

Nested if and if...else Statements

176

(3)

switch Statements

179

(4)

Repeating Code

183

(12)

while Statements

183

(5)

do...while Statements

188

(2)

for Statements

190

(3)

foreach Statements

193

(2)

Chapter Summary

195

(1)

Review Questions

196

(3)

Hands-On Projects

199

(5)

Case Projects

204

(3)

Manipulating Strings

207

(50)

Constructing Text Strings

208

(10)

Working with String Operators

212

(1)

Adding Escape Characters and Sequences

213

(3)

Simple and Complex String Syntax

216

(2)

Parsing Strings

218

(14)

Counting Characters and Words in a String

218

(2)

Finding and Extracting Characters and Substrings

220

(4)

Replacing Characters and Substrings

224

(2)

Dividing Strings into Smaller Pieces

226

(4)

Converting Between Strings and Arrays

230

(2)

Comparing Strings

232

(6)

String Comparison Functions

234

(3)

Determining the Similarity of Two Strings

237

(1)

Determining if Words Are Pronounced Similarly

237

(1)

Handling Form Submissions

238

(5)

Using a Single Script to Display and Process a Form

239

(1)

Validating Submitted Data

240

(3)

Chapter Summary

243

(1)

Review Questions

244

(2)

Hands-On Projects

246

(9)

Case Projects

255

(2)

Working with Files and Directories

257

(54)

Opening and Closing File Streams

258

(6)

Opening a File Stream

258

(5)

Closing a File Stream

263

(1)

Writing Data to Files

264

(14)

Writing an Entire File

265

(5)

Handling Magic Quotes

270

(3)

Writing Data Incrementally

273

(2)

Locking Files

275

(3)

Reading Data from Files

278

(8)

Reading an Entire File

278

(5)

Reading Data Incrementally

283

(3)

Managing Files and Directories

286

(12)

Working with Directories

286

(4)

Obtaining File and Directory Information

290

(4)

Copying and Moving Files

294

(2)

Renaming Files and Directories

296

(1)

Removing Files and Directories

296

(2)

Chapter Summary

298

(1)

Review Questions

299

(3)

Hands-On Projects

302

(6)

Case Projects

308

(3)

Manipulating Arrays

311

(52)

Manipulating Elements

312

(13)

Adding and Removing Elements from the Beginning of an Array

315

(2)

Adding and Removing Elements from the End of an Array

317

(2)

Adding and Removing Elements Within an Array

319

(3)

Removing Duplicate Elements

322

(3)

Declaring and Initializing Associative Arrays

325

(4)

Iterating Through an Array

329

(3)

Finding and Extracting Elements and Values

332

(5)

Determining if a Value Exists

332

(3)

Determining if a Key Exists

335

(1)

Returning a Portion of an Array

336

(1)

Manipulating Arrays

337

(9)

Sorting Arrays

337

(5)

Combining Arrays

342

(2)

Comparing Arrays

344

(2)

Understanding Multidimensional Arrays

346

(8)

Creating Two-Dimensional Indexed Arrays

346

(4)

Creating Two-Dimensional Associative Arrays

350

(1)

Creating Multidimensional Arrays with a Single Statement

351

(1)

Working with Additional Dimensions

352

(2)

Chapter Summary

354

(1)

Review Questions

355

(2)

Hands-On Projects

357

(4)

Case Projects

361

(2)

Working with Databases and MySQL

363

(54)

Introduction to Databases

364

(10)

Understanding Relational Databases

365

(4)

Working with Database Management Systems

369

(4)

Querying Databases with Structured Query Language

373

(1)

Getting Started with MySQL

374

(9)

Logging in to MySQL

375

(3)

Working with the MySQL Monitor

378

(2)

Understanding MySQL Identifiers

380

(1)

Getting Help with MySQL Commands

381

(2)

Working with MySQL Databases

383

(4)

Selecting a Database

383

(2)

Creating Databases

385

(1)

Deleting Databases

386

(1)

Managing User Accounts

387

(7)

Securing the Initial MySQL Accounts

387

(2)

Creating Users

389

(4)

Deleting Users

393

(1)

Defining Tables

394

(4)

Specifying Field Data Types

394

(1)

Creating Tables

395

(2)

Deleting Tables

397

(1)

Working with Records

398

(10)

Adding Records

398

(2)

Retrieving Records

400

(1)

Sorting Query Results

401

(3)

Filtering Query Results

404

(2)

Updating Records

406

(1)

Deleting Records

407

(1)

Chapter Summary

408

(1)

Review Questions

409

(3)

Hands-On Projects

412

(3)

Case Projects

415

(2)

Manipulating MySQL Databases with PHP

417

(60)

Connecting to MySQL with PHP

418

(6)

Enabling MySQL Support in PHP

418

(2)

Opening and Closing a MySQL Connection

420

(3)

Selecting a Database

423

(1)

Handling MySQL Errors

424

(10)

Suppressing Errors with the Error Control Operator

427

(1)

Terminating Script Execution

428

(2)

Reporting MySQL Errors

430

(4)

Executing SQL Statements

434

(9)

Working with Query Results

436

(5)

Accessing Query Result Information

441

(1)

Closing Query Results

442

(1)

Working with Databases and Tables

443

(8)

Creating and Deleting Databases

443

(4)

Creating and Deleting Tables

447

(4)

Manipulating Records

451

(14)

Adding, Deleting, and Updating Records

451

(11)

Returning Information on Affected Records

462

(3)

Chapter Summary

465

(1)

Review Questions

466

(3)

Hands-On Projects

469

(5)

Case Projects

474

(3)

Managing State Information

477

(48)

Understanding State Information

478

(6)

Using Hidden Form Fields to Save State Information

484

(6)

Using Query Strings to Save State Information

490

(2)

Using Cookies to Save State Information

492

(14)

Creating Cookies

492

(1)

The name and value Arguments

493

(4)

The expires Argument

497

(2)

The path Argument

499

(1)

The domain Argument

500

(1)

The secure Argument

500

(1)

Reading Cookies

500

(6)

Deleting Cookies

506

(1)

Using Sessions to Save State Information

506

(8)

Starting a Session

507

(1)

Working with Session Variables

508

(4)

Deleting a Session

512

(2)

Chapter Summary

514

(1)

Review Questions

515

(2)

Hands-On Projects

517

(6)

Case Projects

523

(2)

Developing Object-Oriented PHP

525

(54)

Introduction to Object-Oriented Programming

526

(5)

Understanding Encapsulation

527

(1)

Object-Oriented Programming and Classes

528

(3)

Using Objects in PHP Scripts

531

(16)

Working with Database Connections as Objects

533

(8)

Defining Custom PHP Classes

541

(5)

Collecting Garbage

546

(1)

Declaring Data Members

547

(5)

What Is Information Hiding?

547

(1)

Using Access Specifiers

548

(2)

Serializing Objects

550

(2)

Working with Member Functions

552

(14)

Initializing with Constructor Functions

553

(2)

Cleaning Up with Destructor Functions

555

(1)

Writing Accessor Functions

556

(4)

Serializing Functions

560

(6)

Chapter Summary

566

(1)

Review Questions

567

(2)

Hands-On Projects

569

(8)

Case Projects

577

(2)

Error Handling and Debugging

579

(48)

Understanding Logic and Debugging

580

(4)

Syntax Errors

582

(1)

Run-Time Errors

582

(1)

Logic Errors

583

(1)

Handling and Reporting Errors

584

(16)

Printing Errors to the Web Browser

590

(1)

Setting the Error Reporting Level

591

(1)

Logging Errors to a File

592

(2)

Implementing Custom Error Handling

594

(6)

Using Basic Debugging Techniques

600

(15)

Examining Your Code

600

(4)

Tracing Errors with echo ( ) Statements

604

(6)

Using Comments to Locate Bugs

610

(1)

Combining Debugging Techniques

611

(2)

Analyzing Logic

613

(2)

Chapter Summary

615

(1)

Review Questions

616

(3)

Hands-On Projects

619

(5)

Case Projects

624

(3)

APPENDIX A Working with Regular Expressions

627

(12)

Understanding Regular Expressions

627

(2)

Writing Regular Expression Patterns

629

(1)

Matching Any Character

630

(1)

Matching Characters at the Beginning or End of a String

631

(1)

Matching Special Characters

631

(1)

Specifying Quantity

632

(1)

Specifying Subexpressions

633

(1)

Defining Character Classes

634

(3)

Matching Multiple Pattern Choices

637

(2)

APPENDIX B Formatting Strings

639

(8)

Using the printf() and sprintf() Functions

639

(1)

Specifying Types

640

(1)

Determining Decimal Number Precision

641

(1)

Specifying Padding

642

(2)

Formatting Numbers

644

(1)

Formatting Alignment

645

(2)

APPENDIX C Processing XML

647

(16)

The Basics of XML

647

(1)

The XML Declaration

648

(1)

Parsing XML Documents

649

(1)

Writing Well-Formed Documents

650

(4)

All XML Documents Must Have a Root Element

650

(1)

XML Is Case Sensitive

651

(1)

All XML Elements Must Have Closing Tags

651

(1)

XML Elements Must Be Properly Nested

652

(1)

Attribute Values Must Appear Within Quotation Marks

653

(1)

Empty Elements Must Be Closed

654

(1)

Generating XML with PHP

654

(4)

Parsing XML with SimpleXML Functions

658

(5)

APPENDIX D Secure Coding with PHP

663

(1)

Understanding PHP Security Issues

663

(1)

Disabling the register_globals Directive

664

(1)

Validating Submitted Form Data

664

(1)

Using Sessions to Validate User Identities

665

(1)

Storing Code in External Files

665

(1)

Accessing Databases Through a Proxy User

666

(1)

Handling Magic Quotes

666

(1)

Reporting Errors

667

Amazon no longer offers textbook rentals. We do!

Php Programming with MySQL

Php Programming with MySQL

9780619216870

0619216875

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

Php Programming with MySQL

Php Programming with MySQL

9780619216870

0619216875

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products