1.1 Create PHP Application
1.1.1 Create PHP Console Application
1.1.2 Create PHP Web Application
2. Data Base
2.1 Access
2.1.1 Connect
2.1.2 Select
2.1.3 Update
2.1.4 Insert
2.1.5 Delete
2.1.6 Create Table
2.2 Oracle
2.2.1 Connect
2.2.2 Select
2.2.2.1 From Dual
2.2.2.2 From Table
2.2.2.3 Prepared Statement
2.2.3 Insert
2.2.3.1 Prepared Statement
2.2.4 Update
2.2.4.1 Prepared Statement
2.2.5 Delete
2.2.5.1 Prepared Statement
2.3 MySQL
2.3.1 Connect
2.3.2 Select
2.3.3 Insert
2.3.4 Delete
2.3.5 Update
2.4 MySQLi
2.4.1 Connect
2.4.2 Select
2.4.2.1 String Statement
2.4.2.2 Prepared Statements
2.4.2.2.1 bindParam()
2.4.3 Delete
2.4.3.1 String Statement
2.4.3.2 Prepared Statements
2.4.3.2.1 bind_param()
2.4.4 Insert
2.4.4.1 String Statement
2.4.4.2 Prepared Statements
2.4.4.2.1 bind_param()
2.4.5 Update
2.4.5.1 String Statement
2.4.5.2 Prepared Statements
2.4.5.2.1 bind_param()
2.5 ADODB
2.5.1 Install
2.5.2 Connect
2.5.3 Select
2.5.3.1 String Statement
2.5.3.2 Prepared Statements
2.5.3.2.1 array()
2.5.4 Insert
2.5.4.1 String Statement
2.5.4.2 Prepared Statements
2.5.4.2.1 array()
2.5.5 Delete
2.5.5.1 String Statement
2.5.5.2 Prepared Statements
2.5.5.2.1 array()
2.5.6 Update
2.5.6.1 String Statement
2.5.6.2 Prepared Statements
2.5.6.2.1 array()
2.6 PDO
2.6.1 Connect
2.6.2 Insert
2.6.2.1 String Statement
2.6.2.2 Prepared Statements
2.6.2.2.1 array()
2.6.2.2.2 bindValue()
2.6.2.2.3 bindParam()
2.6.3 Delete
2.6.3.1 String Statement
2.6.3.2 Prepared Statements
2.6.3.2.1 array()
2.6.3.2.2 bindValue()
2.6.3.2.3 bindParam()
2.6.4 Update
2.6.4.1 String Statement
2.6.4.2 Prepared Statements
2.6.4.2.1 array()
2.6.4.2.2 bindValue()
2.6.4.2.3 bindParam()
2.6.5 Select
2.6.5.1 String Statement
2.6.5.2 Prepared Statements
2.6.5.2.1 array()
2.6.5.2.2 bindValue()
2.6.5.2.3 bindParam()
2.6.5.3 Return records
2.6.5.3.1 FETCH_ASSOC
2.6.5.3.2 FETCH_NUM
2.6.5.3.3 FETCH_BOTH
2.6.5.3.4 FETCH_OBJ
2.6.5.3.5 FETCH_CLASS
2.6.5.3.6 FETCH_FUNC
2.7 Doctrine DBAL
2.7.1 Install
2.7.1.1 By using Composer
2.7.1.2 By using PEAR
2.7.1.3 By using GIT
2.7.1.4 By downloading package
2.7.2 Connect
2.7.2.1 SQLite
2.7.2.2 MySQL
2.7.3 Insert
2.7.3.1 String Statement
2.7.3.2 Prepared Statement - With named placeholders
2.7.3.3 Prepared Statement - With positional placeholders
2.7.4 Select
2.7.4.1 String Statement
2.7.4.2 Prepared Statement - With named placeholders
2.7.4.3 Prepared Statement - With positional placeholders
2.7.5 Update
2.7.5.1 String statement
2.7.5.2 Prepared Statement - With named placeholders
2.7.5.3 Prepared Statement - With positional placeholders
2.7.6 Delete
2.7.6.1 String Statement
2.7.6.2 Prepared Statement - With named placeholders
2.7.6.3 Prepared Statement - With positional placeholders
2.7.7 Transaction
2.8 Doctrine ORM
2.8.1 Install by using Composer
2.8.2 Test
2.8.3 Create Doctrine ORM Project
2.8.4 Repository
2.8.4.1 Insert
2.8.4.2 Retrieve
2.8.4.3 Delete
2.8.4.4 Update
2.8.5 DQL
2.8.5.1 Select
2.8.5.2 Insert
2.8.5.3 Update
2.8.5.4 Delete
2.8.6 Tools
2.8.6.1 orm:generate-entities
2.8.6.2 orm:convert-mapping
2.8.6.3 orm:schema-tool
2.8.7 Examples
2.8.7.1 CreateSchema
2.8.7.2 Convert Entities
2.9 RedBeanPHP
2.9.1 Install
2.9.2 Create RedBeanPHP Application
2.9.3 Connect to DB
2.9.3.1 SQLite
2.9.3.2 PostgreSQL
2.9.4 CRUD
2.9.4.1 Create
2.9.4.2 Retrieve
2.9.4.3 Update
2.9.4.4 Delete
2.9.5 Find
2.9.5.1 Find
2.9.5.2 Find - With Placeholders
2.9.5.3 Find - With Placeholders - For IN-queries
2.9.5.4 Find - With Named Slots
2.9.5.5 Find One
2.9.5.6 Find All
2.9.5.7 Find Collection
2.9.5.8 Find or Create
2.9.6 SQL
2.9.6.1 Update
2.9.6.2 Delete
2.9.6.3 Insert
2.9.6.4 Select
2.9.6.4.1 getAll()
2.9.6.4.2 getRow()
2.9.6.4.3 getCol()
2.9.6.4.4 getCell()
2.9.6.4.5 getAssoc()
2.9.6.4.6 convertToBeans()
2.9.7 Database
2.9.7.1 Get table columns
2.9.7.2 Get all tables
2.9.7.3 Transaction methods
2.9.7.4 Transaction closure
2.9.7.5 Logging
2.9.8 Relations
2.9.8.1 One-to-many
2.9.8.2 One-to-many - Exclusive mode
2.9.8.3 Many-to-one
2.9.8.4 Many-to-many
2.9.8.5 Many-to-many using via()
2.9.8.6 Filter and order
3. XML
3.1 XML_Beautifier
3.1.1 Install
3.1.2 Format XML File
3.1.3 Format XML String
3.1.4 Format XML String with Options
4. Web Services
4.1 SOAP Extension
4.1.1 WSDL
4.1.2 SOAP Messages
4.1.3 Exception handling
4.1.4 Examples
4.1.4.1 Create Server & Client
4.1.4.1.1 Server from Class and Client from WSDL
4.1.4.1.2 Server from Function and Client without WSDL
4.1.4.2 Return Object or Array or Hash as anyType
4.1.4.3 Return Object as <complexType>
4.1.4.3.1 Simple
4.1.4.3.2 Nested
4.1.4.4 Code Snippets
4.2 PHP2WSDL
4.2.1 Install
4.2.2 Example
5. Web Forms
5.1 HTML_QuickForm
5.1.1 Install
5.1.2 Create Form
5.1.3 Filters
5.1.4 Rules
5.1.4.1 Example
5.1.5 Get Field Values
5.1.5.1 getSubmitValues()
5.1.5.2 process()
5.1.5.3 exportvalue()
5.1.6 Autocomplete Field
5.1.7 Summery
6. Authentication
6.1 Auth
6.1.1 Install
6.1.2 Examples
6.1.2.1 CustomAuthContainer
6.2 Auth_HTTP
6.2.1 Install
6.2.2 Database Authentication
7. Templating Engines
7.1 Smarty
7.1.1 Install
7.1.2 Create Web Page
7.1.3 Syntax
7.1.3.1 Comments
7.1.3.2 Variable Modifiers
8. Errors
8.1 Access
8.1.1 Invalid directory or filepath
8.2 MySQL
8.2.1 Call to undefined function mysql_connect()
8.2.2 Unable to load dynamic library 'C:\php\php_mysql.dll'
8.3 Doctrine
8.3.1 [PDOException] could not find driver
8.3.2 General error: 1 table addresses already exists
8.3.3 PHP Startup: Unable to load dynamic library 'C:\php5\php_pdo_sqlite.dll'
8.3.4 fatal: Not a git repository (or any of the parent directories): .git
8.3.5 Call to undefined function Doctrine\Common\Cache\apc_fetch()
8.3.6 General error: 1 table users already exists
8.3.7 General error: 1 no such table: users
8.4 ReadBeanPHP
8.4.1 Could not connect to database
8.4.2 Unable to load dynamic library
8.5 SOAP Extension
8.5.1 SOAP-ERROR: Parsing WSDL: No location associated with <port>
8.6 PHP2WSDL
8.6.1 WSDL generated with errors
8.7 Auth_HTTP
8.7.1 Errors – Fatal error: Class 'DB' not found