PHP ERROR HANDLING : Error message is not Showing

Asked Dec 01 '16 at 05:06

Active Dec 01 '16 at 05:52

Viewed 24 times

I am new with PDO and i tried connecting to the database using TRY and CATCH error handling. But the problem is when i intentionally put some errors in my script, the error message is not showing.

connectionDAO.php :

<?php

error_reporting(E_ALL);
ini_set('display_errors', 1);

class connectionDAO {

    $username = "root";
    $password = "";
    $host = "localhost";
    $database = "RMSs";
    $dbh = null;

    public function openConnection() {
        $this->dbh = new PDO("mysql:host=". $this->host . ";dbname=" . $this->database, $this->username, $this->password);
        $this->dbh = setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    public function closeConnection() {
        try {
            $this->dbh = null;
        } catch(Exception $e) {
            $e->getMessage();
        }
    }
}

?>

In the above code, my database name is "RMS" but i intentionally input it wrong. When i go to it's URL(localhost/website/php/connectionDAO.php) it's not showing any errors. what seems to be the problem here? My main goal for this is to test either the database if connecting properly before proceeding. Can somebody also give me some other example except mine how to test for database connection in PDO?

edited Dec 01 '16 at 05:52

asked Dec 01 '16 at 05:06

Mr Veloso

What is the error? – Fabulous Dec 01 '16 at 05:11
The way you are trying to report errors is wrong, both by intention and implementation. The proper solution is in the linked answer. – Your Common Sense Dec 01 '16 at 05:13
In short, just get rid of try...catch stuff – Your Common Sense Dec 01 '16 at 05:15
@Fabulous the error should show since my database name is not right(intentionally did it for testing) but the problem is no error is show. . – Mr Veloso Dec 01 '16 at 05:22
@YourCommonSense where is the answer link sir ? – Mr Veloso Dec 01 '16 at 05:22
On top of your of your question. – Your Common Sense Dec 01 '16 at 05:30
@YourCommonSense i edit my question tried what you said but im not sure if im doing right? – Mr Veloso Dec 01 '16 at 05:53
Get rid of that try and catch operators. remove them completely from your code. And you will have your error "handling" first class – Your Common Sense Dec 01 '16 at 06:14

PHP ERROR HANDLING : Error message is not Showing

0 Answers0