PHPackages                             db/sql-packge - 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. db/sql-packge

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

db/sql-packge
=============

v1(4y ago)28[1 PRs](https://github.com/yossef-ashraf/sql-packge/pulls)MITPHP

Since Mar 30Pushed 4y ago1 watchersCompare

[ Source](https://github.com/yossef-ashraf/sql-packge)[ Packagist](https://packagist.org/packages/db/sql-packge)[ RSS](/packages/db-sql-packge/feed)WikiDiscussions main Synced 1mo ago

READMEChangelog (1)DependenciesVersions (2)Used By (0)

sql-packge
==========

[](#sql-packge)

sql-packge is a small php wrapper for mysql databases.

installation
------------

[](#installation)

install once with composer:

```
composer require db/sql-packge

```

then add this to your project:

```
require __DIR__ . '/vendor/autoload.php';
use Db\SqlPackge\sql;
$db = new sql();
```

usage
-----

[](#usage)

```
/* connect to database */
$db = new sql('127.0.0.1', 'username', 'password', 'database', 3306);

/* exaples */

/* select */
var_dump( $db->select("users","*")->getAll());
var_dump( $db->select("users","*")->where("id","=","9")->getRow());
var_dump( $db->andWhere("id","LIKE","5")->getRow());
var_dump( $db->orWhere("id","BETWEEN","5")->getRow());
var_dump( $db->WhereNot("id","IN","5")->getRow());
var_dump( $db->notWhere("id","