Download the PHP package eril/crud without Composer
On this page you can find all versions of the php package eril/crud. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
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 crud
QCrud
QCrud is a PDO-based PHP library for common database operations and fluent SQL queries. It includes optional query caching and transaction support.
Documentation
See the usage documentation for concise guides:
- Getting started
- CRUD operations
- Query builder
- Transactions
- Caching
Features
- CRUD operations through a small, fluent API
- Query builder with conditions, joins, subqueries, aggregates, pagination, and unions
- Prepared statements for bound values
- Optional file or APCu query cache
- Automatic cache invalidation after writes
- Callback-based and queued transactions
Requirements
- PHP 8.0 or later
- PDO and a PDO driver for your database
- APCu only if you select the APCu cache driver
Installation
Quick start
Register a PDO connection once during application setup:
CRUD operations
Query builder
where() supports equality, comparison operators, NULL, arrays for IN, and subqueries. The builder also provides whereBetween(), whereExists(), whereRaw(), groupBy(), having(), union(), paginate(), first(), exists(), and aggregate methods such as count() and sum().
Use bound parameters for values. SQL expressions and identifiers passed to methods such as select(), orderBy(), groupBy(), joins, and raw conditions should come from trusted code; do not pass untrusted user input as SQL.
Transactions
Use the callback API for a standard transaction. Exceptions roll back the transaction and are rethrown.
The queued API is also available when you need to collect operations before executing them:
Query cache
Caching is disabled by default. Configure a store once, then enable caching only on reads that should be cached:
The file cache creates the configured directory if needed; the PHP process must be able to write to it. To use APCu, set 'driver' => 'apcu' and install/enable the APCu extension. Use a distinct namespace for each application or environment that shares a cache store.
Successful writes that affect rows and successful transaction commits invalidate the current cache namespace. For writes performed outside the library, use clearCache():
Cache storage failures fall back to executing the query against the database.
Cache options
| Option | Required | Description |
|---|---|---|
driver |
Yes | file or apcu |
directory |
File only | Writable directory for cache files |
ttl |
No | Entry lifetime in seconds; defaults to 300 |
namespace |
No | Cache isolation key; defaults to the document root or current working directory |
Helper functions
The Composer autoloader also provides crud() and query() shortcuts:
API overview
| Entry point | Main methods |
|---|---|
CRUD |
registerConnection(), table(), query(), configureCache(), clearCache(), transaction() |
| CRUD instance | create(), read(), update(), delete(), select(), useCache() |
| Query builder | select(), where(), join(), groupBy(), having(), orderBy(), limit(), paginate(), union(), get(), first(), exists(), aggregates |
License
QCrud is released under the MIT License.
Support
All versions of crud with dependencies
ext-pdo Version *