<?php

//Initial Setup to connect to Database later. Simple login used with no password.
//In a real database with security issues setup the users in PHPMYADMIN for more
//secure connections
$username="luke";
$database="assignmentdatabase";

//Connect to the database
mysql_connect('localhost',$username);
@mysql_select_db($database) or die("Unable to Select database");

//Declare a null value to be used
$sort="";

//Assign a sort method, if nothing has been posted in then this defaults to Server Name
if (isset($_POST['Server']))
{
  $sort="Server_Name";
}
else if (isset($_POST['Admin']))
  {
    $sort='Admin';
  }
  else if (isset($_POST['Location']))
  {
    $sort='Location';
  }
  else
  {
    $sort='Server_Name';
  }

//Define the search query, run it and grab how many results we find
$servers="SELECT * FROM server ORDER BY '.$sort.'";
$archives="SELECT * FROM archive ORDER BY '.$sort.'";
$result1=mysql_query($servers);
$result2=mysql_query($archives);
$num=mysql_numrows($result1);
$num2=mysql_numrows($result2);
//Check if there are any servers found, if not then database must be empty
if($num<=0)
{
  echo("No servers currently in the database. Please check that at least one server has been input");
}

//Else we loop through and show the server names
else
{
  //Two counters to control stepping through each area
  $x=0;
  $y=0;
  while($x<$num)
  {
?>
    <dt>Server Name:        </dt> <dd><input type="text" name="Server_Name: " value="<?php echo mysql_result($result1,$x,['Server_Name']); ?>"></dd>
    <dt>Location:           </dt> <dd><input type="text" name="Location"value="<?php echo mysql_result($result1,$x,['Location'] ); ?>"></dd>
    <dt>MAC Address:        </dt> <dd><input type="text" name="MAC"value="<?php echo mysql_result($result1,$x,['MAC']); ?>"></dd>
    <dt>Port Number:        </dt> <dd><input type="text" name="Port"value="<?php echo mysql_result($result1,$x,['Port']); ?>"></dd>
    <dt>IP Address:         </dt> <dd><input type="text" name="IP" value="<?php echo mysql_result($result1,$x,['IP']); ?>"></dd>
    <dt>Operating System:   </dt> <dd><input type="text" name="Operating_System" value="<?php echo mysql_result($result1,$x,['Operating_System']); ?>"></dd>
    <dt>Admin Name:         </dt> <dd><input type="text" name="Admin" required value="<?php echo mysql_result($result1,$x,['Admin']); ?>"></dd><br>
    <dt>Contact number:     </dt> <dd><input type="text" name="Contact_Number" required value="<?php echo mysql_result($result1,$x,['Contact_Number']); ?>"></dd>
    <dt>Email:              </dt> <dd><input type="email" name="Email" required value="<?php echo mysql_result($result1,$x,['Email']); ?>"></dd>
    <dt>  Secondary Contact:</dt> <dd><input type="text" name="Contact2" value="<?php echo mysql_result($result1,$x,['Contact2']); ?>"></dd>
    <dt>Contact number:     </dt> <dd><input type="text" name="Contact_Number2" value="<?php echo mysql_result($result1,$x,['Contact_Number2']); ?>"></dd>
    <dt>Comments:           </dt> <dd><input type="text" name="Comments" value="<?php echo mysql_result($result1,$x,['Comments']); ?>"></dd>

<?php
    //Increase the counter
    ++$x;
  }
  //This loops through archive servers
  while($y<$num2)
  {
    echo "Server:", mysql_result($result2,$y,['Server_Name']), "<br>";
    ++$y;
  }
}
//Close database
mysql_close();
?>