Download the PHP package phpdevcommunity/relational-query without Composer

On this page you can find all versions of the php package phpdevcommunity/relational-query. 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 phpdevcommunity/relational-query

Informations about the package relational-query

PHP SQL Query Builder

A lightweight PHP query builder for easy database interactions.

Installation

You can install this library via Composer. Make sure your project meets the minimum PHP version requirement of 7.4 or higher.

Usage

The SQL Query Builder library allows you to build SQL queries fluently using an object-oriented approach. Here are some examples of usage:

Creating a SELECT Query

Types of SQL Joins with QueryBuilder

The SQL Query Builder library supports various types of JOIN operations to combine rows from multiple tables based on a related column between them. Below are examples of different JOIN types you can use with QueryBuilder:

1. INNER JOIN

An INNER JOIN returns records that have matching values in both tables.

2. LEFT JOIN

A LEFT JOIN returns all records from the left table (first table) and the matched records from the right table (second table). If there is no match, the result is NULL on the right side.

3. RIGHT JOIN

A RIGHT JOIN returns all records from the right table (second table) and the matched records from the left table (first table). If there is no match, the result is NULL on the left side.

Creating a SELECT Query with DISTINCT

You can use the distinct() method to specify a SELECT DISTINCT query with QueryBuilder.

Creating a SELECT Query with GROUP BY

You can use the groupBy() method to specify a GROUP BY clause with QueryBuilder.

Creating a SELECT Query with HAVING Clause

You can use the having() method to specify a HAVING clause with QueryBuilder.

Creating an INSERT Query

Creating an UPDATE Query

Creating an DELETE Query

Creating a SELECT Query with Custom Expression

List of Available Expressions (Expr)

Here is a comprehensive list of available static methods in the Expr class along with examples demonstrating their usage:

Expr::equal(string $key, string $value)

Expr::notEqual(string $key, string $value)

Expr::greaterThan(string $key, string $value)

Expr::greaterThanEqual(string $key, string $value)

Expr::lowerThan(string $key, string $value)

Expr::lowerThanEqual(string $key, string $value)

Expr::isNull(string $key)

Expr::isNotNull(string $key)

Expr::in(string $key, array $values)

Expr::notIn(string $key, array $values)

These examples demonstrate how to use each Expr class method to generate SQL expressions for various comparison and conditional operations. Incorporate these methods into your SQL Query Builder usage to construct complex and precise SQL queries effectively.

Features

License

This library is open-source software licensed under the MIT license.

All versions of relational-query with dependencies

PHP Build Version
Package Version
Requires php Version >=7.4
ext-pdo 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 phpdevcommunity/relational-query contains the following files

Loading the files please wait ....