KoderSolutionKoderSolution LogoKoderSolution Logo
HomeArticlesTutorialsToolsRun CodeForumAI Lab
🐘

PHP

Topic Hub & Articles

PHP Intro

10 min

PHP MySQL Database

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Install

10 min

PHP Syntax

10 min

PHP Comments

10 min

PHP Variables

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Echo / Print

10 min

PHP Data Types

10 min

PHP Strings

10 min

PHP Numbers

10 min

PHP Math

10 min

PHP Constants

10 min

PHP Operators

10 min

Recap Quiz

Gated

Milestone Assessment

PHP If...Else...Elseif

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Switch

10 min

PHP Loops

10 min

PHP Functions

10 min

PHP Arrays

10 min

PHP Superglobals

10 min

Recap Quiz

Gated

Milestone Assessment

PHP RegEx

10 min

PHP Form Handling

10 min

PHP Form Validation

10 min

PHP Form Required

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Form URL/E-mail

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Date and Time

10 min

PHP Include

10 min

PHP File Handling

10 min

PHP File Open/Read

10 min

PHP File Create/Write

10 min

PHP File Upload

10 min

PHP Cookies

10 min

PHP Sessions

10 min

PHP Filters

10 min

PHP Filters Advanced

10 min

PHP JSON

10 min

PHP Exceptions

10 min

PHP What is OOP

10 min

PHP Classes/Objects

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Constructor

10 min

PHP Destructor

10 min

PHP Access Modifiers

10 min

PHP Inheritance

10 min

PHP Class Constants (OOP)

10 min

PHP Abstract Classes

10 min

PHP Interfaces

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Traits

10 min

Recap Quiz

Gated

Milestone Assessment

PHP Static Methods

10 min

PHP Static Properties

10 min

PHP Iterables

10 min

Connect to MySQL

10 min

Create Database

10 min

Create Table

10 min

Insert Data

10 min

Get Last ID

10 min

Insert Multiple

10 min

Recap Quiz

Gated

Milestone Assessment

Prepared Statements

10 min

Recap Quiz

Gated

Milestone Assessment

Select Data

10 min

Delete Data

10 min

Update Data

10 min

Limit Data

10 min

Progress
0%

0 / 60 Lessons

KoderSolutionKoderSolution LogoKoderSolution Logo

The world’s most advanced technical ecosystem for modern software engineers. Learn, build, and grow with next-generation developer tools and resources.

Facebook PageX (Twitter) ProfileYouTube ChannelContact Support

Engineering Newsletter

Subscribe for weekly software engineering tutorials, architecture guides, and developer tool updates.

Platforms

  • Technical Articles
  • Interactive Tutorials
  • AI Coding Lab
  • Developer Forum
  • Developer Tools

Pages

  • About Us
  • Contact Us
  • Privacy Policy
  • Terms of Service
  • Refund Policy
  • Disclaimer
  • Advertisement

Popular Topics

  • PHP
  • Laravel
  • Python
  • React.Js
  • MySQL
© 2026 KoderSolutionAll Rights Reserved
Developed Bymaksudur.dev
PHPPHP MySQL
Lesson

Select Data

10 min reading
Free Course

Selecting Data from MySQL in PHP with PDO

Reading records from a MySQL database in PHP uses SELECT queries executed through PDO statements, followed by fetch(), fetchAll(), or fetchColumn() to retrieve rows into PHP arrays. Picking the right fetch method keeps memory usage low and makes template rendering straightforward.

Choosing Between fetch(), fetchAll(), and fetchColumn()

Match the PDO fetch helper to the exact shape of data your query returns.

Method Return Value Best Use Case
$stmt->fetch() Single associative array or false Fetching one record by id or email, or streaming row-by-row
$stmt->fetchAll() Array of associative arrays ([] if empty) Small paginated lists (e.g., 20 rows per page)
$stmt->fetchColumn() Single scalar value or false SELECT COUNT(*), SUM(...), or single-column lookup
<?php
declare(strict_types=1);

function getUserSummary(PDO $pdo, int $userId): ?array
{
    $stmt = $pdo->prepare(
        'SELECT id, full_name, email, created_at FROM users WHERE id = :id LIMIT 1'
    );
    $stmt->execute([':id' => $userId]);

    $user = $stmt->fetch();
    return $user !== false ? $user : null;
}

function listRecentOrders(PDO $pdo, int $userId): array
{
    $stmt = $pdo->prepare(
        'SELECT id, total_amount, created_at FROM orders WHERE user_id = :user_id ORDER BY id DESC LIMIT 20'
    );
    $stmt->execute([':user_id' => $userId]);

    return $stmt->fetchAll();
}

Rendering Database Rows Safely in HTML

Even if records came from your own database, treat every string column as untrusted when outputting HTML. Escape text with htmlspecialchars((string) $row['full_name'], ENT_QUOTES, 'UTF-8') to block stored XSS attacks.

Common Mistakes to Avoid

  • Using SELECT * in production queries: Fetching unused TEXT or BLOB columns wastes database memory and network bandwidth. Always list the exact columns you need.
  • Calling fetchAll() on a table with 100,000 rows: Loading massive result sets into an array exhausts PHP's memory_limit. Paginate with LIMIT / OFFSET (or keyset pagination) or iterate row by row with while ($row = $stmt->fetch()).
  • Ignoring false return from fetch(): Accessing $user['email'] when fetch() returned false (no matching ID) triggers a PHP warning. Check if ($user === false) first.

Frequently Asked Questions

What does PDO::FETCH_ASSOC do?

It configures fetch() and fetchAll() to return clean associative arrays keyed by column names ($row['email']), avoiding duplicated numeric indices from PDO::FETCH_BOTH.

How do I count matching rows efficiently?

Run SELECT COUNT(*) FROM orders WHERE user_id = :id and read the integer via (int) $stmt->fetchColumn(), rather than calling count($stmt->fetchAll()).

Can I fetch rows directly into a PHP DTO class?

Yes. Use $stmt->fetchObject(UserDto::class) or PDO::FETCH_CLASS when mapping results directly onto typed objects.

Save Your Progress

Unlock Your
Full Potential.

Sign in to track your learning journey, earn industry-recognized certificates, and join our elite developer community.

Quick Access With

Enterprise-Grade Security Protocol

Try it Yourself

Experiment with the code from this lesson in our interactive playground.

Open Playground

Related Developer Tools & Topic Hub

PHP Topic Hub
Regex Tester
Test PCRE and string patterns
Hash Generator
Generate SHA-256 and MD5 hashes
Base64 Converter
Encode and decode Base64 strings
All PHP Articles
Deep-dive guides, tips & discussions
PreviousPrepared Statements
Continue JourneyNext: Delete Data

Stuck on this lesson?

Join our community of senior developers.

Ask in Forum