2

I've simple array:

$array = array(1,5,7,9,3,0);

And collection from database:

$collection = DB::table('numbers')->pluck('number');

Collection {#194 ▼
      #items: array:12 [▼
        0 => "1"
        1 => "2"
        2 => "3"
        3 => "4"
        4 => "5"
        5 => "6"
      ]
    }

How I can diff this arrays in Laravel ? And how I can diff default array($array) another array in laravel:

$another_array = DB::select("SELECT number FROM numbers");

array:12 [▼
      0 => {#194 ▼
        +"number": "0"
      }
      1 => {#207 ▼
        +"number": "-1"
      }
      2 => {#209 ▼
        +"number": "1"
      }
      3 => {#206 ▼
        +"number": "-2"
      }
    ]
Andreas Hunter
  • 4,504
  • 11
  • 65
  • 125
  • 2
    Have you tried $collection = DB::table('numbers')->pluck('number')->toArray(); $diff = array_diff($collection, $array); – pseudoanime Oct 17 '17 at 15:35

1 Answers1

0

Try:

$collection = DB::table('numbers')->pluck('number')->toArray(); 
$diff = array_diff($collection, $array);
pseudoanime
  • 1,547
  • 12
  • 19