예제 #1
0
/**
 * http://stackoverflow.com/a/4128377/2790481
 *
 * @param $needle
 * @param $courses
 * @param bool $strict
 * @return bool
 */
function getMajor($needle, $majors, $strict = false)
{
    foreach ($majors as $major) {
        if (($strict ? $major === $needle : $major == $needle) || is_array($major) && getMajor($needle, $major, $strict)) {
            return $major;
        }
    }
    return false;
}
예제 #2
0
            $row = mysql_fetch_row($rs);
            $rsA = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
            if ($row) {
                while ($row = mysql_fetch_row($rsA)) {
                    if ($row[2] == 0) {
                        $advName = "Group";
                    } else {
                        $advName = getAdvisorName($row);
                    }
                    $found = "<tr><td>" . date('l, F d, Y g:i A', strtotime($row[1])) . "</td>" . "<td>" . $advName . "</td>" . "<td>" . $row[3] . "</td></tr>" . array_push($results, $found);
                }
            }
        }
    } else {
        foreach ($times as $t) {
            $sql = "select * from Proj2Appointments where `Time` like '%{$date}%' and `Time` > '" . date('Y-m-d H:i:s') . "' and `Time` like '%{$t}%' and `AdvisorID` like '%{$advisor}%' and `EnrolledNum` = 0 and `Major` like '%" . getMajor() . "%' order by `Time` ASC Limit 30";
            $rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
            $row = mysql_fetch_row($rs);
            if ($row) {
                while ($row = mysql_fetch_row($rs)) {
                    if ($row[2] == 0) {
                        $advName = "Group";
                    } else {
                        $advName = getAdvisorName($row);
                    }
                    $found = "<tr><td>" . date('l, F d, Y g:i A', strtotime($row[1])) . "</td>" . "<td>" . $advName . "</td>" . "<td>" . $row[3] . "</td></tr>" . array_push($results, $found);
                }
            }
        }
    }
}
예제 #3
0
?>
>Theatre</option>
					<option <?php 
if (getMajor() == 'Visual Arts') {
    echo "selected";
}
?>
>Visual Arts</option>
					<option <?php 
if (getMajor() == 'Undecided') {
    echo "selected";
}
?>
>Undecided</option>
					<option <?php 
if (getMajor() == 'Other') {
    echo "selected";
}
?>
>Other</option>
-->
					</select>
			</div>
			<div class="nextButton">
				<input type="submit" name="save" class="button large go" value="Save">
			</div>
			</div>
		</form>
  </body>
  
</html>
예제 #4
0
<?php

session_start();
include 'GetStudentData.php';
$debug = false;
$COMMON = new Common($debug);
if (isset($_POST["advisor"])) {
    // Put student's advisor into Proj2Student table
    $tempAdvisor = $_POST["advisor"];
    $sql = "update `Proj2Students` set `Advisor`= '{$tempAdvisor}' where `id` = 55";
    $rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
}
$localAdvisor = getAdvisor();
$localMaj = getMajor();
$sql = "select * from Proj2Advisors where `id` = '{$localAdvisor}'";
$rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
$row = mysql_fetch_row($rs);
$advisorName = $row[1] . " " . $row[2];
?>

<html lang="en">
  <head>
    <meta charset="UTF-8" />
    <title>Select Appointment</title>
	<link rel='stylesheet' type='text/css' href='css/standard.css'/>

  </head>
  <body>
    <div id="login">
      <div id="form">
        <div class="top">
예제 #5
0
            }
        }
    } else {
        // for every result found, output to the user
        foreach ($times as $t) {
            $sql = "select * from Proj2Appointments where `Time` like '%{$date}%' and `Time` > '" . date('Y-m-d H:i:s') . "' and `Time` like '%{$t}%' and `AdvisorID` like '%{$advisor}%' and `EnrolledNum` = 0 and `Major` like '%" . $_SESSION['major'] . "%' order by `Time` ASC Limit 30";
            $rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
            $row = mysql_fetch_row($rs);
            if ($row) {
                while ($row = mysql_fetch_row($rs)) {
                    if ($row[2] == 0) {
                        $advName = "Group";
                    } else {
                        $advName = getAdvisorName($row);
                    }
                    $majors = getMajor($row[3]);
                    $found = "<tr><td>" . date('l, F d, Y g:i A', strtotime($row[1])) . "</td>" . "<td>" . $advName . "</td>" . "<td>" . $majors . "</td>" . array_push($results, $found);
                }
            }
        }
    }
}
// if nothing found, print the instance of no results found for search filters set by user
if (empty($results)) {
    echo "No results found.<br><br>";
} else {
    echo "<table border='1'><th colspan='3'>Appointments Available</th>\n";
    echo "<tr><td width='60px'>Time:</td><td>Advisor</td><td>Major</td></tr>\n";
    foreach ($results as $r) {
        echo $r . "\n";
    }
예제 #6
0
    $stmt->execute();
    
    if($stmt->rowCount() == 0){die;}

    $student = $stmt->fetch();

    $dateObj   = DateTime::createFromFormat('!m', $student['grad_month']);
    $monthName = $dateObj->format('F'); // March
?>
<div class="container">
    <!-- Portfolio Item Heading -->
    <div class="row">
        <div class="col-lg-12">
            <h1 class="page-header"><?=$student['first_name']." ".$student['last_name']?>
                <small>
                    <?=getMajor($student['major'])?>
                    <h5>Anticipated Graduation Date: <?=$monthName?> <?=$student['grad_year']?></h5>
                </small>
            </h1>
        </div>
    </div>
    <!-- /.row -->

    <!-- Portfolio Item Row -->
    <div class="row">
        <div class="col-md-4">
            <img class="img-responsive" src="http://rufflifechicago.com/wp-content/uploads/cat-treats.jpg" alt="">
            <div class="social-links">
            <?php foreach(unserialize($student['social']) as $key => $value){ ?>
                <a href="<?=$value?>" target="_blank"><i class="fa fa-<?=$key?>"></i></a>
            <? } ?>
예제 #7
0
	<link rel='stylesheet' type='text/css' href='css/standard.css'/>  </head>
  <body>
	<div id="login">
      <div id="form">
        <div class="top">
		<h1>Confirm Appointment</h1>
	    <div class="field">
		<form action = "StudProcessSch.php" method = "post" name = "SelectTime">
	    <?php 
$debug = false;
include 'GetStudentData.php';
$COMMON = new Common($debug);
$firstn = getFirstName();
$lastn = getLastName();
$studid = $_SESSION["studID"];
$major = getMajor();
$email = getEmail();
if ($_SESSION["resch"] == true) {
    $sql = "select * from Proj2Appointments where `EnrolledID` like '%{$studid}%'";
    $rs = $COMMON->executeQuery($sql, $_SERVER["SCRIPT_NAME"]);
    $row = mysql_fetch_row($rs);
    $oldAdvisorID = $row[2];
    $oldDatephp = strtotime($row[1]);
    if ($oldAdvisorID != 0) {
        $sql2 = "select * from Proj2Advisors where `id` = '{$oldAdvisorID}'";
        $rs2 = $COMMON->executeQuery($sql2, $_SERVER["SCRIPT_NAME"]);
        $row2 = mysql_fetch_row($rs2);
        $oldAdvisorName = $row2[1] . " " . $row2[2];
    } else {
        $oldAdvisorName = "Group";
    }