| Server IP : 162.240.98.243 / Your IP : 3.17.157.6 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"],
':Category' => $_POST["Category"],
':Dose' => $_POST["Dose"],
':Route' => $_POST["Route"],
':Frequency' => $_POST["Frequency"],
':duration' => $_POST["duration"],
':durationselect' => $_POST["durationselect"],
':potential' => $_POST["potential"],
':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"]
);
$query = "
INSERT INTO medicinede
(prescriptionid, patientid, DRUGS, Category, Dose, Route, Frequency, duration, durationselect, potential, poa, status, Action_med, availability, batchno, entered_by, created_at, updated_at)
VALUES (:prescriptionid, :patientid, :DRUGS, :Category, :Dose, :Route, :Frequency, :duration, :durationselect, :potential, :poa, :status, :Action_med, :availability, :batchno, :entered_by, :created_at, :updated_at)
";
$statement = $connect->prepare($query);
if($statement->execute($data))
{
$output = array(
'prescriptionid' => $_POST['prescriptionid'],
'patientid' => $_POST['patientid'],
'DRUGS' => $_POST['DRUGS'],
'Category' => $_POST['Category'],
'Dose' => $_POST['Dose'],
'Route' => $_POST['Route'],
'Frequency' => $_POST['Frequency'],
'duration' => $_POST['duration'],
'durationselect' => $_POST['durationselect'],
'potential' => $_POST['potential'],
'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']
);
echo json_encode($output);
}
?>