Web Database Applications With Php and Mysql,9780596005436

Web Database Applications With Php and Mysql

by
Edition: 2nd
ISBN13: 9780596005436
ISBN10: 0596005431
Format: Paperback
Pub. Date: 2004-05-01
Publisher(s): Oreilly & Associates Inc
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $52.49

Buy New

Arriving Soon. Will ship when available.
$49.99
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$47.99
$47.99
Add to Cart

Used Book

We're Sorry
Sold Out

Buy from our Marketplace starting at $2.29

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Successful e-commerce sites rely on a well-designed database and a suite of applications that allow a web front end to interact with it. In fact, this combination is key to any robust web site. In this new and expanded edition of Web Database Applications with PHP and MySQL, experienced web developers will find a mixture of theoretical and practical information on creating web database applications, including detailed information on designing relational databases and web application architectures that interact with them. Throughout the book, the authors use a sample web application using PHP and MySQL on the Apache platform, a potent and popular combination of open source technologies that drive numerous real-world web sites.

Author Biography

Hugh E. Williams is a software design engineer at Microsoft's Windows Live Search in Redmond, WA. Previously, he was the Associate Professor in Information Retrieval at RMIT University in Melbourne, Australia. He's published over 70 research papers and holds around 10 patents, mostly in the search engine area. When not at work Hugh likes to hang out with his family, exercise, watch Richmond play footy, and learn about baseball. Hugh has a PhD from RMIT University. His home page is http://hughwilliams.com.

Since the mid 1990s David Lane has worked as a software engineer and IT manager with the Multimedia Database Systems group at RMIT University in Melbourne, Australia. In that group he has helped to develop and commercialize the Structured Information Manager, a large-scale SGML/XML document repository and a high performance Web server. David has also worked with Australia's largest telecommunications company, Telstra, in areas as diverse as Satellite Communications, Human Factors Research, and Electronic Document Interchange (EDI). David has a Bachelor's degree in Applied Science (majoring in mathematics and computer science) from Swinburne University.

Table of Contents

Preface ix
Database Applications and the Web
1(15)
The Web
2(1)
Three-Tier Architectures
3(13)
The PHP Scripting Language
16(41)
Introducing PHP
16(12)
Conditions and Branches
28(5)
Loops
33(3)
Functions
36(1)
Working with Types
37(6)
User-Defined Functions
43(10)
A Working Example
53(4)
Arrays, Strings, and Advanced Data Manipulation in PHP
57(51)
Arrays
57(19)
Strings
76(11)
Regular Expressions
87(10)
Dates and Times
97(6)
Integers and Floats
103(5)
Introduction to Object-Oriented Programming with PHP 5
108(26)
Classes and Objects
108(16)
Inheritance
124(7)
Throwing and Catching Exceptions
131(3)
SQL and MySQL
134(37)
Database Basics
135(5)
MySQL Command Interpreter
140(2)
Managing Databases and Tables
142(6)
Inserting, Updating, and Deleting Data
148(4)
Querying with SQL Select
152(8)
Join Queries
160(8)
Case Study: Adding a New Wine
168(3)
Querying Web Databases
171(48)
Querying a MySQL Database Using PHP
172(16)
Processing User Input
188(20)
MySQL Function Reference
208(11)
Pear
219(32)
Overview
219(1)
Core Components
220(10)
Packages
230(21)
Writing to Web Databases
251(34)
Database Inserts, Updates, and Deletes
251(19)
Issues in Writing Data to Databases
270(15)
Validation with PHP and JavaScript
285(53)
Validation and Error Reporting Principles
285(2)
Server-Side Validation with PHP
287(20)
JavaScript and Client-Side Validation
307(31)
Sessions
338(31)
Introducing Session Management
339(1)
PHP Session Management
340(7)
Case Study: Using Sessions in Validation
347(10)
When to Use Sessions
357(3)
PHP Session API and Configuration
360(9)
Authentication and Security
369(33)
HTTP Authentication
369(4)
HTTP Authentication with PHP
373(12)
Form-Based Authentication
385(12)
Protecting Data on the Web
397(5)
Errors, Debugging, and Deployment
402(20)
Errors
402(5)
Common Programming Errors
407(5)
Custom Error Handlers
412(10)
Reporting
422(35)
Creating a Report
422(5)
Producing PDF
427(13)
PDF-PHP Reference
440(17)
Advanced Features of Object-Oriented Programming in PHP 5
457(22)
Working with Class Hierarchies
457(5)
Class Type Hints
462(1)
Abstract Classes and Interfaces
462(7)
Freight Calculator Example
469(10)
Advanced SQL
479(62)
Exploring with SHOW
480(1)
Advanced Querying
481(16)
Manipulating Data and Databases
497(8)
Functions
505(8)
Automating Querying
513(3)
Table Types
516(6)
Backup and Recovery
522(5)
Managing Users and Privileges
527(5)
Tuning MySQL
532(9)
Hugh and Dave's Online Wines: A Case Study
541(42)
Functional and System Requirements
542(2)
Application Overview
544(7)
Common Components
551(32)
Managing Customers
583(13)
Code Overview
584(3)
Customer Validation
587(4)
The Customer Form
591(5)
The Shopping Cart
596(22)
Code Overview
597(1)
The Winestore Home Page
598(6)
The Shopping Cart Implementation
604(14)
Ordering and Shipping at the Online Winestore
618(24)
Code Overview
618(2)
Credit Card and Shipping Instructions
620(4)
Finalizing Orders
624(6)
HTML and Email Receipts
630(12)
Searching and Authentication in the Online Winestore
642(25)
Code Overview
643(5)
Searching and Browsing
648(10)
Authentication
658(9)
A. Linux Installation Guide 667(21)
B. Microsoft Windows Installation Guide 688(10)
C. Mac OS X Installation Guide 698(16)
D. Web Protocols 714(12)
E. Modeling and Designing Relational Databases 726
F. Managing Sessions in the Database Tier 716(45)
G. Resources 761(5)
H. The Improved MySQL Library 766(13)
Index 779

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.