kodols/php-mysql-library

A Simple MySQL Library for PHP

Sunday, April 22, 2018
by kodols
Repository
3 Watchers
3 Stars
64 Installations

PHP
0 Dependents
0 Suggesters
1 Forks
0 Open issues
16 Versions
25 % Grown

The README.md

MySQL Library for PHP

, _(*1)

This library will give you access to everything you need from MySQL in PHP., _(*2)

See our Object Reference to learn what is possible, or view our demo folder for examples., _(*3)

About

The library is a hybrid between PHP's PDO and generic query building., _(*4)

Started as a helper class for in-house projects and grown into a usefull tool for Kodols Ltd. A decision was made to make this library public give others the chance to use a well oriented library for database management., _(*5)

Library will keep getting support and upgrades as this has been become the goto library for Kodols Ltd. to use for our projects., _(*6)

This library supports access to the native PDO methods, few helper methods to simplify commonly used methods and a query builder to really give you access to build cool statements., _(*7)

Prerequisites

This library will work on PHP 5.4 or later, _(*8)

Installing

You can clone this git repository into your project, _(*9)

git clone git://github.com/kodols/PHP-MySQL-Library.git

or you can use composer, _(*10)

composer require kodols/php-mysql-library

Deployment

The integration process is very simple, you call the main library class, add a configuration and you are all set. However we would recommend spend some time to really prepare the environment so you get the best out of this library. The library is based in src/ with its namespace \Kodols\MySQL. In our examples we will use a demo variable $KML (Kodols MySQL Library), but of course you can use any variable you like., _(*11)

$KML = new \Kodols\MySQL\Library;

Once you have successfuly create the object you need to add MySQL connection details to it. The library supports multiple configurations attached and multiple connections established in the same request., _(*12)

$config = $KML->newConfiguration();
$config->setHostname('my.host.com');
$config->setUsername('web');
$config->setPassword('42412');
$config->setDatabase('project');

The $config variable is \Kodols\MySQL\Configuration object, see Wiki for in depth details., _(*13)

Once configuration is created you can attach it to the main library via $KML->attachConfiguration($config); and start using the library. However if your environment has multiple database endpoints, or maybe you have production, development and local environment, then you can setup it as follows:, _(*14)

$config = $KML->newConfiguration();
$config->setHostname('my.host.com');
...
$KML->attachConfiguration($config, 'live');

So when you call the server variable you can choose with of the server endpoints you want to use., _(*15)

Contributors

We welcome a good idea, bug fixes, suggestions and requests. This list will be updated every time a new contribution has been made., _(*16)

Edgars Kohs - author - Kodols Ltd.

License

This project is licensed under the MIT License - see the https://github.com/kodols/php-mysql-library/blob/master/LICENSE file for details, _(*17)

The Versions

22/04 2018

dev-master

9999999-dev http://www.kodols.com

A Simple MySQL Library for PHP

library php-mysql-library

A Simple MySQL Library for PHP

kodols/php-mysql-library

The README.md

MySQL Library for PHP

About

Prerequisites

Installing

Deployment

Contributors

License

The Versions

dev-master

The Requires

The Development Requires

by Edward

v1.1.3

The Requires

The Development Requires

by Edward

v1.1.2

The Requires

by Edward

v1.1.1

The Requires

by Edward

dev-ed

The Requires

by Edward

v1.1.0

The Requires

by Edward

v1.0.9

The Requires

by Edward

v1.0.8

The Requires

by Edward

v1.0.7

The Requires

by Edward

v1.0.6

The Requires

by Edward

v1.0.5

The Requires

by Edward

v1.0.4

The Requires

by Edward

v1.0.3

The Requires

by Edward

v1.0.2

The Requires

by Edward

v1.0.1

The Requires

by Edward

v1

The Requires

by Edward