Expand|Select|Wrap|Line Numbers
- mysql_query("UPDATE 'grades' SET '$class' = '$grade' WHERE student='$student'");
- mysql_query("UPDATE 'assignments' SET '$class' = '$grade' WHERE student='$student'");
- mysql_query("UPDATE 'comments' SET '$class' = '$grade' WHERE student='$student'");
Expand|Select|Wrap|Line Numbers
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
- <title>Untitled Document</title>
- <?
- session_start(); // Use session variable on this page. This function must put on the top of page.
- if(!session_is_registered("teacher")){ // if session variable "username" does not exist.
- header("location:login.php"); // Re-direct to index.php
- }
- ?>
- <?
- // Connect database.
- $host="localhost"; // Host name.
- $db_user="rcadmin"; // MySQL username.
- $db_password="nsds2004"; // MySQL password.
- $database="RCA"; // Database name.
- $RCA = mysql_pconnect($host, $db_user, $db_password) or trigger_error(mysql_error(),E_USER_ERROR);
- mysql_select_db($database, $RCA);
- $login=$_POST('login');
- $class=$_POST('job_select');
- $grade=$_POST('job_select');
- $assignment=$_POST('job_select');
- $comments=$_POST('job_select');
- //this section updates the database
- $grade = "grade";
- $assignments = "assignments";
- $comments = "comments";
- $student = "student";
- $class = "class";
- if (isset($_POST['grade']))
- $grade = strip_tags($_POST['grade']);
- if (isset($_POST['assigments']))
- $assignments = strip_tags($_POST['assignments']);
- if (isset($_POST['comments']))
- $comments = strip_tags($_POST['comments']);
- if (isset($_POST['student']))
- $student = strip_tags($_POST['student']);
- if (isset($_POST['classs']))
- $class = strip_tags($_POST['classs']);
- mysql_query("UPDATE 'grades' SET $class = '$grade' WHERE student='$student'");
- mysql_query("UPDATE assignments SET '$class' = '$grade' WHERE student='$student'");
- mysql_query("UPDATE comments SET $class = '$grade' WHERE student='$student'");
- ?>
- </head>
- <body>
- <?
- echo $grade, "<br />";
- echo $assignments , "<br />";
- echo $comments , "<br />";
- echo $student , "<br />";
- echo $class , "<br />";
- ?>
- </body>
- </html>