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

1454PHP

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 yesterday

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

21

—

LowBetter than 18% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity17

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://avatars.githubusercontent.com/u/577409?v=4)[Oscar Daniel Villarraga](/maintainers/dvillarraga)[@dvillarraga](https://github.com/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

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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