Monday, 29 August 2016

mysql - Expected exception message not displaying in PHP

I want to write a program with database connectivity and exception handling in PHP. If I insert an incorrect username then it should display its corresponding error message, and if I insert the incorrect database it should display its corresponding error message.



But in the following program whether I insert incorrect database or incorrect username it only displays the message "Could not connect to database".



   $hostname = "localhost";
$username = "root1";

$password = "";
$database = "php_thenewboston";
$conn = mysqli_connect($hostname,$username,$password);
$conn_db = mysqli_select_db($conn,$database);
class ServerException extends Exception{}
class DatabaseException extends Exception{}
try{
if(!$conn){
throw new ServerException('Could not connect to server.');
}elseif(!$conn_db){

throw new DatabaseException('Could not connect to database.');
}else{
echo "Connected.";
}
}catch(ServerException $ex){
echo "Error :".$ex->getMessage();
}catch(DatabaseException $ex){
echo "Error :".$ex->getMessage();
}
?>



I am a beginner in PHP.
Please comment below for any query.



EDIT



As asked by @Hatef
Below is the var_dump of $conn when username is incorrect, password is correct and database name is correct




object(mysqli)#1 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $"
["client_version"]=>
int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>

NULL
["errno"]=>
int(1044)
["error"]=>
string(68) "Access denied for user ''@'localhost' to database 'php_thenewboston'"
["error_list"]=>
array(1) {
[0]=>
array(3) {
["errno"]=>

int(1044)
["sqlstate"]=>
string(5) "42000"
["error"]=>
string(68) "Access denied for user ''@'localhost' to database 'php_thenewboston'"
}
}
["field_count"]=>
int(0)
["host_info"]=>

string(20) "localhost via TCP/IP"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>
string(21) "5.5.5-10.1.16-MariaDB"
["server_version"]=>
int(50505)
["stat"]=>

string(132) "Uptime: 1072 Threads: 1 Questions: 16 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 11 Queries per second avg: 0.014"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>
int(9)
["warning_count"]=>
int(0)
}



Below is the var_dump of $conn when the username is correct, password is correct and database name is incorrect.



object(mysqli)#1 (19) {
["affected_rows"]=>
int(-1)
["client_info"]=>
string(79) "mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $"
["client_version"]=>

int(50012)
["connect_errno"]=>
int(0)
["connect_error"]=>
NULL
["errno"]=>
int(1049)
["error"]=>
string(36) "Unknown database 'php_thenewboston1'"
["error_list"]=>

array(1) {
[0]=>
array(3) {
["errno"]=>
int(1049)
["sqlstate"]=>
string(5) "42000"
["error"]=>
string(36) "Unknown database 'php_thenewboston1'"
}

}
["field_count"]=>
int(0)
["host_info"]=>
string(20) "localhost via TCP/IP"
["info"]=>
NULL
["insert_id"]=>
int(0)
["server_info"]=>

string(21) "5.5.5-10.1.16-MariaDB"
["server_version"]=>
int(50505)
["stat"]=>
string(132) "Uptime: 1417 Threads: 1 Questions: 18 Slow queries: 0 Opens: 18 Flush tables: 1 Open tables: 11 Queries per second avg: 0.012"
["sqlstate"]=>
string(5) "00000"
["protocol_version"]=>
int(10)
["thread_id"]=>

int(10)
["warning_count"]=>
int(0)
}

No comments:

Post a Comment

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...