Download the PHP package cuongnd88/lara-query-kit without Composer

On this page you can find all versions of the php package cuongnd88/lara-query-kit. 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?

Informations about the package lara-query-kit

Lara Query Kit

Lara Query Kit utilizes the Eloquent model. PHP Trait and Laravel local scope are used to implement this utilitiy

PHP Traits

PHP only supports single inheritance: a child class can inherit only from one single parent.

So, what if a class needs to inherit multiple behaviors? OOP traits solve this problem.

Traits are used to declare methods that can be used in multiple classes. Traits can have methods and abstract methods that can be used in multiple classes, and the methods can have any access modifier (public, private, or protected).

Laravel local scope

Local scopes allow you to define common sets of constraints that you may easily re-use throughout your application. To define a scope, simply prefix an Eloquent model method with scope.

Installation & Configuration

1-Install cuongnd88/lara-query-kit using Composer.

2-Push lara-query-kit into your application.

3-App\Traits\QueryKit.php is already to pump your performance. Please add QueryKit into the model

Available methods

Let discuss each method available on the Query Kit.

insertDuplicate

insertDuplicate(array $data, array $insertKeys, array $updateKeys): Insert new rows or update existed rows.

getTableColumns

getTableColumns(): Get the array of columns.

exclude

exclude(array $columns): Retrieve a subset of the output data.

You should define which model attributes you want to exclude. You may do this using the $excludable property on the model.

Or pass a array of excludable columns as argument

filter

filter(array $params): Get the result with filter conditions.

You may use the fitler method on a query builder instance to add where clauses to the query. The $filterable property should contain an array of conditions that you want to execute searching. The key of filterable array corresponds to table columns, whereas the value is condition to call where clauses. The most basic condition requires two arguments:

Exceptionally, the third argument is required with the operator is LIKE, it is for a specified pattern

For convenience, if you verify only column in fiterable property, the default clause is where with = operator

Dynamically, you can call filterableCondition() and assign the filterable conditions

searchFulltext

_searchFulltext($value, $mode = NATURAL_LANGUAGE): Run full-text queries against character-based data in MySQL tables._

There are four modes of full-text searches:

The $searchable property should contain an array of conditions that you search full-

You flexibly add matched columns by searchableCols()

You must create a full-text index on the table before you run full-text queries on a table. The full-text index can include one or more character-based columns in the table.


All versions of lara-query-kit with dependencies

PHP Build Version
Package Version
No informations.
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 cuongnd88/lara-query-kit contains the following files

Loading the files please wait ....