setting an array() index

Question

i am playing with an array in PHP (still learning arrays!)

i have the following PHP code to pull data from my eventsTest table, and echo the array;

    <?php
if ($result = $con->query("SELECT * FROM eventsTest")) {
    $array = array();
    while($row=mysqli_fetch_assoc($result)) {
        $array[] = $row;

    }
print "<pre>";
print_r($array);
print "</pre>"; // DEBUG--- show all array data
}

which prints my array as:

Array
(
    [0] => Array
        (
            [id] => 1
            [dateStart] => 2018-12-26
            [dateEnd] => 2018-12-26
            [name] => Test Event 1
        )

    [1] => Array
        (
            [id] => 2
            [dateStart] => 2018-12-27
            [dateEnd] => 2018-12-27
            [name] => Test Event 2
        )
)

instead of the [0] [1] [2] keys as the index, can i set the dateStart as the key for the array index?

for example:

    Array
(
    [2018-12-26] => Array
        (
            [0] => Array
                (
                    [dateEnd] => 2018-12-27
                    [name] => Test Event 1
                )

        )

    [2018-12-27] => Array
        (
            [0] => Array
                (
                    [dateEnd] => 2018-12-27
                    [name] => Test Event 2
                )

        )

    [2018-12-28] => Array
        (
            [0] => Array
                (
                    [dateEnd] => 2108-12-28
                    [name] => Test Event 3
                )

            [1] => Array
                (
                    [dateEnd] => 2018-12-28
                    [name] => Test Event 4
                )

        )

)

grouping the dateStart also in the same index if there is multiple rows with the same dateStart for example?

Yes. You can easily do that in your loop.

John Conde
– John Conde

2018-12-23 23:40:04 +00:00
Commented Dec 23, 2018 at 23:40 — John Conde
– John Conde, Commented Dec 23, 2018 at 23:40

ArtisticPhoenix · Accepted Answer · 2018-12-23 23:55:40Z

2

Like this:

while($row=mysqli_fetch_assoc($result)) {
    $array[$row['dateStart']][] = $row;
}

Note that this will give you a structure similar to what you asked for.

 Array
(
    [2018-12-26] => Array
        (
            [0] => Array
                (
                    [dateEnd] => 2018-12-27
                    [name] => Test Event 1
                )

        )

Because this $array[$row['dateStart']][] = is an array $array[$row['dateStart']] with a key $row['dateStart'] and it's value is an array that contains the rows.

answered Dec 23, 2018 at 23:55

ArtisticPhoenix

21.7k2 gold badges27 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wehr · Accepted Answer · 2018-12-23 23:46:37Z

1

You can do it like that:

<?php
if ($result = $con->query("SELECT * FROM eventsTest")) {
     $array = [];
     while($row=mysqli_fetch_assoc($result)) {
      if (isset($row['dateStart'])) {
       $array[$row['dateStart']] = $row;
      }
     }

print "<pre>";
print_r($array);
print "</pre>"; // DEBUG--- show all array data
}

answered Dec 23, 2018 at 23:46

wehr

111 silver badge2 bronze badges

4 Comments

ArtisticPhoenix Over a year ago

it will overwrite the last one. They would be better off doing $array[$row['dateStart']][]= $row; that way each level would be consistent, it will be hard to tell an array of data from an array of arrays of data.

NavyPixel Over a year ago

i didnt need the isset so i left it out, and my index now shows dateStart, but i know in my table i have an index with the same value (multiple dateStart are the same) and its not showing these? is this because they have to be a unique index?

ArtisticPhoenix Over a year ago

Yes and no. It's because they didn't do what I said above. But yes you only see one because the indexes are unique, so in that case make them arrays of rows of data.

NavyPixel Over a year ago

@ArtisticPhoenix you were right, i changed it to add your code and it now shows the groups. thank you very much and good explanation of an already difficult part of arrays to get my head around.

Collectives™ on Stack Overflow

setting an array() index

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related