在mysql中插入多维数组

Question

我尝试根据用户选择将预订摊位存储到数据库中，每个摊位有10个复选框，用户可以选择要预订哪一天的摊位。每个复选框在数据库中都有自己的字段，如果用户选择了展台A01, D1和D2，当按下保留键时，会在D1和D2中插入值。但我不知道如何得到选中的复选框值存储在数据库

我的展位界面https://i.stack.imgur.com/YB8wB.gif

我的表结构https://i.stack.imgur.com/Y6Ix7.gif

我的编码

<?php
session_start();
if ( !isset($_SESSION['AUTHORIZED_USERNAME']) || empty($_SESSION['AUTHORIZED_USERNAME']) )  {
header("location:index.php");
}else{
$user=$_SESSION['AUTHORIZED_USERNAME'];
}
include('db.php');
if($_REQUEST){
$id     = $_REQUEST['search_category_id'];
$query2 = mysql_query("SELECT filenameBig, filename, url FROM eventinfo where eventID ='$id'");
  $row = mysql_fetch_array($query2, MYSQL_ASSOC);
if($id == -1)
{ 
  echo "<style type='text/css'>#btn_submit{visibility:hidden}</style>";
}
else{

      /*echo "<a href='{$row['url']}'>Click me!</a>";*/
      echo "<p><br><img src='{$row['filename']}' alt='' /></p>";
      echo "<p></p>";
      echo "<p align='right'><a href='$row[filenameBig]' target='_blank'>Click to view large image</a></p>";
      echo "<hr size='1'>";
      echo "<div style='padding-left:4px;' align='left'><strong>Booths Listing</strong>";
      echo "<p></p>";


$query = "select boothAlias, totalDay from booths, eventinfo where booths.eventID=eventinfo.eventID && booths.eventID = ".$id."";
$_SESSION['EVENT_ID']=$id;
$result = mysql_query($query);
$result2= mysql_query($query);

echo "<table border='0' style='width:400px;table-layout:fixed' >";

$rows2 = mysql_fetch_array($result);
$Day=$rows2['totalDay'];
echo "<table>";
for ($day = 0; $day <= $Day; ++$day) {
 if($day==0){
    echo "<th>Booth</th>";
}else{
         echo "<th>D".$day."</th>";
    }
}
while($rows = mysql_fetch_array($result2)){
    $boothAlias=$rows['boothAlias'];
    $totalDay=$rows['totalDay'];

         echo "<tr><td>$boothAlias</td>";
             for ($day2 = 1; $day2 <= $totalDay; ++$day2) {
                 echo "<td><input name='day2[]' type='checkbox' value='$day2' /></td>";
             }
        echo "</tr>";
}
echo "</table>";
}
}
?>

Answer 1

我认为SET类型是一个很好的解决方案。

http://dev.mysql.com/doc/refman/5.0/en/set.html