Examples
Table of Contents
- Introduction
- Getting Started
- Introduction to Connections
- Configuration
- Connections
- Introduction to Models
- Defining Models
- Working with Models
- DQL (Doctrine Query Language)
- Component Overview
- Native SQL
- YAML Schema Files
- Data Validation
- Data Hydrators
- Inheritance
- Behaviors
- Searching
- Hierarchical Data
- Data Fixtures
- Database Abstraction Layer
- Transactions
- Event Listeners
- Caching
- Migrations
- Extensions
- Utilities
- Unit Testing
- Improving Performance
- Technology
- Exceptions and Warnings
- Real World Examples
- Coding Standards
Examples
Example 1. Connect to database through a socket
mysql://user@unix(/path/to/socket)/pearExample 2. Connect to database on a non standard port
pgsql://user:pass@tcp(localhost:5555)/pearIf you use, the IP address 127.0.0.1, the port parameter is ignored (default: 3306).
Example 3. Connect to SQLite on a Unix machine using options
sqlite:////full/unix/path/to/file.db?mode=0666Example 4. Connect to SQLite on a Windows machine using options
sqlite:///c:/full/windows/path/to/file.db?mode=0666Example 5. Connect to MySQLi using SSL
mysqli://user:pass@localhost/pear?key=client-key.pem&cert=client-cert.pemQuestions and Feedback
If you find a problem with the documentation or have a suggestion, please register and open a ticket.If you need support or have a technical question, you can post to the user mailing-list.
