Download the PHP package 1owe1/query-box without Composer
On this page you can find all versions of the php package 1owe1/query-box. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Table of contents
Download 1owe1/query-box
More information about 1owe1/query-box
Files in 1owe1/query-box
Download 1owe1/query-box
More information about 1owe1/query-box
Files in 1owe1/query-box
Vendor 1owe1
Package query-box
Short Description SQL immutable query builder
License MIT
Homepage https://github.com/1ove1/query-box
Package query-box
Short Description SQL immutable query builder
License MIT
Homepage https://github.com/1ove1/query-box
FAQ
After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.
Example:
Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories.
In this case some credentials are needed to access such packages.
Please use the auth.json textarea to insert credentials, if a package is coming from a private repository.
You can look here for more information.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?
Informations about the package query-box
Query Box - immutable SQL query builder with minimum dependencies
Description
Actual features:
- Select, insert, update, delete;
- Where, join (inner, left, right), limit, order by;
- Sub select queries;
- Simple migration tools.
Setup
-
Instal package from composer:
-
Setup db connection params in your $_ENV directly (like bootstrap action) or use .env parser instead:
- Create your first model (or use QueryBuilder::table('my_table')):
Migration example:
Usage:
Configuration
App expect these global variables:
- Debug options:
- $_ENV['LOG_QUERY_RESULTS'] (boolean, false by default) - logg raw queries into the log file (require log path otherwise log will be output in std);
- $_ENV['LOG_PATH'] (string) - path to log file;
- DB connection:
- $_ENV['DB_TYPE'] (mysql/pgsql, mysql by default) - type of db (for now support only mysql and pgsql);
- *$_ENV['DB_NAME'] (required) - name of db;
- $_ENV['DB_HOST'] (localhost by default) - host of db;
- $_ENV['DB_PORT'] (3306 by default) - db port;
- *$_ENV['DB_USER'] (required) - db username or role;
- *$_ENV['DB_PASS'] (required) - db pass.
Tests
Tests defined into ./test directory (QueryBox\Tests\ namespace), use './vendor/bin/phpunit'.
Also you can use phpstan by './vendor/bin/phpstan' (level 9 by default).
Examples
You also can find some examples into ./example directory.
All versions of query-box with dependencies
PHP Build Version
Package Version
The package 1owe1/query-box contains the following files
Loading the files please wait ....