データベースを使ったPHPの表示方法

config.php

$dbConfig = [ 'dsn' => 
'mysql:host=localhost;dbname=データベース名', 
'username' => 'ユーザ名', 'password' => 'パスワード' ]; 

//データベース接続 
function db_open():PDO{ 
global $dbConfig;
try{ 
$dbh = new PDO($dbConfig['dsn'],
$dbConfig['username'],
$dbConfig['password'],[
 PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
 PDO::ATTR_EMULATE_PREPARES => false, ]); 
return $dbh; 
}catch(PDOException $e)
{ echo $e->getMessage(); 
} 
}

control.php

$dbh = db_open();

$sql = "SELECT * FROM items"
$stmt = $dbh->prepare($sql);
$stmt->execute();

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

page_view.php

<?php foreach($lists as $list){ ?>
                      
<tr>
  <td><?php echo $list['item'];?></td>
</tr>
<?php } ?>