<?php

 if(isset($_POST['edit_button'])){
    $ID=$_POST['edit_button'];
    $query = "SELECT  PNAME , GENDER, AGE, ADDRESS , PHONENUMBER
    FROM PATIENT LEFT OUTER JOIN PHONENUMBER
    ON PID=EPID AND '$ID'=PID";

    $stid = oci_parse($conn, $query);
    oci_execute($stid);
    $row = oci_fetch_array($stid, OCI_ASSOC+OCI_RETURN_NULLS);

        $patient_name= $row['PNAME'];
        $patient_gender= $row['GENDER'];
        $patient_address= $row['ADDRESS'];
        $patient_age= $row['AGE'];
        $patient_phone= $row['PHONENUMBER'];
    }
?>


 <?php
if(isset($_POST['Edit_Patient'])){
    $new_pname=$_POST['pName'];
    $new_pGender=$_POST['pGender'];
    $new_pAge=$_POST['pAge'];
    $new_pAddress=$_POST['pAddress'];
    $new_phone=$_POST['phone'];
    $update_query=" UPDATE PATIENT
                   SET PNAME= '$new_pname', GENDER= '$new_pGender', AGE=$new_pAge, ADDRESS='$new_pAddress'
                   WHERE PID= '$ID'";
    $stid = oci_parse($conn, $update_query);
    $result=oci_execute($stid);
    if (!$result) {
        echo oci_error();
    }

}