Connect to Microsoft SQL Server Using PHP

Connect to Microsoft SQL Server Using PHP

Below Code will connect to the Microsoft Sql Server using php script.

	<?php
	$serverName = "*****.*****.****.**";//Host Name
	$uid = "mtcdb";//User Name
	$pwd = "******";//Password
	$databaseName = "Mobile_Dev";//Database Name
	$connectionInfo = array("UID" => $uid,
	"PWD" => $pwd,
	"Database" => $databaseName);
	/* Connect using SQL Server Authentication. */
	$conn = sqlsrv_connect($serverName, $connectionInfo);
	if( $conn )
	{
	echo "Connected";
	}
	else
	{
	echo "<pre>";
	die( print_r( sqlsrv_errors(), true));
	}
	//var_dump($conn);exit;
	$tsql = "SELECT * FROM users";
	/* Execute the query. */
	$stmt = sqlsrv_query($conn, $tsql);
	if ($stmt) {
	echo "Statement executed.<br>\n";
	} else {
	echo "Error in statement execution.\n";
	die(print_r(sqlsrv_errors(), true));
	}
	/* Iterate through the result set printing a row of data upon each iteration. */
	while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_NUMERIC)) {
	// print_r($row);exit;
	echo "Col1: " . $row[0] . "\n";
	echo "Col2: " . $row[1] . "\n";
	echo "Col3: " . $row[2] . "<br>\n";
	echo "-----------------<br>\n";
	}
	/* Free statement and connection resources. */
	sqlsrv_free_stmt($stmt);
	sqlsrv_close($conn);

view raw mssqlserver.php hosted with ❤ by GitHub