AHMAD ASJAD – احمد اسجد

Sometime you’d stuck like that you’ll need all other rows coming with left join as a duplicate row for all record, where you would need to have all these inside an array variable. For example if you have an tbl_emp and another tbl_contact, in tbl_contact you would have one foreign key emp_id.

You made a query to fetch all employee record with their contact nos, when you left join the query such like LEFT JOIN tbl_contact ON tbl_contact.emp_id=tbl_emp.emp_id, you will get record in associative array something like this.

array (size=3)
  0 => 
    array (size=3)
      'name' => string 'test1' (length=5)
      'age' => int 23
      'email' => string 'Good' (length=4)
  1 => 
    array (size=3)
      'name' => string 'test2' (length=5)
      'age' => int 24
      'email' => string 'Good' (length=4)
  2 => 
    array (size=3)
      'name' => string 'test2' (length=5)
      'age' => int 24
      'email' => string 'Best' (length=4)

 Here you are getting two record for test2 employee, because this employee has two email as a contact.

So, to simplify this you will need to have all contact nos inside a single variable key and the duplicate record to be removed, then here is the logic to do that.

Code Block

<?php
$total_size=sizeof($arr);
for($i=0;$i<$total_size;$i++){
	$arr[$i]['emails']=array();
	$arr[$i]['emails'][]=$arr[$i]['email'];
	$unset=0;
	foreach($arr[$i] as $key=>$value){
		if($key=='name' && $arr[$i]['name']==$arr[$i+1]['name']){
			$arr[$i]['emails'][]=$arr[$i+1]['email'];
			$unset=1;
		}
	}
	unset($arr[$i]['email']);
	if($unset==1){
		unset($arr[$i+1]);
		$i++;
	}
}
var_dump($arr);
?>

Now you’ll get the result something like that

array (size=2)
  0 => 
    array (size=3)
      'name' => string 'test1' (length=5)
      'age' => int 23
      'emails' => 
        array (size=1)
          0 => string 'Good' (length=4)
  1 => 
    array (size=3)
      'name' => string 'test2' (length=5)
      'age' => int 24
      'emails' => 
        array (size=2)
          0 => string 'Good' (length=4)
          1 => string 'Best' (length=4)