<?php
$conn= pg_connect("host=localhost dbname=session user=postgres password=moira port=5432");
if($conn){
echo "Success";
}
else{
echo "Failed";
}
?>

<?php

if(isset($_POST['insert']))
{
include 'pgcon.php';
$level = pg_escape_string($_POST['level']);
$type =  pg_escape_string($_POST['type']);
$bd =    pg_escape_string($_POST['bd']);
$jc =    pg_escape_string($_POST['jc']);
$aa =    pg_escape_string($_POST['aa']);

$user1 = pg_escape_string($_POST['user1']);
$area1a = pg_escape_string($_POST['area1a']);
$date1a = pg_escape_string($_POST['date1a']);
$date2a = pg_escape_string($_POST['date2a']);

$area1b = pg_escape_string($_POST['area1b']);
$user1b = pg_escape_string($_POST['user1b']);
$date2b = pg_escape_string($_POST['date2b']);





$q=" INSERT INTO request (req_lvl,req_type,req_desc,req_jchange,req_area1,req_area2,req_aff_area,req_date) VALUES ('".$level."','".$type."','".$bd."','".$jc."','".$aa."')";
$qq="INSERT INTO emp_requestor(emp_name_r,emp_dept_area,emp_datesent_r,emp_dateexp_r) VALUES ('".$user1."', '".$area1a."','".$date1a."','".$date2a."')";
$qqq="INSERT INTO emp_endorser(emp_name,emp_dept_area,date_received) VALUES ('".$area1b."', '".$user1b."', '".$date2b."')";

$result= pg_query($q);
$result= pg_query($qq);
$result= pg_query($qqq);

if($result)
{
    echo ("Data Inserted");
}
}
?>