<meta http-equiv="content-type" content="text/html" charset="utf-8"/>
<h1>用mysqli面向?qū)ο蠓椒ㄟB接數(shù)據(jù)庫(kù)!-姚遠(yuǎn)的博客</h1>
<form method="POST" action="<?php echo htmlspecialchars($_SERVER['PHP_SELF'])?>">
服務(wù)器地址：<input type="text" name="mysqlip"/>
<br/>
服務(wù)器賬號(hào)：<input type="text" name="mysqluser"/>
<br/>
服務(wù)器密碼：<input type="password" name="mysqlpassword"/>
<br/>
<input type="submit" value="連接mysql"/>
</form>
<?php
if($_SERVER['REQUEST_METHOD']=="POST"){//獲取提交方式進(jìn)行對(duì)比,然后用if進(jìn)行判斷!
  //用mysqli面向?qū)ο蠓椒ㄟB接mysql數(shù)據(jù)庫(kù)
  $servername=$_POST['mysqlip'];//服務(wù)器地址
  $username=$_POST['mysqluser'];//用戶(hù)賬號(hào)
  $password=$_POST['mysqlpassword'];//密碼
  $conn = new mysqli($servername,$username,$password);//把myqli實(shí)例化,用面向?qū)ο箧溄觤ysql數(shù)據(jù)庫(kù)!
  if($conn->connect_error){//$conn->connect_error用面向?qū)ο髞?lái)表示,有錯(cuò)誤信息會(huì)返回字符串,沒(méi)錯(cuò)誤信息返回null；用if判斷輸出的信息；
    echo "連接失敗!".$conn->connect_error;//返回null輸出
  }else{
    echo "你所連接的數(shù)據(jù)庫(kù)地址為：".$servername;
    echo "<br/>你所連接的數(shù)據(jù)庫(kù)賬號(hào)為：".$username;
    echo "<br/>你所連接的數(shù)據(jù)庫(kù)密碼為：".$password;
    echo "<br/>連接成功!";//返回字符串輸出
  }
  if($conn->connect_error){
    echo "<br/>未檢測(cè)到連接的數(shù)據(jù)庫(kù),所以未關(guān)閉!";
  }else{
    $conn->close();//面向?qū)ο箨P(guān)閉數(shù)據(jù)庫(kù)!
    echo "<br/>已成功關(guān)閉數(shù)據(jù)庫(kù)連接!";
  }
}
?>