PHPackages                             sinasalek/pdoplus - 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. sinasalek/pdoplus

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

sinasalek/pdoplus
=================

PDO wrapper. Extends PDO and PDOStatement with useful methods.

054PHP

Since Oct 20Pushed 9y ago1 watchersCompare

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

READMEChangelogDependenciesVersions (1)Used By (0)

PDO wrapper with query builder
==============================

[](#pdo-wrapper-with-query-builder)

PDO wrapper extends PDO and PDOStatement classes and add some nice methods as insert/update/delete and so on. Also, there is very useful SQL query builder.

API
---

[](#api)

Because library extends [PDO driver](http://php.net/manual/en/book.pdo.php), you can use all of native PDO methods and new additional: ###DB - The database class

- `insert` - insert object or array as row to database table (optionaly: using prepared statement)
- `update` - update existent row in database table (optionaly: using prepared statement)
- `replace` - insert or replace (using REPLACE table... syntax)
- `save` - save data to table (method determinate does insert or update will be used)
- `delete` - delete row(s) in database table
- `count` - shortcut for SELECT COUNT(\*) statement
- `select` - query build object
- `createQuery` - create new query builder
- `getColumnsFromTable` - all columns from table as array

\###Statement

- `fetchInto` - fetch row into object (optionaly: only from specific table)
- `fetchIntoFromLastRow` - fetch another object from last row (based on table name)
- `fetchCollection` - fetch collection of objects (custom defined object or stdClass)
- `getColumnValue` - value from specific column

\###Query - Build SQL query object

- `select` - statement for SELECT
- `from` - statement for FROM
- `where` - adding new WHERE statement. Multiple where will be joined by AND
- `whereIn` - adding WHERE IN (...) statement
- `whereNotIn` - adding WHERE NOT IN (...) statement
- `having` - statement for HAVING
- `join` - join table syntax
- `groupBy` - GROUP BY statement
- `orderBy` - ORDER BY statement
- `limit` - LIMIT statement
- `getQuery` - buld and return query string
- `execute` - execute query

See more information about [how to use database query builder](https://github.com/salebab/database/wiki/How-to-use-Database-query-builder).

Usage examples
--------------

[](#usage-examples)

### Creating database instance

[](#creating-database-instance)

```
$db = new database\DB("mysql:host=localhost;dbname=YOUR_DB_NAME", "YOUR_DB_USERNAME", "YOUR_DB_PASSWORD");

```

### Select

[](#select)

Execute query and fetch **User** object:

```
class User {}

$user_id = 1;
$sql = "SELECT * FROM users WHERE user_id = ? AND is_active = ?";
$user = $db->executeQuery($sql, array($user_id, 1))
	->fetchInto(new User); // or ->fetchObject("User") as in standard PDO driver

```

If you need a collection of **User** objects, you can use `fetchCollection` method:

```
$users = $db->executeQuery($sql, array($user_id, 1))
	->fetchCollection(new User); // or ->fetchCollection("User");

```

More complex, with query builder. You can build 'native' structure of objects. For example, you can fetch collection of objects **Post** and every **Post** object may have a property `$author` which is a instance of **User** object:

```
class User
{
    /**
     * Get user's first and last name
     *
     * @return string
     */
    function getName() {
        return $this->first_name . " ". $this->last_name;
    }
}

class Post
{
	/**
	 * @var User
	 */
	public $author;
}

// Library need FETCH_TABLE_NAMES option for mapping class names and table names
$db->setFetchTableNames(1);

$sql = $db->select("p.*, u.*")
	->from("posts p")
	->join("INNER JOIN users u USING(user_id)")
	->where("u.user_id = ?", $user_id)
	->orderBy("p.title");

$stmt = $sql->execute();

/* @var Post[] $post_collection  */
$post_collection = array();

// Fetching data into Post object from posts table (p is alias)
while($post = $stmt->fetchInto(new Post, "p")) {

	// fetch User object from users table (u is alias)
	$post->author = $stmt->fetchIntoFromLastRow(new User, "u");

	$post_collection[] = $post;
}

// You can send $post_collection from model to view in your controller, so here is usage in view
foreach($post_collection as $post) {
    echo $post->author->getName();
}

```

### Insert

[](#insert)

Library has `insert` method for easy inserting **array or object** as row to database table. Note that all other properties or elements that not match column names will be ignored.

```
$data = array(
	"username" => "User 1234",
	"email" => "user@example.com",
	"mtime" => time()
);
$db->insert("users", $data);

```

### Insert with prepared statement

[](#insert-with-prepared-statement)

Third param for `insert()` method is "unique prepared stmt key". Every insert which have that key will use the same prepared statement.

```
foreach($data_array as $data) {
	$db->insert("users", $data, "unique_stmt_key");
}

```

### Update

[](#update)

Some examples of update statement

```
$user_id = 1;
$db->update("users", $data, "user_id = ?", $user_id);
$db->update("users", $data, "user_id = ? AND email = ?", array(1, "user@example.com"));

```

### Saving data

[](#saving-data)

Automatic determination of INSERT or UPDATE. If $data\['user\_id'\] exits it will be UPDATE, otherwise it will be INSERT.

```
$db->save("users", $data, "user_id"); // user_id is name of PRIMARY column

```

### More examples

[](#more-examples)

```
// Delete row in table
// some as $db->exec("DELETE FROM users WHERE user_id = 1");
$db->delete("users", "user_id = ?", $user_id);

// Count rows in table
$count = $db->count("users");

/* @var User[] $users Collection of User objects */
$users = $db->executeQuery("SELECT * FROM users")->fetchCollection(new User);

```

[See more examples for Sakila database](https://github.com/salebab/database/tree/master/examples/sakila)

###  Health Score

21

—

LowBetter than 19% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity41

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.

### Community

Maintainers

![](https://www.gravatar.com/avatar/571bc5d492f577748449e5624607338f321e59571a60043b65970f4129def671?d=identicon)[sinasalek](/maintainers/sinasalek)

---

Top Contributors

[![sinasalek](https://avatars.githubusercontent.com/u/592240?v=4)](https://github.com/sinasalek "sinasalek (22 commits)")

### Embed Badge

![Health badge](/badges/sinasalek-pdoplus/health.svg)

```
[![Health](https://phpackages.com/badges/sinasalek-pdoplus/health.svg)](https://phpackages.com/packages/sinasalek-pdoplus)
```

###  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.3k](/packages/illuminate-database)[mongodb/mongodb

MongoDB driver library

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

Use ramsey/uuid as a Doctrine field type.

90340.3M209](/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)