[PHP] MsSQL 연동하여 쿼리 실행하기 sqlsrv

■ PHP MsSQL 연동하여 쿼리 실행하기 sqlsrv

PHP에서 MsSQL connect 연동하여 쿼리 실행하는 방법

---

■ MsSQL 연동

sqlsrv_connect

$endpoint = "test.zxchsr.amazonaws.com";
$connectionOptions = array(
    "database" => "user_database_name",
    "uid" => "user_id",
    "pwd" => "user_password"
);

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

---

■ 연동한 MsSQL 쿼리 실행 방법

sqlsrv_fetch_object OR sqlsrv_fetch_array

$selSql = "
    SELECT *
    FROM test_table_name
";
$selRes = sqlsrv_query($conn, $selSql);
/* Retrieve each row as a PHP object and display the results.*/  
while( $obj = sqlsrv_fetch_object($selRes) ){  
	echo $obj->LastName.", ".$obj->FirstName."\n";  
}

// OR
// while( $obj = sqlsrv_fetch_array($selRes) )  {  
//      echo $obj['LastName'].", ".$obj['FirstName']."\n";  
// }