helios-ag/fm-lessql-bundle

Lessql bundle, adds LessQL ORM PHP to your Symfony2 project

FMLessQLBundle

LessQL integration in Symfony2, _(*1)

LessQL is a lightweight and powerful alternative to Object-Relational Mapping for PHP., _(*2)

Installation

Step 1: Installation

Using Composer, just add the following configuration to your composer.json:, _(*3)

Or you can use composer to install this bundle: Add FMBbcodeBundle in your composer.json:, _(*4)

    composer require helios-ag/fm-lessql-bundle

Now tell composer to download the bundle by running the command:, _(*5)

    composer update helios-ag/fm-lessql-bundle

Step 2: Enable the bundle

Finally, enable the bundle in the kernel:, _(*6)

``` php <?php // app/AppKernel.php, <sub>(*7)</sub>

public function registerBundles() { $bundles = array( // ... new FM\LessqlBundle\FMLessqlBundle(), ); }, <sub>(*8)</sub>

## Configuration

You can configure bundle as follows
```yaml
fm_lessql:
    instances:
        default:
            dsn: sqlite:%kernel.root_dir%/test.sqlite3
            username: ''
            password: ''
            options:
        mysql:
            dsn: mysql:host=localhost;dbname=testdb;charset=utf8
            username: root
            password: 12345
            options:
              'PDO::ATTR_EMULATE_PREPARES': { value: false }
              'PDO::ATTR_ERRMODE': { value: 'PDO::ERRMODE_EXCEPTION' }

Usage

Controller, <sub>(*9)</sub>

class AppController extends Controller
{
    /**
     * @Template()
     */
    public function indexAction()
    {

        $db = $this->get('fm_lessql.manager')->getDB('default');
        $posts = array();
        $result = $db->table_name();
        $result = $db->table( 'post' );
        $row = $result->fetch();      // fetch next row in result
        $rows = $result->fetchAll();  // fetch all rows
    }     
}

More information can be found at http://lessql.net/, <sub>(*10)</sub>