if ($value !== "NotSelected") { $fullName = ldapGleaner($value); echo "<tr><td>" . $value . " -- " . $fullName[0] . " " . $fullName[1] . "</td><td><input type='text' name='sentDate3' class='dp' value=" . $row['refLetter_sentDate3'] . "></td></tr>"; } else { echo "<input type='hidden' name='sentDate3' value= 0000-00-00 >"; } } elseif ($key === "refLetter_FKwriterID4") { if ($value !== "NotSelected") { $fullName = ldapGleaner($value); echo "<tr><td>" . $value . " -- " . $fullName[0] . " " . $fullName[1] . "</td><td><input type='text' name='sentDate4' class='dp' value=" . $row['refLetter_sentDate4'] . "></td></tr>"; } else { echo "<input type='hidden' name='sentDate4' value= 0000-00-00 >"; } } elseif ($key === "refLetter_FKwriterID5") { if ($value !== "NotSelected") { $fullName = ldapGleaner($value); echo "<tr><td>" . $value . " -- " . $fullName[0] . " " . $fullName[1] . "</td><td><input type='text' name='sentDate5' class='dp' value=" . $row['refLetter_sentDate5'] . "></td></tr>"; } else { echo "<input type='hidden' name='sentDate5' value= 0000-00-00 >"; } } } ?> </table> </fieldset> <fieldset> <legend>Recipient Details</legend> <!-- <label for="recipTitle">Title:</label> -->
echo "{$deptLngName}"; ?> Reference Letter Requests Application</p> </div><!-- #instructions --> <div id="adminList"> <span id="currAdmins"> <?php $queryRecord = 'SELECT * FROM SRL_tbl_Admin ORDER BY AdminUniqname ASC'; if (!($result = $db->query($queryRecord))) { db_fatal_error('data select issue', $db->error, $queryRecord); exit($user_err_message); } while ($row = $result->fetch_array(MYSQLI_ASSOC)) { $fullname = ldapGleaner($row['AdminUniqname']); echo '<div class="record" id="record-', $row['id'], '"> <a href="?delete=', $row['id'], '" class="delete"><span style=color:red;font-weight:bold;>X</span></a> <strong>', $row['AdminUniqname'], '</strong> -- ', $fullname[0], " ", $fullname[1], '</div>'; } ?> </span> </div><!-- testing delete --> <br /> <div id="myAdminForm"><!-- add Admin --> If you would like to register another Administrator please enter their <b>uniqname</b> here <input type="text" name="name" /> <button id="adminSub">Add Administrator</button><br /><i>--look up uniqnames using the <a href="https://mcommunity.umich.edu/" target="_blank">Mcommunity directory</a>.</i> </div><!-- add Admin --> <!--
<?php require_once $_SERVER["DOCUMENT_ROOT"] . '/../Support/configEnglishContest.php'; require_once $_SERVER["DOCUMENT_ROOT"] . '/../Support/basicLib.php'; $queryAdmin = "SELECT * FROM tbl_contestadmin ORDER BY uniqname ASC"; $resAdmin = $db->query($queryAdmin); $resultAdmin = array(); if ($db->error) { try { throw new Exception("MySQL error {$db->error} <br> Query:<br> {$queryAdmin}", $db->errno); } catch (Exception $e) { echo "Error No: " . $e->getCode() . " - " . $e->getMessage() . "<br >"; echo nl2br($e->getTraceAsString()); } } while ($admins = $resAdmin->fetch_assoc()) { $fullName = ldapGleaner($admins["uniqname"]); array_push($resultAdmin, array('admin' => $admins["uniqname"], 'adminID' => $admins["id"], 'adminFname' => $fullName[0], 'adminLname' => $fullName[1])); } echo json_encode(array("result" => $resultAdmin)); $resAdmin->free(); $db->close();
<?php require_once $_SERVER["DOCUMENT_ROOT"] . '/../Support/configSocRefLetV2.php'; $fullName = ldapGleaner($login_name); // prepare and bind $stmt = $db->prepare('INSERT IGNORE INTO SRL_tbl_student (student_uniqname, student_Fname, student_Lname) VALUES( ?,?,?)'); $stmt->bind_param('sss', $login_name, $fullName[0], $fullName[1]); // set parameters and execute if (!$stmt->execute()) { die('Error: ' . mysqli_error($db)); } // prepare and bind $sql = $db->prepare('INSERT INTO SRL_tbl_refLetter (refLetter_FKstudent_uniqname, refLetter_requestDate, refLetter_dueDate, refLetter_positionTitle, refLetter_type,refLetter_title,refLetter_Fname,refLetter_Mname,refLetter_Lname,refLetter_suffix, refLetter_Email,refLetter_URL,refLetter_institute_name,refLetter_institute_dept,refLetter_institute_room,refLetter_institute_street, refLetter_institute_city,refLetter_institute_state,refLetter_institute_country,refLetter_institute_zipcode,refLetter_institute_phone, refLetter_specialInstx,refLetter_FKwriterID,refLetter_FKwriterID2,refLetter_FKwriterID3,refLetter_FKwriterID4,refLetter_FKwriterID5) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)'); $sql->bind_param('sssssssssssssssssssssssssss', $_POST['rqstrUniq'], $_POST['rqstrRqstDate'], $_POST['dueDate'], $_POST['posTitle'], $_POST['letterType'], $_POST['recipTitle'], $_POST['recipFname'], $_POST['recipMname'], $_POST['recipLname'], $_POST['recipSuffix'], $_POST['recipEmail'], $_POST['recipURL'], $_POST['recipInst'], $_POST['recipDept'], $_POST['recipRoom'], $_POST['recipStreet'], $_POST['recipCity'], $_POST['recipState'], $_POST['recipCountry'], $_POST['recipZip'], $_POST['recipPhone'], $_POST['recipSpInstx'], $_POST['writerID'], $_POST['writerID2'], $_POST['writerID3'], $_POST['writerID4'], $_POST['writerID5']); // set parameters and execute if (!$sql->execute()) { die('Error: ' . mysqli_error($db)); } ?> <html> <body> <div style="width:320px;margin:50px;padding:10px;border-style:ridge;border-width:5px"> You have submitted your request successfully <br /> <a style="color:sienna;margin-left:60px" href="../index.php">Return to main page</a> </div><!-- infoBanner -->
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/../Support/configSocRefLetV2.php'; // prepare and bind $query = $db->prepare('SELECT FK_writer_uniqname FROM SRL_tbl_StudentToWriter WHERE FK_student_uniqname = ? '); $query->bind_param('s', $login_name); // set parameters and execute $query->execute(); $result = array(); $query->bind_result($name); while ($query->fetch()) { $writerName = ldapGleaner($name); array_push($result, array('writer' => $name, 'fName' => $writerName[0], 'lName' => $writerName[1])); } echo json_encode(array('result' => $result));
Application</p> </div><!-- #instructions --> <div id="adminList"> <span id="currAdmins"> <?php $sqlAdmSel = <<<SQL SELECT * FROM tbl_contestadmin ORDER BY uniqname SQL; if (!($resADM = $db->query($sqlAdmSel))) { db_fatal_error("data read issue", $db->error, $sqlAdmSel, $login_name); exit; } while ($row = $resADM->fetch_assoc()) { $fullname = ldapGleaner($row['uniqname']); echo '<div class="record"> <button type="button" class="btn btn-xs btn-danger btnDelADM" data-delid="' . $row['id'] . '"><span class="glyphicon glyphicon-remove"></span></button> <strong>' . $row['uniqname'] . '</strong> -- ' . $fullname[0] . " " . $fullname[1] . '</div>'; } ?> </span> </div> <br /> <div id="myAdminForm"><!-- add Admin --> To add an Administrator please enter their <b>uniqname</b> below:<br> <input class="form_control" type="text" name="name" /><br> <button class="btn btn-info btn-xs" id="adminSub">Add Administrator</button><br /><i>--look up uniqnames using the <a href="https://mcommunity.umich.edu/" target="_blank">Mcommunity directory</a>--</i> </div><!-- add Admin --> </div> </div>
<?php require_once $_SERVER["DOCUMENT_ROOT"] . "/../Support/configStudentVisit.php"; require_once $_SERVER["DOCUMENT_ROOT"] . "/../Support/basicLib.php"; $queryFacAppt = <<<SQL \t\tSELECT * \t\tFROM tbl_facAppts \t\tORDER BY uniqname, appDate, startTime ASC SQL; $resultFacAppt = array(); if (!($resFacAppt = $db->query($queryFacAppt))) { die("Database query failed."); } while ($items = mysqli_fetch_assoc($resFacAppt)) { $facFullname = ldapGleaner($items["uniqname"]); $start = new DateTime($items["startTime"]); $day = new DateTime($items["appDate"]); array_push($resultFacAppt, array('id' => $items["id"], 'facFname' => $facFullname[0], 'facLname' => $facFullname[1], 'uniqname' => $items["uniqname"], 'startTime' => $start->format('g:i A'), 'appDate' => $day->format('F jS'), 'roomLoc' => $items["roomLoc"], 'studentName' => $items["studentName"])); } echo json_encode($resultFacAppt); $db->close();