<?php
	$hostname = "localhost";
	$database = 'perizinanOnline';
	$username = 'root';
	$password ='pus4td4t4/2017/1Z1N';
	
	try {
    $conn = new PDO("mysql:host=".$hostname.";dbname=".$database, $username, $password);
	$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );	
    }
catch(PDOException $e)
    {
    echo "Koneksi Database Gagal : " . $e->getMessage();
    }
	
		$stmt = $conn->prepare("INSERT INTO kotaksaran
								(kspUserID, kspIsi, kspJenis, kspTgl, kspStatus) 
								VALUES (:kspUserID, :kspIsi, :kspJenis, :kspTgl, :kspStatus)  "); 
		$data = array(
					':kspUserID'=>$_POST['Nama'].' / '.$_POST['email'],
					':kspJenis'=>$_POST['Jenis'],
					':kspIsi'=>$_POST['message'].'<br>'.'Nama : '.$_POST['Nama'].'<br>'.'Alamat : '.$_POST['Alamat'].'<br>'.'No HP : '.$_POST['phone'],
					':kspTgl'=>date('Y-m-d H:i:s'),
					':kspStatus'=>0
					);
					
		if ($stmt->execute($data)) { 
			header('location:http://dpmptsp.pekanbaru.go.id/Kontak/');
			}else{
			header('location:http://dpmptsp.pekanbaru.go.id/Kontak/');
			}
	
	?>