<?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']; }