<? 
header("Content-type: image/gif");
include"../include/conn.php";
  $sql = "SELECT PICTURE FROM fpoe_2025_ac where CNIC='". $_GET["cnic"]."'"; 
//echo $sql;exit;
  $stmt = OCIParse ($conn, $sql);
  OCIExecute($stmt, OCI_DEFAULT);
  OCIFetchInto($stmt, $arr, OCI_ASSOC+OCI_RETURN_LOBS);
  $result = $arr['PICTURE'];
  
  if (strlen($result)<=0) 
  {
	  $sql = "SELECT GR_PHOTO FROM new_gr_app_master_12_2017 where NTC_GR_APPLICANT_ID=". $_GET["userId"].""; 
	  $stmt = OCIParse ($conn, $sql);
	  OCIExecute($stmt, OCI_DEFAULT);
	  OCIFetchInto($stmt, $arr, OCI_ASSOC+OCI_RETURN_LOBS);
	  $result = $arr['GR_PHOTO'];
  }
  if (strlen($result)>0) 
    echo $result;
  else {
$fp = fopen("../images/nopic.gif", 'rb');
header("Content-Type: image/png");
header("Content-Length: " . filesize($name));
fpassthru($fp);
exit;}
?>