Download the PHP package hectororm/connection without Composer

On this page you can find all versions of the php package hectororm/connection. 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 hectororm/connection

Informations about the package connection

Hector Connection

Latest Version Software license Build Status Quality Grade Total Downloads

Hector Connection is the PDO connection module of Hector ORM. Can be used independently of ORM.

Installation

Composer

You can install Hector Connection with Composer, it's the recommended installation.

Dependencies

Usage

Create a connection

The connection information must be pass to DSN format, with password inside.

To create a simple connection:

You can create a complex connection with read/write ways:

Query

Execute

Execute a statement and get the number of affected rows.

The method execute queries on write DSN.

Fetch

Three methods are available to fetch results. When multiple results, methods returns a Generator.

You can pass parameters for statement to the second argument of methods.

All fetch methods are done on read DSN.

Fetch one

Fetch one result from statement. NULL returned if no result.

Fetch all

Fetch all result from statement.

Fetch column

Fetch only one column of all result from statement.

Last insert ID

You can retrieve the last insert ID with method getLastInsertId().

Transactions

Connection class has 4 methods to play with transactions:

If you begin a new transaction even though a transaction has already started, the new transaction will be ignored, and it needed to call even times the commit or rollBack methods.

Connection set

You can create a set of Connection objects with ConnectionSet class. It needed to name different connections, the default name is store in constant Connection::DEFAULT_NAME.

Logger

A logger is available to log queries.

All versions of connection with dependencies

PHP Build Version
Package Version
Requires php Version ^8.0
ext-pdo Version *
berlioz/helpers Version ^1.6
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 hectororm/connection contains the following files

Loading the files please wait ....