Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Insert Checkbox Values to MySQL Using PHP
05-19-2009, 07:10 PM
Post: #1
Insert Checkbox Values to MySQL Using PHP
PHP Code:
<?
if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form
?>
<html>
<head>
<title>Personal INFO</title>
</head>
<body>
<form method="post" action="<?php echo $PHP_SELF;?>">
<input type="checkbox" name="media[]" value="Poster" />Poster<br />
<input type="checkbox" name="media[]" value="Website" />Website<br />
<input type="checkbox" name="media[]" value="Magazine" />Magazine<br />
<input type="submit" value="submit" name="submit">
</form>
<?
} else {
mysql_connect("localhost""mysql_user""mysql_password") or
die(
"Could not connect: " mysql_error());
mysql_select_db("mydb");
$media_array $_POST['media'];
foreach (
$media_array as $one_media) {
$source .= $one_media.", ";
}
$media substr($source0, -2);

$query "INSERT INTO mydb (media_type)
VALUES( '$media')"
;
$result mysql_query($query);
}
?>
</body>
</html> 

My Main Site
My Forum
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump: