🇺🇦 UKRAINE NEEDS YOUR HELP NOW!
Doctrine
Projects
Coding Standard
Collections
Common
Data fixtures
DBAL
Event Manager
Inflector
Instantiator
Lexer
Migrations
MongoDB ODM
ORM
Persistence
PHPCR ODM
RST Parser
Skeleton Mapper
View All
Development
Community
Contributor Workflow
Maintainer Workflow
Contribute to Website
Maintainers
Contributors
Policies
GitHub
Styleguide
Consulting
Partners
Blog
Edit
Architecture
Drivers
Platforms
Logging
Schema
Types
Caching
Configuration
Getting a Connection
Driver
Wrapper Class
Connection Details
Custom Platform
Custom Driver Options
Data Retrieval And Manipulation
Data Retrieval
Dynamic Parameters and Prepared Statements
Using Prepared Statements
Binding Types
DoctrineDBALTypes Conversion
List of Parameters Conversion
API
prepare()
executeUpdate()
executeQuery()
fetchAll()
fetchArray()
fetchColumn()
fetchAssoc()
delete()
insert()
update()
quote()
quoteIdentifier()
Events
PostConnect Event
Introduction
Known Vendor Issues
PostgreSQL
DateTime, DateTimeTz and Time Types
Timezones and DateTimeTz
MySQL
DateTimeTz
Sqlite
DateTimeTz
IBM DB2
DateTimeTz
Oracle
DateTimeTz
OCI8: SQL Queries with Question Marks
OCI-LOB instances
Microsoft SQL Server
Unique and NULL
DateTime, DateTimeTz and Time Types
Platforms
Portability
Connection Wrapper
Database Platform
Keyword Lists
SQL Query Builder
Schema-Manager
listDatabases()
listSequences()
listTableColumns()
listTableDetails()
listTableForeignKeys()
listTableIndexes()
listTables()
listViews()
createSchema()
Schema-Representation
Security
User input in your queries
Wrong: String Concatenation
Right: Prepared Statements
Right: Quoting/Escaping values
Non-ASCII compatible Charsets in MySQL
Sharding
ID Generation
Use GUID/UUIDs
Table Generator
Natural Identifiers
Transactions
Foreign Keys
Complex Queries
ShardManager Interface
Schema Operations: SchemaSynchronizer Interface
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
Transactions
Transaction Nesting
Types
Detection of Database Types
Custom Mapping Types
Projects
DBAL
Documentation
You are browsing a version that is no longer maintained.
Table of Contents
2.4.5
Maintained
4.0.0-BETA2 (upcoming)
3.7 (upcoming)
3.6.7 (current)
Unmaintained
3.5
3.4
3.3
3.2
3.1
3.0
2.13
2.12
2.11
2.10
2.9
2.8
2.7
2.6
2.5
2.4
Welcome to Doctrine DBAL's documentation!
Contents:
Introduction
Architecture
Configuration
Data Retrieval And Manipulation
SQL Query Builder
Transactions
Platforms
Types
Schema-Manager
Schema-Representation
Events
Security
Sharding
SQLAzure Sharding Tutorial
Supporting Other Databases
Portability
Caching
Known Vendor Issues
Indices and tables
Top
