Download the PHP package gamernetwork/yolk-database without Composer
On this page you can find all versions of the php package gamernetwork/yolk-database. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download gamernetwork/yolk-database
More information about gamernetwork/yolk-database
Files in gamernetwork/yolk-database
Package yolk-database
Short Description Gamer Network's PHP database abstraction library
License MIT
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 yolk-database
Want to work for Gamer Network? We are hiring!
Yolk Database
A simple database abstraction layer that provides a lightweight wrapper around PDO for ease-of-use. It currently supports MySQL, Postgres and SQLite.
Also included are simple query generators and a class for handling a tree structure within a relational database via modified preorder tree traversal.
Requirements
This library requires only PHP 5.4 or later and the Yolk Contracts package (gamernetwork/yolk-contracts).
Installation
It is installable and autoloadable via Composer as gamernetwork/yolk-database.
Alternatively, download a release or clone this repository, and add the \yolk\database namespace to an autoloader.
License
Yolk Database is open-sourced software licensed under the MIT license
Quick Start
DSNs
A DSN is an object that specifies the properties of a database connection.
Common properties are:
type- the type of database to connect to (mysql, postgres or sqlite)host- the host to connect toport- the port number to connect onuser- the user to authenticate aspass- the user's passworddb- the name of the database schema to connect tooptions- an array of driver specific options
DSNs can be created by passing an array of properties to the constructor:
or by calling the static fromString() method with a URI:
ConnectionManager
The ConnectionManager is a service to handle multiple database connections. A client can register a connection or DSN under a specific name and retrieve the connection at a later time.
When a DSN is registered, a suitable connection object is created automatically.
Query Method Reference
The above methods accept the following parameters:
$statement: aPDO_Statementinstance or a SQL string$params: an array of parameters to bind to the statement
Query parameters may be bound name:
or by position:
If the query has only a single parameter it may be specified directly and will be automatically converted to a positional parameter:
Other Methods
Transactions
Query Generators
OO query generators are available for SELECT, INSERT, UPDATE and DELETE.
An instance of each can be created by calling the corresponding method on the DatabaseConnection.
