πΊπ¦ UKRAINE NEEDS YOUR HELP NOW!
Doctrine
Projects
Annotations
Cache
Coding Standard
Collections
Common
Data fixtures
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
Supporting Other Databases
Implementation Steps in Detail
Types
Detection of Database Types
Custom Mapping Types
Platforms
SQL Query Builder
Architecture
Drivers
Platforms
Logging
Schema
Types
Transactions
Transaction Nesting
Schema-Representation
Portability
Connection Wrapper
Database Platform
Keyword Lists
Security
User input in your queries
Wrong: String Concatenation
Right: Prepared Statements
Right: Quoting/Escaping values
Non-ASCII compatible Charsets in MySQL
Schema-Manager
listDatabases()
listSequences()
listTableColumns()
listTableDetails()
listTableForeignKeys()
listTableIndexes()
listTables()
listViews()
createSchema()
Introduction
Events
PostConnect Event
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
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()
executeUpdate()
executeQuery()
fetchAll()
fetchArray()
fetchColumn()
fetchAssoc()
delete()
insert()
update()
quote()
quoteIdentifier()
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
Caching
Configuration
Getting a Connection
Driver
Wrapper Class
Connection Details
Custom Platform
Custom Driver Options
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
Welcome to Doctrine DBAL's documentation!
Indices and tables
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.3 (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