if(isset($_POST['add_course']))
  {
    $course_id = $_POST["course_id"];
    $course_name = $_POST["course_name"];

    $sql = "SELECT course_id, course_name FROM course WHERE course_id=:course_id OR course_name=:course_name";
    $query = $db_con -> prepare($sql);
    $query -> bindParam(':course_id',$course_id, PDO::PARAM_INT);
    $query -> bindParam(':course_name',$course_name);
    $query -> execute();
    $result=$query->fetch(PDO::FETCH_ASSOC);

    if($result>0){

      $msg='<div class="alert alert-danger" id="flash-msg">Data Already Have In Database. Try Again!</div>';

    }else {

      $sql2="INSERT INTO course(course_id,course_name) VALUES(:ci,:cn)";
      $query2 = $db_con->prepare($sql2);
      $query2->bindParam(':ci',$course_id,PDO::PARAM_INT);
      $query2->bindParam(':cn',$course_name);
      $executed = $query2->execute();

      if($executed)
      {
        $msg='<div class="alert alert-success" id="flash-msg">Data Inserted Successfully!</div>';
      }
      else
      {
        $msg='<div class="alert alert-danger" id="flash-msg">Sorry there was an error inserting your data. Please try again later</div>';
      }
    }
}