Page 1 of 1

Run array through foreach.

Posted: Sat Sep 06, 2014 1:43 pm
by donny
hello,

i need help writing out a foreach that will run through an array and take info from it also.
i need to run through each array under every ordernumber. some order numbers only have 1 array under it, some have more.
i also need to know how to set variables in the foreach using the data in the arrays such as info1, info2.


this is what my arrays look like

Code: Select all

Array
(
    [ORDERNUMBER] => Array
        (
            [0] => Array
                (
                    [0] => dataforinfo1
                    [info1] => dataforinfo1
                    [1] => dataforinfo2
                    [info2] => dataforinfo2
                    [5] => dataforformnumber
                    [formnumber] => dataforformnumber

                )

            [1] => Array
                (
                    [0] => dataforinfo1
                    [info1] => dataforinfo1
                    [1] => dataforinfo2
                    [info2] => dataforinfo2
                    [5] => dataforformnumber
                    [formnumber] => dataforformnumber
                )
        )

    [ORDERNUMBER] => Array
        (
            [0] => Array
                (
                    [0] => dataforinfo1
                    [info1] => dataforinfo1
                    [1] => dataforinfo2
                    [info2] => dataforinfo2
                    [5] => dataforformnumber
                    [formnumber] => dataforformnumber
                )

        )

)
my foreach should look something like this.

Code: Select all

foreach (each array under ordernumber  seperatly) {

//set variables
$info1 = dataforinfo1;
$info2 = dataforinfo2;
$formnumber = dataforformnumber;


//OTHER CODING WILL BE HERE

}

thanks a lot!!!

Re: Run array through foreach.

Posted: Sat Sep 06, 2014 1:46 pm
by Celauran
Nested foreach loops.

Re: Run array through foreach.

Posted: Sat Sep 06, 2014 6:01 pm
by donny
thank you i was able to figure it out by looking up nested foreach loops.

so in the end this is the code i needed

Code: Select all

<?php
include 'dblogin.php';
$select_list = $_POST['selected'];
foreach ($select_list as $key => $value) {
        $select_list[$key] = "'" . $value . "'";
}
$list = implode(', ', $select_list);

$query = "SELECT * FROM `rawdata` WHERE `ordernumber` IN ($list)";
$result = mysql_query($query) or die(mysql_error());

$ordercid = array();
while ($row = mysql_fetch_array($result)) {
        $ordercid[$row['ordernumber']][] = $row;
}

foreach($ordercid as $ordernumber) {
foreach($ordernumber as $info) {
include '/'.$info['type'].'script.php';
}
}
?>
thanks for all your help