Как лучше реализовать большую таблицу? Массивом или по другому?

$size = array("xs", "s", "m", "l", "xl", "xxl");
$index = array("blu", "bl", "g", "gr", "w", "y", "p", "r", "fl", "bg");
$image = array("bl", "blk", "g", "gr", "w", "y", "pn", "r", "fl", "be");
 
echo "<table style=\"font-size:11px\" border=\"1px\" bordercolor=\"#FFFFFF\">";
 
echo "<tr>";
 
echo "<td class=\"head_tb\">размер</td>";
 
for($i = 0; $i < count($image); $i++)
{
    echo "<td class=\"head_tb\"><img src=\"../admin/imge/color_".$image[$i].".png\" /></td>";
}
 
echo "</tr>";
 
echo "<form action=\"action.php\" method=\"post\">";
 
for($i = 0; $i < count($size); $i++)
{
    echo "<tr>";
 
    echo "<td class=\"size_tb\">".strtoupper($size[$i])."</td>";
 
    for($j = 0; $j < count($index); $j++)
    {
        echo "<td class=\"size_tb\"><input name=\"".$size[$i]."_".$index[$j]."\" class=\"input\" type=\"text\" value=\"0\"></td>";
    }
    
    echo "</tr>";
}
 
echo "<tr>";
echo "<td><input name=\"submit\" type=\"submit\" value=\"OK\"></input></td>";
echo "</tr>";
 
echo "</form>";
 
echo "</table>";

$size = array("xs", "s", "m", "l", "xl", "xxl");
$index = array("blu", "bl", "g", "gr", "w", "y", "p", "r", "fl", "bg", "bl", "blk", "g", "gr", "w", "y", "pn", "r", "fl", "be");

mysql_query("CREATE TABLE IF NOT EXISTS `sizes` (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name varchar(5))");
mysql_query("INSERT INTO `sizes` (name) VALUES ('xs'), ('s'), ('m'), ('l'), ('xl'), ('xxl')");
mysql_query("CREATE TABLE IF NOT EXISTS `colors` (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), name varchar(5))");
mysql_query("INSERT INTO `colors` (name) VALUES ('blu'), ('bl'), ('g'), ('gr'), ('w'), ('y'), ('r'), ('fl'), ('bg')");
mysql_query("CREATE TABLE IF NOT EXISTS `products` (model varchar(255), description TEXT, added BIGINT)");
mysql_query("CREATE TABLE IF NOT EXISTS `products_amount` (model varchar(255), size INT, color INT, amount INT)");

if(isset($_POST["submit"]) && $_POST["submit"] == "OK")
{
    $arr = $_POST;
    $model = $arr["modelname"];
 
    unset($arr["submit"]);
    unset($arr["modelname"]);
 
    $sizesinsert = array();
 
    $ressizes = mysql_query("SELECT * FROM sizes ORDER BY id");
 
    if(mysql_num_rows($ressizes) > 0)
    {
        while($rowsizes = mysql_fetch_array($ressizes, MYSQL_ASSOC))
        {
            $sizesinsert[$rowsizes[$name]] = $rowsizes["id"];
        }
    }
                                      
    $colorsinsert = array();
 
    $rescolors = mysql_query("SELECT * FROM colors ORDER BY id");
 
    if(mysql_num_rows($rescolors) > 0)
    {
        while($rowcolors = mysql_fetch_array($rescolors, MYSQL_ASSOC))
        {
            $colorsinsert[$rowcolors["name"]] = $rowcolors["id"];
        }
    }
 
    $query = "INSERT INTO `products_amount` (model, size, color, amount) VALUES ";
 
    $insertarr = array();
 
    foreach($arr as $key=>$value)
    {
        $index = explode("_", $key);
 
        if(count($index) == 2 && !empty($sizesinsert[$index[0]]) && !empty($colorsinsert[$index[1]]))
        {
            $insertarr[] = "('".mysql_real_escape_string($model)."', '".$sizesinsert[$index[0]]."', '".$colorsinsert[$index[0]]."', '".mysql_real_escape_string($value)."')";
        }
    }
 
    if(!empty($insertarr))
    {
        $query = $query.implode(",", $insertarr);
 
        mysql_query("INSERT INTO products (model, description, added) VALUES ('".mysql_real_escape_string($model)."', '', '".time()."')");
        mysql_query($query);
    }
}
 
 
$sizes = array();
 
$ressizes = mysql_query("SELECT id, name FROM sizes ORDER BY id");
 
if(mysql_num_rows($ressizes) > 0)
{
    while($rowsizes = mysql_fetch_array($ressizes, MYSQL_ASSOC))
    {
        $sizes[$rowsizes["id"]] = $rowsizes["name"];
    }
}
                                      
$colors = array();
 
$rescolors = mysql_query("SELECT id, name FROM colors ORDER BY id");
 
if(mysql_num_rows($rescolors) > 0)
{
    while($rowcolors = mysql_fetch_array($rescolors, MYSQL_ASSOC))
    {
        $colors[$rowcolors["id"]] = $rowcolors["name"];
    }
}
 
//пример с добавлением одного наименования
echo "<form action=\"action.php\" method=\"post\">";
 
echo "Наименование: <input type=\"text\" name=\"modelname\" value=\"\" />";
 
 
echo "<table style=\"font-size:11px\" border=\"1px\" bordercolor=\"#FFFFFF\">";
 
echo "<tr>";
 
echo "<td class=\"head_tb\">размер</td>";
 
foreach($colors as $c)
{
    echo "<td class=\"head_tb\"><img src=\"../admin/imge/color_".$c.".png\" /></td>";
}
 
echo "</tr>";
 
foreach($sizes as $s)
{
    echo "<tr>";
 
    echo "<td class=\"size_tb\">".strtoupper($s)."</td>";
 
    foreach($colors as $c)
    {
        echo "<td class=\"size_tb\"><input name=\"".$s."_".$c."\" class=\"input\" type=\"text\" value=\"0\"></td>";
    }
    
    echo "</tr>";
}
 
echo "<tr>";
echo "<td><input name=\"submit\" type=\"submit\" value=\"OK\"></input></td>";
echo "</tr>";
 
echo "</form>";
 
echo "</table>";
 
 
$resproducts = mysql_query("SELECT * FROM products ORDER BY added DESC");
 
if(mysql_num_rows($resproducts) > 0)
{
    while($rowproducts = mysql_fetch_array($resproducts, MYSQL_ASSOC))
    {
        echo "<hr />";
 
        echo "Наименование: ".$rowproducts["model"]."<br />";
 
        $resproductsamounts = mysql_query("SELECT * FROM products_amount WHERE model='".$rowproducts["model"]."' ORDER BY size ASC, color ASC");
 
        if(mysql_num_rows($resproductsamounts) > 0)
        {
            $tablecolorsarr = array(); 
            $values = array();
 
            while($rowproductsamounts = mysql_fetch_array($resproductsamounts, MYSQL_ASSOC))
            {
                $tablecolorsarr[] = $rowproductsamounts["color"];
 
                if(empty($values[$rowproductsamounts["size"]]))
                {
                    $values[$rowproductsamounts["size"]] = array();
                }
 
                $values[$rowproductsamounts["size"]][$rowproductsamounts["size"]] = $rowproductsamounts["amount"];
            }
 
            $tablecolors = array_unique($tablecolorsarr);
 
            echo "<table style=\"font-size:11px\" border=\"1px\" bordercolor=\"#FFFFFF\">";
            echo "<tr>";
 
            echo "<td class=\"head_tb\">размер</td>";
 
            foreach($tablecolors as $c)
            {
                echo "<td class=\"head_tb\"><img src=\"../admin/imge/color_".$colors[$c].".png\" /></td>";
            }
 
            echo "</tr>";
 
            foreach($values as $key=>$productscolors)
            {
                echo "<tr>";
 
                echo "<td class=\"size_tb\">".strtoupper($key)."</td>";
 
                foreach($productscolors as $c)
                {
                    echo "<td class=\"size_tb\">".$c."</td>";
                }
            
                echo "</tr>";
            }
 
            echo "</table>";
        }
    }
}

<?php
 
session_start();
 
include_once'bd.php';
 
if(isset($_GET['id']))
{
$id_cat = $_GET['id_cat'];
 echo $id_mod = $_GET['id'];
 $customer = session_id();
 $quantity = 1;
 $datatime = time();
 $sql_add_basket = "INSERT INTO basket (customer, id_mod, quantity, datatime) VALUES ('$customer', $id_mod, $quantity, $datatime)";
 
 $query_add_basket = mysql_query($sql_add_basket) or die (mysql_error());
 
$redicet = $_SERVER['HTTP_REFERER'];
@header ("Location: $redicet");
 
}

$color ["bl"] = array (
 
"xs" => $xs,
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);
 
$color ["w"] = array (
 
"xs" => '5',
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);
 
$color ["y"] = array (
 
"xs" => '4',
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);

if(isset($_GET['id']))
{
    //здесь возможно будет получение информации о продукте по поводу наличия размеров и цветов и последующего исключения их их выбора
 
    $sizes = array();
 
    $ressizes = mysql_query("SELECT name FROM sizes ORDER BY id");
 
    if(mysql_num_rows($ressizes) > 0)
    {
        while($rowsizes = mysql_fetch_array($ressizes, MYSQL_ASSOC))
        {
            $sizes[] = $rowsizes["name"];
        }
    }
                                      
    $colors = array();
 
    $rescolors = mysql_query("SELECT name FROM colors ORDER BY id");
 
    if(mysql_num_rows($rescolors) > 0)
    {
        while($rowcolors = mysql_fetch_array($rescolors, MYSQL_ASSOC))
        {
            $colors[] = $rowcolors["name"];
        }
    }
 
    //пример с добавлением одного наименования
    echo "<form action=\"action.php\" method=\"post\">";
 
    //здесь id модели, который был получен по гету
    echo "<input type=\"hidden\" name=\"model\" value=\"".$_GET["id"]."\">";
 
    echo "<table style=\"font-size:11px\" border=\"1px\" bordercolor=\"#FFFFFF\">";
 
    echo "<tr>";
 
    echo "<td class=\"head_tb\">размер</td>";
 
    foreach($colors as $c)
    {
        echo "<td class=\"head_tb\"><img src=\"../admin/imge/color_".$c.".png\" /></td>";
    }
 
    echo "</tr>";
 
    foreach($sizes as $s)
    {
        echo "<tr>";
 
        echo "<td class=\"size_tb\">".strtoupper($s)."</td>";
 
        foreach($colors as $c)
        {
            echo "<td class=\"size_tb\"><input name=\"".$s."_".$c."\" class=\"input\" type=\"text\" value=\"0\"></td>";
        }
    
        echo "</tr>";
    }
 
    echo "<tr>";
    echo "<td><input name=\"submit\" type=\"submit\" value=\"OK\"></input></td>";
    echo "</tr>";
 
    echo "</form>";
 
    echo "</table>";
}

//обработчик формы при нажатии ОК
session_start();
include_once'bd.php';
 
if(isset($_POST["submit"]) && $_POST["submit"] == "OK")
{
    $arr = $_POST;
    $model = $arr["model"];
 
    $id_mod = $arr["model"];
    $customer = session_id();
    $datatime = time();
 
    unset($arr["submit"]);
    unset($arr["model"]);
 
    $sizesinsert = array();
 
    $ressizes = mysql_query("SELECT * FROM sizes ORDER BY id");
 
    if(mysql_num_rows($ressizes) > 0)
    {
        while($rowsizes = mysql_fetch_array($ressizes, MYSQL_ASSOC))
        {
            $sizesinsert[$rowsizes[$name]] = $rowsizes["id"];
        }
    }
                                      
    $colorsinsert = array();
 
    $rescolors = mysql_query("SELECT * FROM colors ORDER BY id");
 
    if(mysql_num_rows($rescolors) > 0)
    {
        while($rowcolors = mysql_fetch_array($rescolors, MYSQL_ASSOC))
        {
            $colorsinsert[$rowcolors["name"]] = $rowcolors["id"];
        }
    }
 
    $query = "INSERT INTO basket (customer, id_mod, size, color, quantity, datatime) VALUES ";
 
    $insertarr = array();
 
    foreach($arr as $key=>$value)
    {
        $index = explode("_", $key);
 
        if(count($index) == 2 && !empty($sizesinsert[$index[0]]) && !empty($colorsinsert[$index[1]]))
        {
            $insertarr[] = "('".$customer."', '".mysql_real_escape_string($id_mod)."', '".$sizesinsert[$index[0]]."', '".$colorsinsert[$index[1]]."', '".mysql_real_escape_string($value)."', '".$datatime."')";
        }
    }
 
    if(!empty($insertarr))
    {
        $query = $query.implode(",", $insertarr);
        mysql_query($query);
    }
 
    //не уверен, что это тут еще нужно, может быть редирект будет другой, уже не на добавление в корзину, а список продуктов в корзине или что-то подобное
    $redicet = $_SERVER['HTTP_REFERER'];
    @header ("Location: $redicet");
}

$xs = 110;
 
$bl = array (
 
"xs" => $xs,
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);

$w = array (
 
"xs" => $xs,
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);

$xs = 110;
 
$color ['$bl'] = array (
 
"xs" => $xs,
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);

$color ['$w'] = array (
 
"xs" => $xs,
"s" => ' 1 ',
"m" => ' 15 ',
"l" => ' 20 ',
 
);

echo "<input type=\"hidden\" name=\"model\" value=\"".$_GET["id"]."\">";

unset($arr["submit"]);
unset($arr["model"]);

$sizes = array();
 
$ressizes = mysql_query("SELECT id, name FROM sizes ORDER BY id");
 
if(mysql_num_rows($ressizes) > 0)
{
    while($rowsizes = mysql_fetch_array($ressizes, MYSQL_ASSOC))
    {
        $sizes[$rowsizes["id"]] = $rowsizes["name"];
    }
}
                                      
$colors = array();
 
$rescolors = mysql_query("SELECT id, name FROM colors ORDER BY id");
 
if(mysql_num_rows($rescolors) > 0)
{
    while($rowcolors = mysql_fetch_array($rescolors, MYSQL_ASSOC))
    {
        $colors[$rowcolors["id"]] = $rowcolors["name"];
    }
}
 
$res = mysql_query("SELECT * FROM basket WHERE customer='21434fdsfds5' AND id_mod='1' ORDER BY size ASC, color ASC");
 
if(mysql_num_rows($res) > 0)
{
    echo "Модель: 1<br />";
 
    $tablecolorsarr = array(); 
    $values = array();
 
    while($row = mysql_fetch_array($res, MYSQL_ASSOC))
    {
        $tablecolorsarr[] = $row["color"];
 
        if(empty($values[$sizes[$row["size"]]]))
        {
            $values[$sizes[$row["size"]]] = array();
        }
 
        $values[$sizes[$row["size"]]][$colors[$row["color"]]] = $row["quantity"];
    }
 
    $tablecolors = array_unique($tablecolorsarr);
 
    echo "<table style=\"font-size:11px\" border=\"1px\" bordercolor=\"#FFFFFF\">";
    echo "<tr>";
 
    echo "<td class=\"head_tb\">размер</td>";
 
    foreach($tablecolors as $c)
    {
        echo "<td class=\"head_tb\"><img src=\"../admin/imge/color_".$colors[$c].".png\" /></td>";
    }
 
    echo "</tr>";
 
    foreach($values as $key=>$productscolors)
    {
        echo "<tr>";
 
        echo "<td class=\"size_tb\">".strtoupper($key)."</td>";
 
        foreach($productscolors as $c)
        {
            echo "<td class=\"size_tb\">".$c."</td>";
        }
            
        echo "</tr>";
    }
 
    echo "</table>";
}