Insert Value from Checkbox in MySql Database in PHP

By Satyapriya Nayak Mar 29, 2012
In this blog we will know how to Insert Value from Checkbox in MySql Database in PHP.
Download Files: Insert Value from Ch

In this blog we will know how to Insert Value from Checkbox in MySql Database in PHP.

 

 

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

 

<?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

 

<html>

<head>

<title> PHP Form</title>

</head>

<body>

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

<input type="checkbox" name="chk1[]" value="Raj">Raj<br />

<input type="checkbox" name="chk1[]" value="Ravi">Ravi<br />

<input type="checkbox" name="chk1[]" value="Rahul">Rahul<br />

<input type="checkbox" name="chk1[]" value="Rajesh">Rajesh<br />

<br>

<br>

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

</form>

</body>

</html>

 

checkbox.php

 

<?php

include("config.php");

$checkbox1 = $_POST['chk1'];

if($_POST["Submit"]=="Submit")

{

for ($i=0; $i<sizeof($checkbox1);$i++) {

$query="INSERT INTO employee (name) VALUES ('".$checkbox1[$i]."')";

mysql_query($query) or die(mysql_error());

}

echo "Record is inserted";

}

?>

 

 

Thanks for reading

Satyapriya Nayak

Satyapriya Nayak is a software developer from Bhubaneswar, India. He holds a Bachelor's degree in Electronics and telecommunication and is an active member of C# Corner. 

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs