spojenet/pohoda-sql

Management Library for PohodaSQL

0.1.0 2023-10-03 16:18 UTC

Requires

• vitexsoftware/ease-fluentpdo: dev-main

Requires (Dev)

• phpunit/phpunit: ^9.5

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