Cargando…
Web database applications with PHP and MySQL /
Demonstrates techniques of dynamic content through a complex sample application. Presents principles of good design, such as dividing logic from presentation. Introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in wide...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly,
©2004.
|
| Edición: | 2nd ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Database Applications and the Web
- The Web
- Three-Tier Architectures
- The PHP Scripting Language
- Introducing PHP
- Conditions and Branches
- Loops
- Functions
- Working with Types
- User-Defined Functions
- A Working Example
- Arrays, Strings, and Advanced Data Manipulation in PHP
- Arrays
- Strings
- Regular Expressions
- Dates and Times
- Integers and Floats
- Introduction to Object-Oriented Programming with PHP 5
- Classes and Objects
- Inheritance
- Throwing and Catching Exceptions
- SQL and MySQL
- Database Basics
- MySQL Command Interpreter
- Managing Databases and Tables
- Inserting, Updating, and Deleting Data
- Querying with SQL Select
- Join Queries
- Case Study: Adding a New Wine
- Querying Web Databases
- Querying a MySQL Database Using PHP
- Processing User Input
- MySQL Function Reference
- Pear
- Core Components
- Packages
- Writing to Web Databases
- Database Inserts, Updates, and Deletes
- Issues in Writing Data to Databases
- Validation with PHP and JavaScript
- Validation and Error Reporting Principles
- Server-Side Validation with PHP
- JavaScript and Client-Side Validation
- Sessions
- Introducing Session Management
- PHP Session Management
- Case Study: Using Sessions in Validation
- When to Use Sessions
- PHP Session API and Configuration
- Authentication and Security
- HTTP Authentication
- HTTP Authentication with PHP
- Form-Based Authentication
- Protecting Data on the Web
- Errors, Debugging, and Deployment
- Errors
- Common Programming Errors
- Custom Error Handlers
- Reporting
- Creating a Report
- Producing PDF
- PDF-PHP Reference
- Advanced Features of Object-Oriented Programming in PHP 5
- Working with Class Hierarchies
- Class Type Hints
- Abstract Classes and Interfaces
- Freight Calculator Example
- Advanced SQL
- Exploring with SHOW
- Advanced Querying
- Manipulating Data and Databases
- Functions
- Automating Querying
- Table Types
- Backup and Recovery
- Managing Users and Privileges
- Tuning MySQL
- Hugh and Dave's Online Wines: A Case Study
- Functional and System Requirements
- Application Overview
- Common Components
- Managing Customers
- Code Overview
- Customer Validation
- The Customer Form
- The Shopping Cart
- Code Overview
- The Winestore Home Page
- The Shopping Cart Implementation
- Ordering and Shipping at the Online Winestore
- Code Overview
- Credit Card and Shipping Instructions
- Finalizing Orders
- HTML and Email Receipts
- Searching and Authentication in the Online Winestore
- Code Overview
- Searching and Browsing
- Authentication
- Linux Installation Guide
- Microsoft Windows Installation Guide
- Mac OS X Installation Guide
- Web Protocols
- Modeling and Designing Relational Databases
- Managing Sessions in the Database Tier
- The Improved MySQL Library.