<?php require_once('Connections/SEEK.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO Allocation (ID, createDate, EMPL_ID, First_Name, Last_Name, Address, Apt_number, City, `State`, Zip, Cell_Phone, Home_Phone, Primary_Email, Gender, DOB, DOB_Place, Ethnicity, Ethnicity_Other, Citizenship, Citizenship_Other, First_Language, English_Study_years, USA_Residency_years, Home_Languages, Living_Arrangement_1, Living_Arrangement_1a, Living_Arrangement_Family, Living_Arrangement_Other, Living_Arrangement_cousin, Living_Arrangement_sister, Living_Arrangement_brother, Living_Arrangement_Change, Financial_Status_1, Financial_Status_2, Financial_Status_2a, Financial_Status_3, Financial_Status_3a, Hospitalization_1, Hospitalization_1a, Medication_1, Medication_1a, Treatment, Counseling_Support_1, Counseling_Support_1a, First_Generation_Student, Employment_Status_1, Employment_Status_2, Employer_1_Info, Employer_2_Info, Career_Goals, Intended_Major, Study_Techniques, Study_Techniques_Other, Study_Habits_1, Study_Habits_2, Reading_Speed_1, Reading_Speed_1_Other, Reading_Speed_Textbook, Reading_Speed_Novel, Reading_Comprehension, Note_Taking_1, Note_Taking_2, Note_Taking_3, Writing_Skills_1, Writing_Skills_2, Writing_Skills_3, Writing_Skills_4, Writing_Skills_5, Attendance_1, Attendance_2, Attendance_2a, Attendance_3, Attendance_3a, Support_Services_1, Support_Services_1a, Support_Services_2, Support_Services_2a, Probation_concerns, Counseling_services, Academic_Success_Plan, Emergency_Contact_Name, Emergency_Contact_Phone, Emergency_Contact_Address) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['ID'], "int"),
                       GetSQLValueString($_POST['createDate'], "date"),
                       GetSQLValueString($_POST['EMPL_ID'], "text"),
                       GetSQLValueString($_POST['First_Name'], "text"),
                       GetSQLValueString($_POST['Last_Name'], "text"),
                       GetSQLValueString($_POST['Address'], "text"),
                       GetSQLValueString($_POST['Apt_number'], "text"),
                       GetSQLValueString($_POST['City'], "text"),
                       GetSQLValueString($_POST['State'], "text"),
                       GetSQLValueString($_POST['Zip'], "text"),
                       GetSQLValueString($_POST['Cell_Phone'], "text"),
                       GetSQLValueString($_POST['Home_Phone'], "text"),
                       GetSQLValueString($_POST['Primary_Email'], "text"),
                       GetSQLValueString($_POST['Gender'], "text"),
                       GetSQLValueString($_POST['DOB'], "text"),
                       GetSQLValueString($_POST['DOB_Place'], "text"),
                       GetSQLValueString($_POST['Ethnicity'], "text"),
                       GetSQLValueString($_POST['Ethnicity_Other'], "text"),
                       GetSQLValueString($_POST['Citizenship'], "text"),
                       GetSQLValueString($_POST['Citizenship_Other'], "text"),
                       GetSQLValueString($_POST['First_Language'], "text"),
                       GetSQLValueString($_POST['English_Study_years'], "text"),
                       GetSQLValueString($_POST['USA_Residency_years'], "text"),
                       GetSQLValueString($_POST['Home_Languages'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_1'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_1a'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_Family'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_Other'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_cousin'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_sister'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_brother'], "text"),
                       GetSQLValueString($_POST['Living_Arrangement_Change'], "text"),
                       GetSQLValueString($_POST['Financial_Status_1'], "text"),
                       GetSQLValueString($_POST['Financial_Status_2'], "text"),
                       GetSQLValueString($_POST['Financial_Status_2a'], "text"),
                       GetSQLValueString($_POST['Financial_Status_3'], "text"),
                       GetSQLValueString($_POST['Financial_Status_3a'], "text"),
                       GetSQLValueString($_POST['Hospitalization_1'], "text"),
                       GetSQLValueString($_POST['Hospitalization_1a'], "text"),
                       GetSQLValueString($_POST['Medication_1'], "text"),
                       GetSQLValueString($_POST['Medication_1a'], "text"),
                       GetSQLValueString($_POST['Treatment'], "text"),
                       GetSQLValueString($_POST['Counseling_Support_1'], "text"),
                       GetSQLValueString($_POST['Counseling_Support_1a'], "text"),
                       GetSQLValueString($_POST['First_Generation_Student'], "text"),
                       GetSQLValueString($_POST['Employment_Status_1'], "text"),
                       GetSQLValueString($_POST['Employment_Status_2'], "text"),
                       GetSQLValueString($_POST['Employer_1_Info'], "text"),
                       GetSQLValueString($_POST['Employer_2_Info'], "text"),
                       GetSQLValueString($_POST['Career_Goals'], "text"),
                       GetSQLValueString($_POST['Intended_Major'], "text"),
                       GetSQLValueString($_POST['Study_Techniques'], "text"),
                       GetSQLValueString($_POST['Study_Techniques_Other'], "text"),
                       GetSQLValueString($_POST['Study_Habits_1'], "text"),
                       GetSQLValueString($_POST['Study_Habits_2'], "text"),
                       GetSQLValueString($_POST['Reading_Speed_1'], "text"),
                       GetSQLValueString($_POST['Reading_Speed_1_Other'], "text"),
                       GetSQLValueString($_POST['Reading_Speed_Textbook'], "text"),
                       GetSQLValueString($_POST['Reading_Speed_Novel'], "text"),
                       GetSQLValueString($_POST['Reading_Comprehension'], "text"),
                       GetSQLValueString($_POST['Note_Taking_1'], "text"),
                       GetSQLValueString($_POST['Note_Taking_2'], "text"),
                       GetSQLValueString($_POST['Note_Taking_3'], "text"),
                       GetSQLValueString($_POST['Writing_Skills_1'], "text"),
                       GetSQLValueString($_POST['Writing_Skills_2'], "text"),
                       GetSQLValueString($_POST['Writing_Skills_3'], "text"),
                       GetSQLValueString($_POST['Writing_Skills_4'], "text"),
                       GetSQLValueString($_POST['Writing_Skills_5'], "text"),
                       GetSQLValueString($_POST['Attendance_1'], "text"),
                       GetSQLValueString($_POST['Attendance_2'], "text"),
                       GetSQLValueString($_POST['Attendance_2a'], "text"),
                       GetSQLValueString($_POST['Attendance_3'], "text"),
                       GetSQLValueString($_POST['Attendance_3a'], "text"),
                       GetSQLValueString($_POST['Support_Services_1'], "text"),
                       GetSQLValueString($_POST['Support_Services_1a'], "text"),
                       GetSQLValueString($_POST['Support_Services_2'], "text"),
                       GetSQLValueString($_POST['Support_Services_2a'], "text"),
                       GetSQLValueString($_POST['Probation_concerns'], "text"),
                       GetSQLValueString($_POST['Counseling_services'], "text"),
                       GetSQLValueString($_POST['Academic_Success_Plan'], "text"),
                       GetSQLValueString($_POST['Emergency_Contact_Name'], "text"),
                       GetSQLValueString($_POST['Emergency_Contact_Phone'], "text"),
                       GetSQLValueString($_POST['Emergency_Contact_Address'], "text"));

  mysql_select_db($database_SEEK, $SEEK);
  $Result1 = mysql_query($insertSQL, $SEEK) or die(mysql_error());

  $insertGoTo = "SHConfirmation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>


<style type="text/css">
body {
	width: 900px;
	margin-right: auto;
	margin-left: auto;
	margin-top: 10px;
}
.form {
	background-color: #FFF;
	position: relative;
}
.pageTitle {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 1.5em;
	font-weight: bold;
	color: #FFF;
	text-align: left;
	padding: 5px;
	float: none;
	width: 880px;
	background-color: #13417d;
	border-top-width: 10px;
	border-right-width: 0px;
	border-bottom-width: 10px;
	border-left-width: 10px;
	border-top-style: solid;
	border-right-style: none;
	border-bottom-style: solid;
	border-left-style: solid;
	border-top-color: #13417d;
	border-right-color: #13417d;
	border-bottom-color: #13417d;
	border-left-color: #13417d;
	margin: 0px;
}
.formTitle {
	font-family: "Times New Roman", Times, serif;
	font-size: 1em;
	font-weight: bold;
	text-align: center;
}
.formTitle {
	font-size: 1.4em;
	background-color: #CCC;
	padding-top: 10px;
	color: #13417d;
	font-weight: bolder;
	font-style: normal;
}
.header1 footer {
	text-align: center;
	font-size: small;
	font-style: normal;
	color: #006;
}
.header1 {
	margin-top: 15px;
	font-size: medium;
	font-style: normal;
}
.header1 #studyhall table tr td {
	color: #006;
	font-family: Arial, Helvetica, sans-serif;
	font-size: small;
}
.formSH {
	font-family: Arial, Helvetica, sans-serif;
	font-size: small;
	color: #006;
	font-style: normal;
}
.header1 .formSH form table tr .formSH {
	font-family: Arial, Helvetica, sans-serif;
	font-size: small;
	color: #006;
	font-weight: bold;
}
#SHform {
	font-family: Arial, Helvetica, sans-serif;
	font-size: small;
	color: #006;
}
.instruction {
	font-size: small;
	font-style: italic;
	color: #900;
}
.ath {font-size: large}
</style>


<title>Tutor Staff Directory</title>

<body class="header1" style="color: #009; font-style: italic; font-weight: bold; border-bottom-width: thin;">
<div><img src="images/Lehman-Logo-t2.gif" width="900" height="296"/></div>
<div class="formTitle" id="sh"><strong>CT &amp; SI Schedule - Spring 2017</strong></div>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>">
  <p><img src="images/sp2017/under-construction.jpg" width="436" height="347" align="top">  
<div></div>


</div>
</div>

<footer>
  <blockquote>
    <p>&copy;2016-2017 SEEK Learning Center | (718) 960-7705 | Dr. Annette Hern&aacute;ndez, Director</p>
  </blockquote>
</footer>
</body>