</head> <body bgcolor="FFFF99"> <div class="container"> <div class="header"> <div style="margin-top:10px;"><center>E-Mail Format </center></div> <div style="float:left; font-size:20px;margin-left:20px;"><a href="admin.php">Home</a></div> </div> <div id="bottom"> <div style="float:right;margin-right:20px;"><a href="editformat.php?hiddentype=new">Add new e-mail format</a></div> <div style="margin-top:20px;"> <?php include "ConnectionUtil.php"; beginConnection(); $result = getMyResult("Select * from mailview;"); if (mysqli_num_rows($result) > 0) { //echo ""; //display all list generated based on criteria while ($row = mysqli_fetch_assoc($result)) { echo "<div style=\" clear:both;\"><b>" . $row['name'] . "</b></div><div style=\"float:right;margin-top:10px;\"><a style=\"margin-right:40px;\" href=\"editformat.php?hidden=" . $row['name'] . "& hiddentype=update\">edit</a><a href=\"deleteformat.php?hidden=" . $row['name'] . "\" style= \"margin-right:10px;\">"; if ($row['name'] != "Wish Happy Birthday" && $row['name'] != "Appointment Reminder") { echo "delete"; } echo "</a></div>"; echo "<div style=\" height:30px;width:inherit;border:solid;margin-top:10px;\"><b>Subject :</b> " . $row['subject'] . "</div>"; echo "<div style=\" height:100px;width:inherit;border:solid;margin-bottom:30px;\"><div>Dear {Student},</div>"; echo "<div style=\"margin-left:100px;\">" . $row['body'] . "</div>"; echo "</div>"; }
<div style="margin-top:20px;"><center><input type="submit" value="Submit"><input type="reset" value="Reset"/></center></div> </fieldset> </form> </div> </div> <div style="width:50%;height:inherit;background-color:#FFFF99;float:left;"> <div style="font-size:20px;margin-top:10px;height:30px;"><center>Important News</center></div> <div style="margin-top:20px;margin-left:40px;"> <fieldset> <legend>News</legend> <marquee direction="up" scrolldelay="300"> <ul> <?php include "ConnectionUtil.php"; $conn = beginConnection(); $result = getMyResult("SELECT * from news order by date desc;"); if (mysqli_num_rows($result) > 0) { while ($row = mysqli_fetch_assoc($result)) { echo "<li>" . $row["name"] . "</li>"; } } else { echo "<div>No news to display.</div>"; } ?> </ul> </marquee> </fieldset> </div>
<html><head><meta charset="utf-8"></head> <?php $url = "student_search.php"; if ($_REQUEST["aluno"] && $_REQUEST["cpf"] && $_REQUEST["newCompany"] && $_REQUEST["inicio"] && $_REQUEST["fim"]) { $nome = $_REQUEST["aluno"]; $cpf = $_REQUEST["cpf"]; $novaEmp = $_REQUEST["newCompany"]; $inicio = $_REQUEST["inicio"]; $fim = $_REQUEST["fim"]; include "dbfunctions.php"; $c = beginConnection("localhost/root//diemp"); $sql = "select"; if (querySql($c, $sql, "find") == false) { // Se estágio ainda não existe, criar $sql = "select a.id as id\n\t\t\t\t from aluno a\n\t\t\t\t where(a.aluno='{$nome}' and a.cpf='{$cpf}')"; $line = querySql($c, $sql, "getline"); $id = $line["id"]; $sql = "insert into "; } $url .= "?nome=" . $nome . "&cpf=" . $cpf; } header("location:{$url}"); ?> </html>