PHPackages                             midorikocak/querymaker - 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. midorikocak/querymaker

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

midorikocak/querymaker
======================

QueryMaker is a little library that helps you create simple PDO queries

v1.4.7(6y ago)1630912MITPHPPHP ~7.4

Since Jan 23Pushed 6y ago1 watchersCompare

[ Source](https://github.com/midorikocak/querymaker)[ Packagist](https://packagist.org/packages/midorikocak/querymaker)[ Docs](https://github.com/midorikocak/querymaker)[ RSS](/packages/midorikocak-querymaker/feed)WikiDiscussions master Synced today

READMEChangelog (10)Dependencies (4)Versions (16)Used By (2)

querymaker
==========

[](#querymaker)

[![Latest Version on Packagist](https://camo.githubusercontent.com/bdb3e1a8c8673619e40e8ecd742f2930475b0de920bcee6c30bc4b106ccd9488/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f762f6d69646f72696b6f63616b2f71756572796d616b65722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/midorikocak/querymaker)[![Software License](https://camo.githubusercontent.com/55c0218c8f8009f06ad4ddae837ddd05301481fcf0dff8e0ed9dadda8780713e/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c61742d737175617265)](LICENSE.md)[![Build Status](https://camo.githubusercontent.com/54541c5e496872614f72e4af2da1546a76963d468bc83bcbb0fa8783ffd01cc1/68747470733a2f2f696d672e736869656c64732e696f2f7472617669732f6d69646f72696b6f63616b2f71756572796d616b65722f6d61737465722e7376673f7374796c653d666c61742d737175617265)](https://travis-ci.org/midorikocak/querymaker)[![Coverage Status](https://camo.githubusercontent.com/575a50704d22e19d13e99666932e5da641617bda1e31c9065b591a0570cd8eb7/68747470733a2f2f696d672e736869656c64732e696f2f7363727574696e697a65722f636f7665726167652f672f6d69646f72696b6f63616b2f71756572796d616b65722e7376673f7374796c653d666c61742d737175617265)](https://scrutinizer-ci.com/g/midorikocak/querymaker/code-structure)[![Quality Score](https://camo.githubusercontent.com/3e82ef65b9ce60de933677885a3810021e143d3108a0d7a2210a8d2c489b9caf/68747470733a2f2f696d672e736869656c64732e696f2f7363727574696e697a65722f672f6d69646f72696b6f63616b2f71756572796d616b65722e7376673f7374796c653d666c61742d737175617265)](https://scrutinizer-ci.com/g/midorikocak/querymaker)[![Total Downloads](https://camo.githubusercontent.com/e92f9db71fe2bde6c74580cafc8062dbd54a8d935389e4d197e371b6e557dd9e/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f6d69646f72696b6f63616b2f71756572796d616b65722e7376673f7374796c653d666c61742d737175617265)](https://packagist.org/packages/midorikocak/querymaker)

This small library, allows you to create simple SQL queries to use with PDO easily. Just using methods with simple db command names, you can create seamless statements and key value array to use in execution.

Motivation
----------

[](#motivation)

When using PDO, writing queries are prone to syntax and parameter errors. To prevent them in simple queries you can use this library.

Requirements
------------

[](#requirements)

Strictly requires PHP 7.4.

Install
-------

[](#install)

Via Composer

```
$ composer require midorikocak/querymaker
```

Usage
-----

[](#usage)

There are starter methods to create a query, such as `SELECT` and `UPDATE`.

### Select

[](#select)

```
$queryMaker = new QueryMaker();
$queryMaker->select('users');
echo $queryMaker->getQuery();
```

The above example will output:

```
SELECT * FROM users
```

### Select with fields

[](#select-with-fields)

Fields to select can be specified as well:

```
$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email']);
echo $queryMaker->getQuery();
```

The above example will output:

```
SELECT id, email FROM users
```

### Fields with different operators

[](#fields-with-different-operators)

Field values can include operators, such as: `=`,`>`, `select('users', ['id', 'email'])->where('id', '3', '>=');
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();
```

The above example will output:

```
SELECT id, email FROM users WHERE id>='3'
SELECT id, email FROM users WHERE id>=:id'
```

### Delete

[](#delete)

```
$queryMaker = new QueryMaker();
$queryMaker->delete('users');
echo $queryMaker->getQuery();
```

The above example will output:

```
DELETE FROM users
```

### Where

[](#where)

To specify `WHERE` clauase use `where($key, $value)` method.

```
$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('id', 3);
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();
```

The above example will output:

```
SELECT id, email FROM users WHERE id='3'
SELECT id, email FROM users WHERE id=:id
```

### AND and OR

[](#and-and-or)

Contraints such as `AND` and `OR`, are methods as well. `and($key, $value)` and `or($key, $value)`

```
$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('id', 3)->and('email', 'mtkocak@gmail.com')->or('username', 'midori');
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();
```

The above example will output:

```
SELECT id, email FROM users WHERE id='3' OR username='midori'
SELECT id, email FROM users WHERE id=:id OR username=:username
```

Multiple AND and OR clauses can have same field conditions.

```
$queryMaker = new QueryMaker();
$queryMaker->select('users', ['id', 'email'])->where('email', 'mtkocak@gmail.com')->and('id', '>3')->and('id', 'select('users', ['id', 'email'])->where('id', 3)->and('email', 'mtkocak@gmail.com')->or('username', 'midori');

$statement = $db->prepare($query->getStatement());

$statement->execute($query->getParams());
```

### Insert

[](#insert)

To specify `INSERT` operation, `insert()` method, expects a key value array.

```
$queryMaker = new QueryMaker();
$queryMaker->insert('users', ['email' => 'mtkocak@gmail.com', 'username' => 'midorikocak']);
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();
```

The above example will output:

```
INSERT INTO users (email, username) VALUES ('mtkocak@gmail.com', 'midorikocak')
INSERT INTO users (email, username) VALUES (:email, :username)
```

### Update

[](#update)

To specify `UPDATE` operation, handy `update()` method, expects a key value array. All statement params are generated thoroughly.

```
$queryMaker = new QueryMaker();
$queryMaker->update('users', ['email' => 'mtkocak@gmail.com', 'username' => 'midorikocak'])->where('id', 3);
echo $queryMaker->getQuery();
echo $queryMaker->getStatement();
```

The above example will output:

```
UPDATE users SET email='mtkocak@gmail.com', username='midorikocak' WHERE id='3'
UPDATE users SET email=:email, username=:username WHERE id=:id
```

Warning
-------

[](#warning)

This library is for educational purposes. Use at your own risk. Exposing query values and using it would create security issues.

Change log
----------

[](#change-log)

Please see [CHANGELOG](CHANGELOG.md) for more information on what has changed recently.

Testing
-------

[](#testing)

```
$ composer test
```

Contributing
------------

[](#contributing)

Please see [CONTRIBUTING](CONTRIBUTING.md) and [CODE\_OF\_CONDUCT](CODE_OF_CONDUCT.md) for details.

Security
--------

[](#security)

If you discover any security related issues, please email  instead of using the issue tracker.

Credits
-------

[](#credits)

- [Midori Kocak](https://github.com/midorikocak)
- [All Contributors](../../contributors)

License
-------

[](#license)

The MIT License (MIT). Please see [License File](LICENSE.md) for more information.

###  Health Score

33

—

LowBetter than 72% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity22

Limited adoption so far

Community12

Small or concentrated contributor base

Maturity65

Established project with proven stability

 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

15

Last Release

2346d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/983c3c55c001768e4e31e784835671f27dcccd9158a77870ffbb8167896f88f1?d=identicon)[midorikocak](/maintainers/midorikocak)

---

Top Contributors

[![midorikocak](https://avatars.githubusercontent.com/u/545472?v=4)](https://github.com/midorikocak "midorikocak (34 commits)")

---

Tags

midorikocakquerymaker

###  Code Quality

TestsPHPUnit

Code StylePHP\_CodeSniffer

### Embed Badge

![Health badge](/badges/midorikocak-querymaker/health.svg)

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.8k117.8M121](/packages/jdorn-sql-formatter)[backup-manager/backup-manager

A framework agnostic database backup manager with user-definable procedures and support for S3, Dropbox, FTP, SFTP, and more with drivers for popular frameworks.

1.7k1.6M11](/packages/backup-manager-backup-manager)[propel/propel1

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

8351.6M88](/packages/propel-propel1)[insolita/yii2-migration-generator

Set of gii tools for generating files for migration by schema of table , phpdoc or table data

108508.0k5](/packages/insolita-yii2-migration-generator)[xpdo/xpdo

A PDO-based Object/Relational Bridge Library

7088.4k4](/packages/xpdo-xpdo)[voku/session2db

A PHP library acting as a wrapper for PHP's default session handling functions which stores data in a MySQL database, providing both better performance and better security and protection against session fixation and session hijacking.

2920.0k](/packages/voku-session2db)

PHPackages © 2026

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