Download the PHP package wp-forge/wp-query-builder without Composer
On this page you can find all versions of the php package wp-forge/wp-query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download wp-forge/wp-query-builder
More information about wp-forge/wp-query-builder
Files in wp-forge/wp-query-builder
Package wp-query-builder
Short Description A lightweight and efficient SQL query builder for WordPress.
License GPL-2.0-or-later
FAQ
Example:
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 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 wp-query-builder
WP Query Builder
A lightweight and efficient SQL query builder for WordPress.
This is a fork of the original project (https://github.com/sultann/wp-query-builder) which appears to be unmaintained.
Installation
WP Query Builder uses PSR-4 autoloading and can be installed using composer:
Documentation
Initialization
The init method takes a string argument. You can use that later to use actions/filters specific to your query builder instance.
Without argument.
With argument
Select
This will build the query, execute and returns all users from users table with applying table prefix automatically. by default, it selects all(*) but you can define what to select from the query; If you are selecting all then you can omit the select statement.
Select specific column
Select multiple column
Where conditions
For the next few examples, lets assume a larger dataset so that the queries make sense.
Notice how omitting the operator in the first condition ->where('user_url', '') makes this default to =. By default all where conditions are defined with the and operator.
Different where operators:
There are few more builtin Where conditions available
andWhere()whereIn()whereNotIn()whereNull()whereNotNull()orWhereNull()orWhereNotNull()whereBetween()whereNotBetween()whereDateBetween()whereRaw()
Where scopes
Allow you to group conditions:
Where Between
Where Not Between
Where Date Between
Joins
By default, all joins are Left Join. Available join types 'LEFT', 'RIGHT', 'INNER', 'CROSS', 'LEFT OUTER', 'RIGHT OUTER' Joining tables:
Joins scopes
Allow you to group conditions:
There are few more builtin join conditions available
leftJoin()rightJoin()innerJoin()outerJoin()
Grouping
Grouping data:
Having
Group by with having data:
Ordering
Ordering data:
Limiting data
Limit and offset:
Only limit
Offset as separate
Pagination
shortcut of limit and offset
Find
find item with column value
First
Get first item from the posts table
Last
Get last item from the posts table
Counting
count total rows
toSql
Out the query instead of executing
Update
Update a row
Delete
Delete a row
Search
Search a value from columns
