Connecting to mssql from windows 10 apache/php/cakephp3

Need Help
4

  1. test pdo connection in php

    <?php

    try {
    $pdo = new PDO( “sqlsrv:server=$servername;Database=$db”, $username, $pw);
    } catch( PDOException $e ) {
    die( “Error connecting to SQL Server:” . $e->getMessage());
    }

    $stmt = $pdo->query(‘SELECT fieldname FROM tablename’);
    while ($row = $stmt->fetch())
    {
    echo $row[‘fieldname’] . “
    ”;
    }
    ?>