<?php
include 'include/config.php';
include 'include/commonfunctions.php';
if (!empty($_POST['add'])) {
$st_username = trim($_POST['st_username']);
$st_pass = trim($_POST['st_pass']);
$st_name = trim($_POST['st_name']);
$st_email = trim($_POST['st_email']);
$st_mobile = trim($_POST['st_mobile']);
$st_location = trim($_POST['st_location']);
if ($cn = ChkExists("dup_students", "st_username", $st_username, "err_student") == 0) {
$query = "INSERT INTO dup_students ( st_id, st_username, st_pass, st_email,\r\n\t\t\t\t\t\t\t\tst_name, st_location, st_created, st_mobile,\r\n\t\t\t\t\t\t\t\tst_status)\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\tVALUES \r\n\t\t\t\t\t\t\t\t('','{$st_username}','{$st_pass}','{$st_email}','{$st_name}',\r\n\t\t\t\t\t\t\t\t'{$st_location}', NOW(), '{$st_mobile}','active')";
$res = mysql_query($query);
if ($res) {
header("location:student_afterreg.php");
} else {
triggerMessage("err_student", "Error: Registration Failed!");
}
}
}
include 'header.php';
?>
<script type="text/javascript">
$.validator.setDefaults({
submitHandler: function() { this.submit(); }
});
$().ready(function() {
}
if (!empty($_POST['edit'])) {
$name = trim($_POST['name']);
$locationstatus = trim($_POST['locationstatus']);
$editid = trim($_POST['editid']);
$query = "update dup_location set\r\n\t\t\t\t\tname = '{$name}', locationstatus = '{$locationstatus}' where locationid = '{$editid}'";
$eres = mysql_query($query);
if (!empty($eres)) {
triggerMessage("admin_create_ind", "Account edited successfully!");
}
}
if (!empty($_POST['add'])) {
$name = trim($_POST['name']);
$locationstatus = trim($_POST['locationstatus']);
if (!empty($name)) {
if ($cn = ChkExists("dup_location", "name", $name, "admin_create_ind") == 0) {
$query = "INSERT INTO dup_location ( locationid, name, locationstatus)\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\tVALUES \r\n\t\t\t\t\t\t\t\t\t('','{$name}','{$locationstatus}')";
$res = mysql_query($query);
if (!empty($res)) {
triggerMessage("admin_create_ind", "Record Created Successfully!");
}
}
} else {
triggerMessage("admin_create_ind", "Please Enter name!");
}
}
if ($_GET['act'] == "edit") {
$editid = $_GET['id'];
$esql = mysql_query("select * from dup_location where locationid = '{$editid}' limit 1");
$eresult = mysql_fetch_array($esql);
}
}
if (!empty($_POST['edit'])) {
$industryname = trim($_POST['industryname']);
$industrystatus = trim($_POST['industrystatus']);
$editid = trim($_POST['editid']);
$query = "update dup_industry set\r\n\t\t\t\t\tindustryname = '{$industryname}', industrystatus = '{$industrystatus}' where industryid = '{$editid}'";
$eres = mysql_query($query);
if (!empty($eres)) {
triggerMessage("admin_create_ind", "Account edited successfully!");
}
}
if (!empty($_POST['add'])) {
$industryname = trim($_POST['industryname']);
$industrystatus = trim($_POST['industrystatus']);
if (!empty($industryname)) {
if ($cn = ChkExists("dup_industry", "industryname", $industryname, "admin_create_ind") == 0) {
$query = "INSERT INTO dup_industry ( industryid, industryname, industrystatus)\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\tVALUES \r\n\t\t\t\t\t\t\t\t\t('','{$industryname}','{$industrystatus}')";
$res = mysql_query($query);
if (!empty($res)) {
triggerMessage("admin_create_ind", "Created industry Successfully!");
}
}
} else {
triggerMessage("admin_create_ind", "Please Enter Industry name!");
}
}
if ($_GET['act'] == "edit") {
$editid = $_GET['id'];
$esql = mysql_query("select * from dup_industry where industryid = '{$editid}' limit 1");
$eresult = mysql_fetch_array($esql);
}
}
if (!empty($_POST['edit'])) {
$functionname = trim($_POST['functionname']);
$functionstatus = trim($_POST['functionstatus']);
$editid = trim($_POST['editid']);
$query = "update dup_functions set\r\n\t\t\t\t\tfunctionname = '{$functionname}', functionstatus = '{$functionstatus}' where functionid = '{$editid}'";
$eres = mysql_query($query);
if (!empty($eres)) {
triggerMessage("admin_create_ind", "Account edited successfully!");
}
}
if (!empty($_POST['add'])) {
$functionname = trim($_POST['functionname']);
$functionstatus = trim($_POST['functionstatus']);
if (!empty($functionname)) {
if ($cn = ChkExists("dup_functions", "functionname", $functionname, "admin_create_ind") == 0) {
$query = "INSERT INTO dup_functions ( functionid, functionname, functionstatus)\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\tVALUES \r\n\t\t\t\t\t\t\t\t\t('','{$functionname}','{$functionstatus}')";
$res = mysql_query($query);
if (!empty($res)) {
triggerMessage("admin_create_ind", "Created function Successfully!");
}
}
} else {
triggerMessage("admin_create_ind", "Please Enter function name!");
}
}
if ($_GET['act'] == "edit") {
$editid = $_GET['id'];
$esql = mysql_query("select * from dup_functions where functionid = '{$editid}' limit 1");
$eresult = mysql_fetch_array($esql);
}
}
if (!empty($_POST['edit'])) {
$salaryname = trim($_POST['salaryname']);
$salarystatus = trim($_POST['salarystatus']);
$editid = trim($_POST['editid']);
$query = "update dup_salary set\r\n\t\t\t\t\tsalaryname = '{$salaryname}', salarystatus = '{$salarystatus}' where salaryid = '{$editid}'";
$eres = mysql_query($query);
if (!empty($eres)) {
triggerMessage("admin_create_ind", "Account edited successfully!");
}
}
if (!empty($_POST['add'])) {
$salaryname = trim($_POST['salaryname']);
$salarystatus = trim($_POST['salarystatus']);
if (!empty($salaryname)) {
if ($cn = ChkExists("dup_salary", "salaryname", $salaryname, "admin_create_ind") == 0) {
$query = "INSERT INTO dup_salary ( salaryid, salaryname, salarystatus)\t\t\t\t\t\t\t \r\n\t\t\t\t\t\t\t\t\tVALUES \r\n\t\t\t\t\t\t\t\t\t('','{$salaryname}','{$salarystatus}')";
$res = mysql_query($query);
if (!empty($res)) {
triggerMessage("admin_create_ind", "Created salary Successfully!");
}
}
} else {
triggerMessage("admin_create_ind", "Please Enter salary description!");
}
}
if ($_GET['act'] == "edit") {
$editid = $_GET['id'];
$esql = mysql_query("select * from dup_salary where salaryid = '{$editid}' limit 1");
$eresult = mysql_fetch_array($esql);
}
