如何在php5中通过类和对象设置动态数据库值

class Database {
    private $connection;
    
    public function __construct($host, $username, $password, $database) {
        $this->connection = new mysqli($host, $username, $password, $database);
        if ($this->connection->connect_error) {
            die("Connection failed: " . $this->connection->connect_error);
        }
    }
    
    public function setDynamicValue($tableName, $columnName, $value) {
        $query = "UPDATE $tableName SET $columnName = '$value'";
        if ($this->connection->query($query) === TRUE) {
            echo "Dynamic value set successfully.";
        } else {
            echo "Error setting dynamic value: " . $this->connection->error;
        }
    }
    
    public function closeConnection() {
        $this->connection->close();
    }
}

// 创建数据库连接
$database = new Database("localhost", "username", "password", "database_name");

// 设置动态值
$database->setDynamicValue("table_name", "column_name", "dynamic_value");

// 关闭数据库连接
$database->closeConnection();