新的 Mysqli 对象为空

2021-12-25 00:00:00 php mysql mysqli

我正在尝试在 PHP 中使用 Mysqli 创建到 MySQL 数据库的连接.当我在独立页面上执行以下代码时:

I'm trying to create a connection to a MySQL database using Mysqli in PHP. When I execute the following code on a stand alone page:

<?php
ini_set('display_errors', 'On');
error_reporting(E_ALL);

$link = new mysqli('localhost', 'myuser', 'mypass', 'dbname');
var_dump($link);

我得到的只是一个空的 Mysqli 对象，其中所有的属性都是空的.不会显示任何错误或任何内容.

All I get outputted is an empty Mysqli object where all the properties are null. No error or anything gets displayed.

我也没有在 Apache 或 MySQL 日志中看到任何条目.我有点不知所措.

I also don't see any entries in the Apache or MySQL logs. I'm kind of at a lost on this one.

推荐答案

我也遇到了这个问题，并且疯狂地尝试调试它.事实证明，有时出于某种原因，mysqli 对象没有被填充，但直接访问它的属性仍然会执行其背后的本机代码.因此，即使整个 mysqli 对象的 var_dump 显示空属性，如果您单独访问它们，它们也会存在.如果 errorno 结果为 false，则您可能执行了一个有效查询，但结果集为空，这是您不期望的.希望这会有所帮助.

I had this problem too and was going crazy trying to debug it. It turns out that sometimes for whatever reason the mysqli object does not get populated, but directly accessing it's properties still executes the native code behind it. So even though a var_dump of the entire mysqli object shows null properties, they are there if you access them individually. If errorno turns out to be false, you may have executed a valid query with an empty resultset that you weren't expecting. Hope this helps.

$mysqli = mysqli_connect('localhost', 'root', '', 'test', 3306);

var_dump($mysqli);

var_dump($mysqli->client_info);
var_dump($mysqli->client_version);
var_dump($mysqli->info);

和输出:

object(mysqli)[1]
  public 'affected_rows' => null
  public 'client_info' => null
  public 'client_version' => null
  public 'connect_errno' => null
  public 'connect_error' => null
  public 'errno' => null
  public 'error' => null
  public 'field_count' => null
  public 'host_info' => null
  public 'info' => null


public 'insert_id' => null
  public 'server_info' => null
  public 'server_version' => null
  public 'stat' => null
  public 'sqlstate' => null
  public 'protocol_version' => null
  public 'thread_id' => null
  public 'warning_count' => null

string 'mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $' (length=50)
int 50008
null
int 0
string 'localhost via TCP/IP' (length=20)
string '5.5.20-log' (length=10)
int 50520

相关文章