PHP Centos unixODBC

2 sene önce, Burak Çalışkan tarafından yazılmıştır.
PHP Centos unixODBC için yorumlar kapalı
CentOS,MSSQL,PHP

yum remove unixODBC*

# CentOS 6
curl https://packages.microsoft.com/config/rhel/6/prod.repo &gt; /etc/yum.repos.d/mssql-release.repo


# CentOS 7
curl https://packages.microsoft.com/config/rhel/7/prod.repo &gt; /etc/yum.repos.d/mssql-release.repo


ACCEPT_EULA=Y yum install msodbcsql17 unixODBC unixODBC-devel

yum remove unixODBC*

# CentOS 6

curl https://packages.microsoft.com/config/rhel/6/prod.repo > /etc/yum.repos.d/mssql-release.repo

# CentOS 7

curl https://packages.microsoft.com/config/rhel/7/prod.repo > /etc/yum.repos.d/mssql-release.repo

ACCEPT_EULA=Y yum install msodbcsql17 unixODBC unixODBC-devel

&lt;?php
$serverName = "your server hostname/IP, port";
$connectionOptions = array(
    "database" =&gt; "yourDatabase",
    "uid" =&gt; "yourUsername",
    "pwd" =&gt; "yourPassword"
);

// Establishes the connection
$conn = sqlsrv_connect($serverName, $connectionOptions);
if ($conn === false) {
    die(formatErrors(sqlsrv_errors()));
}

// Select Query
$tsql = "SELECT @@Version AS SQL_VERSION";

// Executes the query
$stmt = sqlsrv_query($conn, $tsql);

// Error handling
if ($stmt === false) {
    die(formatErrors(sqlsrv_errors()));
}
?&gt;

&lt;h1&gt; Results : &lt;/h1&gt;

&lt;?php
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
    echo $row&#91;'SQL_VERSION'] . PHP_EOL;
}

sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);

function formatErrors($errors)
{
    // Display errors
    echo "Error information: &lt;br/&gt;";
    foreach ($errors as $error) {
        echo "SQLSTATE: ". $error&#91;'SQLSTATE'] . "&lt;br/&gt;";
        echo "Code: ". $error&#91;'code'] . "&lt;br/&gt;";
        echo "Message: ". $error&#91;'message'] . "&lt;br/&gt;";
    }
}
?&gt;

<?php

$serverName = "your server hostname/IP, port";

$connectionOptions = array(

"database" => "yourDatabase",

"uid" => "yourUsername",

"pwd" => "yourPassword"

);

// Establishes the connection

$conn = sqlsrv_connect($serverName, $connectionOptions);

if ($conn === false) {

die(formatErrors(sqlsrv_errors()));

}

// Select Query

$tsql = "SELECT @@Version AS SQL_VERSION";

// Executes the query

$stmt = sqlsrv_query($conn, $tsql);

// Error handling

if ($stmt === false) {

die(formatErrors(sqlsrv_errors()));

}

<h1> Results : </h1>

<?php

while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {

echo $row['SQL_VERSION'] . PHP_EOL;

}

sqlsrv_free_stmt($stmt);

sqlsrv_close($conn);

function formatErrors($errors)

{

// Display errors

echo "Error information: <br/>";

foreach ($errors as $error) {

echo "SQLSTATE: ". $error['SQLSTATE'] . "<br/>";

echo "Code: ". $error['code'] . "<br/>";

echo "Message: ". $error['message'] . "<br/>";

}