interface/patient_file/summary/patient_picture.php

   1 <?
   2 require_once("../../globals.php");
   3 require_once("$srcdir/sql.inc");
   4 function pic_array() {
   5     $picture_directory = "Patient Photograph"; //change this if you want
   6     $pics = array();
   7     $sql_query = "select documents.url, documents.id from documents join categories_to_documents on documents.id = categories_to_documents.document_id join categories on categories.id = categories_to_documents.category_id where categories.name like '$picture_directory' and documents.foreign_id = ".$_SESSION['pid'];
   8     if ($query = sqlStatement($sql_query)) {
   9       $filename = '';
  10       while ($results = mysql_fetch_array($query)) {
  11         $expl = explode("/",$results['url']);
  12         $filename = $expl[sizeof($expl)-1];
  13         $doc_id = $results['id'];
  14         array_push($pics,"<iframe border='0' frameborder='0' style='border:none;' width='320' height='240' type='image/pjpeg' src='/openemr/controller.php?document&retrieve&patient_id=".$pid."&document_id=".$doc_id."&".$filename."&as_file=true'></iframe>");
  15       }
  16     }
  17     return $pics;
  18 }
  19 ?>