gistfile1.txt

$server = "(local)\SQLEXPRESS";
$username = "sa";
$password = "weak";
try
{
    $conn = new PDO("sqlsrv:server=$server;Database=MyDB", $username, $password);
}
catch (PDOException $e)
{
    echo 'Connection failed: ' . $e->getMessage();
}
 
$conn->beginTransaction();
 
$statement = $conn->prepare("SELECT * FROM employee WHERE age = :age", array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$statement->execute(array(':age' => '26'));
 
while($row = $statement->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT))
{
?>
    Results: <!--?php echo var_dump($row) ?-->
<!--?php
}
$conn--->commit();
 
?>