thecsea/mysqltcs

The simplest and the most powerful library to access to a mysql database, optimizing the connections and allowing you to perform common database actions immediately and efficiently

mysqltcs

Build status: , _(*1)

The simplest and the most powerful library for mysql written in php:, _(*2)

• You can use the same db connection in more than one instances (optimizing mysql physical connections)
• This library allow you to make common database operations immediately and efficiently, returning simple data structures
• Log all actions performed on db
• All mysql error as exception
• Clone support
• Transactions support

Download, install and use

Download

via git

Clone repository, _(*3)

git clone https://github.com/thecsea/mysqltcs.git, _(*4)

via composer

download composer here https://getcomposer.org/, _(*5)

add the following dependence in composer.json, _(*6)

"thecsea/mysqltcs": "3.0.*", _(*7)

or type, _(*8)

php composer.phar require thecsea/mysqltcs, _(*9)

Install/Update

Update composer (download composer here https://getcomposer.org/), _(*10)

php composer.phar self-update, _(*11)

Followings commands must be executed in project root directory, _(*12)

Install mysqltcs

php composer.phar install, _(*13)

Update mysqltcs

You can perform an updated if you have added mysqltcs as composer dependency, _(*14)

php composer.phar update, _(*15)

You have to perform an update when a new version is released, _(*16)

How to use

When composer installation is finished you will see vendor/autoload.php that is the auload generated by composer. If you have set mysqltcs as composer dependence the autoload loads both mysqltcs and other dependecies. So you just have to include autload in each file where you want use mysqltcs and create the mysqtcs object in the following way:, _(*17)

$connection = new it\thecsea\mysqltcs\Mysqltcs(...);, _(*18)

or, _(*19)

use it\thecsea\mysqltcs\Mysqltcs; and $connection = new Mysqltcs(...);, _(*20)

You can see examples to understand how to use library, _(*21)

You can also take a look to wiki to see the detailed description or go to generated phpdoc documents (documentations of all classes), _(*22)

Tests

Mysqltcs is tested with automatic test: phpunit test. So we have a good chance of not having errors, but not the certainty. But we have covered the following percentage of statements with tests: , _(*23)

• Change db data in tests/config.php
• Import tests/mysqltcs.sql
• Execute the unit tests:

1. Go in the root directory
2. Type phpunit or if you have downloaded the phar php phpunit-xxx.phar

In fact phpunit.xml contains the correct test configuration, _(*24)

CAUTION: each time tests are executed, the database must be in the initial state, like the import has just been executed (you should have a empty table, only the db structure), _(*25)

Examples

You can find some examples under examples to run it:, _(*26)

• Change db data in examples/config.php
• Import examples/mysqltcs.sql

There is a simple example simpleExample.php that shows you how to use the library in the simplest way, _(*27)

There are not examples about transactions yet (you have to remember to set autocommit to true after using transactions), _(*28)

N.B. if you have added mysqltcs as composer dependency you will find example under vendor/thecsea/mysqltcs/examples, _(*29)

By thecsea.it