Getting a specific value from array

Question

I have this query on mysql, and i'm getting this array with print_r():

$data = Array ( [2] => Array ( [0] => Array ( [sale_order_value_id] => 3 [sale_order_id] => 2 [name] => Comprobante Fiscal [value] => Consumidor Final [price] => 0.0000 ) [1] => Array ( [sale_order_value_id] => 4 [sale_order_id] => 2 [name] => RNC / Cédula [value] => 00111936266 [price] => 0.0000 ) ) )

I want to extract just the [name] from $data for each input, i have tried explode() to separate the values but that does not help.

i also tried echo $data[0]['name']; and $data = array_shift($data); echo $data['name']; but i get nothing with that — Alejandro Guzman, May 04 '16 at 23:13

score 0 · Answer 1 · answered May 04 '16 at 23:16

0

echo implode (',',array_column($data[2], 'name'));

array_column gets each name in an array then i implode them as you asked for.

Demo:http://ideone.com/PfX7HA

answered May 04 '16 at 23:16

YEs... this worked... i was working on PHP 5.3 and had lots of problems... now i'm on PHP 5.5 and everything works fine. – Alejandro Guzman May 05 '16 at 13:33

score 0 · Accepted Answer · answered May 04 '16 at 23:28

Here is a proper way to do it :

By Using array_column() :

Example :

<?php
// Array representing a possible record set returned from a database
$records = array(
    array(
        'id' => 2135,
        'first_name' => 'John',
        'last_name' => 'Doe',
    ),
    array(
        'id' => 3245,
        'first_name' => 'Sally',
        'last_name' => 'Smith',
    ),
    array(
        'id' => 5342,
        'first_name' => 'Jane',
        'last_name' => 'Jones',
    ),
    array(
        'id' => 5623,
        'first_name' => 'Peter',
        'last_name' => 'Doe',
    )
);

$first_names = array_column($records, 'first_name');
print_r($first_names);
?>

OUTPUT :

Array
(
    [0] => John
    [1] => Sally
    [2] => Jane
    [3] => Peter
)

And Yes in your case it can be done like this way too as it is easy :

YOUR CODE:

<?php
$data = array( 2 => array( 0 => array('name' => "John")));
//You can simply print the name column value like this
echo $data[2][0]["name"];
?>

OUTPUT OF YOUR CODE :

John

Live Working Link Of Your Code : https://eval.in/565707

score 0 · Answer 3 · answered May 04 '16 at 23:47

You can use the following to get your exact output...

$data =  array ( array ('sale_order_value_id' => 3,
                             'sale_order_id' => 2,
                             'name' => 'Comprobante Fiscal',
                             'value' => 'Consumidor Final',                 
                             'price' => 0.0000 ),
                array ( 'sale_order_value_id' => 4,
                             'sale_order_id' => 2,
                             'name' => 'RNC / Cédula',
                             'value' => 00111936266,
                             'price' => 0.0000 )
              ) ;

$names = array_column($data, 'name');

Getting a specific value from array

3 Answers3

By Using array_column() :