<meta http-equiv="content-type" content="text/html" charset="utf-8"/>
<h1>用mysqli面向?qū)ο蠓椒ㄟB接數(shù)據(jù)庫！-姚遠(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ù)庫
  $servername=$_POST['mysqlip'];//服務(wù)器地址
  $username=$_POST['mysqluser'];//用戶賬號(hào)
  $password=$_POST['mysqlpassword'];//密碼
  $conn = new mysqli($servername,$username,$password);//把myqli實(shí)例化，用面向?qū)ο箧溄觤ysql數(shù)據(jù)庫！
  if($conn->connect_error){//$conn->connect_error用面向?qū)ο髞肀硎荆绣e(cuò)誤信息會(huì)返回字符串，沒錯(cuò)誤信息返回null；用if判斷輸出的信息；
    echo "連接失??！".$conn->connect_error;//返回null輸出
  }else{
    echo "你所連接的數(shù)據(jù)庫地址為：".$servername;
    echo "<br/>你所連接的數(shù)據(jù)庫賬號(hào)為：".$username;
    echo "<br/>你所連接的數(shù)據(jù)庫密碼為：".$password;
    echo "<br/>連接成功！";//返回字符串輸出
  }
  if($conn->connect_error){
    echo "<br/>未檢測到連接的數(shù)據(jù)庫，所以未關(guān)閉！";
  }else{
    $conn->close();//面向?qū)ο箨P(guān)閉數(shù)據(jù)庫！
    echo "<br/>已成功關(guān)閉數(shù)據(jù)庫連接！";
  }
}
?>