mysqli を使用して MySQL データベースから単一のレコードを効率的に取得する方法

$row = $result->fetch_assoc();

// PHP >= 8.1
$value = $result->fetch_column();

// Legacy PHP versions
$value = $result->fetch_row()[0] ?? false;

// PHP >= 8.2
$row = $conn->execute_query($query, [$id])->fetch_assoc();

// Legacy PHP versions
$stmt = $conn->prepare($query);
$stmt->bind_param("s", $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();

// Array
$user = $conn->query("SELECT * FROM users LIMIT 1")->fetch_assoc();

// Value
$count = $conn->query("SELECT count(*) FROM users")->fetch_column();

// Value < 8.1
$count = $conn->query("SELECT count(*) FROM users")->fetch_row()[0];