<?php
session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
$narayan=LoginManager::currentUser();
$usertype23=LoginManager::getUserTypeByuname("$narayan");
$connect = new PDO("mysql:host=localhost;dbname=easenuph_hand2secure", "easenuph", "@#admin@#");

$query = "
INSERT INTO medicinede
(prescriptionid,patientid,DRUGS,Dose,Route,Frequency,duration,poa,status,Action_med,availability,batchno,entered_by,created_at,updated_at) 
VALUES (:prescriptionid, :patientid, :DRUGS, :Dose, :Route, :Frequency, :duration, :poa, :status, :Action_med, :availability, :batchno, :entered_by, :created_at, :updated_at)
";
$usertype=$usertype23;
for($count = 0; $count<count($_POST['hidden_prescriptionid']); $count++)
{
	$data = array(
		':prescriptionid'	=>	$_POST['hidden_prescriptionid'][$count],
	      ':patientid'	=>	$_POST['hidden_patientid'][$count],
	       ':DRUGS'	=>	$_POST['hidden_DRUGS'][$count],
	       ':Dose'	=>	$_POST['hidden_Dose'][$count],
	       ':Route'	=>	$_POST['hidden_Route'][$count],
            ':Frequency'	=>	$_POST['hidden_Frequency'][$count],
	         ':duration'	=>	$_POST['hidden_duration'][$count],	
	         ':poa'	=>	$_POST['hidden_poa'][$count],
	         ':status'	=>	$_POST['hidden_status'][$count],
	         ':Action_med'	=>	$_POST['hidden_Action_med'][$count],
	         ':availability'	=>	$_POST['hidden_availability'][$count],
	         ':batchno'	=>	$_POST['hidden_batchno'][$count],
	         	':entered_by'=>$usertype,
	         	  ':created_at'=>date("F d, Y / h:i:s A"),
	         	':updated_at'=>date("F d, Y / h:i:s A"),
             
	 
	);
	$batchno=$usertype;
	$statement = $connect->prepare($query);
	$statement->execute($data);
}

?>