Show result of multiple keys and array column in php

Question

I have an array like this:-

$str = array(
    array(
        'amount' => 1.87,
        'user' => 'hello',
    ),
    array(
        'amount' => 0.9,
        'user' => 'test' ,
    ),
    array(
        'amount' => 9,
        'user' => 'hello',
    ),
    array(
        'amount' => 1.4,
        'user' => 'test1',
    )
);

Now I want to show the both the amounts in an html table which user 'hello' has. I tried the following for searching it :-

$ac = array_search("hello", $str);
echo $str["$ac"];

But it doesnt work. Is there anyway to show an result like this for user 'hello' :-

1.87
9

So that I can later show in html table.

Death-is-the-real-truth · Accepted Answer · 2018-09-01 05:18:51Z

2

You can use array_column()

$users = array_column($str,'user'); // get all the user list from array
$search = "hello"; // user you want to search
foreach($users as $key=>$value){ // iterate over user array
  if($value == $search){ // compare user name with search value
    echo $str[$key]['amount'] .PHP_EOL; // if matched print the corresponding amount
  }
}

https://eval.in/1052935

answered Sep 1, 2018 at 5:18

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

4 Comments

JeffB Over a year ago

Thnx it worked :D but any ideas how to get this on html table?

Death-is-the-real-truth Over a year ago

you can use same code in HTML TABLE. make sure file extension will be .php and add tr and td correspondingly.

JeffB Over a year ago

<html> <head> <title>Test</title> </head> <body> <table style="width:100%"> <tr> <th>Amount</th> </tr> <tr> <td><?php $users = array_column($str,'user'); // get all the user list from array $search = "man"; // user you want to search foreach($users as $key=>$value){ // iterate over user array if($value == $search){ // compare user name with search value echo $str[$key]['amount'] ; // if matched print the corresponding amount } } ?></td> </table> </body> </html> I tried this but doesnt show properly

Death-is-the-real-truth Over a year ago

@JeffB please ask a new question with code and HTML. and you will get answer by some-one

Amit Verma · Accepted Answer · 2018-09-01 06:11:27Z

2

foreach($str as $new_str){
    if($new_str['user']=="hello"){
        echo $new_str['amount'];
        echo "<br />";
    }
}

answered Sep 1, 2018 at 6:11

Amit Verma

319 bronze badges

Comments

Yousaf · Accepted Answer · 2018-09-01 05:18:23Z

0

Here you can get this

$ac = array_column($record, ‘Hello’);
Print($ac);

answered Sep 1, 2018 at 5:18

Yousaf

1654 bronze badges

Comments

Saravanan · Accepted Answer · 2018-09-01 05:41:58Z

0

<?php
$str = array(
 array(
'amount' => 1.87,
'user' => 'hello',
 ),
 array(
 'amount' => 0.9,
 'user' => 'test' ,
 ),
 array(
'amount' => 9,
'user' => 'hello',
 ),
 array(
 'amount' => 1.4,
 'user' => 'test1',
)
    );

$key = array_keys(array_column($str, 'user'), 'hello');
foreach($key as $value){
  echo $str[$value]["amount"]."<br/>";
}
?>

edited Sep 1, 2018 at 5:41

answered Sep 1, 2018 at 5:26

Saravanan

8299 silver badges16 bronze badges

2 Comments

JeffB Over a year ago

Thanks for spending you'r time but it shows [0,2] which is wrong.

Saravanan Over a year ago

I used to get the array index of all that containing key user="hello". I have updated just check it

Collectives™ on Stack Overflow

Show result of multiple keys and array column in php

4 Answers 4

4 Comments

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related