Edit: tbc_request

Editing: tbc_request_add.php

Kembali

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

$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;
	$nor=$_POST["idpat"];
	$lssn=$_POST["lssn1"];
	if (empty($lssn)){
		$_SESSION['error'] = $conn->error;
		header('location: tbc_request.php');
		exit;
	}
	$lssn=$_POST["lssn1"];
	$tssn=$_POST["tssn1"];
   
   	$aldeia1=$_POST["aldeia1"];
	$chefefamilia1=$_POST["chefefamilia1"];
	$statushiv1=$_POST["statushiv1"];
	$aspasien1=$_POST["aspasien1"];
	$todan1=$_POST["todan1"];
	$vasinabcg1=$_POST["vasinabcg1"];
	$bmi1=$_POST["bmi1"];
	$vitalila1=$_POST["vitalila1"];
	$durasaunhela1=$_POST["durasaunhela1"];
	$aimoruk1=$_POST["aimoruk1"];
	$morasuluk1=$_POST["morasuluk1"];
	$pg1=$_POST["pg1"];
	$pg2=$_POST["pg2"];
	$pg3=$_POST["pg3"];
	$pg4=$_POST["pg4"];
	$pg5=$_POST["pg5"];
	$pg6=$_POST["pg6"];
	$pg7=$_POST["pg7"];
	$pg8=$_POST["pg8"];
	$pg9=$_POST["pg9"];
	$pg10=$_POST["pg10"];
	$pg11=$_POST["pg11"];
	$pg12=$_POST["pg12"];

$sql="INSERT INTO tbc_test VALUES ('','$nor','$lssn', '$tssn', '$datetime','$aldeia1','$chefefamilia1','$statushiv1','$aspasien1',
          '$todan1','$vasinabcg1',
          '$bmi1','$vitalila1',
          '$durasaunhela1','$aimoruk1','$morasuluk1','$pg1',
          '$pg2','$pg3','$pg4','$pg5','$pg6',
          '$pg7','$pg8','$pg9','$pg10','$pg11','$pg12')";
		if($conn->query($sql)){
			$_SESSION['success'] = 'TBC Test added successfully';
		}
		else{
			$_SESSION['error'] = $conn->error;
		}

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