duandian4501 2018-01-03 06:32
浏览 37
已采纳

PHP不同的2个数组和使用条件进行比较

I have 2 arrays follow this:

Array A

Array
(
       [0] => Array
            (
                [TD_CODE] => 24203
                [CRS_NAME] => Adobe Photoshop CS6+CC            
            )

        [1] => Array
            (
                [TD_CODE] => 24202
                [CRS_NAME] => Advance Microsoft excel 2010/2007
            )

        [2] => Array
            (
                [TD_CODE] => 24197
                [CRS_NAME] => Beginning Auditor Tools and Techniques

            )
    );

And Array B

Array
(
    [0] => Array
        (
            [crs_id] => 1
            [crs_ia_id] => 2017-6495
            [crs_oracle_id] => 24653
            [crs_name] => Windows8          
            [crs_start_date] => 2017-08-07
            [crs_end_date] => 2017-08-11

        )

    [1] => Array
        (
            [crs_id] => 2
            [crs_ia_id] => 2017-5013
            [crs_oracle_id] => 24202
            [crs_name] => Advance Microsoft excel 2010/2007
            [crs_start_date] => 2017-02-08
            [crs_end_date] => 2017-02-09

        )

)

I want to make array A different array B. The condition is to use TD_CODE of the array A compared to crs_oracle_id of array b And and take it as array C.

So The results are as follows.

Array
(
       [0] => Array
            (
                [TD_CODE] => 24203
                [CRS_NAME] => Adobe Photoshop CS6+CC            
            )

      [1] => Array
            (
                [TD_CODE] => 24197
                [CRS_NAME] => Beginning Auditor Tools and Techniques

            )
    );

How should I do?

  • 写回答

3条回答 默认 最新

  • douchang8219 2018-01-03 06:42
    关注

    Get ids from second array which needs to be rejected, then add only those records which doesn't exists in this id array,

    $rejected_ids = array_column($b,'crs_oracle_id');
    $c = [];
    foreach($a as $v){
        if(!in_array($v['TD_CODE'], $rejected_ids)){
            $c[] = $v;
        }
    }
    
    print_r($c);
    

    array_column — Return the values from a single column in the input array

    Here is working demo

    EDIT

    Here is more optimized code,

    $c = array_filter($a, function($v,$k) use($rejected_ids){
        return !in_array($v['TD_CODE'], $rejected_ids);
    },ARRAY_FILTER_USE_BOTH);
    

    Here is working demo.

    array_filter — Filters elements of an array using a callback function

    ARRAY_FILTER_USE_BOTH - pass both value and key as arguments to callback instead of the value

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
  • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
  • ¥15 绘制多分类任务的roc曲线时只画出了一类的roc,其它的auc显示为nan
  • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
  • ¥20 腾讯企业邮箱邮件可以恢复么
  • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
  • ¥15 错误 LNK2001 无法解析的外部符号
  • ¥50 安装pyaudiokits失败
  • ¥15 计组这些题应该咋做呀
  • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?