當前位置: 首頁> 最新文章列表> 如何用mysql_get_host_info 函數詳細獲取MySQL 主機的連接信息？

如何用mysql_get_host_info 函數詳細獲取MySQL 主機的連接信息？

gitbox 2025-07-26 
<span><span><span class="hljs-meta"><?php</span></span><span>
</span><span><span class="hljs-comment">// 這部分代碼和文章內容無關，僅作示例展示</span></span><span>
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"歡迎閱讀本文！"</span></span><span>;
</span><span><span class="hljs-meta">?></span></span><span>

<hr>

<h1>如何用 <code>mysql_get_host_info

- $link_identifier ：可選參數，MySQL 連接資源。如果省略，則使用最近一次打開的連接。

返回值

返回一個字符串，格式通常為：

  • hostname:port
  • hostname:socket

例如：

  • localhost via TCP/IP
  • 127.0.0.1 via UNIX socket

示例代碼

&lt;?php
</span><span><span class="hljs-comment">// 連接數據庫</span></span><span>
</span><span><span class="hljs-variable">$link</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_connect</span></span><span>(</span><span><span class="hljs-string">'localhost'</span></span><span>, </span><span><span class="hljs-string">'root'</span></span><span>, </span><span><span class="hljs-string">'password'</span></span><span>);
</span><span><span class="hljs-keyword">if</span></span><span> (!</span><span><span class="hljs-variable">$link</span></span><span>) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">'連接失敗: '</span></span><span> . </span><span><span class="hljs-title function_ invoke__">mysql_error</span></span><span>());
}

</span><span><span class="hljs-comment">// 獲取並打印主機連接信息</span></span><span>
</span><span><span class="hljs-variable">$hostInfo</span></span><span> = </span><span><span class="hljs-title function_ invoke__">mysql_get_host_info</span></span><span>(</span><span><span class="hljs-variable">$link</span></span><span>);
</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"當前 MySQL 連接主機信息： "</span></span><span> . </span><span><span class="hljs-variable">$hostInfo</span></span><span>;

</span><span><span class="hljs-comment">// 關閉連接</span></span><span>
</span><span><span class="hljs-title function_ invoke__">mysql_close</span></span><span>(</span><span><span class="hljs-variable">$link</span></span><span>);
?&gt;

運行效果

假設成功連接，本示例會輸出類似：

<span class="fun">當前MySQL 連接主機信息： localhost via TCP/IP</span>

注意事項

  • 廢棄警告：從PHP 7.0起， mysql_系列函數已被廢棄，建議使用mysqli或PDO擴展替代。
  • 兼容性：在新項目中推薦使用mysqli_get_host_info() ，用法類似。

使用mysqli 獲取主機信息示例

&lt;?php
</span><span><span class="hljs-variable">$mysqli</span></span><span> = </span><span><span class="hljs-keyword">new</span></span><span> </span><span><span class="hljs-title function_ invoke__">mysqli</span></span><span>(</span><span><span class="hljs-string">'localhost'</span></span><span>, </span><span><span class="hljs-string">'root'</span></span><span>, </span><span><span class="hljs-string">'password'</span></span><span>);

</span><span><span class="hljs-keyword">if</span></span><span> (</span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error) {
    </span><span><span class="hljs-keyword">die</span></span><span>(</span><span><span class="hljs-string">'連接失敗: '</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>-&gt;connect_error);
}

</span><span><span class="hljs-keyword">echo</span></span><span> </span><span><span class="hljs-string">"當前 MySQL 連接主機信息： "</span></span><span> . </span><span><span class="hljs-variable">$mysqli</span></span><span>->host_info;

</span><span><span class="hljs-variable">$mysqli</span></span><span>-></span><span><span class="hljs-title function_ invoke__">close</span></span><span>();
?&gt;

總結

通過mysql_get_host_info函數，我們可以輕鬆獲取當前MySQL 連接所使用的主機信息，幫助開發者調試和監控數據庫連接環境。不過，鑑於mysql_函數的廢棄，推薦轉用mysqli或PDO ，它們同樣支持獲取連接的主機詳情且功能更強大。

相關內容