Sunday, 11 December 2016

Lab Assignment

Grading System
Index source code
!DOCTYPE html>
<html>
<head>
<title>Interactive Creative Design </title>
<link href="assets\css\bootstrap.css" rel="stylesheet">
<link href="assets\css\custom.css" rel="stylesheet">
</head>
<body>
<div class="container-fluid">
<div class="row">
<div class="col-ms-12">
<div class="col-md-2"></div>
<div class="col-md-8 panel panel-info top-buffer left-buffer">
<div class="panel-heading"> <h1><b> UUM Grading System For Interactive Creative Design(STIV3053) </b> </h1> </div> 
<form action = "result.php" method="post" class="top-buffer">
<div class="panel-body">

<fieldset>
<legend><b>Student Information</b></legend>
<div>
<label>Student Name:</label>
<input type="text" name="name" id="name" class="form-control" required ><br/><br/>
<label>Student Matric Number:</label>
<input type="text" name="matric" id="matric" class="form-control"><br/><br/>
</div>
</fieldset><hr><br\><br/>

<fieldset>
<legend><b>Quizzes</b></legend>
<div class="col-sm-3">
<label>Enter mark for quiz 1</label>
<input type="number" name="number[]" id="num1" class="form-control"><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 2</label>
<input type="number" name="number[]" id="num2" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 3</label>
<input type="number" name="number[]" id="num3" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 4</label>
<input type="number" name="number[]" id="num4" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 5</label>
<input type="number" name="number[]" id="num5" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 6</label>
<input type="number" name="number[]" id="num6" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 7</label>
<input type="number" name="number[]" id="num7" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 8</label>
<input type="number" name="number[]" id="num8" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 9</label>
<input type="number" name="number[]" id="num9" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Enter mark for quiz 10</label>
<input type="number" name="number[]" id="num10" class="form-control"><br/><br/>
</div>
</fieldset><hr><br\><br/>

<fieldset>
<legend>Assignments</legend>
<div class="col-sm-3">
<label>Assignment 1</label>
<input type="number" name="assgn1" id="assgn" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Assignment 2</label>
<input type="number" name="assgn2" id="assgn" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Assignment 3</label>
<input type="number" name="assgn3" id="assgn" class="form-control"><br/><br/>
</div>
<div class="col-sm-3">
<label>Assignment 4</label>
<input type="number" name="assgn4" id="assgn" class="form-control">
</div>
</fieldset><hr><br\><br/>

<fieldset>
<legend>Final Project</legend>
<label>Enter mark for design</label>
<input type="number" name="design" id="design" class="form-control"><br/><br/>
<label>Enter mark for report</label>
<input type="number" name="report" id="report" class="form-control"><br/><br/>
</fieldset><hr><br\><br/>

<fieldset>
<legend>Final Exam</legend>
<label>Please enter final exam mark</label>
<input type="number" name="final" id="final" class="form-control"><br/><br/>
</fieldset>
</div>
<div class="btm-buffer">
<input type="submit" name="submit" value="submit" class="btn btn-primary">
</div>
</form>
</div>
<div class="col-md-2"></div>
</div>
</div>
</div>
</body>

</html>


Result


<?php

if(isset($_POST['submit'])){
//Captures the user input from the input box and stores it in a variable
$name =  $_POST["name"];
$matric =  $_POST["matric"];
$final  = $_POST["final"];
$quizzes   = $_POST["number"];
$assgn1 = $_POST["assgn1"];
$assgn2 = $_POST["assgn2"];
$assgn3 = $_POST["assgn3"];
$assgn4 = $_POST["assgn4"];
$design_w   = $_POST["design"];
$report_w   = $_POST["report"];
$finalexam = 0.4;
//$quiz = 0.1;
//$assignment = 0.2;
$design = 0.2;
$report = 0.1;
$f_total = 0;
$q_total = 0;
$a_total = 0;
$p_total = 0;
$r_total = 0;
$d_total = 0;
$c_total = 0;
$grand_total =0;

//To Sort the $quizzes array from highest to lowest
rsort($quizzes);
$arrlength=count($quizzes);
 
//Calculates the quizzes total mark. each quiz is multiplied by 2%
$q_total = (($quizzes[0] *0.02) +($quizzes[1]*0.02)+ ($quizzes[2] *0.02) +($quizzes[3] *0.02) +($quizzes[4] *0.02));
//Calculates the final exam mark. multiplied by 40%
$f_total  = $final * $finalexam;
//Calculates the assignments total. each assignment is multiplied by 5%
$a_total = (($assgn1 * 0.05) + ($assgn2 * 0.05) + ($assgn3 * 0.05) + ($assgn4 * 0.05));
//Calculates the total for the final project. Design + Report.
$d_total = ($design_w * $design);
$r_total = ($report_w * $report);
$p_total =  ($d_total + $r_total);
//Calculates the total for the carry mark
$c_total = $q_total + $a_total + $p_total;
//Calculates the total marks obtained for the subject
$grand_total = $c_total + $f_total;
 
 }
?>
<html>
<head>
<title>Result</title>
<link href="assets\css\bootstrap.css" rel="stylesheet">
<link href="assets\css\custom.css" rel="stylesheet">
</head>
<body>
<div class="container-fluid">
<div class="row">
<div class="col-ms-12">
<div class="col-md-2"></div>
<div class="col-md-8  panel panel-info top-buffer left-buffer">
<div class="panel-heading"> <h1><b>Result</b> </h1> </div> 
<div class="panel-body">
<fieldset>
<legend><b>Student Information</b></legend>
<div class="cap">
<label>Student Name:</label> <?php echo $name ?><br/>
<label>Student Id:</label> <?php echo $matric ?>
</div>
</fieldset><hr/><br/>
<fieldset>
<legend><b>Carry Mark Summary</b></legend>
<div class="col-md-3">
<label>Highest Quiz Marks</label><br/>
<ol>
<li> <?php echo $quizzes[0]; ?></li>
<li> <?php echo $quizzes[1]; ?></li>
<li> <?php echo $quizzes[2]; ?></li>
<li> <?php echo $quizzes[3]; ?></li>
<li> <?php echo $quizzes[4]; ?></li>
</ul><br/>
<label>Total (10%): <?php echo $q_total ?></label>
</div>
<div class="col-md-3">
<label>Project Mark</label><br/>
<ol>
<li>Design Work : <?php echo $d_total ; ?></li>
<li>Project Report: <?php echo $r_total ; ?></li>
<li class="hide"> wq</li>
<li class="hide"> q</li>
<li class="hide">e </li>
</ul><br/><br/><br/><br/>
<label>Total (20%/10%):  <?php echo $p_total ?></label>
</div>
<div class="col-md-3">
<label>Assignment Mark</label><br/>
<ol>
<li>Assignment A : <?php echo $assgn1 ; ?></li>
<li>Assignment B : <?php echo $assgn2 ; ?></li>
<li>Assignment C : <?php echo $assgn3 ; ?></li>
<li>Assignment D : <?php echo $assgn4 ; ?></li>
<li class="hide">e </li>
</ul><br/><br/>
<label>Total (20%):  <?php echo $a_total ?></label>
</div>
</fieldset>
<label>Total Carry Mark: <?php echo $c_total; ?> </label> <hr/><br/>
<fieldset>
<legend><b>Student Final Result</b></legend>
<div>
<label>Final Exam Mark (40%): </label> <?php echo $f_total ?><br/>
<label>Final Exam + Carry Mark (100%): </label> <?php echo $grand_total ?><br/>
<label>Gred: </label> 
<?php //Sets the gred base on the total carry marks obtained
if ($grand_total >= 80 || $grand_total == 100  ){ 
echo "A";
}else if ($grand_total >= 60 || $grand_total == 79){
echo "B";
}else if ($grand_total >= 50 || $grand_total == 59){
echo "C";
}else if ($grand_total >= 40 || $grand_total == 49){
echo "D";
}else{
echo "F"; 
}?>
 
</div>
</fieldset><hr/><br/>
<div>
<input type="button" value="Back" class="btn btn-success" onclick="history.back(-1)"/>
</div>
</div>
</div>
<div class="col-md-2"></div>
</div>
</div>
</div>
</div>
</body>
</html>


CSS

.top-buffer { margin-top:20px; }
.btm-buffer { margin-bottom:20px; }
.left-buffer { margin-left:50px; }
.cap {text-transform: capitalize;}
.hide{display:none;  }

Interfaces

Index




Result





Posted by at No comments:

Admin Page 

 <html>
      <head><title> Halaman Sulit Administrator</title></head>
<body>
 <?php
      session_start();
      $user = $_REQUEST['user']  ;

      if($_SESSION['username'] != $user)
      {
        $url = "Location: cannot.php?user=$username";
        header($url);
      }

      $connect=mysql_connect('localhost','root');
      mysql_select_db('student_db');

      $query1="SELECT staffID,name,post,curr_department FROM staff,login ";
      $query2="WHERE staffID = login.ID AND login.loginID = '$user'";
      $SQLcommand = $query1.$query2;

      $result = mysql_query ($SQLcommand, $connect) or die (mysql_error());
      $row = mysql_fetch_array ($result);

      print "Administrator";
      print "<table border = \"1\" witdh=\"300\">";
      print "<tr bgcolor=\"#DDDDDD\">";
      print "<td>";
      print "Staff ID: ";
      print $row["staffID"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#EEEEEE\">";
      print "<td>";
      print "Name: ";
      print $row["name"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#DDDDDD\">";
      print "<td>";
      print "Post: ";
      print $row["post"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#EEEEEE\">";
      print "<td>";
      print "Department: ";
      print $row["curr_department"];
      print "</td>";
      print "</tr>";

      print "</table>";
      print "<br>";
      print "<a href = \"logout.php?\"> Click to Logout </a>";

</body></html>


Delete list


<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF">
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr>
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a>
:: <a href="register.php">register</a>
:: <a href="deleteList.php">delete user</a>
:: <a href="editList.php">edit user</a>
:: <a href="searching.php">search user</a>
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Users </strong></font></p>
 <p>
        <?php
           
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people";

$result = mysql_query($SQLcommand, $connect);

print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Phone</td>";
print "<td>DOB</td>";

print "</tr>";

 while($row = mysql_fetch_row($result))
 {
print "<tr bgcolor=\"#EEEEEE\">";
 print "<td> $row[0] </td>";
 print "<td> $row[1] </td>";
 print "<td> $row[2] </td>";
 print "<td> $row[3] </td>";


 print "<td>";


 print "<a href =\"deleteUser.php?ID=";
 print $row[0] ;
 print "\">";
 print "[delete]";
 print"</a>";

 print "</td>";

print "</tr>";
 }
 print "</table>";
 mysql_close($connect);
?>
 
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font>
</body>
</html>

Delete user

<html>
<head>
<title>Data Updated</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>User Data has  been deleted. TQ.</strong></font></p>
 <p>
        <?php
//request nilai id
$IDno = $_REQUEST['ID'];
//database
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "DELETE FROM people WHERE id=".$IDno;
$result = mysql_query($SQLcommand, $connect);

mysql_close($connect);

      ?>
   
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>


edit process 

html>
<head>
<title>Data Updated</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></div></td>

  </tr>

  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">



:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::

<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Your details have been updated. TQ.</strong></font></p>

</font></div></td>


 <p>
        <?php
            $IDno = $_POST['IDno'];
$name= $_POST['name'];
$phone= $_POST['phone'];
$dob= $_POST['dob'];
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "UPDATE `people` SET `name` = '$name', `phone` = '$phone', `dob` = '$dob'   WHERE `id`=".$IDno;

$result = mysql_query($SQLcommand, $connect);
mysql_close($connect);

      ?>

      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>



Edit list

<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Users </strong></font></p>
 <p>
        <?php
            
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people";
 
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Phone</td>";
print "<td>DOB</td>";
print "</tr>";
 
 while($row = mysql_fetch_row($result))
 {
print "<tr bgcolor=\"#EEEEEE\">";
 print "<td> $row[0] </td>";
 print "<td> $row[1] </td>";
 print "<td> $row[2] </td>";
 print "<td> $row[3] </td>";
 
 print "<td>";
 print "<a href =\"editUser.php?ID=";
 print $row[0] ;
 print "\">";
 print "[edit]";
 print"</a>";
 
 
 print "</td>";
 
print "</tr>";  
 }
 print "</table>";
 mysql_close($connect);
?>
   
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>

Edit user

<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Users </strong></font></p>
 <p>
        <?php
            
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people";
 
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Phone</td>";
print "<td>DOB</td>";
print "</tr>";
 
 while($row = mysql_fetch_row($result))
 {
print "<tr bgcolor=\"#EEEEEE\">";
 print "<td> $row[0] </td>";
 print "<td> $row[1] </td>";
 print "<td> $row[2] </td>";
 print "<td> $row[3] </td>";
 
 print "<td>";
 print "<a href =\"editUser.php?ID=";
 print $row[0] ;
 print "\">";
 print "[edit]";
 print"</a>";
 
 
 print "</td>";
 
print "</tr>";  
 }
 print "</table>";
 mysql_close($connect);
?>
   
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>



Edit user 

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Update User Data</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
<h1><font face="Geneva, Arial, Helvetica, sans-serif">Editing Form </font></h1>
      <p><font face="Geneva, Arial, Helvetica, sans-serif">Please enter your details and click the submit button. </font>
 </p>
 
<?php 
  
//request nilai id
$IDno = $_REQUEST['ID'];
//databae
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people WHERE id=".$IDno;
$result = mysql_query($SQLcommand, $connect);
while($row = mysql_fetch_array($result))
 {
$tmpname= $row[1];
$tmpphone= $row[2];
$tmpdob= $row[3];
     }
?>
 
     <form method = "post" action = "edit_process.php">
        <div align="left"><span style = "color: blue"> </span>
          <table align="center" border="1" cellspacing="0" cellpadding="3">
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Name:</font></td>
<td><input name="name" type="text" id="name" value="<?php print $tmpname; ?>" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Phone:</font></td>
   <td><input name="phone" type="text" id="phone" value="<?php print $tmpphone; ?>" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">DOB:</font></td>
   <td><input name="dob" type="text" id="dob" value="<?php print $tmpdob; ?>" size="40" maxlength="50"></td></tr>
<tr>
<tr>
<tr>
<tr>
  <td colspan="2" align="right">
<input name="IDno" type = "hidden" value = "<?php print $IDno; ?>">
<input name="submit" type = "submit" value = "Update">
<input name="reset" type = "reset" value = "Reset">
<p></p></td>
</tr>
</table>
          
        </div>
      </form> </td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>


List All

<html>
<head>
<title>List of Users</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>List of Registered Users </strong></font></p>
 <p>
        <?php
                       // error_reporting(E_ALL ^ E_DEPRECATED);
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people";
 
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Telephone</td>";
print "<td>DOB</td>";
print "</tr>";
 
 while($row = mysql_fetch_row($result))
 {
print "<tr bgcolor=\"#EEEEEE\">";
 print "<td> $row[0] </td>";
 print "<td> $row[1] </td>";
 print "<td> $row[2] </td>";
 print "<td> $row[3] </td>";
 
 print "<td>";
 print "<a href =\"viewUser.php?ID=";
 print $row[0] ;
 print "\">";
 print "[view]";
 print"</a>";
 print "</td>";
 
//  print "<td> position: $row[6] </td>";
print "</tr>";  
 }
 print "</table>";
 mysql_close($connect);
 
?>
   
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>

Login Process 

<?php

$username = $_POST['userid'];
$password = $_POST['password'];

$connect=mysql_connect('localhost','root');
mysql_select_db('student_db');

$query1= "SELECT ID,status FROM login ";
$query2= "WHERE loginID ='$username' AND password = '$password'";
$SQLcommand = $query1.$query2;

$result = mysql_query ($SQLcommand, $connect) or die (mysql_error());
$row = mysql_fetch_array ($result);

if($row['status'] == "admin")
{
 session_start();
 $_SESSION['username'] = $username;
 //session_register($username);
 //session_encode();
 $url = "Location: listAll.php?user=$username";
 header($url);
}

else if($row['status'] =="student")
{
 session_start();
 $_SESSION['username'] = $username;
 //session_register($username);
 //session_encode();
 $url= "Location: listAll.php?user=$username";
 header($url);
}

else if($row['status'] == "staff")
{
 session_start();
 $_SESSION['username'] = $username;
// session_register($username);
// session_encode();
 $url = "Location: listAll.php?user=$username";
 header($url);
}

else
{
  echo "Error!";
 }

?>

Login

<html>
      <head>
            <title> Form</title>
      </head>
      <body>
      <form method= "post" action="login_process.php">
      Please fill in your details: <br>
      User ID: <input type="text" name="userid"><br>
      Password: <input type="password" name="password"><br>
      <input type="submit" name="submit" value="Submit"><br>
      </form>
      </body>
</html>


Logout
<?php

       session_start();
       session_destroy();
       $url = "Location: logoutMSG.php";
       header($url);
?>

Logout Message 


Successfully Logout              
<br>
<a href ="loginS.php">Login again</a>


Register 



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Registration Form</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
<h1><font face="Geneva, Arial, Helvetica, sans-serif">Registration Form </font></h1>
      <p><font face="Geneva, Arial, Helvetica, sans-serif">Please enter your details and click the submit button. </font></p>
   
     <form method = "post" action = "register_process.php">
        <div align="left"><span style = "color: blue"> </span>
          <table align="center" border="1" cellspacing="0" cellpadding="3">
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">ID:</font></td>
   <td><input name="id" type="int" id="id" size="40" maxlength="50"></td></tr>

<tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Name:</font></td>
<td><input name="name" type="text" id="name" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Phone:</font></td>
   <td><input name="phone" type="text" id="phone" size="40" maxlength="50"></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">DOB:</font></td>
   <td><input name="dob" type="text" id="dob" size="40" maxlength="50"></td></tr>
<tr>

<tr>
  <td colspan="2" align="right">
<input name="submit" type = "submit" value = "Register">
<input name="reset" type = "reset" value = "Reset">
<p></p></td>
</tr>
</table>
          
        </div>
      </form> </td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>


Register Process 

<html>
<head>
<title>Data Saved</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Your details have been save. TQ.</strong></font></p>
 <p>
        <?php
                        $id= $_POST['id'];
$name= $_POST['name'];
$phone= $_POST['phone'];
$dob= $_POST['dob'];
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "INSERT INTO people (id, name, phone, dob) 
VALUES ('$id','$name', '$phone', '$dob') ";
$result = mysql_query($SQLcommand, $connect);
mysql_close($connect);

      ?>
   
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>


Searching

<html>
<head>
<title>Searching</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Search </strong></font></p>
 <p>
  <form name="form1" method="post" action="searching_process.php">
          <br>
          [ search by keyword]<br>
          <input type="text" name="keyword">
          <input type="submit" name="submit" value="Search">
        </form>
   
      </p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>

Searching Process 

<html>
<head>
<title>Searching</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="searching.php">search user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
 <p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Search </strong></font></p>
 <p>
 <?php
$keyword= $_POST['keyword'];
$connect=mysql_connect('localhost','root','');
mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people WHERE name like '%$keyword%' order by name asc";
 
$result = mysql_query($SQLcommand, $connect);
print "<table width=\"500\">";
print "<tr bgcolor=\"#DDDDDD\">";
print "<td>ID</td>";
print "<td>Name</td>";
print "<td>Phone</td>";
print "<td>DOB</td>";
print "</tr>";
 
 while($row = mysql_fetch_row($result))
 {
print "<tr bgcolor=\"#EEEEEE\">";
 print "<td> $row[0] </td>";
 print "<td> $row[1] </td>";
 print "<td> $row[2] </td>";
 print "<td> $row[3] </td>";
 
print "</tr>";  
 }
 print "</table>";
 mysql_close($connect);
 
?>      
</p></td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>

Staff page 

<html>
      <head><title> Halaman Sulit Penguna Staff</title><head>
<body>
 <?php

      session_start();
      $user = $_REQUEST['user']  ;

      if($_SESSION['username'] != $user)
      {
        $url = "Location: cannot.php?user=$username";
        header($url);
      }

      $connect=mysql_connect('localhost','root');
      mysql_select_db('student_db');

      $query1="SELECT staffID,name,post,curr_department FROM staff,login ";
      $query2= "WHERE staffID = login.ID AND login.loginID = '$user'";
      $SQLcommand = $query1.$query2;

      $result = mysql_query ($SQLcommand, $connect) or die (mysql_error());
      $row = mysql_fetch_array ($result);
      
      print "Staff";
      print "<table border = \"1\" witdh=\"300\">";
      print "<tr bgcolor=\"#DDDDDD\">";
      print "<td>";
      print "Staff ID: ";
      print $row["staffID"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#EEEEEE\">";
      print "<td>";
      print "Name: ";
      print $row["name"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#DDDDDD\">";
      print "<td>";
      print "Post: ";
      print $row["post"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#EEEEEE\">";
      print "<td>";
      print "Department: ";
      print $row["curr_department"];
      print "</td>";
      print "</tr>";

      print "</table>";
      print "<br>";
      print "<a href = \"logout.php?\"> Click to Logout </a>";
?>
</body></html>


Student Page 
<html>
 <head><title> Halaman Sulit Penguna Pelajar</title></head>
 <body>
 <?php
      session_start();
      $user = $_REQUEST['user']  ;

      if($_SESSION['username'] != $user)
      {
        $url = "Location: cannot.php?user=$username";
        header($url);
      }

      $connect=mysql_connect('localhost','root');
      mysql_select_db('student_db');

      $query1 ="SELECT studentID,name,program,faculty FROM student,login ";
      $query2 = "WHERE studentID = ID AND loginID = '$user'";
      $SQLcommand = $query1.$query2;

      $result = mysql_query ($SQLcommand, $connect) or die (mysql_error());
      $row = mysql_fetch_array ($result);
      
      print "Student";
      print "<table border = \"1\" witdh=\"300\">";
      print "<tr bgcolor=\"#DDDDDD\">";
      print "<td>";
      print "Student ID: ";
      print $row["studentID"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#EEEEEE\">";
      print "<td>";
      print "Name: ";
      print $row["name"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#DDDDDD\">";
      print "<td>";
      print "Program: ";
      print $row["program"];
      print "</td>";
      print "</tr>";

      print "<tr bgcolor=\"#EEEEEE\">";
      print "<td>";
      print "Faculty: ";
      print $row["faculty"];
      print "</td>";
      print "</tr>";

      print "</table>";
      print "<br>";
      print "<a href = \"logout.php?\"> Click to Logout </a>";
?>
     </body></html>


View user 

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Update User Data</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<table width="80%" height="339" border="1" align="center" bordercolor="#000000">
  <tr bordercolor="#FFFFFF"> 
    <td width="80" rowspan="3" align="center" bordercolor="#FFFFFF" bgcolor="#FFFFFF">&nbsp;</td>
    <td height="104" colspan="5" align="center" valign="top" bordercolor="#000000"><img src="baner.jpg" width="800" height="100"></td>
    <td width="80" rowspan="3" align="center" bgcolor="#FFFFFF">&nbsp;</td>
  </tr>
  <tr> 
    <td height="23" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66"><div align="center"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">
:: <a href="listAll.php">list of users</a> 
:: <a href="register.php">register</a> 
:: <a href="deleteList.php">delete user</a> 
:: <a href="editList.php">edit user</a> 
:: <a href="logout.php">Logout</a>
::</font></div></td>
  </tr>
  <tr>
    <td height="202" colspan="5" align="center" valign="top" bordercolor="#000000" bgcolor="#FFCC66">
<h1><font face="Geneva, Arial, Helvetica, sans-serif">View User Data </font></h1>
      <p>&nbsp;</p>
 
<?php 
                //error_reporting(E_ALL ^ E_DEPRECATED);
  
//request nilai id
$IDno = $_REQUEST['ID'];

//databae
$connect=mysql_connect('localhost','root','');
  mysql_select_db('mydomain');
$SQLcommand = "SELECT * FROM people WHERE id=".$IDno;

print $SQLcommand;

$result = mysql_query($SQLcommand, $connect);
while($row = mysql_fetch_array($result))
 {
$tmpname= $row[1];
$tmpphone= $row[2];
$tmpdob= $row[3];
     }
?>
 
     
        <div align="left"><span style = "color: blue"> </span>
<font size="2" face="Geneva, Arial, Helvetica, sans-serif">
          <table align="center" border="1" cellspacing="0" cellpadding="3">
<tr>
                  <td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">UserID:</font></td>
 <td><?php print $IDno; ?></td>
   </tr>
<tr>
                  <td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Name:</font></td>
 <td><?php print $tmpname; ?></td>
   </tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Phone:</font></td>
   <td><?php print $tmpphone; ?></td></tr>
<tr>
<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">DOB:</font></td>
   <td><?php print $tmpdob; ?></td></tr>
<tr>
<tr>

<tr>
   <td colspan="2" align="right"><p></p></td>
</tr>
</table>
</font>
          
        </div>
    </td>
  </tr>
</table>
<font color="#FFFFFF"></font> 
</body>
</html>


Interface 







Posted by at No comments:
Subscribe to: Comments (Atom)