ArrayResult

\Kotchasan\Result\ArrayResult is a ResultInterface implementation for array-based results, primarily used with cached queries.

Creation

use Kotchasan\Result\ArrayResult;

$data = [
    ['id' => 1, 'name' => 'John'],
    ['id' => 2, 'name' => 'Jane']
];

// Array format (default)
$result = new ArrayResult($data);

// Object format
$result = new ArrayResult($data, 'object');

Constructor

public function __construct(array $data, string $resultFormat = 'array')

Result Formats

Array Format (Default)

$result = new ArrayResult($data);

$row = $result->fetch();
echo $row['id'];
echo $row['name'];

Object Format

$result = new ArrayResult($data, 'object');

$row = $result->fetch();
echo $row->id;
echo $row->name;

Methods

Standard Methods (from ResultInterface)

Additional Methods

Iterator Methods

Usage Examples

Basic Usage

$data = [
    ['id' => 1, 'name' => 'John', 'email' => 'john@example.com'],
    ['id' => 2, 'name' => 'Jane', 'email' => 'jane@example.com']
];

$result = new ArrayResult($data);

// Fetch row by row
while ($row = $result->fetch()) {
    echo $row['name'] . "\n";
}

Using first() and all()

$result = new ArrayResult($data, 'object');

// Fetch first row (pointer stays)
$first = $result->first();
echo $first->name;  // John

// Fetch all (pointer stays)
$all = $result->all();
echo count($all);  // 2

Using foreach (Iterator)

$result = new ArrayResult($data);

foreach ($result as $index => $row) {
    echo "{$index}: {$row['name']}\n";
}

Column Metadata

$result = new ArrayResult($data);

$meta = $result->getColumnMeta(0);
// ['name' => 'id', 'native_type' => 'STRING']

echo $result->columnCount();  // 3 (id, name, email)

Reset and Reread

$result = new ArrayResult($data);

$all1 = $result->fetchAll();  // Fetch all, pointer at end
$result->reset();              // Reset
$all2 = $result->fetchAll();  // Fetch again

Close (Free Memory)

$result = new ArrayResult($data);
// Use it...

$result->close();  // Clear data array, free memory

Use Cases

Cached Query Results

// Query cache returns ArrayResult
$cached = $cache->get('users_query');

if ($cached) {
    $result = new ArrayResult($cached);
} else {
    $result = $db->select('*')->from('user')->execute();
    $cache->set('users_query', $result->fetchAll());
}

Mock Results for Testing

// Create mock result for unit test
$mockData = [
    ['id' => 1, 'name' => 'Test User']
];

$result = new ArrayResult($mockData, 'object');
$user = $result->first();

$this->assertEquals('Test User', $user->name);

Converting PDOResult to ArrayResult

// Fetch from database
$pdoResult = $db->select('*')->from('user')->execute();
$data = $pdoResult->fetchAll();
$pdoResult->close();

// Convert to ArrayResult for multiple iterations
$arrayResult = new ArrayResult($data);

// Iterate multiple times
foreach ($arrayResult as $user) { ... }
$arrayResult->reset();
foreach ($arrayResult as $user) { ... }

Internal Properties

Related Classes

• ResultInterface - Interface
• PDOResult - PDO implementation
• Database - Core database class