Download the PHP package phel-lang/phel-pdo without Composer

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

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 phel-lang/phel-pdo

Informations about the package phel-pdo

phel-pdo

PDO wrapper for Phel. Talk to relational databases from Phel without dropping into PHP interop.

Every PDO method has a wrapper, params bind with the right type automatically, rows come back as Phel maps, and transactions nest properly. Tested against SQLite, MySQL and PostgreSQL.

Install

Requires PHP >=8.4 and phel-lang/phel-lang ^0.41.

Your project needs a phel-config.php, as any Phel project does - that is how Phel finds both your sources and your dependencies' namespaces:

Quick start

Rows come back as maps keyed by column keyword. pdo/select returns [] when there are no rows; pdo/select-one and pdo/select-value return nil.

Need the statement itself - to stream, to re-execute, to check row-count? pdo/query and pdo/prepare hand it back:

With phel-sql

phel-sql is an optional data-driven SQL DSL. It returns [sql params] you feed straight into pdo/prepare + pdo/execute:

API

All functions live in the phel.pdo namespace.

Connection

Function Signature Description
connect (connect dsn & [username password options]) Open a connection. Throws PDOException on failure. Sets ERRMODE_EXCEPTION by default.
from-connection (from-connection pdo & [options]) Wrap an already-open \PDO (e.g. a framework/DBAL connection) as-is. {:apply-defaults true} sets ERRMODE_EXCEPTION.
close (close conn) Roll back any open transaction and mark the connection unusable. Idempotent. Never disturbs a from-connection handle.
with-connection (with-connection [name init] & body) Bind, run body, close on return and on throw. Returns the last body value.
closed? (closed? conn) true once close has been called.
exec (exec conn sql) Execute SQL, return number of affected rows.
query (query conn sql & [params options]) Run SQL, binding params (map by name, vector positionally) through a prepared statement. Without params, uses PDO::query. options takes {:fetch-mode …}.
prepare (prepare conn sql & [options]) Prepare a statement for later execute.
select (select conn sql & [params options]) Run SQL and return every row. options takes {:as :maps\|:rows}, as fetch-all.
select-one (select-one conn sql & [params]) First row as a map, or nil.
select-value (select-value conn sql & [params not-found]) First column of the first row — count(*), max(id), an existence check. not-found (default nil) when there are no rows.
insert (insert conn table row) Insert a non-empty row map into table via a prepared statement and return the new last-insert-id (string). Identifiers must match [A-Za-z_][A-Za-z0-9_]*.
update (update conn table set-map where-map) UPDATE matched rows, return affected count. Both maps must be non-empty.
delete (delete conn table where-map) DELETE matched rows, return affected count. where-map must be non-empty.
insert-many (insert-many conn table rows) Insert a seq of same-keyed maps in one multi-VALUES statement, return affected count.
expand-in (expand-in sql params) Expand list params into IN (?, ?, ?) runs, returning [sql params] for query / prepare.
quote (quote conn string & [type]) Quote a string for safe embedding in SQL.
last-insert-id (last-insert-id conn) ID of the last inserted row, as a string (as PDO reports it).
begin / commit / rollback (begin conn) … Transaction control.
in-transaction (in-transaction conn) true if a transaction is active.
with-transaction (with-transaction conn & body) Run body in a transaction: commit + return last value, or rollback + re-throw. When already in a transaction, body runs in a SAVEPOINT so a caught failure undoes only that block.
with-savepoint (with-savepoint conn f) Call f inside a SAVEPOINT: release + return its value, or roll back to it and re-throw. The primitive behind nested with-transaction.
get-attribute / set-attribute (get-attribute handle attr) / (set-attribute handle attr value) PDO attribute access; handle is a connection or a statement.
get-available-drivers (get-available-drivers) Vector of installed PDO drivers (static; no connection needed).
error-code (error-code handle) SQLSTATE string of the last operation; handle is a connection or a statement.
error-info (error-info handle) [sqlstate driver-code driver-message]; handle is a connection or a statement.

Statement

Returned by pdo/query and pdo/prepare.

Function Signature Description
execute (execute stmt & [params]) Run a prepared statement. A map binds by name, a vector positionally; each param's PDO type is inferred. Returns the statement so it threads through -> / let.
fetch (fetch stmt) Next row as a map, or nil if exhausted.
fetch-all (fetch-all stmt & [options]) Remaining rows. {:as :maps} (default) gives maps keyed by column keyword; {:as :rows} gives {:cols […] :rows [[…]]} — ~5x faster on large result sets.
fetch-column (fetch-column stmt & [column not-found]) Single 0-indexed column from the next row, or not-found (default nil) once exhausted. A SQL NULL reads back as nil, so pass a distinct not-found to tell the two apart.
fetch-object (fetch-object stmt & [class-name ctor-args]) Next row as an object (stdClass by default, or an instance of class-name), or nil if exhausted.
statement-seq (statement-seq stmt) Lazy seq of the remaining rows as maps, fetched one at a time.
bind-value (bind-value stmt column value & [type]) Bind a value to a placeholder. type defaults to the type inferred from the value. Returns the statement.
bind-param (bind-param stmt column value & [type]) Bind a parameter, applied at execution time. Same type inference as bind-value. Returns the statement.
column-count (column-count stmt) Number of columns in the result set.
column-names (column-names stmt) Result-set column names as a vector of keywords, in select order, or nil if the driver can't report them.
row-count (row-count stmt) Rows affected by the last DML.
column-meta (column-meta stmt column) Metadata map for a 0-indexed column, or nil if unavailable.
close-cursor (close-cursor stmt) Free the cursor so the statement can be re-executed. Returns the statement.
set-fetch-mode (set-fetch-mode stmt mode & args) Set the statement's default fetch mode (extra args match the mode). Returns the statement.
next-rowset (next-rowset stmt) Advance to the next rowset of a multi-rowset statement; false when none remain.
bind-column (bind-column stmt column target) Bind a column (1-based position or name) to an atom, refreshed by fetch-bound. Returns a new statement.
fetch-bound (fetch-bound stmt) Fetch the next row, resetting every bound atom. true while rows remain, false once exhausted.
debug-dump-params (debug-dump-params stmt) Dump prepared statement info as a string.

[!NOTE] Unlike PDOStatement::execute() (returns bool), pdo/execute returns the statement itself so it composes with ->.

[!NOTE] Every PDO method has a wrapper here. The one that isn't a direct translation is PDOStatement::bindColumn, which binds a PHP variable by reference — Phel has no by-reference locals, so pdo/bind-column binds an atom instead and pdo/fetch-bound refreshes it.

Development

Docs

Deeper docs live in docs/:

All versions of phel-pdo with dependencies

PHP Build Version
Package Version
Requires php Version >=8.4
phel-lang/phel-lang Version ^0.41
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 phel-lang/phel-pdo contains the following files

Loading the files please wait ...