{"repo":"FoolCode/SphinxQL-Query-Builder","free":true,"listed":false,"github":"https://github.com/FoolCode/SphinxQL-Query-Builder","clone":"git clone https://github.com/FoolCode/SphinxQL-Query-Builder.git","description":"SphinxQL Query Builder generates SphinxQL, a SQL dialect, which is used to query the Sphinx search engine. (Composer Package)","language":"PHP","stars":323,"topics":["database","query-builder","sql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"SphinxQL Query Builder 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 M","default_branch":null,"files":null,"tree":[],"storefront":"/r/FoolCode","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/FoolCode/SphinxQL-Query-Builder/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}