D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
home
/
diafrica
/
result.dominicaninstitute.org
/
Filename :
requesttranscript.php
back
Copy
<?php if (!$_SESSION){ session_start(); } $acc=$_SESSION['acc']; $yto=$_SESSION['yto']; if(isset($acc) && ($acc=="studentoftheuniversity2015byto")){?> <?php include("Connecter/dataconn.php"); ?> <?php if (isset($_GET['deltab'])) { unset($temp); if(isset($_GET['deltab'])){ $_GET['deltab']=trim($_GET['deltab']); if(preg_match('/^[0-9]/u',$_GET['deltab'])){ settype($_GET['deltab'], 'int'); $temp=(int)$_GET['deltab']; } } if(!isset($temp)){echo "Sorry! Wrong Data!"; exit();} $deltab=$temp; $sql=sprintf("delete from transcripts where sn = %s", mysql_real_escape_string($deltab)); $result=mysql_query($sql,$csn) or die(mysql_error()); } $query_dio1 = "SELECT * FROM transcripts where archived='No' and matric='$yto' order by dater desc"; $dio1 = mysql_query($query_dio1, $csn) or die(mysql_error()); $row_dio1 = mysql_fetch_array($dio1); $totalRows_dio1 = mysql_num_rows($dio1); $query_dio = "SELECT * FROM transcripts where archived='Yes' and matric='$yto' order by dater desc"; $dio = mysql_query($query_dio, $csn) or die(mysql_error()); $row_dio = mysql_fetch_array($dio); $totalRows_dio = mysql_num_rows($dio); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <?php include("head.php"); ?> </head> <body> <?php include("top.php"); ?> <?php include("dtable0.php"); ?> <?php include("nav.php"); ?> <?php include("dtable1.php"); ?> <?php include("topcontainer.php"); ?> <!--Content Goes Here--> <div class="headingbiggest">Transcript Requests…</div> <p class="headingbigger"><b>Create a New Transcript Request</b></p> <form id="form1" name="form1" method="post" action="dstu.php" enctype="multipart/form-data"> <table width="100%" cellpadding="1" cellspacing="2"> <tr valign="top"> <td style="font-weight:bold; text-align:center">Name of Recipient Institute</td> <td align="left" style="font-size:9px;"><input name="titler" type="text" size="70" /></td> </tr> <tr valign="top"> <td style="font-weight:bold; text-align:center">Address of Recipient Institute</td> <td align="left" style="font-size:9px;"><textarea name="contenter" cols="69" rows="10"></textarea></td> </tr> <tr valign="top"> <td style="text-align:right; font-size:10px;" colspan="2"><br /><a href="dstu.php">Cancel</a> <input name="addnew" type="submit" style="font-size:12px;" id="addnew" value=" Request Transcript " /> <input name="dater" type="hidden" value="<?php echo(date('Y-m-d')); ?>" /> <input name="matric" type="hidden" value="<?php echo($yto); ?>" /> </td> </tr> </table> </form> <hr /> <p> </p> <div class="headingbigger"><b>Pending Transcript Requests</b></div> <?php if ($totalRows_dio1>0) { ?> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo $row_dio1['institute']; ?></td> <td style="border-bottom:1px solid #333333;"> <a href="requesttranscript.php?deltab=<?php echo $row_dio1['sn']; ?>">Delete</a> </td></tr> <?php } while ($row_dio1 = mysql_fetch_array($dio1)); ?> </table> <?php } else { echo ("None Found!"); } ?> <p> </p><p> </p> <div class="headingbigger"><b>Completed Transcript Requests</b></div> <?php if ($totalRows_dio>0) { ?> <table width="90%"> <?php do { ?><tr valign="top"> <td style="border-bottom:1px solid #333333;"><?php echo $row_dio['institute']; ?></td> </tr> <?php } while ($row_dio = mysql_fetch_array($dio)); ?> </table> <?php } else { echo ("None Found!"); } ?> <p> </p> <p><hr /><a href="dstu.php">Back to Home Page</a></p> <p> </p> <!--Content Ends Here--> <?php include("bottomcontainer.php"); ?> <?php include("dtable2.php"); ?> <?php include("side.php"); ?> <?php include("dtable3.php"); ?> <?php include("foot.php"); ?> </body> </html> <?php } else { include("student.php"); }?>