show PHP PDO data

You must use PDOStatement :: fetch or PDOStatement::fetchAll to retrieve the results.

<?php


try {
    $conn = new PDO("sqlsrv:server = tcp:name.database.windows.net,1344;Database = my_db_name", "my_user_name", "my_password");
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $conn->prepare("SELECT Prod_Usu, Prod_Tit, Prod_Fec FROM productos"); 
    $stmt->execute();

    // set the resulting array to associative
    $stmt->setFetchMode(PDO::FETCH_ASSOC); 

    /* creamos un while para optener fila a fila los refultados devueltos mediante fetch() */
    while ($row = $stmt->fetch()) {
        echo $row['Prod_Usu'] . " - " . $row['Prod_Tit'] . " - " .$row['Prod_Fec'] . "<br>";
    }

}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;

?>

There is just one line of your code that is wrong.

Changing this:

$result = $stmt->setFetchMode(PDO::FETCH_ASSOC);

for this:

    $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

should work.     

    try {
        $conn = new PDO("sqlsrv:server = tcp:name.database.windows.net,1344; 
    Database = my_db_name", "my_user_name", "my_password");
        $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $stmt = $conn->prepare("SELECT Prod_Usu, Prod_Tit, Prod_Fec FROM productos"); 
        $stmt->execute();

        // set the resulting array to associative
        $result = $stmt->fetchAll(PDO::FETCH_ASSOC);

        foreach($result as $row) { 
            echo $row['Prod_Usu'] . " - " . $row['Prod_Tit'] . " - " . 
        $row['Prod_Fec'] . "<br>";
        }
    }
    catch(PDOException $e) {
        echo "Error: " . $e->getMessage();
    }
    $conn = null;

    ?>

Then, the result set can be read using a foreach loop or using while .