PHPackages                             dvillarraga/datatables-doctrine1 - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. dvillarraga/datatables-doctrine1

ActiveLibrary[Database & ORM](/categories/database)

dvillarraga/datatables-doctrine1
================================

A simple way to use DataTables (The JQuery Plugin) + PHP + Doctrine 1.2.4

0377PHP

Since Mar 25Pushed 6y agoCompare

[ Source](https://github.com/dvillarraga/datatables-doctrine1)[ Packagist](https://packagist.org/packages/dvillarraga/datatables-doctrine1)[ RSS](/packages/dvillarraga-datatables-doctrine1/feed)WikiDiscussions master Synced 1mo ago

READMEChangelogDependenciesVersions (1)Used By (0)

DataTables for Doctrine 1.2
===========================

[](#datatables-for-doctrine-12)

It is just a simple way to use DataTables (The JQuery Plugin) + PHP + Doctrine 1.2.4

You can use this class in order to implement a server side DataTable

For more information go to [https://datatables.net/examples/data\_sources/server\_side.html](https://datatables.net/examples/data_sources/server_side.html)

Creating a simple service
-------------------------

[](#creating-a-simple-service)

```
$q = Doctrine_Query::create()
    ->select('c.id AS c.id,
        c.fiscal_id AS c.fiscal_id,
        c.name AS c.name,
        a.name AS a.name
        ')
    ->from('Client c')
    ->leftJoin('c.Account a')
    ;

$columns = array(
    array('db' => 'c.id', 'dt' => 0),
    array('db' => 'c.fiscal_id', 'dt' => 1),
    array('db' => 'c.name', 'dt' => 2),
    array('db' => 'a.name', 'dt' => 3),
);

$data_to_render = new DataTablesDoctrine1($q, $_GET, $columns);
echo json_encode($data_to_render->getData());
exit;
```

Sample using Symfony 1.4 (Legacy Version)
-----------------------------------------

[](#sample-using-symfony-14-legacy-version)

Just create a simple action in your controller...

```
public function executeGetDataTableClients(sfWebRequest $request){
    $q = Doctrine_Query::create()
      ->select('c.id AS c.id,
          c.fiscal_id AS c.fiscal_id,
          c.name AS c.name,
          a.name AS a.name
          ')
      ->from('Client c')
      ->leftJoin('c.Account a')
      ;

    $columns = array(
      array('db' => 'c.id', 'dt' => 0),
      array('db' => 'c.fiscal_id', 'dt' => 1),
      array('db' => 'c.name', 'dt' => 2),
      array('db' => 'a.name', 'dt' => 3),
    );

    $data_to_render = new DataTablesDoctrine1($q, $request->getGetParameters(), $columns);
    return $this->renderText(json_encode($data_to_render->getData()));
}
```

Help and docs
-------------

[](#help-and-docs)

Please feel free to contact me. You also can [tweet @dvillarraga](http://twitter.com/dvillarraga)!

Installing DataTables Doctrine 1
--------------------------------

[](#installing-datatables-doctrine-1)

The recommended way to install it is through [Composer](http://getcomposer.org).

```
# Install Composer
curl -sS https://getcomposer.org/installer | php
```

Next, run the Composer command to install the latest stable version of this lib:

```
php composer.phar require dvillarraga/datatables-doctrine1
```

After installing, you need to require Composer's autoloader:

```
require 'vendor/autoload.php';
```

You can then later update it using composer:

```
php composer.phar update
```

###  Health Score

20

—

LowBetter than 14% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community6

Small or concentrated contributor base

Maturity34

Early-stage or recently created project

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/3b855b58706fe6ab1bae289a63f004bb1ef89438c924d1cf449b47d9f6d10129?d=identicon)[dvillarraga](/maintainers/dvillarraga)

---

Top Contributors

[![dvillarraga](https://avatars.githubusercontent.com/u/577409?v=4)](https://github.com/dvillarraga "dvillarraga (9 commits)")

### Embed Badge

![Health badge](/badges/dvillarraga-datatables-doctrine1/health.svg)

```
[![Health](https://phpackages.com/badges/dvillarraga-datatables-doctrine1/health.svg)](https://phpackages.com/packages/dvillarraga-datatables-doctrine1)
```

###  Alternatives

[doctrine/orm

Object-Relational-Mapper for PHP

10.2k285.3M6.2k](/packages/doctrine-orm)[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k115.1M102](/packages/jdorn-sql-formatter)[illuminate/database

The Illuminate Database package.

2.8k52.4M9.4k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

1.6k64.0M546](/packages/mongodb-mongodb)[ramsey/uuid-doctrine

Use ramsey/uuid as a Doctrine field type.

90340.3M211](/packages/ramsey-uuid-doctrine)[reliese/laravel

Reliese Components for Laravel Framework code generation.

1.7k3.4M16](/packages/reliese-laravel)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)