php 动态调用成员函数,致命错误：调用成员函数query()PHP CLASS

您的方法：

public function db_connect() {

$connection = mysqli_connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name) or die("Error " . mysqli_error($connection));

echo "Conexión realizada". "
";

}

不会从方法中重新调整$connection,因此rest方法调用失败：

public function db_connect() {

$connection = mysqli_connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name) or die("Error " . mysqli_error($connection));

echo "Conexión realizada". "
";

return $connection; // return the $connection object

}

如前所述,您的代码效率不高,因为对于每个执行的查询,代码都(重新)连接到数据库.这不必要地昂贵/低效.

有很多方法可以解决此问题.

>在数据库类的实例上连接到数据库

例如

class Db{

private static $db_host = "localhost";

private static $db_user = "root";

private static $db_pass = "";

private static $db_name = "sivi";

public $connection;

public function __construct()

{

$this->connection = $this->db_connect();

}

public function db_connect() {

$connection = mysqli_connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name) or die("Error " . mysqli_error($connection));

echo "Conexión realizada". "
";

return $connection;

}

}

>延迟连接,即仅在第一次执行查询时连接

例如

class Db{

private static $db_host = "localhost";

private static $db_user = "root";

private static $db_pass = "";

private static $db_name = "sivi";

public $connection = null;

public function __construct()

{

}

public function db_connect() {

$connection = mysqli_connect(self::$db_host, self::$db_user, self::$db_pass, self::$db_name) or die("Error " . mysqli_error($connection));

echo "Conexión realizada". "
";

return $connection;

}

public function db_query($query){

if ( null ==== $this->connection ) $this->connection = $this->db_connect();

var_dump($query);

$result = $this->connection->query($query);

while($row = mysqli_fetch_array($result)) {

echo $row["COD_PRE"] . "
";

}

}

}