2017 © Pedro Peláez
 

library mymssql

My Mssql Pdo (MSSQL or SQLSRV)

image

emalherbi/mymssql

My Mssql Pdo (MSSQL or SQLSRV)

  • Monday, July 23, 2018
  • by emalherbi
  • Repository
  • 1 Watchers
  • 0 Stars
  • 97 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 0 Forks
  • 0 Open issues
  • 30 Versions
  • 149 % Grown

The README.md

MyMssql

My Mssql PDO (MSSQL or SQLSRV), (*1)

Install

composer require emalherbi/mymssql

Usage

require_once 'vendor/autoload.php';

try {
    $mssql = new MyMssql\MyMssql(array(
        'VERBOSE' => true,
        'ADAPTER' => 'SQLSRV', // or MSSQL
        'HOSTNAME' => '192.168.1.100', // or 192.168.1.100\\SQL2016
        'USERNAME' => 'USERNAME',
        'PASSWORD' => 'PASSWORD',
        'DATABASE' => 'DATABASE',
    ), realpath(dirname(__FILE__)), 'UTF-8'); // Ex.: ISO-8859-1

    $mssql->connect();

    $mssql->disconnect();

    $result = $mssql->getAdapter();
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->getIni();
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->isConnect();
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->fetchOne('SELECT * FROM CLIENTES');
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->fetchRow('SELECT * FROM CLIENTES');
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->fetchAll('SELECT TOP 5 * FROM CLIENTES');
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->exec('UPDATE CLIENTES SET NOME = \'TESTE 123\' WHERE ID_CLIENTE = 450');
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    // OR

    $result = $mssql->execSql('UPDATE CLIENTES SET NOME = \'TESTE 123\' WHERE ID_CLIENTE = 450');
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $mssql->begin();

    $result = $mssql->exec('UPDATE CLIENTES SET NOME = \'TESTE 456\' WHERE ID_CLIENTE = 450');
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $mssql->commit();

    $sxName = 'SX_CLIENTES';
    $params = array(1, 385);
    $result = $mssql->fetchRowSx($sxName, $params);
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $sxName = 'SX_CLIENTES';
    $params = array(2, 385);
    $result = $mssql->fetchAllSx($sxName, $params);
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $sxName = 'SX_CLIENTES_SAVE';
    $params = array(2, '2017-01-01', 385, 0, 0, 0, 0);
    $result = $mssql->execSx($sxName, $params);
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $result = $mssql->exec("IF OBJECT_ID('USUARIOS') IS NULL
        BEGIN
            CREATE TABLE [dbo].[USUARIOS]
            (
                [ID_USUARIOS] [INT] IDENTITY(1,1) NOT NULL,
                [NOME] VARCHAR(100) NOT NULL,
                PRIMARY KEY CLUSTERED
            ([ID_USUARIOS] ASC) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
            ) ON [PRIMARY]
        END");
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $sql = " BEGIN DECLARE @REF INT SET @REF = NULL EXEC SX_TESTE @REF OUTPUT SELECT @REF AS REF END ";
    $result = $mssql->execScript($sql);
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    $sql = " BEGIN DECLARE @REF INT SET @REF = NULL EXEC SX_TESTE @REF OUTPUT SELECT @REF AS REF END ";
    $isObject = false; // Array or Object Result
    $result = $mssql->execScriptResult($sql, $isObject);
    echo '<pre>';
    echo print_r($result);
    echo '</pre>';

    echo 'Success...';
} catch (Exception $e) {
    $mssql->rollback();

    die(print_r($e->getMessage()));
}

The Versions

23/07 2018

dev-master

9999999-dev https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

23/07 2018

v2.1.8

2.1.8.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

23/07 2018

v2.1.7

2.1.7.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

06/07 2018

v2.1.6

2.1.6.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

19/06 2018

v2.1.5

2.1.5.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

14/06 2018

v2.1.4

2.1.4.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

12/06 2018

v2.1.3

2.1.3.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

11/06 2018

v2.1.2

2.1.2.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

11/06 2018

v2.1.1

2.1.1.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

08/06 2018

v2.1.0

2.1.0.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

08/06 2018

v2.0.9

2.0.9.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

05/06 2018

v2.0.8

2.0.8.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

01/06 2018

v2.0.7

2.0.7.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

01/06 2018

v2.0.6

2.0.6.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

30/05 2018

v2.0.5

2.0.5.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

30/05 2018

v2.0.4

2.0.4.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

29/05 2018

v2.0.3

2.0.3.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

28/05 2018

v2.0.2

2.0.2.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

28/05 2018

v2.0.1

2.0.1.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

25/05 2018

v2.0.0

2.0.0.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/05 2018

v1.0.9

1.0.9.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/05 2018

v1.0.8

1.0.8.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/05 2018

v1.0.7

1.0.7.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/04 2018

v1.0.6

1.0.6.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/04 2018

v1.0.5

1.0.5.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/04 2018

v1.0.4

1.0.4.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/04 2018

v1.0.3

1.0.3.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/04 2018

v1.0.2

1.0.2.0 https://github.com/emalherbi/MyMssql

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

24/04 2018

v1.0.1

1.0.1.0

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

MIT

The Requires

  • php >= 5.0.0

 

23/04 2018

v1.0.0

1.0.0.0

My Mssql Pdo (MSSQL or SQLSRV)

  Sources   Download

The Requires

  • php >= 5.0.0