Exibindo todo conteúdo da tabela de jeito fácil com FetchMode(PDO::FETCH_ASSOC);

O código vai  relacionar  todo conteúdo da tabela.

<?php;
include "pluga2.php"; # --> classe de conexão


echo "<table  style='width:639px; border: solid 4px #ddffdd;' align='center';>";
echo "<tr style='border: solid 1px #dddddd;' ><th style='border: solid 1px #dddddd ;  width : 10%;'>Ids</th><th style='border: solid 1px #dddddd;  width : 35%;'>Nome</th><th style='border: solid 1px #dddddd;  width : 15%;'>Quantia</th><th style='border: solid 1px #dddddd ; width : 15%;'>Valor</th><th style='border: solid 1px #dddddd;  width : 25px;'>Total</th></tr>";

class TableRows extends RecursiveIteratorIterator {
    function __construct($it) {
        parent::__construct($it, self::LEAVES_ONLY);
    }

    function current() {
        return "<td style='border: solid 4px #dddddd '; align='center';>" . parent::current(). "</td>";
    }

    function beginChildren() {
        echo "<tr>";
    }

    function endChildren() {
        echo "</tr>" . "\n";
    }
}
try {
        $stmt = $conn->prepare("SELECT ids , descr ,quant , valor,  total FROM pecas");
    $stmt->execute();

    // set the resulting array to associative
    $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
    foreach(new TableRows(new RecursiveArrayIterator($stmt->fetchAll())) as $k=>$v) {
        echo $v;
    }
}
catch(PDOException $e) {
    echo "Error: " . $e->getMessage();
}
$conn = null;
echo "</table>";
?>

Mais exemplos em :

http://livreparaprogramar.blogspot.com.br/2017/05/php-mysqlfetcharrayresult-como-acessar.html


Inte: