Home >>MySQL Tutorial >How to update Radio button, Checkbox and dropdown

How to update Radio button, Checkbox and dropdown

In this tutorial You can Learn How to save data in Mysql , display the information from MySQL, and most important How to update radio button, Checkbox and dropdown list in PHP and MySQL.

How to update radio button value PHP MySQL.

How to update checkbox value in PHP MySQL.

How to update dropdown list value in PHP MySQL.

Database Configuration

<?php 
error_reporting(1);

//connectivity
$con=mysql_connect("localhost","root","") or die(mysql_error());

//db selection
mysql_select_db("demo",$con);
?>

Registration Form

<script type="text/javascript">
function deletes(id)
{
     if(confirm('Sure To Remove This Record ?'))
     {
        window.location.href='delete.php?id='+id;
     }
	 
}
</script>	
<style>
table{margin-top:10;border:1px solid gray}
td{padding:5px}
</style>

<?php 
include('config.php');

extract($_POST);
if(isset($save))
{
//check user already exists
$que=mysql_query("select email from student where email='$e'");
//return the records
$row=mysql_num_rows($que);
if($row)
{
echo "<font color='red'>This email id is  alredy exists</font>";
}
else
{
//hobbies
$hob=implode(",",$arr);

mysql_query("insert into student values('','$n','$e','$m','$gen','$hob','$cou',now())");

echo "<font color='blue'>Records saved</font>";
}
}


	echo "<table border='1'>";
	echo "<Tr><th>Stu_Id</th><th>Name</th>
<th>Email</th><th>Mobile</th>
<th>Gender</th><th>Hobbies</th>
<th>Country</th><th>Reg_Date</th>
<th>Delete</th><th>Update</th></tr>";
	
	
	$que = mysql_query("select *  from student");
	while($obj=mysql_fetch_object($que))
	{
	echo "<Tr>";
	echo "<td>".$obj->id."</td>";
	echo "<td>".$obj->name."</td>";	
	echo "<td>".$obj->email."</td>";
	echo "<td>".$obj->mob."</td>";
	echo "<td>".$obj->gender."</td>";
	echo "<td>".$obj->hobbies."</td>";
	echo "<td>".$obj->country."</td>";
	
	echo "<td>".$obj->regDate."</td>";
	//confirm before deletion
	?>
	<Td><a href="javascript:deletes(<?php echo $obj->id; ?>)">Delete</a></Td>
	<?php 
	echo "<Td><a href='update.php?eid=$obj->email'>Update</a>  </td>";	
	
	echo "</tr>";
	}
	echo "</table>";


?>
<html>
	<head>
		<title>Registration Form</title>
	

	</head>
	<body>
		<form method="post" enctype="multipart/form-data">
			<table border="0" style="">
				<Tr>
					<th>Enter Your  name</th>
					<Td><input type="text" name="n"/></td>
				</tr>
				<Tr>
					<th>Enter Your  Email</th>
					<Td><input type="email" name="e"/></td>
				</tr>
				<Tr>
					<th>Enter Your  Mobile</th>
					<Td><input  type="number" name="m"/></td>
				</tr>
				<Tr>
					<th>Select Your gender</th>
					<Td>
					Male<input value="m"  type="radio" name="gen"/>
					Female<input type="radio" name="gen" value="f"/>
					</td>
				</tr>
				<Tr>
					<th>Choose Your hobbies</th>
					<Td>
					Reading<input  type="checkbox" name="arr[]" value="reading"/>
					Singing<input type="checkbox" name="arr[]" value="singing"/>
					Playing<input type="checkbox" name="arr[]" value="playing"/>
					
					</td>
				</tr>
				<Tr>
					<th>Select Your Country</th>
					<Td>
					<select name="cou">
						<option value="">Select Country</option>
						<option>India</option>
						<option>Pakistan</option>
						<option>China</option>
						<option>United State</option>
					</select>
					</td>
				</tr>
				
				<Tr>
					<Td colspan="2" align="center">
					<input type="submit" name="save" value="Save"/>
					</td>
				</tr>
			</table>
		</form>
	</body>
</html>

Update

<?php 
include('config.php');

$que=mysql_query("select * from student where email='".$_GET['eid']."'");
$res=mysql_fetch_array($que);

extract($_POST);
if(isset($update))
{
//hobbies
$hob=implode(",",$arr);
	
	mysql_query("update student set name='$n',mob='$m',gender='$gen',hobbies='$hob',country='$cou' where email='".$_GET['eid']."'");
	header('location:registration.php');
	
}


?>

<html>
	<head>
		<title>Registration Form</title>
		<style>
table{margin-top:10;border:1px solid gray}
td{padding:5px}
</style>
	</head>
	<body>
		<form method="post" enctype="multipart/form-data">
			<table border="0">
				<Tr>
					<th>Enter Your  name</th>
					<Td><input type="text" name="n" value="<?php echo $res['name'];?>"/></td>
				</tr>
				<Tr>
					<th>Enter Your  Email</th>
					<Td><input type="email" name="e" readonly="readonly" value="<?php echo $res['email'];?>"/></td>
				</tr>
				<Tr>
					<th>Enter Your  Mobile</th>
					<Td><input  type="number" name="m" value="<?php echo $res['mob'];?>"/></td>
				</tr>
				<Tr>
					<th>Select Your gender</th>
					<Td>
					
					Male<input value="m"  type="radio" name="gen"  <?php if($res['gender']=="m"){echo "checked";}?>/>
					Female<input <?php if($res['gender']=="f"){echo "checked";}?> type="radio" name="gen" value="f"/>
					</td>
				</tr>
				<Tr>
					<th>Choose Your hobbies</th>
					<Td>
					<?php 
					$chkbox=$res['hobbies'];
					$arr=explode(",",$chkbox);
					
					?>
					Reading<input <?php if(in_array("reading",$arr)){echo "checked";}?> type="checkbox" name="arr[]" value="reading"/>
					Singing<input <?php if(in_array("singing",$arr)){echo "checked";}?>  type="checkbox" name="arr[]" value="singing"/>
					Playing<input <?php if(in_array("playing",$arr)){echo "checked";}?> type="checkbox" name="arr[]" value="playing"/>
					
					
					</td>
				</tr>
				<Tr>
					<th>Select Your Country</th>
					<Td>
					<select name="cou">
						<option value="">Select Country</option>
						<option <?php if($res['country']=="India"){echo "selected";}?>>India</option>
						<option <?php if($res['country']=="Pakistan"){echo "selected";}?>>Pakistan</option>
						<option <?php if($res['country']=="China"){echo "selected";}?>>China</option>
						<option <?php if($res['country']=="United State"){echo "selected";}?>>United State</option>
					</select>
					</td>
				</tr>
				
				<Tr>
					<Td colspan="2" align="center">
					<input type="submit" name="update" value="Update"/>

					</td>
				</tr>
			</table>
		</form>
	</body>
</html>

Delete

<?php 

include('config.php');

$id=$_GET['id'];

mysql_query("delete from student where id='$id'");

header('location:registraion.php');

?>

Download

« Previous Next »

MySQL Tutorial SQL Introduction MySQL Constraints MySQL Common Queries PHP MySQL Connectivity PHP Mysqli Database Connectivity PHP MySQL Create Database PHP Create MySQLi Database PHP MySQL Insert PHP MySQL Update PHP MySQL Delete PHP MySQL Select Mysqli Fetch Array Mysqli Fetch Assoc Mysqli fetch row Mysqli fetch object MySQL Where Clause MySQL Order By Select Insert Update Delete in Php How to create foreign key MySQL auto increment PHP MySQL Secure Registration Page PHP MySQL Secure Login Page MySQL Predefined Function MySQL Joins How to Export MySQL to CSV How to import csv into mysql How to edit radio button in PHP MySQL PHP MySQL Pagination Upload and Display Video in PHP Building a bar chart How to update Radio button, Checkbox and dropdown Create Registration form PHP MySQL How to insert data from textarea to database PHP PHP PDO

No Sidebar ads