PHP download

Download the PHP package openregion/sphinxql-query-builder without Composer

On this page you can find all versions of the php package openregion/sphinxql-query-builder. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download openregion/sphinxql-query-builder
More information about openregion/sphinxql-query-builder
Files in openregion/sphinxql-query-builder

Vendor openregion
Package sphinxql-query-builder
Short Description A PHP query builder for SphinxQL and ManticoreQL with MySQLi and PDO drivers.
License Apache-2.0
Homepage https://github.com/openregion/SphinxQL-Query-Builder

Keywords database sql search query builder sphinx sphinxql

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 openregion/sphinxql-query-builder

Informations about the package sphinxql-query-builder

SphinxQL Query Builder

This a fork of FoolCode's SphinxQL Query Builder. It seems like original one is no longer maintained.

A fluent PHP query builder for SphinxQL and ManticoreQL.

It supports:

SELECT, INSERT, REPLACE, UPDATE, DELETE
MATCH() building (including MatchBuilder)
FACET queries
batched/multi-queries
helper commands (SHOW, CALL, maintenance operations)
percolate workflows for Manticore
both mysqli and PDO drivers

Installation

Requirements:

PHP 8.2+
mysqli or pdo_mysql
Running Sphinx Search or Manticore Search server

Quick Start

Connection Setup

`mysqli` driver

`PDO` driver

Query Builder Examples

Compile SQL before executing

Insert rows

Replace rows

Update rows (including MVA)

Delete rows

Grouped boolean filters

MATCH with builder callback

ORDER BY KNN

Subqueries

Helper API Example

Compile examples from tests:

$helper->showTables()->compile()->getCompiled() -> SHOW TABLES
$helper->showTables('rt')->compile()->getCompiled() -> SHOW TABLES LIKE 'rt'
$helper->showTableStatus()->compile()->getCompiled() -> SHOW TABLE STATUS
$helper->showTableStatus('rt')->compile()->getCompiled() -> SHOW TABLE rt STATUS
$helper->callSuggest('teh', 'rt', ['limit' => 5])->compile()->getCompiled() -> CALL SUGGEST('teh', 'rt', 5 AS limit)

FACET Example

Multi Query / Batch Example

Percolate Example (Manticore)

Capability Checks

Result Objects

execute() returns ResultSetInterface:

getStored()
fetchAllAssoc()
fetchAllNum()
fetchAssoc()
fetchNum()
getAffectedRows()

executeBatch() returns MultiResultSetInterface:

getStored()
getNext()

Documentation Map

Main docs index: docs/index.rst
Builder guide: docs/query-builder.rst
Helper guide: docs/helper.rst
Facets: docs/features/facet.rst
Multi-query: docs/features/multi-query-builder.rst
Migration guide: docs/migrating.rst

Running Tests

This runs the repository test matrix (mysqli + pdo) in Docker.

Contributing

Pull requests are welcome. Please include tests for behavior changes and keep docs in sync with API updates.

All versions of sphinxql-query-builder with dependencies

PHP Build Version

Package Version

Version 5.0.0 Release 10. Mar 2026
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of sphinxql-query-builder from vendor openregion

Requires php Version ^8.2

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 openregion/sphinxql-query-builder contains the following files

Loading the files please wait ...