i need to update a database table using variables in unusual places here are the update statements
now i was just showed by ron how to recive post stuff and that is where the variables come from so i am not even sure if i am getting the variables from the other page. i did try to display all of those variables but with my php skills the echo options might have their own problems so here is the rest of the code
Code:
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'");
Code:
<!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>
Comment