Download the PHP package oeltimacreation/php-simplequery without Composer
On this page you can find all versions of the php package oeltimacreation/php-simplequery. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download oeltimacreation/php-simplequery
More information about oeltimacreation/php-simplequery
Files in oeltimacreation/php-simplequery
Package php-simplequery
Short Description A small, framework-agnostic PDO query builder with deterministic SQL compilation
License MIT
Homepage https://github.com/oeltimacreation/php-simplequery
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 php-simplequery
OeltimaCreation PHP SimpleQuery
PHP SimpleQuery is a small, framework-agnostic PDO query builder for PHP 8.2+ with deterministic SQL compilation, typed positional bindings, and explicit connection and transaction ownership.
It supports MariaDB 11.8, MySQL 8.0, and SQLite 3.39.2+ through PDO. It is a query builder—not an ORM, migration tool, connection pool, or retry layer.
Install
Your PHP installation also needs ext-pdo and the matching driver, such as
pdo_sqlite or pdo_mysql.
Quick start
This complete SQLite example creates a table, writes a row, and reads it back. It needs no server, so it is a good first check after installation.
For a runnable version, use php examples/beginner/first-query.php from a
source checkout.
What it does well
- Builds predictable SQL with SQL and bindings kept separate.
- Quotes structured identifiers and rejects invalid query shapes early.
- Executes reads, writes, aggregates, and one-shot cursors with PDO.
- Provides managed callback transactions with nested savepoints.
- Lets applications test generated SQL without a database using the included compiler testing utilities.
Important boundaries
Values are parameter-bound. Table names, column names, sort fields, and raw SQL are SQL code, so dynamic identifiers must be allowlisted and raw SQL must come only from trusted application code. SimpleQuery never interpolates values into executable SQL and never retries an uncertain write or commit.
Each Connection and its builders/cursors belong to one request, job, or
execution unit. Do not share them between concurrent workers or coroutines.
Documentation
Start here:
- Getting started — SQLite first query, then MySQL/MariaDB
- Examples — small runnable programs, ordered for beginners
- Query builder — filtering, joins, ordering, and compilation
- Results and writes — reads, cursors, aggregates, and writes
- Transactions — callback ownership and nested savepoints
More guides:
- Raw SQL and security
- Database support
- Testing applications
- Migrating from Pixie
- Complete documentation index
Development
See SECURITY.md, CHANGELOG.md for project policy.
Acknowledgments
PHP SimpleQuery takes inspiration from Pecee Pixie and the original Pixie query builder. We express our gratitude to their authors and contributors for their foundational work in PHP query builder design.
License
PHP SimpleQuery is released under the MIT License.
All versions of php-simplequery with dependencies
ext-pdo Version *