<?php

//insert_data.php

include('database_connection.php');

if(isset($_POST["prescriptionid"]))
{
 $error = '';
 $success = '';
 $prescriptionid = '';
 $patientid = '';
 $DRUGS = '';
 $Category = '';
  $Dose = $_POST["Dose"];
   $Route = $_POST["Route"];
    $Frequency =$_POST["Frequency"];  
    $duration=$_POST["duration"];
    $durationselect =$_POST["durationselect"];
    $poa=$_POST["poa"];
    $status=$_POST["status"];
    $Action_med=$_POST["Action_med"];
    $availability=$_POST["availability"];  
    $batchno=$_POST["batchno"];
     $entered_by=$_POST["entered_by"]; 
      $created_at=$_POST["created_at"];  
       $updated_at=$_POST["updated_at"];  
 if(empty($_POST["prescriptionid"]))
 {
  $error .= '<p>prescriptionid is Required</p>';
 }
 else
 {
  $prescriptionid = $_POST["prescriptionid"];
 }
 if(empty($_POST["patientid"]))
 {
  $error .= '<p>patientid is Required</p>';
 }
 else
 {
  $patientid = $_POST["patientid"];
 }
 if(empty($_POST["DRUGS"]))
 {
  $error .= '<p>DRUGS is Required</p>';
 }
 else
 {
  $DRUGS = $_POST["DRUGS"];
 }
 if(empty($_POST["Category"]))
 {
  $error .= '<p>Category is Required</p>';
 }
 else
 {
  $Category = $_POST["Category"];
 }

 if($error == '')
 {
  $data = array(
   ':prescriptionid'   => $prescriptionid,
   ':patientid'  => $patientid,
':DRUGS' => $DRUGS,
   ':Category'   => $Category,
      ':Dose'  => $Dose,
    ':Route' => $Route,    
    ':Frequency' => $Frequency,  
    ':duration' => $duration,  
    ':durationselect' => $durationselect,  
    ':poa' => $poa,  
    ':status' => $status,  
    ':Action_med' => $Action_med,  
    ':availability' => $availability,  
    ':batchno' => $batchno,  
     ':entered_by' => $entered_by,  
      ':created_at' => $created_at,  
       ':updated_at' => $updated_at  
  );

  $query = "
  INSERT INTO medicinede 
  (prescriptionid, patientid, DRUGS, Category,Dose,Route,Frequency,duration,durationselect,poa,status,Action_med,availability,batchno,entered_by,created_at,updated_at) 
  VALUES (:prescriptionid, :patientid, :DRUGS, :Category, :Dose, :Route, :Frequency, :duration, :durationselect, :poa, :status, :Action_med, :availability, :batchno, :entered_by, :created_at, :updated_at)
  ";
  $statement = $connect->prepare($query);
  $statement->execute($data);
  $success = 'Employee Data Inserted';
 }
 $output = array(
  'success'  => $success,
  'error'   => $error
 );
 echo json_encode($output);
}

?>