<?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); }