Amazon no longer offers textbook rentals. We do!

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

by: Ullman, Larry

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

by: Ullman, Larry

ISBN 13:
9780321336576
ISBN 10:
0321336577
Edition: 2nd
Format: Paperback
Copyright: 01/01/2005
Publisher: Peachpit Pr
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

The follow-up to the bestselling task-based guide to MySQL and PHP, at a price readers will appreciate.

Introduction

Introduction to PHP

(34)

Basic Syntax

(4)

Sending Data to the Web Browser

(4)

Understanding PHP, HTML, and White Space

(5)

Writing Comments

(3)

What Are Variables?

(3)

About Strings

(4)

About Numbers

(4)

About Constants

(3)

Single vs. Double Quotation Marks

(3)

Programming with PHP

(46)

Creating an HTML Form

(4)

Handling an HTML Form

(4)

Managing Magic Quotes

(3)

Conditionals and Operators

(5)

Validating Form Data

(5)

What Are Arrays?

(20)

For and While Loops

(4)

Creating Dynamic Web Sites

(44)

Including Multiple Files

(9)

Handling HTML Forms with PHP Redux

(4)

Making Sticky Forms

(3)

Creating and Calling Your Own Functions

(12)

Variable Scope

110

(4)

Date and Time Functions

114

(4)

Sending Email

118

(7)

Introduction to SQL and MySQL

125

(44)

Choosing Your Column Types

126

(4)

Choosing Other Column Properties

130

(2)

Using the mysql Client

132

(4)

Creating Databases and Tables

136

(3)

Inserting Records

139

(3)

Selecting Data

142

(2)

Using Conditionals

144

(3)

Using LIKE and NOT LIKE

147

(2)

Sorting Query Results

149

(2)

Limiting Query Results

151

(2)

Updating Data

153

(2)

Deleting Data

155

(2)

Using Functions

157

(12)

Advanced SQL and MySQL

169

(42)

Database Design

170

(16)

Performing Joins

186

(4)

Grouping Selected Results

190

(2)

Creating Indexes

192

(3)

Using Different Table Types

195

(3)

Performing FULLTEXT Searches

198

(7)

Database Optimization

205

(6)

Error Handling and Debugging

211

(24)

General Error Types and Debugging

212

(6)

Displaying PHP Errors

218

(1)

Adjusting Error Reporting in PHP

219

(3)

Creating Custom Error Handlers

222

(4)

Logging PHP Errors

226

(3)

PHP Debugging Techniques

229

(3)

SQL and MySQL Debugging Techniques

232

(3)

Using PHP with MySQL

235

(40)

Modifying the Template

236

(1)

Connecting to MySQL and Selecting the Database

237

(4)

Executing Simple Queries

241

(9)

Retrieving Query Results

250

(4)

Ensuring Secure SQL

254

(6)

Counting Returned Records

260

(6)

Updating Records with PHP

266

(9)

Web Application Development

275

(48)

Adjusting Behavior for Server Settings

276

(3)

Sending Values to a Script Manually

279

(4)

Using Hidden Form Inputs

283

(6)

Editing Existing Records

289

(8)

Paginating Query Results

297

(8)

Making Sortable Displays

305

(8)

Understanding HTTP Headers

313

(10)

Cookies and Sessions

323

(52)

Using Cookies

324

(18)

Using Sessions

342

(17)

Sessions and Cookies

359

(9)

Improving Session Security

368

(7)

Web Application Security

375

(46)

More Secure Form Validation

376

(12)

Handling HTML

388

(4)

Validating Data by Type

392

(5)

Form Validation with JavaScript

397

(7)

Regular Expressions

404

(12)

Database Security and Encryption

416

(5)

Extended Topics

421

(52)

Handling File Uploads

422

(12)

PHP and JavaScript

434

(10)

Using Output Buffering

444

(9)

Using the Improved MySQL Extension

453

(5)

New MySQL Features

458

(9)

Using PEAR

467

(6)

Example --- Content Management

473

(54)

Creating the Template

474

(4)

Creating the Basic Pages

478

(4)

Managing URLs

482

(31)

Managing Files

513

(14)

Example --- User Registration

527

(50)

Creating the Templates

528

(4)

Writing the Configuration Scripts

532

(7)

Creating the Home Page

539

(2)

Registration

541

(11)

Activating an Account

552

(4)

Logging In and Logging Out

556

(8)

Password Management

564

(13)

Example --- E-Commerce

577

(56)

Creating the Database

578

(5)

The Administrative Side

583

(16)

Creating the Public Template

599

(4)

The Product Catalog

603

(12)

The Shopping Cart

615

(11)

Recording the Orders

626

(7)

Appendix A: Installation

633

(20)

Installation on Windows

634

(5)

Installation on Mac OS X

639

(4)

MySQL Permissions

643

(5)

Testing Your Installation

648

(2)

Configuring PHP

650

(3)

Appendix B: Reference

653

(10)

PHP

654

(4)

MySQL

658

(5)

Appendix C: Resources

663

(12)

PHP

664

(3)

MySQL

667

(2)

SQL

669

(1)

Security

670

(1)

Other Resources

671

(4)

Index

675

Amazon no longer offers textbook rentals. We do!

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

9780321336576

0321336577

Summary

Table of Contents

Supplemental Materials

Write a Review

Amazon no longer offers textbook rentals. We do!

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide

9780321336576

0321336577

Summary

Table of Contents

Supplemental Materials

Write a Review

Related Products