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

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

sql/genericsqlformat
====================

SQL helper, Generic SQL Format

V2(4y ago)020MITPHPPHP >=7.0.0

Since Dec 14Pushed 3y ago1 watchersCompare

[ Source](https://github.com/romulo126/GenericSQLFormat)[ Packagist](https://packagist.org/packages/sql/genericsqlformat)[ Docs](https://github.com/romulo126/GenericSQLFormat)[ RSS](/packages/sql-genericsqlformat/feed)WikiDiscussions main Synced 1mo ago

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

PHP Generic Query SQL
=====================

[](#php-generic-query-sql)

Composer Install
----------------

[](#composer-install)

```
composer require sql/genericsqlformat

```

Description
-----------

[](#description)

```
simple query generator for PHP

```

OBS:
----

[](#obs)

- All classes have manualQueryBuilder() method where you can pass a string with the query
- The database connection settings are in the Config folder in the Config.php file
- If you don't want to use environment edit the config file

Required
--------

[](#required)

```
- PHP 7.0+
- Composer
- ENVIRONMENT VARIABLES

```

ENVIRONMENT VARIABLES
---------------------

[](#environment-variables)

```
- GENERICSQLFORMAT_HOST
- GENERICSQLFORMAT_USER
- GENERICSQLFORMAT_PASSWORD
- GENERICSQLFORMAT_DATABASENAME
- GENERICSQLFORMAT_PORT // 5432 (PostgreSQL), 3306 (MySQL), 1521 (Oracle)
- GENERICSQLFORMAT_DRIVE //mysql, pgsql, sqlite, sqlsrv, oci, mssql, dblib, oracle,

```

Usage
-----

[](#usage)

- Select: ```