当前位置: 首页> 最新文章列表> 如何用 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，它们同样支持获取连接的主机详情且功能更强大。

相关内容