STIV 3013 WWW PROGRAMMING

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"> </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"> </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>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

</body>

</html>

edit process

html>

<head>

<title>Data Updated</title>

</head>

<body>

</tr>

<tr>

</tr>

<tr>

:: <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>

</body>

</html>

Edit list

<html>

<head>

<title>List of Users</title>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

</body>

</html>

Edit user

<html>

<head>

<title>List of Users</title>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

</body>

</html>

Edit user

!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>

<head>

<title>Update User Data</title>

</head>

<body>

</tr>

<tr>

:: <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>

<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];

}

<tr>

<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><input name="dob" type="text" id="dob" value="<?php print $tmpdob; ?>" size="40" maxlength="50"></td></tr>

<tr>

</tr>

</table>

</div>

</form> </td>

</tr>

</table>

</body>

</html>

List All

<html>

<head>

<title>List of Users</title>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

</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>

</head>

<body>

Please fill in your details: <br>

User ID: <input type="text" name="userid"><br>

Password: <input type="password" name="password"><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>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

<tr>

<tr>

<tr>

<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Phone:</font></td>

<tr>

<tr>

</tr>

</table>

</div>

</form> </td>

</tr>

</table>

</body>

</html>

Register Process

<html>

<head>

<title>Data Saved</title>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

</body>

</html>

Searching

<html>

<head>

<title>Searching</title>

</head>

<body>

</tr>

<tr>

:: <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>

<p><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Search </strong></font></p>

<p>

<br>

[ search by keyword]<br>

</form>

</p></td>

</tr>

</table>

</body>

</html>

Searching Process

<html>

<head>

<title>Searching</title>

</head>

<body>

</tr>

<tr>

:: <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>

<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>

</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>

</head>

<body>

</tr>

<tr>

:: <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>

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

}

<tr>

<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">UserID:</font></td>

</tr>

<tr>

</tr>

<tr>

<td><font size="2" face="Geneva, Arial, Helvetica, sans-serif">Phone:</font></td>

<tr>

<tr>

</tr>

</table>

</font>

</div>

</td>

</tr>

</table>

</body>

</html>

Interface

STIV 3013 WWW PROGRAMMING

Sunday, 11 December 2016

No comments:

Post a Comment