PHP array_intersect or in_array then MYSQL

Question

Need to find if two arrays match, and then where they match pull data from the mysql row in which they match. Should I use

 $sql = "SELECT * FROM around";
 $resultsd = $conn->query($sql);
 foreach($resultsd as $rowd) {}

 if (array_intersect($ar1, $ar2)) {
    $sword[] = $rowd['TIM'];
    }

or should I use

 if (in_array($ar1, $ar2)) {
       $sword[] = $rowd['TIM'];
   }

Getting the arrays like:

   $ar1[] = $rowd['nim']; 
   $ar2[] = $rowd['nim']; 

Then how does one go about pulling the specific row that they match at?

I am seeing that they match, and printing out the array's okay:

Array ( [0] => dcbabcbded ) Array ( [0] => fafeafaebee [1] => afabfdefcbb [2] => dcbabcbded

But when I trying a echo the mysql data where they match I fail:

 Array ( )  

Answer 1

i would go with sql IN clause.

You have an array of customer names: $a = array('john','rob','paul');

implode array $nms = join(',',$a);

Make sql: 'SELECT * FROM tabl WHERE name IN ('.$nms.')';

---

do the array intersection first (or what you just have to..) to have an array of needed names.

Answer 2

use $new = array_intersect(Array ( [0] => dcbabcbded ), Array ( [0] => fafeafaebee [1] => afabfdefcbb [2] => dcbabcbded)) : then make valid sql as stated in my answer above.

If u are sure you've allways have array intersenct with one or none values, then make sql just with first array element: $ar[0] using sql WHERE clause.