Cách update Radio button, Checkbox và dropdown

0
4

Cách cập nhật nút Radio, Hộp kiểm và menu thả xuống

Trong hướng dẫn này, Bạn có thể Tìm hiểu Cách lưu dữ liệu trong Mysql, hiển thị thông tin từ MySQL và quan trọng nhất là Cách cập nhật nút radio, Hộp kiểm và danh sách thả xuống trong PHP và MySQL.

  1. Cách cập nhật giá trị nút radio PHP MySQL.
  2. Cách cập nhật giá trị hộp kiểm trong PHP MySQL.
  3. Cách cập nhật giá trị danh sách thả xuống trong PHP MySQL.

Cấu hình cơ sở dữ liệu

<?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');

?>

BÌNH LUẬN

Vui lòng nhập bình luận của bạn
Vui lòng nhập tên của bạn ở đây