Extract a row by value from php array [duplicate]

Question

This is my array:

Array (
    [0] => Array ( [SocketID] => 1 [SocketName] => Name [SocketDecimal] => 0 [SocketHex] => 00 [SocketAtt] => 1 [Category] => 1 [Value] => 100 [Procentage] => 0 ) 
    [1] => Array ( [SocketID] => 2 [SocketName] => Name2 [SocketDecimal] => 50 [SocketHex] => 32 [SocketAtt] => 1 [Category] => 1 [Value] => 800 [Procentage] => 0 ) 
    [2] => Array ( [SocketID] => 3 [SocketName] => Name3 [SocketDecimal] => 100 [SocketHex] => 64 [SocketAtt] => 1 [Category] => 1 [Value] => 60 [Procentage] => 0 )
)

How can I extract a row by SocketDecimal?

For example: I want to extract row where SocketDecimal = 50 and make new an array only with that row.

What do you mean by "extract" , echo ? create a new array ? write to a file ? — Pedro Lobito
– Pedro Lobito, Commented Apr 28, 2015 at 12:38
Edit your question with what your desired output should look like. — ksbg
– ksbg, Commented Apr 28, 2015 at 12:41
@Rizier123 I think he wants it the other way. I think he wants to have the entire record where socketdecimal = 50. — Loko
– Loko, Commented Apr 28, 2015 at 12:45
@Rizier123 Even though I agree 100% with you that this is guesswork. I think it makes the most sense since I dont think he wants all the socketdecimal values where the value =50. Wouldn't make sense unless he wants to count the amount of values where value = 50 which still can be done in a better way. — Loko
– Loko, Commented Apr 28, 2015 at 12:51
@MeTa The better way was about if you wanted just the value==50 returned but according to your accepted answer, you dont want that and treegardens answer is the right answer. — Loko
– Loko, Commented Apr 28, 2015 at 12:58

ksbg · Accepted Answer · 2015-04-28 12:45:46Z

3

foreach($array as $entry) {
    if($entry['SocketDecimal'] == 50)
        $newArr[] = $entry;
}

$newArr will contain the desired "row". Of course you can manipulate the if-statement depending on which "row" (I'd just call it array entry) you want to extract.

answered Apr 28, 2015 at 12:45

ksbg

3,3041 gold badge24 silver badges38 bronze badges

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

1 Comment

Loko Over a year ago

(If I'm right)I think this answer is the only one that understands the question. +1

alibek.gao · Accepted Answer · 2020-12-03 09:27:19Z

2

You can use array_column + array_search combo

$array = Array (
            "0" => Array ( "SocketID" => 1, "SocketName" => "Name", "SocketDecimal" => 0, "SocketHex" => 00, "SocketAtt" => 1, "Category" => 1, "Value" => 100, "Procentage" => 0 ) ,
            "1" => Array ( "SocketID" => 2, "SocketName" => "Name2", "SocketDecimal" => 50, "SocketHex" => 32, "SocketAtt" => 1, "Category" => 1, "Value" => 800, "Procentage" => 0 ),
            "2" => Array ( "SocketID" => 3, "SocketName" => "Name3", "SocketDecimal" => 100, "SocketHex" => 64, "SocketAtt" => 1, "Category" => 1, "Value" => 60 ,"Procentage" => 0 )
        );

var_dump($array[array_search(50,array_column($array,'SocketDecimal'))]);

answered Dec 3, 2020 at 9:27

alibek.gao

463 bronze badges

Comments

Kristiyan · Accepted Answer · 2015-04-28 12:46:25Z

1

It's not the best way for big data! It's easy for deep multiarrays.

$arr = array(
array('socket_id'=>1,'name'=>'test1'),
array('socket_id'=>2,'name'=>'test2'),
array('socket_id'=>3,'name'=>'test3'),
array('socket_id'=>2,'name'=>'test4')
);

$newArr = array();
foreach($arr as $row){
    foreach($row as $key=>$r){
        if($key == 'socket_id' && $r==2)
        $newArr[] = $row;
    }
}
print_r($newArr);

answered Apr 28, 2015 at 12:46

Kristiyan

1,66314 silver badges17 bronze badges

Comments

Qlimax · Accepted Answer · 2015-04-28 12:47:36Z

1

$result = array();
foreach($input as $i){
   if($i['SocketDecimal']==50)
      $result[]=$i;
}

answered Apr 28, 2015 at 12:47

Qlimax

5,2614 gold badges31 silver badges32 bronze badges

Comments

Anand Solanki · Accepted Answer · 2015-04-28 12:48:25Z

1

You can do it by this method

foreach ($yourarray as $key => $value){
    $newarray = array("SocketDecimal"=>$value["SocketDecimal"];
}

print_r($newarray);

edited Apr 28, 2015 at 12:48

Anand Solanki

3,4254 gold badges19 silver badges27 bronze badges

answered Apr 28, 2015 at 12:47

Ahmet ATAK

3422 silver badges13 bronze badges

Comments

BlackPearl · Accepted Answer · 2024-06-15 05:28:13Z

// If your result array is like given below
$arr = array(
            array( 'SocketID' => 1, 'SocketName' => 'Name', 'SocketDecimal' => 0, 'SocketHex' => 0, 'SocketAtt' => 1, 'Category' => 1, 'Value' => 100, 'Procentage' => 0 ),
            array ( 'SocketID' => 2, 'SocketName' => 'Name2', 'SocketDecimal' => 50, 'SocketHex' => 32, 'SocketAtt' => 1, 'Category' => 1, 'Value' => 800, 'Procentage' => 0 ), 
            array ( 'SocketID' => 3, 'SocketName' => 'Name3', 'SocketDecimal' => 100, 'SocketHex' => 64, 'SocketAtt' => 1, 'Category' => 1, 'Value' => 60, 'Procentage' => 0 )
            );

print_r($arr);

// Get row for SocketDecimal=50 by following loop:
<pre>

$resultArr = '';
foreach($arr as $recordSet)
{
    if($recordSet['SocketDecimal'] == 50)
    {
        $resultArr[] = $recordSet;
        break;
    }   
}

</pre>

print_r($resultArr);

//break foreach loop so that it will not traverse for all the array when SocketDecimal(50) founded.

Collectives™ on Stack Overflow

Extract a row by value from php array [duplicate]

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Linked

Related