| Server IP : 162.240.98.243 / Your IP : 18.119.28.194 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/public_html/login.easenup.in/ |
Upload File : |
<?php
//insert.php
$connect = new PDO("mysql:host=localhost;dbname=easenuph_hand2secure", "easenuph", "@#admin@#");
$data = array(
':prescriptionid' => $_POST["prescriptionid"],
':patientid' => $_POST["patientid"],
':DRUGS' => $_POST["DRUGS"],
':DRUGS_name' => $_POST["DRUGS_name"],
':Dose' => $_POST["Dose"],
':Category' => $_POST["Category"],
':Composition' => $_POST["Composition"],
':Route' => $_POST["Route"],
':Frequency' => $_POST["Frequency"],
':duration' => $_POST["duration"],
':action' => $_POST["action"]
);
$query = "
INSERT INTO tbl_sample
(prescriptionid, patientid,DRUGS,DRUGS_name,Dose,Category,Composition,Route,Frequency,duration,action)
VALUES (:prescriptionid, :patientid, :DRUGS, :DRUGS_name, :Dose, :Category, :Composition, :Route, :Frequency, :duration,:action)
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$output = array(
'prescriptionid' => $_POST['prescriptionid'],
'patientid' => $_POST['patientid'],
'DRUGS' => $_POST['DRUGS'],
'DRUGS_name' => $_POST['DRUGS_name'],
'Dose' => $_POST['Dose'],
'Category' => $_POST['Category'],
'Composition' => $_POST['Composition'],
'Route' => $_POST['Route'],
'Frequency' => $_POST['Frequency'],
'duration' => $_POST['duration'],
'action' => $_POST['action']
);
echo json_encode($output);
}
?>