Combining Arrays

faz_matt

I am trying to combine several arrays into 1 to be inserted as rows into a table, so what I have is this array:

Array
(
    [0] => Array
        (
            [0] => 0
            [1] => 1
        )

[1] => Array
    (
        [0] => 10
        [1] => 11
    )
)

that need to be turned into this:

Array
(
    [0] => Array
        (
            [0] => 0
            [1] => 10
        )

[1] => Array
    (
        [0] => 0
        [1] => 11
    )

[2] => Array
    (
        [0] => 1
        [1] => 10
    )

[3] => Array
    (
        [0] => 1
        [1] => 11
    )

)

Is there a function that can do this for me, or does anyone have any idea of how to do this with a loop or 2, there could be more rows in the first array, and more elements too.

Any ideas??

Matt

laserlight

Could you describe what you are actually trying to do?

liquorvicar

how about:

foreach ($array[0] as $null=>$first) {
  foreach ($array[1] as $nul=>$second) {
    $new_array[] = array($first,$second);
  }
}

faz_matt

Thankyou liquorvicar, I just couldn't get my head around how to do this. I was actually looking for something that could handle an infinate number of arrays, but as I only need up to 5, I have used this:

i$tmpArray = $this->taskArray["reoccurringTimes"];
		if(!isset($tmpArray["minute"])) $tmpArray["minute"]["0"] = "";
		if(!isset($tmpArray["hour"])) $tmpArray["hour"]["0"] = "";
		if(!isset($tmpArray["mday"])) $tmpArray["mday"]["0"] = "";
		if(!isset($tmpArray["month"])) $tmpArray["month"]["0"] = "";
		if(!isset($tmpArray["wday"])) $tmpArray["wday"]["0"] = "";

	foreach($tmpArray["minute"] as $null=>$minute){
		foreach($tmpArray["hour"] as $null=>$hour){
			foreach($tmpArray["mday"] as $null=>$mday){
				foreach($tmpArray["month"] as $null=>$month){
					foreach($tmpArray["wday"] as $null=>$wday){
						$this->queryTimes[] = array("minute"=>"$minute","hour"=>"$hour","mday"=>"$mday","month"=>"$month","wday"=>"$wday");
					}
				}
			}
		}
	}

laserlight, what I am actually doing is making a scheduleing app something like cron, I am taking an input from 5 select multiple boxes, and depending on which ones are selected, putting a row into a table for it.

Thanks for the help

liquorvicar

correct me if i've misunderstood you but you're trying to take the five standard cron fields from a form and put them into a row in a database? if so, that looks a very long-winded way around it!
why don't you just grab the values directly and make an array from that?

faz_matt

If I was using a select statement, it would be quite easy, but I am using a select multiple, so I get back an array of times and dates, and each different combination needs to be a row in the database, so if 05:00 and and 6:00 on the 23rd and 25th of the month is selected, then 4 rows have to be put in the database, because the job will run on 4 different dates.