// session_start();
include 'TPGP_db.php';
// self post data
$Order = $_POST['Order'];
$Step = $_POST['Step'];
$Desc = $_POST['Desc'];
$SStepsRequired = $_POST['SStepsRequired'];
/* Let's strip some slashes in case the user entered
any escaped characters. */
$Order = stripslashes($Order);
$Step = stripslashes($Step);
$Desc = stripslashes($Desc);
$SStepsRequired = stripslashes($SStepsRequired);
// echo $PHP_SELF
// THIS IS WHERE THE SELF POST FORM GOES
// Define post fields into simple variables
if ($Step) {
$sql2 = "INSERT into step (StepOrder,Step,Description,SStepsRequired) VALUES ('$Order','$Step','$Desc','$SStepsRequired')";
mysql_query($sql2);
// print "success - .$sql2";
// print "To Create A New Step, click here.";
// END IF greater than one row found inthe class list.
} else {
// $PHP_SELF as the form action will cause the script to post to itself
} // END ELSE IF
echo "";
echo "
|
Turning Point at Granita Park
Student Administration
System
Add / Edit Steps
Click here to return to the main administration page!
|
|
";
$sql="SELECT StepID, StepOrder, Step, Description, SStepsRequired FROM step ORDER BY StepOrder";
$result = mysql_query($sql);
$nrows = mysql_num_rows($result);
if($nrows != 0)
{
print "";
print "";
print "FUNCTION | ";
print "";
print "Order | ";
print "";
print "Step | ";
print "";
print "Description | ";
print "";
print "Required | ";
print "
>";
for($j=0;$j<$nrows;$j++)
{
$row = mysql_fetch_array($result);
$EditURL = "TPGP_EditStep.php?ID=" . $row['StepID'];
$DeleteURL = "TPGP_DeleteStep.php?ID=" . $row['StepID'];
print " EDIT";
print " | DELETE";
print " | " . $row["StepOrder"];
print " | " . $row["Step"];
print " | " . $row["Description"];
print " | " . $row["SStepsRequired"];
print "\n";
}
print " |
\n";
}
// $list_comp = $row["SubjectID"];
// $sql4="SELECT SubjectID,Subject from subject";
// $result4 = mysql_query($sql4)
// or die("error in SQL");
echo '';
print "Click here to return to the main administration page!";
// THIS IS WHERE THE SELF POST FORM ENDS
// mysql_close($dbcon);
?>