PHP Mind Block With Arrays

[clark-studio]

Ok guys have got a mind block, lost it completley and wonder if anyone out there go throw me a line. So here goes.

I have got an array of information like this

    20-10-2009 00:00:00|1
    21-10-2009 00:00:00|1
    23-10-2009 00:00:00|1
    24-10-2009 00:00:00|4
    25-10-2009 00:00:00|4 

What I am doing is using the explode to seperate the pipe delimited values whilst looping through the array

   $split = explode("|", $dates);
   $id= $split[1];
   $date = $split[0]; 

Ok Here is where either I am complltey over complicating things here or have just overlooked it.

What I want to achieve is to have an array for each $id with the $date(s) for that $id in their own arrays which will intail reside in if you like a master array.

Can anyone help. What I want to end up with is something like this:

array(
  [1] => 
       array([0] = > "20-10-2009",  [1] => "21-10-2009", [2] => "23-10-2009")
  [4] =>
      array([0] => " 24-10-2009", [1] => "25-10-2009")
) 

The master array i want to refrence by the $id and its array values to be the dates.

I hope it make sense.

[Dan Grossman]

foreach ($datesarray as $dates) {
  $split = explode("|", $dates);
  $id = $split[1];
  $date = $split[0];

  $newarray[$id][] = substr($date, 0, strpos($date, ' '));
} 

[AnthonySterling]

Like this?

<?php
$aSource = array(
    '20-10-2009 00:00:00|1',
    '21-10-2009 00:00:00|1',
    '23-10-2009 00:00:00|1',
    '24-10-2009 00:00:00|4',
    '25-10-2009 00:00:00|4'
);

foreach($aSource as $sEntry)
{
    $aEntry = explode('|', $sEntry);
    $aFinal[$aEntry[1]][] = current(explode(' ', $aEntry[0]));
}

print_r($aFinal);
/*
Array
(
    [1] => Array
        (
            [0] => 20-10-2009
            [1] => 21-10-2009
            [2] => 23-10-2009
        )

    [4] => Array
        (
            [0] => 24-10-2009
            [1] => 25-10-2009
        )
)
*/
?>

[oddz]

You could this with a SQL GROUP_CONCAT() so that your don't need to worry about arranging the columns.

table
- id
- created

SELECT id,GROUP_CONCAT(created) as created FROM table GROUP by id

Then run a loop and impode each created index by ',';

If your using PDO you could also group the information after your receive the result from mysql using your previous method.

<?php
$sql = 'SELECT id,created FROM table';
if($stmt = $db->prepare($sql)) {
  if($stmt->execute()) {
     $result = $stmt->fetchAll(PDO::FETCH_COLUMN|PDO::FETCH_GROUP));
  }
}
?>

Example 3

[Dan Grossman]

He has a pipe delimited set of strings, not a database with id and date column, so he can't query it