<?php /* Filename: index.php * Author: Kelly Pang * Team: Group 2 - PineApple * Date: 06.17.2009 * Purpose: Start Page * */ include_once "header.php"; $sql_str = "SELECT * FROM StudentTable"; //$result = mysql_query($sql_str); //$row = mysql_fetch_array($result); $row = quick_query($sql_str); echo "result = " . $row['StudentNumber']; echo "<br>"; echo "<a href='displaystudents.php'>display students</a>"; echo "<br>"; echo "<a href='displayclass.php'>display class</a>"; echo "<br>"; ?>
print '"atraso":"' . $dado['ca_atraso'] . '"';
print '}';
} else {
print '{';
print '"atraso":"00:00"';
print '}';
}
} else {
print $mysql->error;
}
} elseif ($metodo == "atualizar_calendario" && $_SESSION['us']['us_nivel'] > 1) {
$id = sanitarizar($_POST['id'], 'int');
$valor = sanitarizar($_POST['valor']) . ":00";
preg_match('/^(\\d{2}:\\d{2}:00)$/', $valor, $matches);
if (!empty($matches)) {
if ($existe = quick_query("SELECT ca_id FROM pl_calendario WHERE assoc_sa_id = {$id}")) {
if ($consulta = $mysql->query("UPDATE pl_calendario SET ca_atraso = '{$valor}' WHERE ca_id = {$existe}")) {
print '{';
print '"status":"ok"';
print '}';
} else {
print $mysql->error;
}
} else {
if ($consulta = $mysql->query("INSERT INTO pl_calendario (assoc_sa_id, ca_atraso) VALUES ('{$id}', '{$valor}')")) {
print '{';
print '"status":"ok"';
print '}';
} else {
print $mysql->error;
}
function get_lec_attendance($lecID)
{
$sql_str = "SELECT COUNT(ID) count\r\n\t\t\t\tFROM attendancetable\r\n\t\t\t\tWHERE LectureID = {$lecID}";
$row = quick_query($sql_str);
return $row['count'];
}
