Filtering two php arrays -


i have 2 arrays. have combined both arrays output total

1st array = 

$farray = array (      [0] => array (          [1] => array (                  [ed] => 15                  [en] => 14                 )          )     [1] => array (          [2] => array (                  [ed] => 5                  [en] => 10                 )           )      )

2nd array = 

$tarray = array (      [0] => array (          [1] => array (                  [ed] => 45                  [en] => 50                               )          )      [1] => array (          [2] => array (                  [ed] => 38                  [en] => 40                )          )     )

the combination of above 2 arrays:

  $all = array (         [0] => array (              [1] => array (                  [ed] => 60                 [en] => 64                                  )              )         [1] => array (              [2] => array (                   [ed] => 43                   [en] => 50                   )               )         )

now want use first array , second array inserting condition following codes:

$fscore = array_reduce( $farray,  function($farray, $item) {     $id = key($item);     $scores = $item[$id];     $farray[$id] = array(     "score" => array_sum($scores),     "farray"=> min($scores)>=7          );     return $farray;    },    array()  );

the above attempt works , output following (print_r($fscore)):

 array (          [1] => array (              [score] => 124             [farray] => 1              )          [2] => array (              [score] => 93             [farray] => 0             )        )

but want put more conditions , combine $tarray below:

 $all= array_reduce(  $all,    function($all, $item) {     $id = key($item);     $scores = $item[$id];     $all[$id] = array(     "score" => array_sum($scores),     "farray"=> min($scores)>=7     //if tarray key==ed 23 else 26 minimum `$scores`     "tarray"=> min($scores)>='ed'? 23:26//ternary operator    );     return $all;    },    array()  );

i don't know how insert $tarray. stated earlier, without $tarray, works.

my attempts failed , not output expected result. in question used ed , en (score keys) save more space. minmum score expected $farray greater or equal 7 whereas minimum score expected $tarray 23/26. if score key ed in $tarray, minimum score greater or equal 23, else must 26. depending on conditions, want return true or false value. please help. below attempt:

    $farray = array(             array (                 1=> array(                     "ed"=>15,                     "en"=>14                    )                ),             array(                2=>array(                     "ed"=>5,                     "en"=>10                    )                  )                );  $tarray = array (           array (             1 => array (                  "ed" => 45,                  "en" => 50                               )          ),           array (            2 => array (                  "ed" => 38,                  "en" => 40                )          )     );  $combine = array (         array (              1 => array (                  "ed" => 60,                 "en" => 64                                  )              ),        array (              2 => array (                   "ed" => 43 ,                  "en" => 50                   )               )         );  function filtertarray($value){     foreach($value $key =>$val){     foreach($val $k=>$v){         foreach($v $t=>$m){             if($t=='ed'){                return $m>=23;             }else{                return $m>=26;             }                     }     }   } } function filterfarray($value){     foreach($value $key =>$val){     foreach($val $k=>$v){         foreach($v $t=>$m){                        return $m>=7;                            }     }   } }   $all = array_reduce(      $combine,       function($combine, $item) use ($farray, $tarray) {         $id = key($item);         $scores = $item[$id];         $combine[$id] = array(               "score" => array_sum($scores),               "farray"=> array_filter($farray,"filterfarray"),               "tarray"=> array_filter($tarray,"filtertarray")             );          return $combine;      },      array()    ); echo "<pre>"; print_r($all); echo "</pre>";

this outputs: 

e_warning : type 2 -- invalid argument supplied foreach()

the expected output code is:

array (      [1] => array (          [score] => 124         [farray] => true//1         [tarray] => true//1         )      [2] => array (          [score] => 93         [farray] => false//0         [tarray] => true//1         )    )

i don't think i'd bother trying spice answer array_reduce() call. more important comprehensibly deliver correct comparisons , result. welcome convert series of foreach loops array functions.

my latest edit added more sample score data newly advised keys. adjustment $fscore's tarray comparison lowest non-ed score compared against 26.

code: (demo)

$farray=[[1=>['ed'=>15,'en'=>14,'mt'=>16,'mz'=>20]],[2=>['ed'=>5,'en'=>10,'mt'=>36,'mz'=>30]]]; $tarray=[[1=>['ed'=>45,'en'=>50,'mt'=>28,'mz'=>27]],[2=>['ed'=>38,'en'=>40,'mt'=>56,'mz'=>60]]];  // generate $all foreach($farray $i=>$a){     foreach($a $n=>$scores){         foreach($scores $k=>$v){             $all[$i][$n][$k]=$v+$tarray[$i][$n][$k];  // sum relative scores         }     } } var_export($all); echo "\n\n";  // generate $fscores $sub23_keys=array_flip(['ed']);  // store list of keys have lower score minimum foreach($all $i=>$a){     foreach($a $n=>$scores){         $fscores[$n]['score']=array_sum($scores);         $fscores[$n]['farray']=min($farray[$i][$n])>=7;  // check both ed , en scores >=7         $fscores[$n]['tarray']=min(array_intersect_key($tarray[$i][$n],$sub23_keys)) && min(array_diff_key($tarray[$i][$n],$sub23_keys))>=26;     } } var_export($fscores);

output:

// $all= array (   0 =>    array (     1 =>      array (       'ed' => 60,       'en' => 64,       'mt' => 44,       'mz' => 47,     ),   ),   1 =>    array (     2 =>      array (       'ed' => 43,       'en' => 50,       'mt' => 92,       'mz' => 90,     ),   ), )  //$fscores= array (   1 =>    array (     'score' => 215,     'farray' => true,     'tarray' => true,   ),   2 =>    array (     'score' => 275,     'farray' => false,     'tarray' => true,   ), )

Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more