PHP Insert Multidimensional Array into mysql

Question

i try to store the booking booths into database based on user selection, there are 10 check boxes for each booths and user can choose which day they want to reserve booths. For each check box has it own field in database, if user choose booth A01, D1 and D2, when he press reserve button, it will insert value into D1 and D2. But I dont know how to get the checked checkbox value to store in database

my booth interface https://i.sstatic.net/YB8wB.gif

my table structure https://i.sstatic.net/Y6Ix7.gif

My coding

<?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>";
}
}
?>

Yeah well that thread says it all. Look at foreach() loops which allow you to loop through your array and then you can deal with it as you wish. — DarkMantis
– DarkMantis, Commented Oct 21, 2011 at 8:50
Please fix those SQL injection hols, see: stackoverflow.com/questions/332365/… — Johan
– Johan, Commented Oct 21, 2011 at 12:11
possible duplicate of array in MySQL, How to store an array into mysql? — outis
– outis, Commented Oct 23, 2011 at 11:54

grongor · Accepted Answer · 2011-10-23 07:58:14Z

0

I think that SET type would be good solution for this.

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

answered Oct 23, 2011 at 7:58

grongor

1,3751 gold badge13 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP Insert Multidimensional Array into mysql

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related