loadList.php

Source of loadList.php

<?php
//connect to database
  try {
    $con= new PDO('mysql:host=localhost;dbname=dbName', "user", "pwd");
    $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 
    $result = $con->query('SELECT * FROM hero');
    $result->setFetchMode(PDO::FETCH_ASSOC);
 
    foreach($result as $row){
      $id = $row["heroID"];
      $name = $row["name"];

      print <<< HERE
    <option value = "$id">$name</option>

HERE;

    } // end record loop                     
  } catch(PDOException $e) {
      echo 'ERROR: ' . $e->getMessage();
  } // end try

?>