spojenet/pohoda-sql

Management Library for PohodaSQL

v0.2.1 2025-07-25 10:24 UTC

Requires

• vitexsoftware/ease-fluentpdo: ^1.4

Requires (Dev)

• ergebnis/composer-normalize: ^2.47
• ergebnis/php-cs-fixer-config: ^6.50
• friendsofphp/php-cs-fixer: ^3.84
• phpstan/phpstan: *
• phpunit/phpunit: *

MIT

• Vitex

README

This is a PHP Library for direct access to Pohoda SQL database tables

Use at your own risk!

Requirements

• PHP 7.2+
• php-sqlsrv
• php-ease-fluentpdo

Composer

composer require spojenet/pohoda-sql

Configuration

Please set up this constants or environment variables:

• DB_TYPE We use sqlsrv
• DB_HOST IP or Hostname machine with SQL Server
• DB_PORT default is 1433
• DB_DATABASE something like StwPh_01234567_2019
• DB_USERNAME sqlserver login
• DB_PASSWORD sqlserver pass
• DB_SETTINGS eg. encrypt=false

You can also int object like this:

$addr = new Adresar(234,['database'=>'StwPh_01234567_2020']); //Load record by ID from overriden Database
$addr = new Adresar(['ICO'=>'69438676']); //Load record by ICO

See https://github.com/VitexSoftware/php-ease-fluentpdo for mor informations

Debian Package

also package for debian/ubuntu is availble:

wget -qO- https://repo.vitexsoftware.com/keyring.gpg | sudo tee /etc/apt/trusted.gpg.d/vitexsoftware.gpg
echo "deb [signed-by=/etc/apt/trusted.gpg.d/vitexsoftware.gpg]  https://repo.vitexsoftware.com  $(lsb_release -sc) main" | sudo tee /etc/apt/sources.list.d/vitexsoftware.list
sudo apt update

sudo apt install php-spojenet-pohoda-sql