create sql server connection in php

To establish a connection between PHP and SQL Server, we can use PDO (PHP Data Objects) library. Follow the below steps:

Install the PDO driver for SQL Server (if not already installed)


main.php
// For Ubuntu
sudo apt-get install php7.0-sybase

// For CentOS
sudo yum install php70w-sybase
95 chars
6 lines

Create a new PDO instance by specifying the server name, database name, username and password.


main.php
$serverName = "localhost\SQLEXPRESS"; //serverName\instanceName
$connectionOptions = array(
    "Database" => "dbName",
    "Uid" => "username",
    "PWD" => "password"
);
$conn = sqlsrv_connect($serverName, $connectionOptions);
229 chars
8 lines

Write SQL queries and execute them using the connection object.


main.php
if ($conn) {
    $sql = "SELECT * FROM tableName";
    $stmt = sqlsrv_query($conn, $sql);
    if ($stmt === false) {
        die(print_r(sqlsrv_errors(), true));
    }

    while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
        echo $row['columnName'] . "\n";
    }

    sqlsrv_free_stmt($stmt);
} else {
    echo "Connection could not be established.<br />";
    die(print_r(sqlsrv_errors(), true));
}
419 chars
17 lines

Note: Remember to handle exceptions and errors while establishing the connection and executing queries.

similar php code snippets

how to retrieve a single record from multiple tables in php

interpolate variable into sql statement in php

read users from csv file and add them to a database in php

change collation in database in php

remove an element from the end of an array in php

reverse an array in php

find the index of an element in an array in php

remove an element from the beginning of an array in php

insert an element into an array at a specific index in php

remove an element from the middle of an array in php

related categories