Dr. S. R. Lasker Library Online Catalogue

Home      Library Home      Institutional Repository      E-Resources      MyAthens      EWU Home

Amazon cover image
Image from Amazon.com

Web database applications with PHP & MySQL / Hugh E. Williams and David Lane.

By: Williams, Hugh EContributor(s): Lane, David (David John), 1964-Material type: TextTextLanguage: English Publication details: Mumbai ; Shroff Publishers and Distributors, c2002. Edition: 1st edDescription: xvi, 563 p. : ill. ; 24 cmISBN: 0596000413; 9780596000417; 8173663475Subject(s): PHP (Computer program language) | Web sites -- DesignDDC classification: 004.678 LOC classification: QA76.73.P224 | W55 2002Online resources: Contributor biographical info | Publisher description | Table of contents only | OCLC WorldCat | E-Book Fulltext
Contents:
Preface 1. Database Applications and the Web Three-Tier Architectures The Client Tier The Middle Tier The Database Tier Our Case Study 2. PHP Introducing PHP Conditions and Branches Loops A Worked Example Arrays Strings Regular Expressions Date and Time Functions Integer and Float Functions User-Defined Functions Objects Common Mistakes 3. MySQL and SQL Database Basics Quick Start Guide MySQL Command Interpreter Managing Databases, Tables, and Indexes Inserting, Updating, and Deleting Data Querying with SQL SELECT Join Queries Modifying the Database Functions More on SQL and MySQL 4. Querying Web Databases Connecting to a MySQL Database Formatting Results Case Study: The Front-Page Panel Interacting with Other DBMSs Using PHP 5. User-Driven Querying User Input Querying with User Input Case Study: Previous and Next Browsing Case Study: Producing a select List 6. Writing to Web Databases Database Inserts, Updates, and Deletes Issues in Writing Data to Databases 7. Validation on the Server and Client Validation and Error Reporting for Web Database Applications Server-Side Validation Client-Side Validation with JavaScript 8. Sessions Building Applications That Keep State Session Management Over the Web PHP Session Management Case Study: Adding Sessions to the Winestore When to Use Sessions 9. Authentication and Security HTTP Authentication HTTP Authentication with PHP Authentication Using a Database Web Database Applications and Authentication Protecting Data on the Web 10. Winestore Customer Management Overview of the Winestore Application Customer Management Authenticating Users The Winestore Include Files 11. The Winestore Shopping Cart The Winestore Home Page The Shopping Cart Architecture Managing Redirection 12. Ordering and Shipping at the Winestore Finalizing Orders HTML and Email Receipts 13. Related Topics Automated Housekeeping Templates Searching and Browsing A. Installation Guide B. Internet and Web Protocols C. Modeling and Designing Relational Databases D. Managing Sessions in the Database Tier E. Resources Index
Summary: This volume offers Web developers a mixture of theoretical and practical information on creating Web database applications. Using PHP, and MySQL, it offers detailed information on designing relational databases and Web application architecture.
List(s) this item appears in: CSE302: Database Systems
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 5.0 (1 votes)
Holdings
Item type Current library Collection Call number Copy number Status Date due Barcode Item holds
E-Book E-Book Dr. S. R. Lasker Library, EWU
E-book 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) Not for loan
Text Text Dr. S. R. Lasker Library, EWU
Reserve Section 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) C-1 Not For Loan 10437
Text Text Dr. S. R. Lasker Library, EWU
Reserve Section 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) C-2 Not For Loan 10438
Text Text Dr. S. R. Lasker Library, EWU
Reserve Section 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) C-3 Not For Loan 10439
Text Text Dr. S. R. Lasker Library, EWU
Circulation Section 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) C-4 Available 10440
Text Text Dr. S. R. Lasker Library, EWU
Circulation Section 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) C-5 Available 10441
Text Text Dr. S. R. Lasker Library, EWU
Circulation Section 		Non-fiction 004.678 WIW 2002 (Browse shelf(Opens below)) C-6 Available 10442
Total holds: 0

Includes bibliographical references (p. 537-549) and index.

Preface 1. Database Applications and the Web Three-Tier Architectures The Client Tier The Middle Tier The Database Tier Our Case Study 2. PHP Introducing PHP Conditions and Branches Loops A Worked Example Arrays Strings Regular Expressions Date and Time Functions Integer and Float Functions User-Defined Functions Objects Common Mistakes 3. MySQL and SQL Database Basics Quick Start Guide MySQL Command Interpreter Managing Databases, Tables, and Indexes Inserting, Updating, and Deleting Data Querying with SQL SELECT Join Queries Modifying the Database Functions More on SQL and MySQL 4. Querying Web Databases Connecting to a MySQL Database Formatting Results Case Study: The Front-Page Panel Interacting with Other DBMSs Using PHP 5. User-Driven Querying User Input Querying with User Input Case Study: Previous and Next Browsing Case Study: Producing a select List 6. Writing to Web Databases Database Inserts, Updates, and Deletes Issues in Writing Data to Databases 7. Validation on the Server and Client Validation and Error Reporting for Web Database Applications Server-Side Validation Client-Side Validation with JavaScript 8. Sessions Building Applications That Keep State Session Management Over the Web PHP Session Management Case Study: Adding Sessions to the Winestore When to Use Sessions 9. Authentication and Security HTTP Authentication HTTP Authentication with PHP Authentication Using a Database Web Database Applications and Authentication Protecting Data on the Web 10. Winestore Customer Management Overview of the Winestore Application Customer Management Authenticating Users The Winestore Include Files 11. The Winestore Shopping Cart The Winestore Home Page The Shopping Cart Architecture Managing Redirection 12. Ordering and Shipping at the Winestore Finalizing Orders HTML and Email Receipts 13. Related Topics Automated Housekeeping Templates Searching and Browsing A. Installation Guide B. Internet and Web Protocols C. Modeling and Designing Relational Databases D. Managing Sessions in the Database Tier E. Resources Index

This volume offers Web developers a mixture of theoretical and practical information on creating Web database applications. Using PHP, and MySQL, it offers detailed information on designing relational databases and Web application architecture.

CSE

Rokon Mahamud

There are no comments on this title.

to post a comment.