PHPackages stk2k/power-pdo - 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. stk2k/power-pdo ActiveLibrary[Database & ORM](/categories/database) stk2k/power-pdo =============== Powerful and thin wrapper of PDO 0.1.4(4y ago)022MITPHPPHP >=7.3 Since Mar 7Pushed 4y ago1 watchersCompare [ Source](https://github.com/stk2k/power-pdo)[ Packagist](https://packagist.org/packages/stk2k/power-pdo)[ Docs](https://github.com/stk2k/power-pdo)[ RSS](/packages/stk2k-power-pdo/feed)WikiDiscussions main Synced 1w ago READMEChangelogDependencies (3)Versions (17)Used By (0) Powerful and thin wrapper of PDO ================================ [](#powerful-and-thin-wrapper-of-pdo) [![Latest Version on Packagist](https://camo.githubusercontent.com/7346413696e09823b04fd5bf82e53806a459414702a66f411759fa66693e407a/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f73746b326b2f706f7765722d70646f2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/stk2k/power-pdo)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)[![Build Status](https://camo.githubusercontent.com/fe73ceff68ccd753eb5ab40a7cc8f8436908d700097f87509719a6b9070ad820/68747470733a2f2f6170702e7472617669732d63692e636f6d2f73746b326b2f706f7765722d70646f2e7376673f6272616e63683d6d61696e)](https://packagist.org/packages/stk2k/power-pdo)[![Coverage Status](https://camo.githubusercontent.com/9d92b26b794871af2822ffb28c0ca9bd9ff8bc687f0db76a3889294b1a5c7649/68747470733a2f2f636f766572616c6c732e696f2f7265706f732f6769746875622f73746b326b2f706f7765722d70646f2f62616467652e7376673f6272616e63683d6d61696e)](https://coveralls.io/github/stk2k/power-pdo?branch=main)[![Code Climate](https://camo.githubusercontent.com/42bcc9864d32ad339af2aa9396e4448e9e24fe9d923912e9d42cfb28bb054674/68747470733a2f2f636f6465636c696d6174652e636f6d2f6769746875622f73746b326b2f706f7765722d70646f2f6261646765732f6770612e737667)](https://codeclimate.com/github/stk2k/power-pdo)[![Total Downloads](https://camo.githubusercontent.com/3ce04ad7ccd1d0e3c412113681e1f910729369653f88eb91c58f85f098b6bd60/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f73746b326b2f706f7765722d70646f2e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/stk2k/power-pdo) Description ----------- [](#description) Powerful and thin wrapper of PDO Feature ------- [](#feature) - Fluent Query Builder - Supports POPO(Plain Old Php Object) entity class - Supports SQL JOIN - PSR-3 Logger How to use ---------- [](#how-to-use) ### Entity class [](#entity-class) ``` class UserEntity { public $ID; public $deleted; public $user_name; public $nickname; public $email; } ``` ### For MySQL [](#for-mysql) ``` use Stk2k\PowerPDO\PowerPDO; $dsn = 'mysql:dbname=mydatabase;host=localhost'; $user = 'myuser'; $password = 'mypass'; $ppdo = new PowerPDO(new PDO($dsn, $user, $password)); or $ppdo = PowerPDO::make($dsn, $user, $password); ``` ### For SQLite [](#for-sqlite) ``` use Stk2k\PowerPDO\PowerPDO; $dsn = 'sqlite:/path/to/dbfile_of_sqlite'; $ppdo = new PowerPDO(new PDO($dsn)); or $ppdo = PowerPDO::make($dsn); ``` ### Logging(PSR-3 Logger) [](#loggingpsr-3-logger) ``` use Monolog\Logger; use Monolog\Handler\StreamHandler; // monolog $log = new Logger('name'); $log->pushHandler(new StreamHandler('path/to/your.log', Logger::WARNING)); $ppdo = new PowerPDO(new PDO($dsn), $log); or $ppdo = PowerPDO::make($dsn)->logger($log); ``` ### SELECT [](#select) ``` // array style $users = PowerPDO::make($dsn) ->select("ID, user_name, nickname, email") ->from("users") ->where("deleted = 0") ->getAll(); foreach($users as $u){ $uid = $u['ID']; $name = $u['user_name']; echo "[$uid]$name"; } // entity style $users = PowerPDO::make($dsn) ->select("ID, user_name, nickname, email") ->from("users") ->where("deleted = 0") ->getAll(UserEntity::class); foreach($users as $u){ $uid = $u->ID; $name = $u->user_name; echo "[$uid]$name"; } ``` ### Placeholders(Prepared statement) [](#placeholdersprepared-statement) ``` $users = PowerPDO::make($dsn) ->select("ID, user_name, nickname, email") ->from("users") ->where("nickname LIKE :nickname") ->bind(['nickname' => '%Bi%']) ->getAll(); ``` ### Count [](#count) ``` use Monolog\Logger; use Monolog\Handler\StreamHandler; $users = PowerPDO::make($dsn) ->count() ->from("users") ->where("deleted = 0") ->get(); ``` ### Transaction [](#transaction) ``` use Stk2k\PowerPDO\Transaction; use Stk2k\PowerPDO\exception\TransactionException; try{ $tr = new Transaction($pdo); $tr->begin(); // execute UPDATE/DELETE/INSERT SQL here $tr->commit(); } catch(TransactionException $ex){ $tr->rollback(); } ``` ### INSERT [](#insert) ``` // array style PowerPDO::make($dsn) ->insert() ->into("users", "ID, user_name, nickname, email") ->values( "ID" => "123", "user_name" => "hanako", "nickname" => "hana", "email" => "hanako@sample.com" ) ->execute(); // entity style $new_user = new UserEntity(); $new_user->ID = 123; $new_user->user_name = 'hanako'; $new_user->nickname = 'hana'; $new_user->email = 'hanako@sample.com'; PowerPDO::make($dsn) ->insert() ->into("users") ->values($new_user) ->execute(); ``` ### UPDATE [](#update) ``` // literal style PowerPDO::make($dsn) ->update("users") ->set("user_name", "hanako2") ->set("email", "hanako2@sample.com") ->where("ID = :ID", ['ID'=>1]) ->execute(); // array style PowerPDO::make($dsn) ->update("users") ->values([ 'user_name' => 'hanako2', 'email' => 'hanako2@sample.com', ]) ->where("ID = :ID", ['ID'=>1]) ->execute(); // entity style $new_user = new UserEntity(); $new_user->user_name = 'hanako2'; $new_user->nickname = 'hana2'; $new_user->email = 'hanako2@sample.com'; PowerPDO::make($dsn) ->update("users") ->values($new_user) ->where("ID = :ID", ['ID'=>1]) ->execute(); ``` ### DELETE [](#delete) ``` use Stk2k\PowerPDO\PowerPDO; // literal style PowerPDO::make($dsn) ->delete() ->from("users") ->where("email = 'hanako2@sample.com'") ->execute(); // placeholder style PowerPDO::make($dsn) ->delete() ->from("users") ->where("email = :email",['email' => 'hanako2@sample.com']) ->execute(); ``` Requirement ----------- [](#requirement) PHP 7.3 or later Installing stk2k/power-pdo -------------------------- [](#installing-stk2kpower-pdo) The recommended way to install stk2k/power-pdo is through [Composer](http://getcomposer.org). ``` composer require stk2k/power-pdo ``` After installing, you need to require Composer's autoloader: ``` require 'vendor/autoload.php'; ``` License ------- [](#license) This library is licensed under the MIT license. Author ------ [](#author) [stk2k](https://github.com/stk2k) Disclaimer ---------- [](#disclaimer) This software is no warranty. We are not responsible for any results caused by the use of this software. Please use the responsibility of the your self. ### Health Score 20 — LowBetter than 14% of packages Maintenance20 Infrequent updates — may be unmaintained Popularity6 Limited adoption so far Community7 Small or concentrated contributor base Maturity42 Maturing project, gaining track record 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. ### Release Activity Cadence Every ~3 days Total 16 Last Release 1479d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/955f3d564811dc5e1212c1a7a66bc4eb7e11ac166cc38600f244dc25f97d3ef4?d=identicon)[stk2k](/maintainers/stk2k) --- Top Contributors [![stk2k](https://avatars.githubusercontent.com/u/985640?v=4)](https://github.com/stk2k "stk2k (31 commits)") --- Tags phpentityquery builderPHP7databsephp8 ### Code Quality TestsPHPUnit ### Embed Badge ![Health badge](/badges/stk2k-power-pdo/health.svg) ``` [![Health](https://phpackages.com/badges/stk2k-power-pdo/health.svg)](https://phpackages.com/packages/stk2k-power-pdo) ``` ### Alternatives [clouddueling/mysqldump-php PHP version of mysqldump cli that comes with MySQL 1.3k22.9k](/packages/clouddueling-mysqldump-php)[wayofdev/laravel-cycle-orm-adapter 🔥 A Laravel adapter for CycleORM, providing seamless integration of the Cycle DataMapper ORM for advanced database handling and object mapping in PHP applications. 3516.7k3](/packages/wayofdev-laravel-cycle-orm-adapter)[tommyknocker/pdo-database-class Framework-agnostic PHP database library with unified API for MySQL, MariaDB, PostgreSQL, SQLite, MSSQL, and Oracle. Query Builder, caching, sharding, window functions, CTEs, JSON, migrations, ActiveRecord, CLI tools, AI-powered analysis. Zero external dependencies. 845.7k](/packages/tommyknocker-pdo-database-class)[matchory/elasticsearch The missing elasticsearch ORM for Laravel! 3059.0k](/packages/matchory-elasticsearch)[hemiframe/php-query-builder Powerful and lightweight PHP SQL Query Builder 1018.2k](/packages/hemiframe-php-query-builder) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)