fork(7) download
copy 
  1. <?php
  2. $tableRows[0]=array("id"=>1,"id_city_a"=>1,"id_city_b"=>1,"distance"=>0);
  3. $tableRows[1]=array("id"=>2,"id_city_a"=>1,"id_city_b"=>2,"distance"=>8);
  4. $tableRows[2]=array("id"=>3,"id_city_a"=>1,"id_city_b"=>3,"distance"=>6);
  5. $tableRows[3]=array("id"=>4,"id_city_a"=>2,"id_city_b"=>1,"distance"=>8);
  6. $tableRows[4]=array("id"=>5,"id_city_a"=>2,"id_city_b"=>2,"distance"=>0);
  7. $tableRows[5]=array("id"=>6,"id_city_a"=>2,"id_city_b"=>3,"distance"=>9);
  8. $tableRows[6]=array("id"=>7,"id_city_a"=>3,"id_city_b"=>1,"distance"=>6);
  9. $tableRows[7]=array("id"=>8,"id_city_a"=>3,"id_city_b"=>2,"distance"=>9);
  10. $tableRows[8]=array("id"=>9,"id_city_a"=>3,"id_city_b"=>3,"distance"=>0);
  11.  
  12. $counter=0;
  13. $result=array();
  14. foreach($tableRows as $tableRow)
  15. {
  16. 	$result[$tableRow["id_city_a"]][$tableRow["id_city_b"]]=array("id_city_a"=>$tableRow["id_city_a"],"id_city_b"=>$tableRow["id_city_b"],"distance"=>$tableRow["distance"] );
  17. }
  18.  
  19. $unique_id_city_a = array_unique(array_map(function ($i) { return $i['id_city_a']; }, $tableRows));
  20. echo "\t";
  21. foreach($unique_id_city_a as $R)
  22. {
  23. 	echo $R."\t";
  24. }
  25. echo "\n";
  26. $unique_id_city_b = array_unique(array_map(function ($i) { return $i['id_city_b']; }, $tableRows));
  27.  
  28.  
  29. foreach($result as $R1)
  30. {		
  31. 	echo $unique_id_city_b[$counter++]."\t";
  32. 	foreach($R1 as $R2)
  33. 	{
  34. 		echo $R2["distance"]."\t";
  35. 	}
  36. 	echo "\n";
  37. }
Success #stdin #stdout 0.02s 24448KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
	1	2	3	
1	0	8	6	
2	8	0	9	
3	6	9	0
https://ideone.com/zQdNoZ
language:
PHP (php 7.3.5)
created:
10 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!