Download the PHP package sultann/wp-query-builder without Composer
On this page you can find all versions of the php package sultann/wp-query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download sultann/wp-query-builder
More information about sultann/wp-query-builder
Files in sultann/wp-query-builder
Package wp-query-builder
Short Description WP Query Builder is a lightweight and efficient SQL Query Builder based on wpdb for WordPress. It supports complicated query generation.
License MIT
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
WP Query Builder is a lightweight and efficient SQL Query Builder based on wpdb for WordPress. It supports complicated query generation.
Installation
WP Query Builder follows PSR-4 autoloading and can be installed using composer:
Documentation 💡
Initialize
Initialize query builder. init method takes a string argument using that later you can do action/filter based on your requirement. 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 select 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
License
The MIT License (MIT). Please see License File for more information.
