Download the PHP package co0lc0der/simple-query-builder without Composer

On this page you can find all versions of the php package co0lc0der/simple-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:
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.
Please rate this library. Is it a good library?

Example code of co0lc0der/simple-query-builder

Informations about the package simple-query-builder

QueryBuilder php component

Latest Version GitHub repo size Packagist Downloads GitHub license Packagist PHP Version Support

This is a small easy-to-use PHP component for working with a database by PDO. It provides some public methods to compose SQL queries and manipulate data. Each SQL query is prepared and safe. QueryBuilder fetches data to arrays by default. At present time the component supports MySQL and SQLite (file or memory).

PAY ATTENTION! v0.2 and v0.3+ are incompatible.

Contributing

Bug reports and/or pull requests are welcome

License

The package is available as open source under the terms of the MIT license

Installation

The preferred way to install this extension is through composer.

Either run

or add

to the require section of your composer.json file.

How to use

Edit config.php and set the parameters up. Choose DB driver, DB name etc

Use composer autoloader

Init QueryBuilder with Connection::make()

Usage examples

Select all rows from a table

Result query

Select rows with two conditions

Result query

Update a row

Result query

More examples you can find in documentation or tests.

ToDo

I'm going to add the next features into future versions

All versions of simple-query-builder with dependencies

PHP Build Version
Package Version
Requires php Version >=7.4
ext-pdo Version *
ext-fileinfo Version *
ext-intl Version *
ext-json Version *
ext-mbstring Version *
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 co0lc0der/simple-query-builder contains the following files

Loading the files please wait ....