Skip to main content

Populate AnyDataSet

You can populate an AnyDataSet with data from various sources including arrays, files, or by building it incrementally.

Populate from an Array​

You can populate an AnyDataSet with data from an array. Each element in the array should be an associative array representing a row.

<?php
use ByJG\AnyDataset\Core\AnyDataset;

$data = [
    ['id' => 1, 'name' => 'John'],
    ['id' => 2, 'name' => 'Mary'],
    ['id' => 3, 'name' => 'Paul'],
];

$dataset = new AnyDataset($data);

Populate from a File​

You can populate an AnyDataSet with data from an XML file. The file extension should be .anydata.xml or you can specify the full filename with extension.

<?php
use ByJG\AnyDataset\Core\AnyDataset;

// Will automatically append .anydata.xml if no extension is provided
$dataset = new AnyDataset('data');

// Or with explicit extension
$dataset = new AnyDataset('data.anydata.xml');

AnyDataset XML Format​

The AnyDataset XML file must follow this structure:

<?xml version="1.0" encoding="utf-8"?>
<anydataset>
    <row>
        <field name="id">1</field>
        <field name="name">John</field>
    </row>
    <row>
        <field name="id">2</field>
        <field name="name">Mary</field>
    </row>
    <row>
        <field name="id">3</field>
        <field name="name">Paul</field>
    </row>
</anydataset>

Building from Scratch​

You can also create an empty dataset and populate it incrementally.

<?php
use ByJG\AnyDataset\Core\AnyDataset;

$dataset = new AnyDataset();

// Add rows one by one
$dataset->appendRow(['id' => 1, 'name' => 'John']);
$dataset->appendRow(['id' => 2, 'name' => 'Mary']);
$dataset->appendRow(['id' => 3, 'name' => 'Paul']);

Importing from Another Iterator​

You can import data from any iterator that implements the GenericIterator interface:

<?php
use ByJG\AnyDataset\Core\AnyDataset;

// Assuming $otherIterator is a valid GenericIterator
$dataset = new AnyDataset();
$dataset->import($otherIterator);

Inserting Rows at Specific Positions​

You can insert a row at a specific position in the dataset:

<?php
use ByJG\AnyDataset\Core\AnyDataset;

$dataset = new AnyDataset();
$dataset->appendRow(['id' => 1, 'name' => 'John']);
$dataset->appendRow(['id' => 3, 'name' => 'Paul']);

// Insert a row at position 1 (between John and Paul)
$dataset->insertRowBefore(1, ['id' => 2, 'name' => 'Mary']);

Removing Rows​

You can remove rows from the dataset:

<?php
use ByJG\AnyDataset\Core\AnyDataset;
use ByJG\AnyDataset\Core\Row;

$dataset = new AnyDataset();
$dataset->appendRow(['id' => 1, 'name' => 'John']);
$dataset->appendRow(['id' => 2, 'name' => 'Mary']);
$dataset->appendRow(['id' => 3, 'name' => 'Paul']);

// Remove by index
$dataset->removeRow(1); // Removes Mary

// Remove by Row object
$row = new Row(['id' => 3, 'name' => 'Paul']);
$dataset->removeRow($row); // Removes Paul

Saving to a File​

After populating your dataset, you can save it to an XML file:

<?php
use ByJG\AnyDataset\Core\AnyDataset;

$dataset = new AnyDataset();
$dataset->appendRow(['id' => 1, 'name' => 'John']);
$dataset->appendRow(['id' => 2, 'name' => 'Mary']);

// Save to the original file (if loaded from a file)
$dataset->save();

// Or save to a new file
$dataset->save('new_data.anydata.xml');

Sorting the Dataset​

You can sort the dataset by a specific field:

<?php
use ByJG\AnyDataset\Core\AnyDataset;

$dataset = new AnyDataset();
$dataset->appendRow(['id' => 3, 'name' => 'Paul']);
$dataset->appendRow(['id' => 1, 'name' => 'John']);
$dataset->appendRow(['id' => 2, 'name' => 'Mary']);

// Sort by id
$dataset->sort('id');

// Now the dataset is ordered by id: John, Mary, Paul