Download the PHP package hemiframe/php-query-builder without Composer
On this page you can find all versions of the php package hemiframe/php-query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
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 php-query-builder
php-query-builder
Powerful and lightweight PHP SQL Query Builder with fluid interface SQL syntax using bindings and complicated query generation
Features
- multiple databases (multiple PDO instances)
- INSERT, INSERT IGNORE, INSERT DELAYED, UPDATE, SELECT, DELETE queries
- support LEFT JOIN, INNER JOIN, RIGHT JOIN, GROUP BY, LIMIT, HAVING and etc.
- =, !=, >, <, >=, <=, IN, NOT IN, IS NULL, NOT NULL operators
- support transactions and sub-queries
- support result caching (
\Psr\SimpleCache\CacheInterface) - multiple fetching data modes (fetch arrays, fetch objects, etc.)
- auto escape column names
- auto format queries
- auto bind variables
- hydration to objects (auto cast types from annotations and property types). See
demo/hydration.php
Quick install
The recommended way to install the Query Builder is through Composer. Run the following command to install it:
Set default PDO instance:
Documentation
Select query
Output:
Select query from sub query
Output:
Insert query
Output:
Insert query with VALUES
Output:
Update query
Output:
Delete query
Output:
Delete query with joins
Output:
Fetching data
Fetch data as array of arrays
Fetch data as array of objects
Fetch first result as array
Fetch first result as object
Using multiple databases
All versions of php-query-builder with dependencies
PHP Build Version
Package Version
The package hemiframe/php-query-builder contains the following files
Loading the files please wait ....