Edit: consul_add - Copy.php

Editing: consul_add - Copy.php

Kembali

<?php
	session_start();
	include 'includes/session.php';

$userid=$_SESSION["userID"];
	$id_login= $_SESSION["uc"];
	
	//if ($id_login == 2){
		//$uid=$userid;
	//}else{
	//	$uid=$_POST["doctorssn"];
	//}
	
   	$newdate=date_Create($_POST["date"]);
   	$date=date_format($newdate,"Y-m-d");
   	$newtime=date_Create($_POST["time"]);
   	$time=date_format($newtime,"H:i:s");
   	$datetime=$date." ".$time;
	$pssn=$_POST["pssn"];
	$doctorssn=$_POST["doctorssn"];
   	$comp=$_POST["complains1"];
   	$find=$_POST["finding1"];
   	$treat=$_POST["treatment1"];
   	$meds=$_POST["meds2"];
   	$alg=$_POST["allergies1"];

$sql="INSERT INTO consultation (Patient_SSN, Doctor_SSN, Date_Time,
       Complains, Findings, Treatments, Medicines, Allergies)
       VALUES ('$pssn', '$doctorssn', '$datetime',
         '$comp', '$find',
          '$treat', '$meds','$alg')";
		if($conn->query($sql)){
			$_SESSION['success'] = 'Consultation added successfully';
		}
		else{
			$_SESSION['error'] = $conn->error;
		}

header('location: consul.php');
?>