What is the potential issue with using mysqli::fetch() in PHP when trying to store results in an array?

When using mysqli::fetch() in PHP to fetch rows from a result set, it only fetches one row at a time. If you want to store all the results in an array, you need to loop through the result set and store each row in the array individually. This can be inefficient for large result sets as it involves multiple database calls. 

// Connect to database
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Query to fetch data
$sql = "SELECT * FROM table";
$result = $conn->query($sql);

// Initialize empty array to store results
$data = array();

// Loop through result set and store each row in the array
while ($row = $result->fetch_assoc()) {
    $data[] = $row;
}

// Close connection
$conn->close();

// Now $data array contains all the fetched rows

Keywords

mysqli fetch array results issue

Related Questions