Blog

Insert Value from Checkbox in MySql Database in PHP

Posted by Satyapriya Nayak Blogs | PHP Mar 29, 2012
In this blog we will know how to Insert Value from Checkbox in MySql Database in PHP.

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

COMMENT USING
PREMIUM SPONSORS
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.