showHero.php

Source of showHero.php

<?php
//get heroID

$heroID = filter_input(INPUT_POST, 'heroID');

      try {
        $con= new PDO('mysql:host=localhost;dbname=dbName', "user", "pwd");
        $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     
        $stmt = $con->prepare("SELECT * FROM hero WHERE heroID = ?");
        $stmt->execute(array($heroID));
        
        $result = $stmt->fetchAll(PDO::FETCH_ASSOC);
        foreach($result as $row){
          foreach ($row as $field => $value){
            print <<< HERE
    <strong>$field: </strong>$value <br />

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