<?php

       session_start();

       include("../common/config.php");

       include("../common/functions.php");

      if(empty($_SESSION["username"])) 

       {

         Header("Location: ../login/login.php");

        }            

​

       $cmd = $_REQUEST["cmd"];

       switch($cmd)

       {

          case "add": 

                if(empty($_REQUEST["id"]))

                {

                    //Data Insert

                    $stmt = $conn->prepare("INSERT INTO designation (DesignationName,grade_id,NoPost,desigslno,officerornot_id)

                                                             VALUES (?,?,?,?,?)"); 

                    $stmt->bind_param("siiii", $_REQUEST["DesignationName"],                                           

                                            $_REQUEST["grade_id"],

                                            englishnum($_REQUEST["NoPost"]),

                                            englishnum($_REQUEST["desigslno"]),

                                            $_REQUEST["officerornot_id"]

                                            );

                    $stmt->execute();

                    $stmt->close();

                }

                else

                {

                    //Data Update

                    $stmt = $conn->prepare("UPDATE designation SET 

                                                           DesignationName = ?, grade_id = ?,

                                                           NoPost = ?,  desigslno = ?,officerornot_id = ?    WHERE id = ?");

                    $stmt->bind_param("siiiii", $_REQUEST["DesignationName"],                                          

                                            $_REQUEST["grade_id"],

                                            englishnum($_REQUEST["NoPost"]),

                                            englishnum($_REQUEST["desigslno"]),

                                            $_REQUEST["officerornot_id"],

                                            $_REQUEST["id"]);