<?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 payscal (PayscalName,nopayscale_id,grade_id) VALUES (?,?,?)"); 

                    $stmt->bind_param("sii", englishnum($_REQUEST["PayscalName"]),

                                            $_REQUEST["nopayscale_id"],

                                            $_REQUEST["grade_id"]

                                            );

                    $stmt->execute();

                    $stmt->close();

                }

                else

                {

                    //Data Update

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

                                                           PayscalName = ?, nopayscale_id = ?, grade_id = ?      WHERE id = ?");

                    $stmt->bind_param("siii", englishnum($_REQUEST["PayscalName"]),

                                            $_REQUEST["nopayscale_id"],

                                            $_REQUEST["grade_id"],

                                            $_REQUEST["id"]);

                    $stmt->execute();

                    $stmt->close();

                }

                Header("Location: ../payscal/payscal.php?cmd=list");                   

                break;