Download the PHP
package zimzat/query-builder-mysql without Composer
On this page you can find all versions of the php package
zimzat/query-builder-mysql. It is possible to download/install
these versions without Composer. Possible dependencies are resolved
automatically.
Vendor zimzat Package query-builder-mysql Short Description A simple, flexible, and safe way to dynamically build queries for MySQL or MariaDB License
MIT
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:
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.
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.
Informations about the package query-builder-mysql
PHP Query Builder for MySQL
A simple, flexible, and safe way to dynamically build queries for MySQL or similar databases.
Features
Parameterize inputs by default.
Flexible to handle custom expressions not available out of the box.
Uses object instances to maintain query state, no static methods.
Works with any connection library (PDO or mysqli)
Installation
Composer
Usage
Main Entry Points
Output
The SqlWriter class can be used to generate the SQL string and Parameter array. It is light-weight and does not contain any state, making it safe to re-use or instantiate on demand.
SELECT
SELECT queries can also be used as part of other statements as a Sub-Query or INSERT ... SELECT.
UNION
Sub-Query
UPDATE
INSERT
The primary use-case for Insert is in conjunction with Select. It does not support multiple rows.
DELETE
Extensions
Any class implementing the Sql interface can be used in several places.
Extensions of the Condition or Expr class can be created to handle repeat expressions.
Alternatively, you can create your own wrapper to return a new stance of Condition to the same effect:
Library Comparisons
See: Query Builder Library Comparison
All versions of query-builder-mysql with dependencies
Composer command for our command line client (download client)This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free.Standard composer command
The package zimzat/query-builder-mysql contains the following files
Loading the files please wait ...
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.