''); $fldArray = array("patient_oral_id" => $id); $orderArray=array(); $orderType=''; $arr=dataSelect($table,$dataArray,$fldArray,$extra="",$orderArray,$orderType); $patient_oral_status=$arr[0]['patient_oral_status']; $patient_oral_last_modified=$arr[0]['patient_oral_last_modified']; $patient_oral_title=$arr[0]['patient_oral_title']; $patient_oral_content=$arr[0]['patient_oral_content']; $patient_oral_status=$arr[0]['patient_oral_status']; $patient_oral_file=$arr[0]['patient_oral_file']; $patient_oral_image=$arr[0]['patient_oral_image']; if($_POST['submit']=='Save') { $table=TABLE_PATIENT_ORAL; $hidden_patient_oral_id=$_REQUEST['hidden_patient_oral_id']; $patient_oral_status=trim(strip_tags($_POST['patient_oral_status'],ENT_QUOTES)); $patient_oral_last_modified=DATETIME; $patient_oral_title=trim(strip_tags($_POST['patient_oral_title'],ENT_QUOTES)); $patient_oral_content=dataPrepare($_REQUEST['patient_oral_content']); $patient_oral_stat=trim(strip_tags($_POST['patient_oral_status'],ENT_QUOTES)); if($patient_oral_status=='') { $patient_oral_status='Active'; } else { $patient_oral_status=$patient_oral_stat; } $dataArray = array("patient_oral_status"=>$patient_oral_status,"patient_oral_last_modified"=>$patient_oral_last_modified,"patient_oral_title"=>$patient_oral_title,"patient_oral_content"=>$patient_oral_content,"patient_oral_status"=>$patient_oral_status); if($patient_oral_title!='' && $patient_oral_content!='') { /*Edit*/ if($hidden_patient_oral_id!='') { $fldArray = array("patient_oral_id" => $hidden_patient_oral_id); dataUpdate($table,$dataArray,$fldArray); $fileElementName = 'patient_oral_file'; if($_FILES[''.$fileElementName.'']['tmp_name']!='') { $msg = ""; //$idc=base64_decode(base64_decode($_SESSION[session_id()]['press_id'])); $table=TABLE_PATIENT_ORAL; $sql_del="delete from ".$table." where patient_oral_id='".$id."'"; $fileTempName=$_FILES[''.$fileElementName.'']['tmp_name']; $fileName=$_FILES[''.$fileElementName.'']['name']; $imginfo = pathinfo($fileName); $imgExt=$imginfo["extension"]; if(empty($_FILES['patient_oral_file']['tmp_name']) || $_FILES['patient_oral_file']['tmp_name'] == 'none'){ mysql_query($sql_del); $error = 'No File was uploaded'; }elseif($_SESSION[$_REQUEST['ssid']]['id']!=$_SESSION[session_id()]['id']){ mysql_query($sql_del); }elseif($imgExt!='pdf'){ mysql_query($sql_del); $error = "Allowed File Types : pdf
Your File Type : ".$imgExt; }else{ $fileName=$_FILES['patient_oral_file']['name']; $oldfileName=''; $fileSize=filesize($_FILES['patient_oral_file']['tmp_name']); $fileTempName=$_FILES['patient_oral_file']['tmp_name']; $folderPath="../".PATIENT_ORAL_FILE_PATH; $maxSize=20480000; //$codeArr=fileUpload($fileName,$oldfileName,$fileSize,$fileTempName,$folderPath,$maxSize,$imgExt); $codeArr=press_fileUpload($fileName,$oldfileName,$fileSize,$fileTempName,$folderPath,$maxSize,$imgExt); $dataArray=array("patient_oral_file"=>$codeArr[1]); $fldArray=array("patient_oral_id"=>$hidden_patient_oral_id); dataUpdate($table,$dataArray,$fldArray); } } redirect('show_patient_oral.php'); /***********image upload*************/ } } else { if($patient_oral_content=='') { $error= NO_DESC; } if($patient_oral_title=='') { $error= NO_TITLE; } } } ?>
Edit Patients oral
Date Time
Title
Description show(); ?>
   
Upload Pdf
Status