I am creating an ecommerce site and am trying to get a list of top selling products.
The following example shows an array of product ids from sales, and is outputting the top selling products in the form of 'product id' x 'number of sales'
<?php
$product_ids = [58,58,68,39,4,118,14,54,39,118,58];
$top_selling_products = "";
$product_sales = array_count_values($product_ids);
arsort($product_sales);
$i = 0;
foreach($product_sales as $sales){
$i++;
$product_id = array_search($sales,$product_sales);
$top_selling_products .= $product_id.' x '.$sales.'<br />';
if($i == 5){break;}
}
echo $top_selling_products;
?>
However, it's not exactly doing what I want, at present this is outputting the following:
58 x 3
118 x 2
118 x 2
54 x 1
54 x 1
Where it should be:
58 x 3
118 x 2
39 x 2
54 x 1
14 x 1
It is getting the last item in the array with the same index so when there are two or more products with the same amount of sales it is not picking them up.
What would be the best way to get all unique ids. Any help or assistance with this would be greatly appreciated.