Home
Contact Us
Sitemap
Available Categories
Adobe
Macromedia
Programming
SQL
Server Administration
Networking
Microsoft Products
Mac OS
Linux systems
Misc
Available Tutorials
.NET Framework Essentials
.NET Programming security
C# In A Nutshell Tutorial
Programming C.Sharp
Mastering Visual Studio .NET
ASP.NET
Web Solutions based on ASP.NET and ADO.NET
Java data objects
Java extreme programming
Java performance tuning
Java development on pda's. Building applications for pocket pc and palm devices
JavaScript and DHTML
Learning UML
UML
Learning XML
Cocoa
Programming Cpp
Perl objects, references and modules
Perl tutorial
Python tutorial
Python. Text processing
Pocket pc network programming
PHP & MySQL. Building web database applications
PHP & MySQL. Programming for beginners
PHP, MySQL and Apache in 24 hours
Software architecture in practice
Software engineering and computer games
Building Solutions With the Microsoft .NET Compact Framework
Programming Microsoft Visual C# 2005
Actionscript
Programming
>
PHP & MySQL. Building web database applications
Tutorial:
PHP & MySQL. Building web database applications
Please select a chapter from the "Contents" menu at the very bottom of the page.
Top
PHP & MySQL. Building web database applications
Chapter 1. Database Applications and the Web
1.1 The Web
1.2 Three-Tier Architectures
Chapter 2. The PHP Scripting Language
2.1 Introducing PHP
2.2 Conditions and Branches
2.3 Loops
2.4 Functions
2.5 Working with Types
2.6 User-Defined Functions
2.7 A Working Example
Chapter 3. Arrays, Strings, and Advanced Data Manipulation in PHP
3.1 Arrays
3.2 Strings
3.3 Regular Expressions
3.4 Dates and Times
3.5 Integers and Floats
Chapter 4. Introduction to Object-Oriented Programming with PHP 5
4.1 Classes and Objects
4.2 Inheritance
4.3 Throwing and Catching Exceptions
Chapter 5. SQL and MySQL
5.1 Database Basics
5.2 MySQL Command Interpreter
5.3 Managing Databases and Tables
5.4 Inserting, Updating, and Deleting Data
5.5 Querying with SQL SELECT
5.6 Join Queries
5.7 Case Study: Adding a New Wine
Chapter 6. Querying Web Databases
6.1 Querying a MySQL Database Using PHP
6.2 Processing User Input
6.3 MySQL Function Reference
Chapter 7. PEAR
7.1 Overview
7.2 Core Components
7.3 Packages
Chapter 8. Writing to Web Databases
8.1 Database Inserts, Updates, and Deletes
8.2 Issues in Writing Data to Databases
Chapter 9. Validation with PHP and JavaScript
9.1 Validation and Error Reporting Principles
9.2 Server-Side Validation with PHP
9.3 JavaScript and Client-Side Validation
Chapter 10. Sessions
10.1 Introducing Session Management
10.2 PHP Session Management
10.3 Case Study: Using Sessions in Validation
10.4 When to Use Sessions
10.5 PHP Session API and Configuration
Chapter 11. Authentication and Security
11.1 HTTP Authentication
11.2 HTTP Authentication with PHP
11.3 Form-Based Authentication
11.4 Protecting Data on the Web
Chapter 12. Errors, Debugging, and Deployment
12.1 Errors
12.2 Common Programming Errors
12.3 Custom Error Handlers
Chapter 13. Reporting
13.1 Creating a Report
13.2 Producing PDF
13.3 PDF-PHP Reference
Chapter 14. Advanced Features of Object-Oriented Programming in PHP 5
14.1 Working with Class Hierarchies
14.2 Class Type Hints
14.3 Abstract Classes and Interfaces
14.4 Freight Calculator Example
Chapter 15. Advanced SQL
15.1 Exploring with SHOW
15.2 Advanced Querying
15.3 Manipulating Data and Databases
15.4 Functions
15.5 Automating Querying
15.6 Table Types
15.7 Backup and Recovery
15.8 Managing Users and Privileges
15.9 Tuning MySQL
Chapter 16. Hugh and Dave's Online Wines:A Case Study
16.1 Functional and System Requirements
16.2 Application Overview
16.3 Common Components
Chapter 17. Managing Customers
17.1 Code Overview
17.2 Customer Validation
17.3 The Customer Form
Chapter 18. The Shopping Cart
18.1 Code Overview
18.2 The Winestore Home Page
18.3 The Shopping Cart Implementation
Chapter 19. Ordering and Shipping at the Online Winestore
19.1 Code Overview
19.2 Credit Card and Shipping Instructions
19.3 Finalizing Orders
19.4 HTML and Email Receipts
Chapter 20. Searching and Authentication in the Online Winestore
20.1 Code Overview
20.2 Searching and Browsing
20.3 Authentication
Appendix A. Linux Installation Guide
A.1 Finding Out What's Installed
A.2 Installation Overview
A.3 Installing MySQL
A.4 Installing Apache
A.5 Installing PHP
A.6 What's Needed for This Book
Appendix B. Microsoft Windows Installation Guide
B.1 Installation Overview
B.2 Installing with EasyPHP
B.3 What's Needed for This Book
Appendix C. Mac OS X Installation Guide
C.1 Getting Started
C.2 Installing MySQL
C.3 Setting Up Apache and PHP
C.4 What's Needed for This Book
Appendix D. Web Protocols
D.1 Network Basics
D.2 Hypertext Transfer Protocol
Appendix E. Modeling and Designing Relational Databases
E.1 The Relational Model
E.2 Entity-Relationship Modeling
Appendix F. Managing Sessions in theDatabase Tier
F.1 Using a Database to Keep State
F.2 PHP Session Management
F.3 MySQL Session Store
Appendix G. Resources
G.1 Client Tier Resources
G.2 Middle-Tier Resources
G.3 Database Tier Resources
G.4 Security and Cryptography Resources
Appendix H. The Improved MySQL Library
H.1 New Features
H.2 Getting Started
H.3 Using the New Features
Search the site
Enter your search terms
Submit search form
Web
etutorials.org