Store array of arrays value in one comma separated string

Question

I have this return array

 $leaseArray =  Array ( [0] => Array ( [LeaseNumber] => OL/2011/0343 ) [1] => Array ( [LeaseNumber] => 184 ) [2] => Array ( [LeaseNumber] => OL/2011/0118 ) [3] => Array ( [LeaseNumber] => OL/2016/1759 ) [4] => Array ( [LeaseNumber] => OL/2013/0858 ) [5] => Array ( [LeaseNumber] => OL/2012/0535 ) [6] => Array ( [LeaseNumber] => OL/2017/2208 ) [7] => Array ( [LeaseNumber] => 2355 ) )

I want to save all the values of LeaseNumber in to one comma separated string like $string = "OL/2011/0343 , 184 , OL/2011/0118 , OL/2016/1759"

please help me

$lease = array();
        for($i=0;$i<=count($leaseArray); $i++){
            $lease = $leaseArray[$i]['LeaseNumber'];
        }

i tried doing with for loop and while loop but it doesn't gave the expected result — hemanth kumar, Apr 18 '18 at 19:13
I can do it with 1 line of code and 2 function calls, just saying.... — ArtisticPhoenix, Apr 18 '18 at 19:17
[`array_column`](http://php.net/manual/en/function.array-column.php), [`implode`](http://php.net/manual/en/function.implode.php) — iainn, Apr 18 '18 at 19:18

score 3 · Answer 1 · answered Apr 18 '18 at 19:24

3

If you want a one-liner then this is the way

$csv = implode(' , ', array_column($a, 'LeaseNumber'));

As I said in the comments, 1 line, 2 function calls.

answered Apr 18 '18 at 19:24

ArtisticPhoenix

21,464
2
24
38

MonkeyZeus · Accepted Answer · 2018-04-18T19:28:02.977

If you want a one-liner then this could work:

$csv = implode( ' , ', array_map( function( $a ){ return $a[ 'LeaseNumber' ]; }, $leaseArray ) );

expanded:

$csv = implode( ' , ', // step 2: implode on ' , ': space-comma-space
    array_map( // step 1: pass $lease array into array_map so that we can get a new array
        function( $a ){ return $a[ 'LeaseNumber' ]; }, // Accept each array in $a and only return the LeaseNumber. array_map will build a new array out of just these values
        $leaseArray // the array to be processed
    )
);

In essence, this is the same as:

$csv = implode( ' , ', array_column( $a, 'LeaseNumber' ) );

but array_map() allows you to transform the data before output/return if you need to.

score 0 · Answer 3 · answered Apr 18 '18 at 19:31

One-liners are great but sometimes hard to read. If you want to stick with what you have here are some note

<?php 
$array = array(array("LeaseNumber" => "OL/2011/0343"), array("LeaseNumber"=> 184 ), array("LeaseNumber"=> "OL/2011/0118") , array("LeaseNumber"=> "OL/2016/1759"), array("LeaseNumber"=> "OL/2013/0858"), array("LeaseNumber"=> "OL/2012/0535"), array("LeaseNumber"=> "OL/2017/2208"), array("LeaseNumber"=> 2355));


$lease = array();

//Not equal to the count it starts at 1 not 0
for($i=0;$i<count($array); $i++){
    //lease is an array add to the index not overwrite
    $lease[] = $array[$i]['LeaseNumber'];
}

//You needed to finish with this
$csv = implode(", ",$lease);

echo $csv;

As an fyi switch to a foreach in this case makes life easier:

$lease = array();
foreach($array as $obj){
    $lease[] = $obj["LeaseNumber"];
}

Store array of arrays value in one comma separated string

3 Answers3