wattanar/sqlsrv-helper

Sqlsrv library help you query a rows of data more easier

1.0.0 2018-09-29 06:08 UTC

Requires

• php: >=5.4.0

MIT

• Wattana Ruengmucha

• php
• sqlsrv

README

Edit composer.json or use composer require wattanar/sqlsrv-helper

{
  "require": {
    "wattanar/sqlsrv-helper": "dev-master"
  }
}

Usage

require_once "./vender/autoload.php";

use Wattanar\SqlsrvHelper;

$conn = sqlsrv_connect(/* your connection here */);

// get single row from query
$row = (new SqlsrvHelper)->getRow(sqlsrv_query(
  $conn,
  "SELECT * FROM Users"
));

// print result
echo "</pre>" . print_r($row, true) . "</pre>";

// get rows from query
$rows = (new SqlsrvHelper)->getRows(sqlsrv_query(
  $conn,
  "SELECT * FROM Users"
));

// print result
echo "</pre>" . print_r($rows, true) . "</pre>";