Download the PHP package phlib/db without Composer

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

Informations about the package db

phlib/db

Code Checks Codecov Latest Stable Version Total Downloads Licence

MySQL PDO DB Adapter. PDO with some extra good stuff specifically for MySQL.

What this DB wrapper offers over others.

Install

Via Composer

or

Basic Usage

Configuration

Name Type Required Default Description
host String Yes Hostname or IP address.
username String No '' Username to connect to server.
password String No '' Password to connect to server.
port Integer No Port to connect to server.
dbname String No Database name to use.
charset String No 'utf8mb4' Sets the character to use on the connection.
timezone String No '+0:00' Sets the timezone to use on the connection. Values: 'system', '+\-dd:dd' or 'timezone'. MySQL Manual
timeout Integer No 2 Sets the connection timeout. Range from 0 to 120.
retryCount Integer No 0 Sets how many times to try to reconnect to the DB server after unsuccessful connection attempts. Range from 0 to 10.
attributes Array No [] Driver-specific options used when connecting, e.g. \PDO::ATTR_*

API

The following section documents the less obvious API's. Most methods are doc blocked and are self explanatory.

Adapter::__clone

This is useful when you're dealing with the results of one query while inserting as both operations can not be done on the same connection.

Adapter Buffering

This is useful when requesting large amounts of data from the DB server. By default, PDO will pull all the results back and hold the results in memory even for fetch() calls. With large result sets this causes out of memory problems. To stop PDO pulling the results back turn off buffering.

Exceptions

All Phlib Db Exceptions implement the interface.

Hierarchy

+-- \Exception
|  +-- \InvalidArgumentException
|  |  +-- \Phlib\Db\Exception\InvalidArgumentException
|  +-- \RuntimeException
|  |  +-- \PDOException
|  |  |  +-- \Phlib\Db\Exception\RuntimeException
|  |  |  |  +-- \Phlib\Db\Exception\UnknownDatabaseException
|  |  |  |  +-- \Phlib\Db\Exception\InvalidQueryException

Invalid Query

The InvalidQueryException has special methods for retrieving the query and associated bind parameters. The message recorded for exception includes these details but the methods allow a clean way of extracting them.

Known Issues

Setting the connection from outside the class will cause odd behaviour.

License

This package is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License along with this program. If not, see http://www.gnu.org/licenses/.

All versions of db with dependencies

PHP Build Version
Package Version
Requires php Version ^7.4 || ^8.0
ext-pdo Version *
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 phlib/db contains the following files

Loading the files please wait ....