Home / Questions / 68694
Accepted
gmarsi
Asked: 2020-05-10 11:15:42 +0800 CST 2020-05-10 11:15:42 +0800 CST

display PHP PDO data

  • 772

I am trying to display some results using PDO. Until now used mysqli_conect()for connection to the database. I suppose that the error is found when displaying the results in the `foreach()´. Could someone tell me how I can correct the error? Thanks in advance"

Code:

<?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
    $result = $stmt->setFetchMode(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;

?>
php

2 Answers

  1. Best Answer

    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;

?>
    • 6

  2. There is only one line of your code that is wrong.

    Changing this:

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

    For this:

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

    it 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;

    ?>

    The result set can then be read using a loop foreachor using while.

    • 0