Server : Apache
System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64
User : apache ( 48)
PHP Version : 8.0.28
Disable Function : NONE
Directory : /var/www/html/venkat/repo-oct-2017/
|
Server : Apache System : Linux profile 3.10.0-1160.88.1.el7.x86_64 #1 SMP Tue Mar 7 15:41:52 UTC 2023 x86_64 User : apache ( 48) PHP Version : 8.0.28 Disable Function : NONE Directory : /var/www/html/venkat/repo-oct-2017/ |
<?php
include ("hmain.php");
ini_set('display_errors',1);
ini_set('display_startup_errors',1);
error_reporting(-1);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$year1 = date('Y');
$decision = $_POST['decision'];
$dept = $_SESSION['dept'];
$user = $_SESSION['username'];
if ($decision == "award") {
$award = htmlspecialchars($_POST['award']);
$issuer = htmlspecialchars($_POST['issue']);
$title = htmlspecialchars($_POST['title']);
$year = htmlspecialchars($_POST['year']);
$month = htmlspecialchars($_POST['month']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($awardee.$award.$issuer.$title.$year);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($awardee) && !empty($award)) {
$stmt = $link->prepare("INSERT INTO award (award, issuer, title, year, dept, user, date, year1, month) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($award, $issuer, $title, $year1, $dept, $user, $date, $year, $month));
if ($title == "Nil") {
$title = "";
}
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo $awardee. "<br>";
echo $award . "<br>";
echo $issuer. "<br>";
echo $title." ".$year . "<br>";
echo "</td> </tr> </table>";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill the mandatory fields </center> </b>";
}
}
}
else if ($decision == "foreign") {
$country = htmlspecialchars($_POST['country']);
$institute = htmlspecialchars($_POST['institute']);
$period = htmlspecialchars($_POST['period']);
$year = htmlspecialchars($_POST['year']);
$sponsor = htmlspecialchars($_POST['sponsor']);
$month = htmlspecialchars($_POST['month']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($faculty.$country.$institute.$period.$year.$sponsor);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($country) && !empty($institute)) {
$stmt = $link->prepare("INSERT INTO foreign_visit (country, institute, year, period, sponsor, user, dept, date, year1, month) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($faculty, $country, $institute, $year1, $period, $sponsor, $user, $dept, $date, $year, $month));
if ($sponsor == "Nil") {
$sponsor = "";
}
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo $faculty. "<br>";
echo $country . "<br>";
echo $institute. "<br>";
echo $period." ".$year . "<br>";
echo $sponsor . "<br>";
echo "</td> </tr> </table>";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill the mandatory fields </center> </b>";
}
}
}
else if ($decision == "talk") {
$month = htmlspecialchars($_POST['month']);
$date1 = htmlspecialchars($_POST['date']);
$period = htmlspecialchars($_POST['period']);
$organizer = htmlspecialchars($_POST['organizer']);
$event = htmlspecialchars($_POST['event']);
$title = htmlspecialchars($_POST['title']);
$type = htmlspecialchars($_POST['type']);
$level = htmlspecialchars($_POST['level']);
$attend = htmlspecialchars($_POST['attend']);
$year = htmlspecialchars($_POST['year']);
$institute = htmlspecialchars($_POST['institute']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($organizer.$event.$title.$type.$level.$attend.$year);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($organizer)) {
$stmt = $link->prepare("INSERT INTO talk (organizer, event, title, type, level, participate, year, user, dept, date, year1, month, date1, institute, period) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($organizer, $event, $title, $type, $level, $attend, $year1, $user, $dept, $date, $year, $month, $date1,$institute, $period));
if ($title == "Nil") {
$title = "NA";
}
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo $organizer . "<br>";
echo $event. "<br>";
echo $title."<br>";
echo $level." ".$type . "<br>";
echo $attend." ".$year . "<br>";
echo "</td> </tr> </table>";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill the mandatory fields </center> </b>";
}
}
}
else if ($decision == "project") {
$investi = htmlspecialchars($_POST['investi']);
$coinvest = htmlspecialchars($_POST['coinvest']);
$agency = htmlspecialchars($_POST['agency']);
$title = htmlspecialchars($_POST['title']);
$status = htmlspecialchars($_POST['status']);
$year = htmlspecialchars($_POST['year']);
$month = htmlspecialchars($_POST['month']);
$cost = htmlspecialchars($_POST['cost']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($investi.$coinvest.$agency.$title.$status.$year.$cost);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($investi) && !empty($title) && !empty($agency)) {
$stmt = $link->prepare("INSERT INTO project (principal, coinvest, sponsor, title, status, year, cost, user, dept, date,year1,month) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($investi, $coinvest, $agency, $title, $status, $year1, $cost, $user, $dept, $date, $year, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo $investi. "<br>";
echo $coinvest . "<br>";
echo $agency. "<br>";
echo $title."<br>";
echo $status."<br>";
echo $cost."<br>";
echo $year."<br>";
echo "</td> </tr> </table>";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill the mandatory fields </center> </b>";
}
}
}
else if ($decision == "organize") {
$organizer = htmlspecialchars($_POST['organizer']);
$name = htmlspecialchars($_POST['name']);
$username = htmlspecialchars($_POST['username']);
$type = htmlspecialchars($_POST['type']);
$level = htmlspecialchars($_POST['level']);
$year = htmlspecialchars($_POST['year']);
$period = htmlspecialchars($_POST['period']);
$sponsor = htmlspecialchars($_POST['sponsor']);
$month = htmlspecialchars($_POST['month']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($organizer.$name.$type.$level.$period.$year.$sponsor);
$i = 0;
if ($username != "Nil" || $username != "") {
$split = explode(',', $username);
}
else {
$split[$i] = $user;
}
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
$i = 0;
if(!empty($month) && !empty($organizer) && !empty($name) && !empty($period)) {
while ($i < count($split)) {
$stmt = $link->prepare("INSERT INTO organize (organizer, event, type, level, year1, period, sponsor, user, dept, date, year, month) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($organizer, $name, $type, $level, $year, $period, $sponsor, $split[$i], $dept, $date, $year1, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
$i++;
echo "<b> Uploaded Details </b> <br>";
echo $organizer. "<br>";
echo $name . "<br>";
echo $level. " ".$type. "<br>";
echo $period."<br>";
echo $year."<br>";
echo $sponsor."<br>";
echo "</td> </tr> </table>";
$_SESSION['LastRequest'] = $signature;
}
}
else {
echo " <b> <center> Please fill the mandatory fields </center> </b>";
}
}
}
else if ($decision == "publication") {
$author = htmlspecialchars($_POST['author']);
$title = htmlspecialchars($_POST['title']);
$journal = htmlspecialchars($_POST['journal']);
$publisher = htmlspecialchars($_POST['publisher']);
$year = htmlspecialchars($_POST['year']);
$volume = htmlspecialchars($_POST['volume']);
$type = htmlspecialchars($_POST['type']);
$level = htmlspecialchars($_POST['level']);
$username = htmlspecialchars($_POST['username']);
$page = htmlspecialchars($_POST['page']);
$place = htmlspecialchars($_POST['place']);
$month = htmlspecialchars($_POST['month']);
$paper = htmlspecialchars($_POST['paper_no']);
$cauthor = htmlspecialchars($_POST['cauthor']);
$major = htmlspecialchars($_POST['major']);
$full = htmlspecialchars($_POST['full']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($author.$title.$journal.$publisher.$volume.$year.$type.$level);
$i = 0;
if ($username != "Nil") {
$split = explode(',', $username);
}
else {
$split[$i] = $s;
}
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
$i = 0;
if(!empty($cauthor) || !empty($author) || !empty($title) || !empty($journal)) {
while ($i < count($split)) {
$stmt = $link->prepare("INSERT INTO publication (author, title, name, publisher, volume, year, type, level, user, dept, date, year1, cauthor, place, page_no, paper_no, month, major, full ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($author, $title, $journal, $publisher, $volume, $year1, $type, $level, $split[$i], $dept, $date, $year, $cauthor, $place, $page, $paper, $month, $major, $full));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo $split[$i]."<br>";
echo $author."<br>";
echo $title ."<br>";
echo $journal."<br>";
echo $publisher."<br>";
echo $volume." ".$year."<br>";
echo $level." ".$type."<br>";
echo $cauthor."<br>";
echo "</td> </tr> </table>";
$_SESSION['LastRequest'] = $signature;
$i++;
}
}
else {
echo " <b> <center> Please fill the mandatory fields </center> </b>";
}
}
}
else if ($decision == "personalinformation") {
$designation = htmlspecialchars($_POST['designation']);
$teaching = htmlspecialchars($_POST['teaching']);
$industry = htmlspecialchars($_POST['industry']);
$total = htmlspecialchars($_POST['total']);
$impactfactor = htmlspecialchars($_POST['impactfactor']);
date_default_timezone_set('Asia/calcutta');
$date = date('Y-m-d H:i:s');
$signature = md5($designation.$teaching.$industry.$impactfactor);
/*$epsilon = 0.00001;
$teachcomp = floor($teaching);
$induscomp = floor($industry);
$total = $teachcomp + $induscomp;
$teachfrac = $teaching - $teachcomp;
$indusfrac = $industry - $induscomp;
$teachf = $teachfrac * 10;
if (($teachf - floor($teachf)) > $epsilon) {
$teachf = $teachf * 10;
}
$indusf = $indusfrac * 10;
if ($indusf - floor($indusf) > $epsilon) {
$indusf = $indusf * 10;
}
$tot = $teachf + $indusf;
$fractot = round((int)$tot/12);
$fracfloor = floor($fractot);
$fracf = round($tot) % 12;
$total1 = $total + $fracfloor;
$kkk = 0;
while ($fracf >= 1) {
$kkk = $kkk + 1 ;
$fracf = $fracf / 10;
}
if ($industry != 0 && $teaching != 0) {
$total = $total1 + $fracf;
}
else {
$total = $teaching + $industry;
}
if($kkk == 2) {
$total = number_format($total,2);
}*/
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($designation) && !empty($total) && !empty($impactfactor)) {
$stmt = $link->prepare("INSERT INTO personalinfo (designation, teaching, industry, total, impactfactor, username, dept, date) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($designation, $teaching, $industry, $total, $impactfactor, $user, $dept, $date));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Designation : " . $designation."<br>";
echo "Teaching/Research Experience : " . $teaching ."<br>";
echo "Industry Experience : ". $industry."<br>";
echo "Total Experience : ". $total."<br>";
echo "Impact Factor : ". $impactfactor."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
if($_FILES["file"]["name"]){
$uploadfile1 = $_FILES["file"]["name"];
$uploadfile1 = str_replace(" ", "_", $uploadfile1);
}
$type1= substr($uploadfile1, strrpos($uploadfile1, '.')+1);
$uploaddir = "photo/".$user.".".$type1;
if($type1 == "png"){
if (move_uploaded_file($_FILES["file"]["tmp_name"],$uploaddir)){
}
else {
echo "Error in uploading Photo";
}
}
echo "<br> <img src = '".$uploaddir."'>";
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "software") {
$name = htmlspecialchars($_POST['name']);
$signature = md5($name);
$month = htmlspecialchars($_POST['month']);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name)) {
$stmt = $link->prepare("INSERT INTO software (name, user, year, date, dept, month) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Name of the Software : " . $name."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "technology") {
$name = htmlspecialchars($_POST['name']);
$month = htmlspecialchars($_POST['month']);
$signature = md5($name);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name)) {
$stmt = $link->prepare("INSERT INTO technology (name, user, year, date, dept, month) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Name of the Technology : " . $name."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "course") {
$name = htmlspecialchars($_POST['name']);
$code = htmlspecialchars($_POST['code']);
$month = htmlspecialchars($_POST['month']);
$signature = md5($name.$code);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name) || !empty($code)) {
$stmt = $link->prepare("INSERT INTO course (name,code, user, year, date, dept, month) VALUES (?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $code, $user, $year1, $date, $dept, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Course Code : " . $code."<br>";
echo "Name of the Course : " . $name."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "industry") {
$name = htmlspecialchars($_POST['name']);
$from = htmlspecialchars($_POST['start_from']);
$month = htmlspecialchars($_POST['month']);
$end = htmlspecialchars($_POST['end']);
$purpose = htmlspecialchars($_POST['purpose']);
$signature = md5($name.$from.$end.$purpose);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name) || !empty($from) || !empty($purpose)) {
$stmt = $link->prepare("INSERT INTO industry (name, user, year, date, dept, start_from, end, purpose, month)VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $from, $end, $purpose, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Name of the Industry/Institute : " . $name."<br>";
echo "Start From : " . $from."<br>";
echo "End : " . $end."<br>";
echo "Purpose : " . $purpose."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "continuing") {
$name = htmlspecialchars($_POST['name']);
$from = htmlspecialchars($_POST['start_from']);
$end = htmlspecialchars($_POST['end']);
$place = htmlspecialchars($_POST['place']);
$month = htmlspecialchars($_POST['month']);
$type = htmlspecialchars($_POST['type']);
$profile = htmlspecialchars($_POST['profile']);
$signature = md5($name.$from.$end.$profile.$type);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name) || !empty($from) || !empty($profile) || !empty($place) || !empty($type)) {
$stmt = $link->prepare("INSERT INTO continuing (name, user, year, date, dept, start_from, end, place, profile, type, month) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $from, $end, $place, $profile, $type, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Name of the Industry/Institute : " . $name."<br>";
echo "Start From : " . $from."<br>";
echo "End : " . $end."<br>";
echo "Profile : " . $profile."<br>";
echo "Place : " . $place."<br>";
echo "Type : " . $type."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "participation") {
$name = htmlspecialchars($_POST['name']);
$from = htmlspecialchars($_POST['start_from']);
$end = htmlspecialchars($_POST['end']);
$month = htmlspecialchars($_POST['month']);
$signature = md5($name.$from.$end);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name) || !empty($from)) {
$stmt = $link->prepare("INSERT INTO participation (name, user, year, date, dept, start_from, end, month) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $from, $end, $month));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Name of the Organization : " . $name."<br>";
echo "Start From : " . $from."<br>";
echo "End : " . $end."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "any") {
$name = htmlspecialchars($_POST['any']);
$month = htmlspecialchars($_POST['month']);
$signature = md5($name);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($name)) {
$stmt = $link->prepare("INSERT INTO any (any, user, year, date, dept, month) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $month));
echo "<table width = '60%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Details : " . $name."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
else if ($decision == "patent") {
$name = htmlspecialchars($_POST['title']);
$year = htmlspecialchars($_POST['year1']);
$granting = htmlspecialchars($_POST['granting']);
$patent = htmlspecialchars($_POST['patent']);
$signature = md5($name.$year.$granting.$patent);
if ($_SESSION['LastRequest'] == $signature) {
echo '<b> <center> This is a refresh. </center> </b>';
}
else {
if(!empty($month) && !empty($title) || !empty($year) || !empty($granting) || !empty($patent)) {
$stmt = $link->prepare("INSERT INTO patent(title, user, year, date, dept, year1, patent, granting) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
$stmt->execute(array($name, $user, $year1, $date, $dept, $year, $patent, $granting));
echo "<table width = '80%' border = '0'> <tr> <td>";
echo "<b> Uploaded Details </b> <br>";
echo "Title of the Patent : " . $name."<br>";
echo "Patent Id : " . $patent."<br>";
echo "Granting Agency: " . $granting."<br>";
echo "Year: " . $year."<br>";
echo "</td> </tr> </table>";
echo " Please check the view submission for proper entry in the database";
$_SESSION['LastRequest'] = $signature;
}
else {
echo " <b> <center> Please fill all the mandatory fields </center> </b>";
}
}
}
?>