Reply to thread

Message

<blockquote data-quote="Skythrust" data-source="post: 467717" data-attributes="member: 87030">Thanks [USER=9520]@Wess[/USER]!What is the best way to filter the JSON Array? On the internet they are talking about filter_array(), but it seems like that is not working for me. For example the Department to show only the persons which are in Dept 3, or the online state is true.[CODE=json]$jsonstringDept = '[&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;DeptId&quot;:1,&quot;DepartmentName&quot;:&quot;CEO&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;DeptId&quot;:2,&quot;DepartmentName&quot;:&quot;NASDAQ&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;DeptId&quot;:3,&quot;DepartmentName&quot;:&quot;Marvel Studios&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;DeptId&quot;:4,&quot;DepartmentName&quot;:&quot;Lucasfilm&quot;}&nbsp; &nbsp; &nbsp; &nbsp; ]';$jsonstringPerson = '[&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Henry&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;Walton&quot;,&quot;Online&quot;:true,&quot;DeptId&quot;:&quot;4&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Klaus&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;Mikaelson&quot;,&quot;Online&quot;:true,&quot;DeptId&quot;:&quot;2&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Kylo&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;Ren&quot;,&quot;Online&quot;:false,&quot;DeptId&quot;:&quot;4&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Stan&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;Lee&quot;,&quot;Online&quot;:false,&quot;DeptId&quot;:&quot;3&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Kevin&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;McNally&quot;,&quot;Online&quot;:false,&quot;DeptId&quot;:&quot;3&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Katherine&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;Pierce&quot;,&quot;Online&quot;:false,&quot;DeptId&quot;:&quot;2&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Clint&quot;,&quot;Middlename&quot;:&quot;&quot;,&quot;LastName&quot;:&quot;Barton&quot;,&quot;Online&quot;:true,&quot;DeptId&quot;:&quot;3&quot;},&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&quot;FrstName&quot;:&quot;Hope&quot;,&quot;Middlename&quot;:&quot;van&quot;,&quot;LastName&quot;:&quot;Dyne&quot;,&quot;Online&quot;:false,&quot;DeptId&quot;:&quot;3&quot;}&nbsp; &nbsp; &nbsp; &nbsp; ]';[/CODE]Full Code;[CODE=php]&lt;?php$i =0;echo &quot;&lt;table&gt;&lt;tr&gt;&quot;;foreach($data as $record){&nbsp; &nbsp; if ($record['APBArea'] == 2) { $APBAreadiv = 'TextOn'; $APBCheck = 'checked'; } else { $APBAreadiv = 'TextOff'; $APBCheck = 'unchecked'; }&nbsp; &nbsp; if ($record['Pin'] == 1) { $BHVDiv = 'fas fa-user-plus'; $BHVValue = ' (BHV)'; } else { $BHVDiv = 'fas fa-user'; $BHVValue = ''; }&nbsp; &nbsp; $i++;&nbsp; &nbsp; echo &quot;&lt;td&gt;&lt;div class=&quot;.$APBAreadiv.&quot;&gt;&lt;i class='&quot;.$BHVDiv.&quot;'&gt;&lt;/i&gt;&quot;&nbsp; &nbsp; &nbsp; &nbsp; .' '.$record['FrstName'] .' '. $record['MiddleName'] .' '. $record['LastName']. $BHVValue;&nbsp; &nbsp; echo '&lt;label class=&quot;switch&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;input type=&quot;checkbox&quot;'.$APBCheck.'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;span class=&quot;slider round&quot;&gt;&lt;/span&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/label&gt;&nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &lt;/td&gt;';&nbsp; &nbsp; $i++;&nbsp; &nbsp; if ($i % 5 == 0) { echo '&lt;/tr&gt;&lt;tr&gt;'; }}&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; echo '&lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; }?&gt;&nbsp; &nbsp; &nbsp; &nbsp; [/CODE]</blockquote>

[QUOTE="Skythrust, post: 467717, member: 87030"] Thanks [USER=9520]@Wess[/USER]! What is the best way to filter the JSON Array? On the internet they are talking about filter_array(), but it seems like that is not working for me. For example the Department to show only the persons which are in Dept 3, or the online state is true. [CODE=json]$jsonstringDept = '[ {"DeptId":1,"DepartmentName":"CEO"}, {"DeptId":2,"DepartmentName":"NASDAQ"}, {"DeptId":3,"DepartmentName":"Marvel Studios"}, {"DeptId":4,"DepartmentName":"Lucasfilm"} ]'; $jsonstringPerson = '[ {"FrstName":"Henry","Middlename":"","LastName":"Walton","Online":true,"DeptId":"4"}, {"FrstName":"Klaus","Middlename":"","LastName":"Mikaelson","Online":true,"DeptId":"2"}, {"FrstName":"Kylo","Middlename":"","LastName":"Ren","Online":false,"DeptId":"4"}, {"FrstName":"Stan","Middlename":"","LastName":"Lee","Online":false,"DeptId":"3"}, {"FrstName":"Kevin","Middlename":"","LastName":"McNally","Online":false,"DeptId":"3"}, {"FrstName":"Katherine","Middlename":"","LastName":"Pierce","Online":false,"DeptId":"2"}, {"FrstName":"Clint","Middlename":"","LastName":"Barton","Online":true,"DeptId":"3"}, {"FrstName":"Hope","Middlename":"van","LastName":"Dyne","Online":false,"DeptId":"3"} ]'; [/CODE] Full Code; [CODE=php]<?php $i =0; echo "<table><tr>"; foreach($data as $record) { if ($record['APBArea'] == 2) { $APBAreadiv = 'TextOn'; $APBCheck = 'checked'; } else { $APBAreadiv = 'TextOff'; $APBCheck = 'unchecked'; } if ($record['Pin'] == 1) { $BHVDiv = 'fas fa-user-plus'; $BHVValue = ' (BHV)'; } else { $BHVDiv = 'fas fa-user'; $BHVValue = ''; } $i++; echo "<td><div class=".$APBAreadiv.">" .' '.$record['FrstName'] .' '. $record['MiddleName'] .' '. $record['LastName']. $BHVValue; echo '<label class="switch"> <input type="checkbox"'.$APBCheck.'> </label> </div> </td>'; $i++; if ($i % 5 == 0) { echo '</tr><tr>'; } } echo '</table>'; } ?> [/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members