course_Entry.php~

<?php
$id="";
$opr="";
$msg = "";
$iid = "";
if(isset($_GET['opr']))
	$opr=$_GET['opr'];

if(isset($_GET['rs_id']))
	$id=$_GET['rs_id'];

if(isset($_GET['usr_id']))
	$iid=$_GET['usr_id'];


//--------------add data-----------------	
if(isset($_POST['btn_sub'])){
	$name=$_POST['course_name']; 
	$cid=$_POST['course_id'];
	$department=$_POST['dept'];
	$credits=$_POST['cred'];
	$mod=$_POST['modular'];
	$pre=$_POST['prereq']; 	

$sql_ins=mysqli_query($con,"INSERT INTO master_course_list 
						VALUES('$name' ,'$cid','$department','$credits','$mod','$pre')");

if($sql_ins==true)
	$msg="1 Row Inserted";
else
	$msg="Insert Error:".mysqli_error($con);
	
}
//------------------uodate data----------
if(isset($_POST['btn_upd'])){
	$name=$_POST['course_name']; 
	$cid=$_POST['course_id'];
	$department=$_POST['dept'];
	$credits=$_POST['cred'];
	$mod=$_POST['modular'];
	$pre=$_POST['prereq']; 	

	echo $id;
	$del_sql=mysqli_query($con,"DELETE FROM master_course_list WHERE course_id='$id'");	
	$sql_ins=mysqli_query($con,"INSERT INTO master_course_list 
						VALUES('$name' ,'$cid','$department','$credits','$mod','$pre')");


	if($sql_ins=='true')
		echo "<div style='background-color: white;padding: 20px;border: 1px solid black;margin-bottom: 25px;''>"
                . "<span class='p_font'>"
                . "Record Updated Successfully... !"
                . "</span>"
                . "</div>";
	else
		$msg="Update Failed...!";
	}

echo $msg
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/style_entry.css" />
</head>
<body>
<?php

if($opr=="upd")
{
	$sql_upd=mysqli_query($con,"SELECT * FROM master_course_list WHERE course_id = '$id' ");
	$rs_upd=mysqli_fetch_array($sql_upd);

?>

<!-- for form Upadte-->

<div class="panel panel-default">
  		<div class="panel-heading"><h1><span class="glyphicon glyphicon-user"></span> Student Entry Form</h1></div>
  			<div class="panel-body">
			<div class="container">
				<p style="text-align:center;">Here, you'll update ac course's detail to record into database.</p>
			</div>


<div class="container_form">
    <form method="post">

				<div class="teacher_name_pos">
					<input type="text" name="course_name" class="form-control" value="<?php echo $rs_upd['course_name'];?>" />

				</div><br>
				
				<div class="teacher_id_pos">
					<input type="text" name="course_id" class="form-control" value="<?php echo $rs_upd['course_id'];?>" />

				</div><br>
		     	
				<div class="teacher_Department_pos">
					<input type="text" name="dept" class="form-control" value="<?php echo $rs_upd['department'];?>" />
				</div><br>
				
				<div class="teacher_credits_pos">
					<input type="text" name="cred" class="form-control" value="<?php echo $rs_upd['credits'];?>" />
				</div><br>
				
				<div class="teacher_radio_pos">
					<input type="radio" name="modular" value="Y" <?php if($rs_upd['modular']=="Y") echo "checked";?> /> <span class="p_font">&nbsp;Modular</span>
					<input type="radio" name="modular" value="N" <?php if($rs_upd['modular']=="N") echo "checked";?> /> <span class="p_font">&nbsp;Not Modular</span>
				</div><br>
				
				<div class="teacher_pre-req_pos">
					<input type="text" name="prereq" class="form-control" value="<?php echo $rs_upd['prereq'];?>" />
				</div><br>
				
				
				<div class="teacher_btn_pos">
					<input type="submit" name="btn_upd" href="#" class="btn btn-primary btn-large" value="Update" />&nbsp;&nbsp;&nbsp;
					<input type="reset"  href="#" class="btn btn-primary btn-large" value="Cancel" />
				</div>
                                    </form>
			</div>
		</div>
	</div><!-- end of style_informatios -->

<?php	
}
else
{
?>
<!-- for form Register-->
	
<div class="panel panel-default">
  		<div class="panel-heading"><h1><span class="glyphicon glyphicon-user"></span> Course Entry Form</h1></div>
  			<div class="panel-body">
			<div class="container">
				<p style="text-align:center;">Here, you'll add a new course's detail into the Master Course List.</p>
			</div>

<div class="container_form">
    <form method="post">
				<div class="teacher_name_pos">
					<input type="text" name="course_name" class="form-control" placeholder="Enter Course Name" />

				</div><br>
				
				<div class="teacher_name_pos">
					<input type="text" name="course_id" class="form-control" placeholder="Enter Course Number" />

				</div><br>
		     	
				<div class="teacher_bdayPlace_pos">
					<div class="select_style">
					<select name="dept" class="form-control">
					<option value="CSE"> CSE </option>
					<option value="EE"> EE </option>
					<option value="ME">ME </option>
					<option value="MTH"> MTH </option>
					<option value="CE"> CE </option>
					<option value="CHE"> CHE </option>
					<option value="CHM"> CHM </option>
					<option value="ECO"> ECO </option>
					<option value="BSBE"> BSBE </option>
					<option value="MSE"> MSE </option>
					<option value="AE"> AE </option>
				</select>
				</div><br>
				
				<div class="teacher_name_pos">
					<input type="text" name="cred" class="form-control" placeholder="credits" />
				</div><br>
				
				<div class="teacher_name_pos"  >
					<input type="radio" name="modular" value="Y"  /> <span class="p_font">&nbsp;Modular</span>
					<input type="radio" name="modular" value="N" /> <span class="p_font">&nbsp;Not-Modular</span>
				</div><br>
				
				<div class="teacher_name_pos">
					<input type="text" name="prereq" class="form-control" placeholder="prerequisites" />
				</div><br>
							
				<div class="teacher_btn_pos">
					<input type="submit" name="btn_sub" href="#" class="btn btn-primary btn-large" value="Register" />&nbsp;&nbsp;&nbsp;
					<input type="reset"  href="#" class="btn btn-primary btn-large" value="Cancel" />
				</div>
                                    </form>
			</div>
		</div>
	</div>
<?php
}
?>
</body>
</html>