Untitled

<body>
    <?php
       echo "<table style='border: solid 1px black; border-collapse: collapse;
        th, td {
       padding: 5px;
       text-align: left;
        }'>";
       echo "<tr>
       <th>date/th>
       <th>Etat de TX1</th>
       <th>Etat de TX2</th>
       <th>Sur antenne</th>
       <th>ALARME</th>      </tr>";

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

         function current() {
         return "<td style='width: 150px; border: 1px solid black;'>" .
         parent::current(). "</td>";
           }

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

         function endChildren() {
         echo "</tr>" . "n";
        }
    }

       $servername = "localhost";
       $username = "root";
       $password = "";
       $dbname = "OACA";

        try {
        $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username,

     $password);
     $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     $stmt = $conn->prepare("SELECT * FROM etat");
     $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>";
    ?>
    </body>