<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<TITLE>Viewing / Deleting Records</TITLE>
</HEAD>
<BODY>

<?php
/***************************************************************************
 *			do_delete4.php	                                   *
 *                       ~~~~~~~~~~~~~~~~~~~~~~~~~~~~	                   *
 *   File Info:		  Delete Users                                     *
 *   Copyright:       Copyright 2003 http://www.128concepts.com            *
 *						                           *
 ***************************************************************************/
include ("./header.inc");
?>
<img src=images/line.gif border=0 width=100% height=1><br><br>
<center><img src=images/computer.gif border=0><font face=verdana size=3 color=darkred> Viewing Records from USERS / Delete Records</font></center><br>

<center>
<table width="500" border=1><tr align="justify" class="subtitle"><td>
  <p align="center">
  <img border="0" src="images/database.GIF" width="24" height="24"><font face=Verdana size=1><a href="./create_db.php">Create database</a>&nbsp;
  <img border="0" src="images/database.GIF" width="24" height="24"></font><a href="./delete_db.php"><font face=Verdana size=1>Delete database</font></a><font face="Verdana" size="1">&nbsp;
  <img border="0" src="images/Records.GIF" width="24" height="24"><a href="./create_menu.php">Create table</a>&nbsp;&nbsp;&nbsp;&nbsp;
  <img border="0" src="images/Records.GIF" width="24" height="24">&nbsp;
  </font> <a href="./add_menu.php"><font face=Verdana size=1>Add Record </font></a>  
  </p>
  <p align="center">&nbsp;<font face="Verdana" size="1"><img border="0" src="images/Records.GIF" width="24" height="24"></font><a href="./view_menu.php"><font face=verdana size=1>View Records</font></a>&nbsp;
  <font face="Verdana" size="1">&nbsp;&nbsp;&nbsp;
  <img border="0" src="images/Records.GIF" width="24" height="24"></font><a href="./del_menu.php"><font face=verdana size=1>Delete Record</font></a>
  <font face="Verdana" size="1">&nbsp;&nbsp;&nbsp;
  <img border="0" src="images/Records.GIF" width="24" height="24"></font> <a href="./upd_menu.php"><font face=verdana size=1>Update Record</font></a>&nbsp;
  <img border="0" src="images/home-to.GIF" width="24" height="24"><font face=verdana size=1>&nbsp; <a href="./index.php">Home</a></font>  </a></td></tr></table><br></center>
<?php
include("./config.php");
$table = "users";
$conn = @mysql_connect($server,$user,$password)
	or die("Unable to connect to SQL database...");
$rs = @mysql_select_db($database,$conn) 
	or die("Unable to select the database...Please press 'Create Database' to create new database.");
$sql = " SELECT * from $table";
$rs = mysql_query($sql,$conn)
	or die("Could not execute SQL query!!! Possibly SQL query already been executed.");
$list = "<table border =\"1\" cellpadding =\"2\" align=center>";
$list.="<tr ><th><font face=verdana size=2>User Name</font></th>";
$list.="<th><font face=verdana size=2>First Name</font></th>";
$list.="<th><font face=verdana size=2>User Name</font></th>";
$list.="<th><font face=verdana size=2>Password</font></th>";
$list.="<th><font face=verdana size=2>Email</font></th>";
$list.="<th><font face=verdana size=2>Hint</font></th>";
$list.="<th><font face=verdana size=2>Date Added</font></th></tr>";

while($row = mysql_fetch_array($rs))
{
	$list.= "<tr><font face=verdana size=2>";
	$list.="<td>".$row["username"]."</td>";
	$list.="<td>".$row["firstname"]."</td>";
	$list.="<td>".$row["lastname"]."</td>";
	$list.="<td>".$row["passwrd"]."</td>";
	$list.="<td>".$row["email"]."</td>";
	$list.="<td>".$row["hint"]."</td>";
	$list.="<td>".$row["date_added"]."</td>";
	$list.="</font></tr>";
}
$list.= "</table>";
echo($list);
?>
<br>
<font face=verdana size=2 color=navy>Delete Record from USERS</font>
<form action = "do_deleterec4.php" method = "POST">
User Name: <input type ="text" name = "username">
<input type = "submit" value="Delete Record">
</form>
<br>
<center><img src=images/readme.gif border=0><font face=verdana size=2 color=navy>   Notes for all users:</font></center><br>
<p align=justify><font face=verdana size=2>Below are menu choices for deleting of records from USERS table
Below you are given the choice by answering 'YES' to
delete all users log records or answer 'NO' and no action will be taken.</font></p>
<form action= "./del_users.php" method = "post">
<font face=verdana size=2>Select choice to delete all user logs records ?</font>
<select name = "acts">
<option value = "yes">Yes</option>
<option value = "no">No</option>
</select>
<input type="submit" value="Submit"></form><br>
<center><img src=images/readme.gif border=0><font face=verdana size=2 color=navy>   Notes for all users:</font></center><br>
<p align=justify><font face=verdana size=2>Below are menu choices for deleting of records from USERS table
Below you are given the choice by answering 'YES' to
delete all users records or answer 'NO' and no action will be taken.</font></p>
<form action= "./do_delete4a.php" method = "post">
Select choice to delete all users records ?
<select name = "acts">
<option value = "yes">Yes</option>
<option value = "no">No</option>
</select>
<input type="submit" value="Submit"></form>
<?php include("./your-footer.inc");?>
</BODY>
</HTML>