Advertisement
noam76

display_data.php

May 15th, 2023
742
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.74 KB | None | 0 0
  1.    <?php
  2.    function display_data() {
  3.        $dsn = 'mysql:host=localhost;dbname=mydatabase';
  4.        $username = 'myusername';
  5.        $password = 'mypassword';
  6.        $options = array(
  7.            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
  8.        );
  9.        try {
  10.            $pdo = new PDO($dsn, $username, $password, $options);
  11.            $stmt = $pdo->query('SELECT * FROM data_storage');
  12.            echo '<table>';
  13.            echo '<tr><th>ID</th><th>Value</th></tr>';
  14.            while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
  15.                echo '<tr><td>' . $row['id'] . '</td><td>' . $row['value'] . '</td></tr>';
  16.            }
  17.            echo '</table>';
  18.        } catch (PDOException $e) {
  19.            throw $e;
  20.        }
  21.    }
  22.    ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement