Propel (PHP)

Propel is a tool for Object-Relational Mapping ( ORM), to store PHP objects in a relational database. Propel is designed for PHP 5 and is based on the Apache Torque project.

Introduction

Propel allows the developer to use objects instead of SQL to read data from the tables of a database or write. Propel consists of two tools:

  • Created the generator which SQL definition files and php classes from the data model
  • The runtime engine can be saved with the objects in the database and read from the database

Propel provides easy ways to customize the generated classes to your needs. By using XML to define the data model, Propel can be easily integrated into existing frameworks. The generated class can be referred to as data objects ( DAO).

Generator

Based on a simple XML schema with the database and the tables are described, created the generator PHP classes that can interact with the data model and SQL definition files to the tables, keys, etc. in the relational database system to to create.

Run-Time Engine

The runtime engine provides the ability to use the generated classes in your own PHP scripts to keep reading and writing the database transparently.

The runtime engine is in contrast to the generator in a version for PHP 4 available. This version is, however, no longer being maintained in the future.

Requirements

The following requirements must be met to use Propel can:

  • PHP on the server must be installed 5
  • As a database abstraction layer uses Propel PDO
  • For logging the PEAR package PEAR :: Log is needed
  • Phing is required to create the data model of the XML schema of the classes and the SQL definition file

Supported databases

Propel currently supports the following databases:

  • MySQL
  • PostgreSQL
  • SQLite
  • Microsoft SQL Server
  • Oracle
662526
de