<?php

require_once './queries.php';
$roleId = filter_input(INPUT_POST, "roleId");
$roledesc= filter_input(INPUT_POST, "roledesc");
$addname = filter_input(INPUT_POST, "addname");
$addrole = filter_input(INPUT_POST, "addrole");
$deletename = filter_input(INPUT_POST, "deletename");
$deleterole = filter_input(INPUT_POST, "deleterole");
$switch = filter_input(INPUT_POST, "switch");

switch ($switch) {
case 'add':
            echo Queries::addRole($roleId, $roledesc);
            break;

}
?>

public static function addRole($njmsroledesc, $njmsroleId) {
       $dbUser = "";
       $dbPass = "";
        $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=))(CONNECT_DATA=(SID=)))";
        $conn = oci_connect($dbUser, $dbPass, $dbConn);
        $sql = oci_parse($conn, "INSERT INTO ROLE (roleId, roledesc) VALUES (:roleid, :roledesc)");
        oci_bind_by_name($sql,':roleId', $roleId);
        oci_bind_by_name($sql,':roledesc', $roledesc);
        oci_execute($sql);

    }