Why Fetching results (fetch, fetchAll) in PHP? - Purpose & Use Cases

The Big Idea

Discover how a simple method can save you hours of tedious coding and headaches!

The Scenario

Imagine you have a huge list of customer orders stored in a database. You want to get all the orders and show them on your website. Without special tools, you might try to grab each order one by one manually.

The Problem

Doing this manually means writing lots of repetitive code to get each order. It's slow, easy to make mistakes, and if the list grows, your code becomes messy and hard to manage.

The Solution

Using fetch and fetchAll lets you grab one result or all results from the database easily. This saves time, reduces errors, and keeps your code clean and simple.

Before vs After

✗ Before

$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // process each row manually
}

✓ After

$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($rows as $row) {
    // process each row easily
}

What It Enables

You can quickly and safely get data from your database to use anywhere in your app without messy loops or repeated code.

Real Life Example

When building an online store, you can fetch all product details at once to display them on a page, making your site faster and easier to update.

Key Takeaways

Manual data fetching is slow and error-prone.

fetch and fetchAll simplify getting data from databases.

This makes your code cleaner and your app faster.