如何在PHP中使用getter和setter方法从数据库中选择

$conn = new mysqli("数据库主机", "用户名", "密码", "数据库名");

if ($conn->connect_error) {
    die("数据库连接失败: " . $conn->connect_error);
}

class User {
    private $id;
    private $name;
    private $email;
    
    // getter方法
    public function getId() {
        return $this->id;
    }
    
    public function getName() {
        return $this->name;
    }
    
    public function getEmail() {
        return $this->email;
    }
    
    // setter方法
    public function setId($id) {
        $this->id = $id;
    }
    
    public function setName($name) {
        $this->name = $name;
    }
    
    public function setEmail($email) {
        $this->email = $email;
    }
}

// 创建一个User对象
$user = new User();

// 执行数据库查询
$sql = "SELECT * FROM users WHERE id = 1";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 读取查询结果中的数据并使用setter方法设置User对象的属性值
    while ($row = $result->fetch_assoc()) {
        $user->setId($row["id"]);
        $user->setName($row["name"]);
        $user->setEmail($row["email"]);
    }
    
    // 使用getter方法获取User对象的属性值
    $id = $user->getId();
    $name = $user->getName();
    $email = $user->getEmail();
    
    // 打印属性值
    echo "ID: " . $id . "<br>";
    echo "Name: " . $name . "<br>";
    echo "Email: " . $email . "<br>";
} else {
    echo "没有找到匹配的记录";
}