Fifo

PHP With MySql

1. Introducing PHP
1. History
2. General Language Features
2. Installation of PHP on Various Platforms
1. Installation Prerequisites
2. Installing Apache & PHP on Windows
3. Installing Apache & PHP on Linux
4. Installing IIS & PHP on Windows
5. Testing your Installation
6. Configuring PHP
7. Run-Time Configuration
8. About IDE
3. PHP Basics
1. Syntax & Semantics of PHP
2. Commenting
3. Outputting
4. PHP Supported Data Types
5. Identifiers
6. Variables, Constants
7. Expressions & String Interpolation
8. Control Structures
1. Conditional Statements
2. Looping Statements
3. File-Inclusion Statements
4. Functions
1. Invoking a Function
2. Creating a Function
1. Passing Arguments by Value
2. Passing Arguments by Reference
3. Default Argument Values
4. Using Type Hinting
5. Returning Values from a Function
6. Recursive Functions
3. Function Libraries
5. Arrays
1. What is an Array?
2. Creating an Array
3. Displaying an Array
4. Adding & Removing Array Elements
5. Locating Array Elements
6. Traversing Arrays
7. Determining Array Size & Uniqueness
8. Sorting Arrays
9. Merging, Slicing, Splicing, and Dissecting Arrays
10. Other Useful Array Functions
6. Object-Oriented PHP
1. The Benefits of OOP
1. Encapsulation
2. Inheritance
3. Polymorphism
2. Key OOP Concepts
1. Classes
2. Objects
3. Properties
4. Constants
5. Methods
3. Constructors & Destructors
4. Static Class Members
5. The instanceof Keyword
6. Autoloading Objects
7. Advanced OOP Features
1. Not Supported by PHP
2. Object Cloning
3. Inheritance
4. Interfaces
5. Abstract Classes
6. Introducing Namespaces
8. Error & Exception Handling
1. Configuration Directives
2. Error Logging
3. Exception Handling
9. Strings & Regular Expressions
1. Regular Expressions
2. Other String-Specific Functions
3. Alternatives for Regular Expression Functions
10. Working with the File & Operating System
1. Learning About Files & Directories
2. Working with Files
3. Executing Shell Commands
4. System-Level Program Execution
11. Date & Time
1. The Unix Timestamp
2. PHP's Date and Time Library
3. Date Functions
4. Date & Time Enhancements for PHP 5.1 + Users
12. Working with HTML Forms
1. PHP & Web Forms
2. Validating Form Data
13. Authenticating Users
1. HTTP Authentication Concepts
2. Authenticating Your Users with PHP
3. User Login Administration
14. File Uploads
1. Uploading Files via HTTP
2. Uploading Files with PHP
15. Networking
1. DNS, Services and Servers
2. Creating Configuration Files
16. Web Services
1. Why Web Services?
2. Really Simple Syndication(RSS)
3. Introducing Simplepie
4. SimpleXML
17. Securing Your Web Site
1. Configuring PHP Securely
2. Hiding Configuration Details
3. Hiding Sensitive Data
4. Data Encryption
18. Creating Ajax-enhanced Features with jQuery and PHP
1. Introducing Ajax
2. Introducing jQuery
1. Installing jQuery
2. A Simple Example
3. Responding to Events
4. jQuery & the DOM
3. Creating a Username Existence Validator
19. Building Web Sites for the World
1. Internationalization
2. Localizing Dates, Numbers, and Times
20. Introducing the Zend Framework
1. Introduction to MVC
2. PHP's Framework Solutions
3. Introducing the Zend Framework
21. MySQL
1. Introduction to MySQL
2. The Evolution of MySQL
3. Prominent MySQL Users
22. Installing and Configuring MySQL
1. Installing MySQL
2. Setting the MySQL Administrator Password
3. Starting & Stopping MySQL
4. Configuring & Optimizing MySQL
5. Configuring PHP to Work with MySQL
23. MySQL Storage Engines and Data Types
1. Storage Engines
2. Data Types and Attributes
3. Working with Databases and Tables
24. Securing MySQL
1. What You Should Do First
2. Securing the Mysql Daemon
3. The MySQL Access Privilege System
4. User and Privilege Management
5. Limiting User Resources
6. Secure MySQL Connections
25. Using PHP with MySQL
1. Installation Prerequisites
2. Using the mysql Extension
3. Interaction with the Database
4. Executing Database Transactions
26. Stored Routines
1. How MySQL Implements Stored Routines
2. Integrating Routines into Web Applications
27. MySQL Triggers
1. Introducing Triggers
2. MySQL Trigger Support
3. Integrating Triggers into Web Applications
28. MySQL Views
1. Introducing Views
2. MySQL's View Support
3. Incorporating Views into Web Applications
29. Practical Database Queries
1. Sample Data
2. Sorting Output
3. Creating Paged Output
4. Listing Page Numbers
5. Querying Multiple Tables with Subqueries
6. Iterating Result Sets with Cursors
30. Indexes & Searching
1. Database Indexing
2. Forms-Based Searches
31. Transactions
1. What's Transaction?
2. MySQL's Transactional Capabilities
3. A Sample Project
4. Building Transactional Applications with PHP
32. Importing and Exporting Data
1. Sample Table
2. Using Data Delimitation
3. Exporting Data
33. Conclusion of All the Sessions