Doctrine
  • Projects
    Annotations Cache Coding Standard Collections Common DBAL Event Manager Inflector Instantiator Lexer Migrations MongoDB ODM ORM Persistence PHPCR ODM Reflection RST Parser Skeleton Mapper View All
  • Development
    Community Contributor Workflow Maintainer Workflow Contribute to Website Maintainers Contributors Policies GitHub Styleguide
  • Events
  • Consulting
  • Partners
  • Blog
Edit
Translate
Loading...
  • Introduction
  • Architecture
    • Drivers
    • Platforms
    • Logging
    • Schema
    • Types
  • Configuration
    • Getting a Connection
      • Connecting using a URL
      • Driver
      • Wrapper Class
      • Connection Details
      • Automatic platform version detection
      • Custom Platform
      • Custom Driver Options
  • Data Retrieval And Manipulation
    • Data Retrieval
      • Dynamic Parameters and Prepared Statements
      • Using Prepared Statements
    • Binding Types
      • Doctrine\DBAL\Types Conversion
      • List of Parameters Conversion
    • API
      • prepare()
      • executeStatement()
      • executeQuery()
      • fetchAllAssociative()
      • fetchAllKeyValue()
      • fetchAllAssociativeIndexed()
      • fetchNumeric()
      • fetchOne()
      • fetchAssociative()
      • iterateKeyValue()
      • iterateAssociativeIndexed()
      • delete()
      • insert()
      • update()
      • quote()
      • quoteIdentifier()
  • SQL Query Builder
    • Security: Safely preventing SQL Injection
    • Building a Query
      • DISTINCT-Clause
      • WHERE-Clause
      • Table alias
      • GROUP BY and HAVING Clause
      • Join Clauses
      • Order-By Clause
      • Limit Clause
      • VALUES Clause
      • Set Clause
    • Building Expressions
    • Binding Parameters to Placeholders
  • Transactions
    • Transaction Nesting
    • Auto-commit mode
    • Error handling
  • Platforms
    • MySQL
    • MariaDB
    • Oracle
    • Microsoft SQL Server
    • PostgreSQL
    • SAP Sybase SQL Anywhere
    • SQLite
    • Drizzle
  • Types
    • Reference
      • Numeric types
      • String types
      • Bit types
      • Date and time types
      • Array types
      • Object types
    • Mapping Matrix
    • Detection of Database Types
    • Custom Mapping Types
  • Schema-Manager
    • listDatabases()
    • listSequences()
    • listTableColumns()
    • listTableDetails()
    • listTableForeignKeys()
    • listTableIndexes()
    • listTables()
    • listViews()
    • createSchema()
  • Schema-Representation
    • Schema Assets
      • Column
  • Events
    • PostConnect Event
    • Schema Events
      • OnSchemaCreateTable Event
      • OnSchemaCreateTableColumn Event
      • OnSchemaDropTable Event
      • OnSchemaAlterTable Event
      • OnSchemaAlterTableAddColumn Event
      • OnSchemaAlterTableRemoveColumn Event
      • OnSchemaAlterTableChangeColumn Event
      • OnSchemaAlterTableRenameColumn Event
      • OnSchemaColumnDefinition Event
      • OnSchemaIndexDefinition Event
  • Security
    • SQL Injection: Safe and Unsafe APIs for User Input
    • User input in your queries
      • Wrong: String Concatenation
      • Right: Prepared Statements
      • Right: Quoting/Escaping values
  • Sharding
    • ID Generation
      • Use GUID/UUIDs
      • Table Generator
      • Natural Identifiers
    • Transactions
    • Foreign Keys
    • Complex Queries
    • ShardManager Interface
    • Schema Operations: SchemaSynchronizer Interface (deprecated)
    • SQL Azure Federations
      • Schema Operations
      • SQLAzure Filtering
    • Generic SQL Sharding Support
  • SQLAzure Sharding Tutorial
    • Install Doctrine
    • Setup Connection
    • Create Database
    • Create Schema
    • View Federation Members
    • Insert Data
    • Split Federation
    • Inserting Data after Split
    • Querying data with filtering off
    • Querying data with filtering on
  • Supporting Other Databases
    • Implementation Steps in Detail
  • Portability
    • Connection Wrapper
    • Database Platform
    • Keyword Lists
  • Caching
  • Known Vendor Issues
    • PostgreSQL
      • DateTime, DateTimeTz and Time Types
      • Timezones and DateTimeTz
    • MySQL
      • DateTimeTz
    • Sqlite
      • Buffered Queries and Isolation
      • DateTime
      • DateTimeTz
      • Reverse engineering primary key order
    • IBM DB2
      • DateTimeTz
    • Oracle
      • DateTimeTz
      • OCI-LOB instances
    • Microsoft SQL Server
      • Unique and NULL
      • DateTime, DateTimeTz and Time Types
  • Upgrading
    • Deprecations
  • Testing Guidelines
    • Requirements
    • Types of Tests
      • Unit Tests
      • Integration Tests
      • Recommendations on Writing Tests
  • Implicit indexes
  1. Projects
  2. DBAL
  3. Documentation
2.12.1
Maintained
3.0.0 (current) 2.12.1
Unmaintained
2.11 2.10 2.9 2.8 2.7 2.6 2.5 2.4
  • Introduction
  • Architecture
    • Drivers
    • Platforms
    • Logging
    • Schema
    • Types
  • Configuration
    • Getting a Connection
      • Connecting using a URL
      • Driver
      • Wrapper Class
      • Connection Details
      • Automatic platform version detection
      • Custom Platform
      • Custom Driver Options
  • Data Retrieval And Manipulation
    • Data Retrieval
      • Dynamic Parameters and Prepared Statements
      • Using Prepared Statements
    • Binding Types
      • Doctrine\DBAL\Types Conversion
      • List of Parameters Conversion
    • API
      • prepare()
      • executeStatement()
      • executeQuery()
      • fetchAllAssociative()
      • fetchAllKeyValue()
      • fetchAllAssociativeIndexed()
      • fetchNumeric()
      • fetchOne()
      • fetchAssociative()
      • iterateKeyValue()
      • iterateAssociativeIndexed()
      • delete()
      • insert()
      • update()
      • quote()
      • quoteIdentifier()
  • SQL Query Builder
    • Security: Safely preventing SQL Injection
    • Building a Query
      • DISTINCT-Clause
      • WHERE-Clause
      • Table alias
      • GROUP BY and HAVING Clause
      • Join Clauses
      • Order-By Clause
      • Limit Clause
      • VALUES Clause
      • Set Clause
    • Building Expressions
    • Binding Parameters to Placeholders
  • Transactions
    • Transaction Nesting
    • Auto-commit mode
    • Error handling
  • Platforms
    • MySQL
    • MariaDB
    • Oracle
    • Microsoft SQL Server
    • PostgreSQL
    • SAP Sybase SQL Anywhere
    • SQLite
    • Drizzle
  • Types
    • Reference
      • Numeric types
      • String types
      • Bit types
      • Date and time types
      • Array types
      • Object types
    • Mapping Matrix
    • Detection of Database Types
    • Custom Mapping Types
  • Schema-Manager
    • listDatabases()
    • listSequences()
    • listTableColumns()
    • listTableDetails()
    • listTableForeignKeys()
    • listTableIndexes()
    • listTables()
    • listViews()
    • createSchema()
  • Schema-Representation
    • Schema Assets
      • Column
  • Events
    • PostConnect Event
    • Schema Events
      • OnSchemaCreateTable Event
      • OnSchemaCreateTableColumn Event
      • OnSchemaDropTable Event
      • OnSchemaAlterTable Event
      • OnSchemaAlterTableAddColumn Event
      • OnSchemaAlterTableRemoveColumn Event
      • OnSchemaAlterTableChangeColumn Event
      • OnSchemaAlterTableRenameColumn Event
      • OnSchemaColumnDefinition Event
      • OnSchemaIndexDefinition Event
  • Security
    • SQL Injection: Safe and Unsafe APIs for User Input
    • User input in your queries
      • Wrong: String Concatenation
      • Right: Prepared Statements
      • Right: Quoting/Escaping values
  • Sharding
    • ID Generation
      • Use GUID/UUIDs
      • Table Generator
      • Natural Identifiers
    • Transactions
    • Foreign Keys
    • Complex Queries
    • ShardManager Interface
    • Schema Operations: SchemaSynchronizer Interface (deprecated)
    • SQL Azure Federations
      • Schema Operations
      • SQLAzure Filtering
    • Generic SQL Sharding Support
  • SQLAzure Sharding Tutorial
    • Install Doctrine
    • Setup Connection
    • Create Database
    • Create Schema
    • View Federation Members
    • Insert Data
    • Split Federation
    • Inserting Data after Split
    • Querying data with filtering off
    • Querying data with filtering on
  • Supporting Other Databases
    • Implementation Steps in Detail
  • Portability
    • Connection Wrapper
    • Database Platform
    • Keyword Lists
  • Caching
  • Known Vendor Issues
    • PostgreSQL
      • DateTime, DateTimeTz and Time Types
      • Timezones and DateTimeTz
    • MySQL
      • DateTimeTz
    • Sqlite
      • Buffered Queries and Isolation
      • DateTime
      • DateTimeTz
      • Reverse engineering primary key order
    • IBM DB2
      • DateTimeTz
    • Oracle
      • DateTimeTz
      • OCI-LOB instances
    • Microsoft SQL Server
      • Unique and NULL
      • DateTime, DateTimeTz and Time Types
  • Upgrading
    • Deprecations
  • Testing Guidelines
    • Requirements
    • Types of Tests
      • Unit Tests
      • Integration Tests
      • Recommendations on Writing Tests
  • Implicit indexes
  • Projects
  • Partners
  • Sponsorship
  • Community
  • Blog
  • Events
  • Consulting