PHPackages                             lnked/q - 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. lnked/q

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

lnked/q
=======

a query builder library for PHP

068PHP

Since Nov 10Pushed 8y ago1 watchersCompare

[ Source](https://github.com/lnked/Q)[ Packagist](https://packagist.org/packages/lnked/q)[ RSS](/packages/lnked-q/feed)WikiDiscussions master Synced yesterday

READMEChangelogDependenciesVersions (1)Used By (0)

Q3
==

[](#q3)

Simple database abstraction library for php

Connect to database
-------------------

[](#connect-to-database)

```
require 'path/to/Q/Q.php';
QF('mysql://user:pass@host/dbname') // setup dsn
    ->connect()                     // connect to database
    ->alias('default')              // set "default" alias
    ->tablePrefix('project__');     // set table prefix
```

Connect to other db and set alias “other-db”

```
QF('mysql://user:pass@host/dbname2?charset=utf8')->alias('other-db')->connect()->tablePrefix('bb__');
```

Executing query, fetch row and free result
------------------------------------------

[](#executing-query-fetch-row-and-free-result)

**Execute query, fetch first row and free result**

```
$res = Q('SELECT * FROM #users WHERE id = ?i', array(1));
$row = $res->row();
```

Builded query:

```
SELECT * FROM project__users WHERE id = 1
```

**Execute query and fetch each rows.** When all rows will be fetched – result will be freeing automatically

```
$res = Q('SELECT * FROM #users');
while ($row = $res->each())
{
    print_r($row);
}
```

Execute query, get all rows and free result

```
$all = Q('SELECT * FROM #users WHERE id > ?i AND id < ?i', array(0, 30))->all();
// get all rows, key in result array will be field ID
$all = Q('SELECT * FROM #users WHERE id > ?i AND id < ?i', array(0, 30))->all('id');
```

Builded query:

```
SELECT * FROM project__users WHERE id > 0 AND id < 30
```

**Insert set of data by using one template**

```
Q('INSERT INTO #test VALUES (?i, ?s, ?x, ?e)
        ON DUPLICATE KEY UPDATE a = VALUES(a)*?x', array(
    array(10, 'str11', 'str12', 'a*10'),
    array(20, 'str21', 'str22', 'a*20'),
    50,
    array(30, 'str31', 'str32', 'a*30')
));
```

Builded query:

```
INSERT INTO project__test VALUES
        (10, 'str11', 'str12', a*10),
        (10, 'str21', 'str22', a*20),
        (10, 'str31', 'str32', a*30)
    ON DUPLICATE KEY UPDATE
        a = VALUES(a)*50
```

Where:
?i – integer
?f – float
?b – boolean
?d – date
?t – time
?dt – datetime
?s – string (mysql\_real\_escape\_string)
?x – auto detect type
?e – eval – no changes
?li – list of int
?ls – list of string

**Building lists for queries with IN**

Build list of int values with `?li` modifier:

```
$ids = array(1,3,5,7);
$res = Q('SELECT * FROM #test WHERE id IN(?li)', array($ids));
```

Builded query:

```
SELECT * FROM project__test WHERE id IN(1,3,5,7)
```

List of string values with `?ls`: modifier:

```
$names = array('Anna', 'Bob');
$res = Q('SELECT * FROM #test WHERE name IN(?ls)', array($names));
```

Builded query:

```
SELECT * FROM project__test WHERE name IN('Anna', 'Bob')
```

**Execute query on other db, get all rows and free result**

```
$all = Q('other-db: SHOW TABLES')->all();
```

**You can use connection as a variable**

```
$db = QF('mysql://user:pass@host/dbname?charset=utf8')->connect()->tablePrefix('aa__');
$all = $db->query('SELECT * FROM #registration_document_types')->all();
```

Aliases for query parameters
----------------------------

[](#aliases-for-query-parameters)

You can use aliases for query parameters:

```
Q('SELECT * FROM #table WHERE a = ?s:param1 AND b = ?i:param2', array(
        'param2' => 123,
        'param1' => 'some value'
);
```

Builded query:

```
SELECT * FROM #table WHERE a = 'some value' AND b = 123
```

Also you can use combined method of passing parameters:

```
Q('SELECT * FROM #table WHERE a = ?s:param1 AND b = ?i:param2 AND c = ?f', array(
        'param2' => 123,
        12.65,
        'param1' => 'some value'
);
```

Builded query (if aliases not set, the parameter will be getting by array\_shift):

```
SELECT * FROM #table WHERE a = 'some value' AND b = 123 AND c = 12.65
```

Another example:

```
Q('INSERT INTO #table (a, b, c) VALUES
                (?i:field_a, ?s:field_b, CONCAT(?x, ":", ?s:field_b))
        ON DUPLICATE KEY UPDATE a = VALUES(a) * ?x:multiplier', array(
    array(
        'field_a' => '1', 'field_b' => 'AAA 1', 1
    ),
    array(
        'field_a' => '2', 'field_b' => 'BBB 2', 2
    ),
    'multiplier' => 75,
    array(
        'field_a' => '3', 'field_b' => 'CCC 3', 3
    )
));
```

Builded query:

```
INSERT INTO seg__table (a, b, c) VALUES
        (1, 'AAA 1', CONCAT(1, ":", 'AAA 1')),
        (2, 'BBB 2', CONCAT(2, ":", 'BBB 2')),
        (3, 'CCC 3', CONCAT(3, ":", 'CCC 3'))
    ON DUPLICATE KEY UPDATE
        a = VALUES(a) * 75
```

###  Health Score

21

—

LowBetter than 18% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity8

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity41

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 62.5% 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://avatars.githubusercontent.com/u/868121?v=4)[Edik Bulikyan](/maintainers/lnked)[@lnked](https://github.com/lnked)

---

Top Contributors

[![lnked](https://avatars.githubusercontent.com/u/868121?v=4)](https://github.com/lnked "lnked (25 commits)")[![im4LF](https://avatars.githubusercontent.com/u/155329?v=4)](https://github.com/im4LF "im4LF (15 commits)")

### Embed Badge

![Health badge](/badges/lnked-q/health.svg)

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

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

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

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

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