<?php
include("dbconnection.php");
if(isset($_POST[submitpat]))
{
	$sql ="INSERT INTO patient(patientname,admissiondate,admissiontime,address,mobileno,gender,dob) values('$_POST[patientname]','$_POST[admissiondate]','$_POST[admissiontime]','$_POST[address]','$_POST[mobilenumber]','$_POST[select]','$_POST[dateofbirth]')";
	if($qsql = mysqli_query($con,$sql))
	{
		echo "<script>alert('patients record inserted successfully...');</script>";
	}
	else
	{
		echo mysqli_error($con);
	}
}

if(isset($_GET[editid]))
{
	$sql="SELECT * FROM patient WHERE patientid='$_GET[editid]' ";
	$qsql = mysqli_query($con,$sql);
	$rsedit = mysqli_fetch_array($qsql);
	
}
?>
<?php
if(!isset($_GET[patientid]))
{
?>

<form method="post" action="" name="frmpatdet" onSubmit="return validateform()">
      <table width="808" border="1">
      <tbody>
     <tr>
                <td width="17%"><strong>Patient Name </strong></td>
                <td width="41%"><input type="text" name="patientname" id="patientname"/></td>
                <td width="16%"><strong>Patient ID</strong></td>
                <td width="26%"><input type="text" name="patientid" id="patientid" /></td>
        </tr>
              <tr>
                <td><strong>Address</strong></td>
                <td align="right"><textarea name="address" id="address" cols="45" rows="5"> </textarea></td>
                <td><strong>Gender</strong></td>
                <td><label for="select"></label>
                  <select name="select" id="select">
                    <option value="">Select</option>
                    <option value="Male">Male</option>
                    <option value="Female">Female</option>
                  </select></td>
              </tr>
              <tr>
                <td><strong>Contact Number</strong></td>
                <td><input type="text" name="mobilenumber" id="mobilenumber"/></td>
                <td><strong>Date Of Birth </strong></td>
                <td><input type="date" name="dateofbirth" id="dateofbirth" /></td>
              </tr>
              <tr>
                <td colspan="4" align="center"><input type="submit" name="submitpat" id="submitpat" value="Submit" /></td>
              </tr>
        </tbody>
  </table>       
    </form>
<?php
}
else
{
$sqlpatient = "SELECT * FROM patient where patientid='$_GET[patientid]'";
$qsqlpatient = mysqli_query($con,$sqlpatient);
$rspatient=mysqli_fetch_array($qsqlpatient);
?>

    <table border="1">
      <tbody>
        <tr>
          <td width="16%"><strong>Patient Name </strong></td>
          <td width="34%">&nbsp;<?php echo $rspatient[patientname]; ?></td>
          <td width="16%"><strong>Patient ID</strong></td>
          <td width="34%">&nbsp;<?php echo $rspatient[patientid]; ?></td>
        </tr>
        <tr>
          <td><strong>Fathers/Husband Name </strong></td>
          <td>&nbsp;<?php echo $rspatient[HusbandName]; ?></td>
          <td><strong>Gender</strong></td>
          <td> <?php echo $rspatient[gender];?></td>
		  
        </tr>
		<tr>
          <td><strong>Weight</strong></td>
          <td>&nbsp;<?php echo $rspatient[Weight]; ?></td>
          <td><strong>Height </strong></td>
          <td> <?php echo $rspatient[Height];?></td>
		  
        </tr>
        <tr>
          <td><strong>Contact Number</strong></td>
          <td>&nbsp;<?php echo $rspatient[mobileno]; ?></td>
          <td><strong>Date Of Birth </strong></td>
          <td>&nbsp;<?php echo $rspatient[dob]; ?></td>
        </tr>
		<tr>
          <td><strong>Blood Group</strong></td>
          <td>&nbsp;<?php echo $rspatient[bloodgroup]; ?></td>
          <td><strong>Nationality </strong></td>
          <td>&nbsp;<?php echo $rspatient[Nationality]; ?></td>
        </tr>
		<tr>
          <td><strong>Marital Status</strong></td>
          <td>&nbsp;<?php echo $rspatient[Marital]; ?></td>
          <td><strong>Mother tough </strong></td>
          <td>&nbsp;<?php echo $rspatient[Mother]; ?></td>
        </tr>
		<tr>
          <td><strong>Religion</strong></td>
          <td>&nbsp;<?php echo $rspatient[Religion]; ?></td>
          <td><strong>Occupation </strong></td>
          <td>&nbsp;<?php echo $rspatient[Occupation]; ?></td>
        </tr>
		<tr>
          <td><strong>Family income </strong></td>
          <td>&nbsp;<?php echo $rspatient[Familyinc]; ?></td>
          <td><strong>Education Qualification  </strong></td>
          <td>&nbsp;<?php echo $rspatient[Education]; ?></td>
        </tr>
		<tr>
          <td><strong>Passport Number  </strong></td>
          <td>&nbsp;<?php echo $rspatient[Passport]; ?></td>
          <td><strong>AadharNumber   </strong></td>
          <td>&nbsp;<?php echo $rspatient[AadharNumber]; ?></td>
        </tr>
		
      </tbody>
    </table>
<?php
}
?>
<script type="application/javascript">
function validateform()
{
	if(document.frmpatdet.patientname.value == "")
	{
		alert("Patient name should not be empty..");
		document.frmpatdet.patientname.focus();
		return false;
	}
	else if(document.frmpatdet.patientid.value == "")
	{
		alert("Patient ID should not be empty..");
		document.frmpatdet.patientid.focus();
		return false;
	}
	else if(document.frmpatdet.admissiondate.value == "")
	{
		alert("Admission date should not be empty..");
		document.frmpatdet.admissiondate.focus();
		return false;
	}
	else if(document.frmpatdet.admissiontime.value == "")
	{
		alert("Admission time should not be empty..");
		document.frmpatdet.admissiontime.focus();
		return false;
	}
	else if(document.frmpatdet.address.value == "")
	{
		alert("Address should not be empty..");
		document.frmpatdet.address.focus();
		return false;
	}
	else if(document.frmpatdet.select.value == "")
	{
		alert("Gender should not be empty..");
		document.frmpatdet.select.focus();
		return false;
	}
	else if(document.frmpatdet.mobilenumber.value == "")
	{
		alert("Contact number should not be empty..");
		document.frmpatdet.mobilenumber.focus();
		return false;
	}
	else if(document.frmpatdet.dateofbirth.value == "")
	{
		alert("Date Of Birth should not be empty..");
		document.frmpatdet.dateofbirth.focus();
		return false;
	}
	
	else
	{
		return true;
	}
}
</script>