php 如何在mysql数据库连接中使用抛出异常

how to use throw exception in mysql database connect

提问by Django Anonymous

I come across this:-

我遇到了这个：-

PHP Error handling: die() Vs trigger_error() Vs throw Exception

PHP 错误处理：die() Vs trigger_error() Vs throw Exception

and understood that throw exception is better

并理解抛出异常更好

How can i replace die and use throw exception here in this code:-

我如何在此代码中替换 die 并在此处使用 throw 异常：-

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_db = "localhost";
$database_db = "database";
$username_db = "root";
$password_db = "password";
$db = mysqli_connect($hostname_db, $username_db, $password_db) or die("Unable to connect with Database"); 
?>

回答by slash197

try
{
    if ($db = mysqli_connect($hostname_db, $username_db, $password_db))
    {
        //do something
    }
    else
    {
        throw new Exception('Unable to connect');
    }
}
catch(Exception $e)
{
    echo $e->getMessage();
}

回答by burzum

It is documented here http://ie2.php.net/manual/en/mysqli.error.php

它记录在这里http://ie2.php.net/manual/en/mysqli.error.php

if (mysqli_connect_errno()) {
    throw new RuntimeException("Connect failed: %s\n", mysqli_connect_error());
}