<?php 
//The code is for selecting all patients records in the database
//This selects the database and connects to the database
require_once('Connections/Database.php');
mysql_select_db($database_Database, $Database);
$stat="select * from patients";
$stat2=mysql_query($stat) or die('Error, query failed,we cant select any records');
echo"<table>";
echo"<tr><th></th><th>ID</th><th></th><th>SURNAME</th><th></th><th>FIRSTNAME</th><th></th><th>VILLAGE</th><th></th><td></td><td></td>
 
<th>DEPARTMENT</th><th></th><th>AGE</th><th></th><th>SEX</th><th></th><th>TRIBE</th><th></th><th></th><th></th
 
><th></th><th></th><th></th><th>SYMPTOMS</th><th></th><th></th><th></th><th></th><th></th><th></th><th>DATE</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th>WEIGHT</th><th></th><th></th><th></th><th></th><th>HEIGHT</th><th></th><th></th><th></th><th></th><th>TEMP</th><th></th><th></th><th></th><th></th><th>BLDPRESSURE</th></tr>";
echo"</table>";
echo"<table>";
while ($stat3=mysql_fetch_array($stat2))
{
echo"<tr><th></th><th>$stat3[pID]
 
</th><td></td><td></td><td></td><td></td><td>$stat3[pName]
 
</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>$stat3[pfName]
 
</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>$stat3[village]</td><td></td><td></td><td></td><td>$stat3[dept]
 
</td><td><td></td><td></td><td></td><td></td><td></td><td></td><td></td></td><td></td><td>$stat3[age]
 
</td><td><td></td><td></td><td></td><td></td></td><td></td><td>$stat3[sex]
 
</td><td></th><td></td><td></td><td></td><td></td><td>$stat3[tribe]</td><td></td><td></td><td></td><td></td><td></td><td>$stat3[symptoms]</td><td></td><td></td><td></td><td></td><td></td><td></td><td>$stat3[day]</td><td>$stat3[month]</td><td>$stat3[year]</td><td></td><td></td><td></td><td></td><td>$stat3[wgt]</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>$stat3[hgt]</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>$stat3[temp]</td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>$stat3[bldp]</td></tr>";
 
}
echo"</table>";
 
 
?>

<?php
// This code will use the username entered to open the wellcome page for kawempe health centre
require_once('Connections/Database.php');
mysql_select_db($database_Database, $Database);
//This makes sure they did not leave any fields blank
if (!$_POST['username'] | !$_POST['password'] )
{
die('You did not complete all of the required fields');
}
$a=$_POST['username'];
$b=$_POST['password'];
//This code runs if the form has been submitted
 
if (isset($_POST['SUBMIT']))
{
 
$_POST['username'] = addslashes($_POST['username']);
$sql = "SELECT * FROM admin WHERE username = '$a' AND Password = '$b'";
$result = mysql_query($sql); 
$num=mysql_num_rows($result);
if($num==1){
header("location:admnwelcom.html");
}
if($num < 1) 
 {
$_POST['username'] = addslashes($_POST['username']);
$sql1 = "SELECT * FROM users WHERE username = '$a' AND Password = '$b'";
$result1 = mysql_query($sql1); 
$num=mysql_num_rows($result1);
if($num < 1) //username and password not found
 {
exit("username and password you  entered are not valid.<br>") ;
 
}
 
 
else {
    header("Location:wellcomepage.html");
}
 
}
 
 
 
 
}
?>

 <?php 
//The code is for selecting all patients records in the database where a particular month and year
//This selects the database and connects to the database
require_once('Connections/Database.php');
mysql_select_db($database_Database, $Database);
 
$a=$_POST['monapt'];
$b=$_POST['yearapt'];
$c=&_POST['day']
$stat="select * from patients where month='$a',day='$c' AND year='$b'";
$result1=mysql_query($stat)or die('Error, query failed,we cant select any records');
$count=mysql_num_rows($result1);
 
echo "<pre>          $count  record(s) Found</pre>";
echo"<table >";
while ($result=mysql_fetch_array($result1)) 
{
 
echo"<pre>          Patients number        :$result[pID] <br>
          Patients Names          :$result[pName] $result[pfName] <br>
          Age                     :$result[age] <br>
          Patients lives in       :$result[village] <br> 
          Department Visited      :$result[dept] <br> 
	  Sex                     :$result[sex] <br>
	  Tribe                   :$result[tribe] <br>
	  Presented with          :$result[symptoms] <br>
          Date visited            :$result[month] $result[day] $result[year]<br>
	  Patients Weight         :$result[wgt] Kilograms<br>
	  Patients Height         :$result[hgt] centimetres<br>
	  Temperature             :$result[temp] Degrees centigrade<br>
          Blood Pressure          :$result[bldp]mmhg <br>
	  Doctors ID              :$result[dID] <br>";
 
}
echo"</table>";
 
 
?>