<?php
if($_GET['icon']){
	$sql = "select * from icon where icon='$_GET[icon]';";
	$result = mysqli_query($conn,$sql);
	while($data=mysqli_fetch_array($result)){
		echo "<div><span class=\"$data[pattern] fa-$_GET[icon] fa-5x\"></span><br><span class=\"$data[pattern] fa-$_GET[icon] fa-5x\"></span></div>";
	}
}else{
?>
<div style="line-height: 60px;">
<?php
$sql = "select * from icon;";
$result = mysqli_query($conn,$sql);
while($data=mysqli_fetch_array($result)){
	$icons[$data['icon']][$data['pattern']]=1;
}
echo "<table border=1>";
echo "<tr><td>Icon name</td><td>fab</td><td>fas</td><td>far</td></tr>";
foreach($icons as $icon => $pattern){
	echo "<tr>";
	echo "<td><a href=\"?icon=$icon\">$icon</a></td>";
	echo "<td>".($pattern['fab']?"<span class=\"fab fa-$icon fa-2x\"></span>":"")."</td>";
	echo "<td>".($pattern['fas']?"<span class=\"fas fa-$icon fa-2x\"></span>":"")."</td>";
	echo "<td>".($pattern['far']?"<span class=\"far fa-$icon fa-2x\"></span>":"")."</td>";
	echo "</tr>";
}
echo "</table>";
?>
</div>
<?php }?>