Code: Select all
<?php
<?
include("database.php");
define('HOST', 'localhost');
define('USER', 'root');
define('PASS', '');
define('DB', 'db1');
$nama = $_POST['nama'];
$jawatan = $_POST['jawatan'];
$staffNo = $_POST['StaffNo'];
$unit = $_POST['unit'];
$jenis = $_POST['jenis'];
$datemula = $_POST['datemula'];
$datetamat = $_POST['datetamat'];
$jumlah = $_POST['jumlah'];
$datemohon = $_POST['datemohon'];
$RefID = "L(".$staffNo.")(".$datemohon.")";
global $conn;
$query = "INSERT INTO leave VALUES ('$nama', '$jawatan', '$staffNo', '$unit', '$jenis', '$datemula', '$datetamat', '$jumlah', '$jumlah',
'$datemohon', '$RefID')";
mysql_query($query,$conn);
?>
<br><br><center>YOUR APPLICATION HAVE BEEN SUBMITTED.</center>
?>