Insert Value from Checkbox in Database(MySql) in PHP

Hi Vineet,


Try this...


Table structure

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 29, 2012 at 05:17 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `employee`
--





config.php


/* Database Connection */

 $sDbHost = 'localhost';
 $sDbName = 'test';
 $sDbUser = 'root';
 $sDbPwd  = '';

$dbConn = mysql_connect ($sDbHost, $sDbUser, $sDbPwd) or die ('MySQL connect failed. ' . mysql_error());
mysql_select_db($sDbName,$dbConn) or die('Cannot select database. ' . mysql_error());

?>



form.php

Raj

Ravi

Rahul

Rajesh

checkbox.php


include("config.php");
$checkbox1 = $_POST['chk1'];
if($_POST["Submit"]=="Submit")
{
for ($i=0; $i$query="INSERT INTO employee (name) VALUES ('".$checkbox1[$i]."')";
mysql_query($query) or die(mysql_error());
}
echo "Record is inserted";
}
?>



Thanks
If this post helps you mark it as answer