asked on

how can i insert multiple check box values into my single database field ? using php and mysql

<html>
<body>
<table>

<form name="registration" method="post" action="registration.php5">
<table align="center" class="style1">
<tr>
<td class="style2">
Email</td>
<td class="style2">
:</td>
<td>
<input id="Text1" type="text" name="email" /></td>
</tr>
<tr>
<td class="style2">
Name</td>
<td class="style2">
:</td>
<td>
<input id="Text2" type="text" name="name" /></td>
</tr>
<tr>
<td class="style2">
Department</td>
<td class="style2">
:</td>
<td>
<input id="Text3" type="text" name="department" /></td>
</tr>
<tr>
<td class="style2">
Office Phone</td>
<td class="style2">
:</td>
<td>
<input id="Text4" type="text" name="phone"/></td>
</tr>
<tr>
<td class="style2">
Alternate Phone</td>
<td class="style2">
:</td>
<td>
<input id="Text5" type="text" name="altphone"/></td>
</tr>
<tr>
<td class="style2">
 </td>
<td class="style2">
 </td>
<td>
 </td>
</tr>
<tr>
<td class="style2">
 </td>
<td class="style2">
 </td>
<td>
<input id="submit" type="submit" value="Submit" /></td>
</tr>

</table>

<br />
<table align="center" class="style3">
<tr>
<td class="style4">
May 12th 11:30am</td>
<td class="style5">

<input type="checkbox" name="media[]" value="winba" /></td>
<td class="style6"><a href="http://www.spsu.edu/asc/knowledgebase/workshops/index.html#8">Advanced Digital Campus Leadership Institute </a></td>

<td>
H-312</td>
</tr>
<tr>
<td class="style4">
June 12th 10:30am</td>
<td class="style5">
<input type="checkbox" name="media[]" value="vista8" /></td>
<td class="style6">
<a href="http://www.spsu.edu/asc/knowledgebase/workshops/index.html#8">Orientation to GeorgiaVIEW Vista 8 </a></td>
<td>
H-321</td>
</tr>
</table>
</form>
</td>
<td rowspan="5"> </td>
</tr>

<tr>
<td bgcolor="#000000" class="subnav"> </td>
</tr>
<tr>
<td bgcolor="#000000" class="subnav"> </td>
</tr>


</table>
</body>
</html>

<?PHP
 
//Database Information
 
$dbhost = "localhost";
$dbname = "spsu";
$dbuser = "root";
$dbpass = "";
 
//Connect to database
 
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname) or die(mysql_error());
           $result = mysql_query($query);          
    
$email = $_POST['email'];
$name = $_POST['name'];    
$department = $_POST['department'];
$phone = $_POST['phone'];
$altphone = $_POST['altphone'];
$workshop= $_POST['workshop'] ;
 
                      
 
 
          $media_array = $_POST['media'];
 
 
            mysql_select_db("registration");
             
              
 
foreach ($media_array as $one_media) 
$source .= $one_media.", ";
 
 $media = substr($source, 0, -2);
 
 
$query = "INSERT INTO registration (email,name,department,phone,altphone,media)
VALUES('$email','$name','$department','$phone','$altphone','$media')";
 
                        $result = mysql_query($query);       
 
 
mysql_query($query) or die(mysql_error());
mysql_close();
 
echo "You have successfully Registered";
?>

Open in new window

ASKER CERTIFIED SOLUTION

webwyzsystems

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

siddharthkool

ASKER

thanks it worked...