pointybeard/symphony-pdo

Wraps the core Symphony database connection with a PDO based library.

SymphonyCMS: PDO Database Wrapper

• Version: v0.1.7
• Date: May 30 2019
• Release notes
• GitHub repository

Wraps the core Symphony CMS database connection with a PDO based library, _(*1)

Installation

This library is installed via Composer. To install, use composer require pointybeard/symphony-pdo or add "pointybeard/symphony-pdo": "~0.1" to your composer.json file., _(*2)

And run composer to update your dependencies:, _(*3)

$ curl -s http://getcomposer.org/installer | php
$ php composer.phar update

Usage

<?php
use SymphonyPDO;

$query = SymphonyPDO\Loader::instance()->query(
    'SELECT * FROM `tbl_sections` ORDER BY `id` ASC;'
);

var_dump($query->fetchObject()->name);
// string(8) "Articles"

// Or, better yet, use a ResultIterator instead
foreach(new SymphonyPDO\Lib\ResultIterator('\stdClass', $query) as $result) {
    printf('%d => %s (%s)' . PHP_EOL, $result->id, $result->name, $result->handle);
}
// 1 => Articles (articles)
// 2 => Categorties (categories)

Support

If you believe you have found a bug, please report it using the GitHub issue tracker, or better yet, fork the library and submit a pull request., _(*4)

Contributing

We encourage you to contribute to this project. Please check out the Contributing documentation for guidelines about how to get involved., _(*5)

License

"SymphonyCMS: PDO Database Wrapper" is released under the MIT License., _(*6)