Insert Value from Checkbox in Database(MySql) in PHP

Question

Hi........ I want to know, how to insert value from many checkbox in database (mysql) from front end (HTML form) in PHP ? Please explain with example ? Thanks.....

Satyapriya Nayak · Answer

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 PHP Form 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

Vineet Kumar Saini · Answer

Thanks Nayak Ji.

Insert Value from Checkbox in Database(MySql) in PHP

Answers (2)