'SET NAMES utf8', ); $dbh = new PDO($dsn, $username, $password, $options); //fetch data from database $stmt = $dbh->query("SELECT * FROM mytable"); $data = $stmt->fetchAll(PDO::FETCH_ASSOC); //display data in HTML table echo ""; echo ""; echo ""; foreach ($data as $row) { echo ""; } echo ""; echo "
ID | Name |
---|---|
".$row['id']." | ".$row['name']." |
query($sql); //display data in HTML table echo ""; echo ""; echo ""; if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo ""; } } echo ""; echo "
ID | Name |
---|---|
".$row["id"]." | ".$row["name"]." |