pdo connection status turned into a variable to echo elsewhere.

[cloudll]

Hey guys,

 

I am currently using the following code to connect to my database and to display custom messages for if it has connected to the database or not.

I would quite like to display these messages in my footer.

 

I was wondering if its possible to turn the messages into a variable to echo them in the footer? Thanks for any tips.

    $hostname = 'localhost';
    $database = 'engine';
    $username = 'root';
    $password = '';
      try {
    $dbh = new PDO("mysql:host=$hostname;dbname=$database", $username, $password);
      echo 'Connected to database'; }
      catch(PDOException $e) {
      echo 'error connecting to database.'; }
      error_reporting(0);

[venkatpvc]

you could try like below;

 

if (!$dbh) {

    $errormsg = "Failed to connect";

} else {

   $errormsg = "Connected to DataBase";

}

[cloudll]

awesome, thanks