PHP Array issue , mulitple rows generated

Question

I have an array that is fetched from database using some bindModel in cakephp. finally now I want to change its format according to my liking to own. here is the array contains.

I want to convert or change its format something like as follows. This will altered on the behalf of DriverLocation=>driver_id

Array
(
    [0] => Array
        (
            [DriverLocation] => Array
                (
                    [id] => 1
                    [dispensary_id] => 1
                    [driver_id] => 85
                    [zip_code_id] => 42
                    [created] => 2015-05-25 12:01:14
                )

            [ZipCode] => Array
                (
                   [0] =>  Array
                    (
                        [id] => 42
                        [province_id] => 3846
                        [city] => Rohtak
                        [zip_code] => 30215
                        [status] => active
                    )
                   [1] =>  Array
                    (
                        [id] => 43
                        [province_id] => 3846
                        [city] => Rohtak
                        [zip_code] => 15478
                        [status] => active
                    )

                )

            [UserProfile] => Array
                (
                    [first_name] => Arman
                    [last_name] => Kumar
                )

        )



    [1] => Array
        (
            [DriverLocation] => Array
                (
                    [id] => 3
                    [dispensary_id] => 1
                    [driver_id] => 77
                    [zip_code_id] => 41
                    [created] => 2015-05-25 12:45:47
                )

            [ZipCode] => Array
                (
                    [id] => 41
                    [province_id] => 3846
                    [city] => Malviya Vihar
                    [zip_code] => 12558
                    [status] => active
                )

            [UserProfile] => Array
                (
                    [first_name] => Manish
                    [last_name] => Kumar
                )

        )

)

Please be more descriptive!

someOne
– someOne

2015-05-25 14:01:40 +00:00
Commented May 25, 2015 at 14:01 — someOne
– someOne, Commented May 25, 2015 at 14:01

n-dru · Accepted Answer · 2015-05-25 14:30:19Z

1

You can use this loop:

foreach($ar as $k1=>$a1){
    foreach($ar as $k2=>$a2){
        if($k1 < $k2 && $a1["DriverLocation"]["driver_id"] == $a2["DriverLocation"]["driver_id"]){
            $ar[$k1]["ZipCode"][] = $a2["ZipCode"];
            if(isset($ar[$k1]["ZipCode"]["id"])){
                $ar[$k1]["ZipCode"][] = array("id"=>$ar[$k1]["ZipCode"]["id"]);
                unset($ar[$k1]["ZipCode"]["id"]);
            }
            unset($ar[$k2]);
        }
    }
}

answered May 25, 2015 at 14:30

n-dru

9,4402 gold badges31 silver badges43 bronze badges

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

1 Comment

Manish Prajapati Over a year ago

thank you so much dear :) its working according to my need.. :D thank you again.

Ananta Prasad · Accepted Answer · 2015-05-25 13:48:37Z

0

Use array_push() function to make it

for sample example

<?php
$a=array("red","green");
array_push($a,"blue","yellow");
print_r($a);
?>

output

Array ( [0] => red [1] => green [2] => blue [3] => yellow )

answered May 25, 2015 at 13:48

Ananta Prasad

3,8683 gold badges26 silver badges36 bronze badges

Collectives™ on Stack Overflow

PHP Array issue , mulitple rows generated

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related