example2

header ("Content-Type: text/html; charset=utf-8");

$myServer = "localhost";
$myUser = "test";
$myPass = "00umonot";
$myDB = "Актёры";
$connectionInfo = array("Database"=>$myDB, "UID" => $myUser, "PWD" => $myPass, "CharacterSet" => "UTF-8");

$conn = sqlsrv_connect($myServer, $connectionInfo); //returns false

if( $conn ) {
    echo "Connection established.<br />";

}else{
    echo "Connection could not be established.<br />";
    die( print_r( sqlsrv_errors(), true));
}

$stmt = sqlsrv_query($conn,"SELECT * FROM actors ");

if( $stmt === false) {
    die( print_r( sqlsrv_errors(), true) );
}



while ($row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC))
{
    echo $row['ФИО'].'<br>';
}

sqlsrv_free_stmt( $stmt);