Multiple-Checkbox

<
HTML________FORM

<body>

<form action="chk.php" method="post">

Which buildings do you want access to?<br />
<input type="text" name="id">
<input type="checkbox" name="media[]" value="internet"/>Internet<br />  
<input type="checkbox" name="media[]" value="friends" />Friends<br />
<input type="checkbox" name="media[]" value="paper" />News paper<br />
<input type="checkbox" name="media[]" value="google" />Google<br />


<input type="submit" name="formSubmit" value="Submit" />

</form>


</body>
</html>

PHP__


<?php
  $con = mysql_connect("localhost","root","Spider1");
  if(!$con)
  {
      die('Could not connect' . mysql_error());
  }                                         mysql_select_db('cric',$con);
           //$_POST['formDoor'] = "HELLO";
              // $aDoor = $_POST['formDoor'];
              
                $internet = "internet";
                $google = "google";
                $paper = "paper";
                 $friends = "friends";
              
        
$media_array = $_POST['media'];
foreach ($media_array as $one_media) {
$source .= $one_media.", ";
}
$media = substr($source, 0, -2);

$query = "INSERT INTO spidy (Firstname)
VALUES( '$media')";
$result = mysql_query($query);

        
 MySQL
Date: 2011-07-31 07:25:45
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `spidy`
-- ----------------------------
DROP TABLE IF EXISTS `spidy`;
CREATE TABLE `spidy` (
  `PersonID` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `FirstName` text,
  PRIMARY KEY (`PersonID`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of spidy
-- ----------------------------
INSERT INTO `spidy` VALUES ('00000000031', 'saab');
INSERT INTO `spidy` VALUES ('00000000032', 'audi');
INSERT INTO `spidy` VALUES ('00000000033', 'fiat');
INSERT INTO `spidy` VALUES ('00000000034', 'volvo');
INSERT INTO `spidy` VALUES ('00000000035', 'internet');
INSERT INTO `spidy` VALUES ('00000000036', 'internet, friends');
INSERT INTO `spidy` VALUES ('00000000037', 'saab');
INSERT INTO `spidy` VALUES ('00000000038', 'saab');
INSERT INTO `spidy` VALUES ('00000000039', 'friends, paper');
INSERT INTO `spidy` VALUES ('00000000040', 'internet, friends, paper, google');
      
        
      
            
?>
>