spojenet/pohoda-sql

Management Library for PohodaSQL

0.1.0 2023-10-03 16:18 UTC

This package is auto-updated.

Last update: 2024-04-08 16:48:43 UTC


README

PohodaSQL

PHP Librabry for direct access to Pohoda SQL database tables

Use at your own risk!

Requirements

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

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

Installation

Composer is supported:

composer require spojenet/pohoda-sql

also debian package 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