<?php
$host        = "192.168.1.1";
$port        = "5432";
$dbname      = "POS";
$username = "postgres";
$password = "postgres";

$dsn = "pgsql:host = $host; port = $port; dbname = $dbname; user = $username; password = $password";

try{
 	// create a PostgreSQL database connection
	$conn = new PDO($dsn);

	// set the PDO error mode to exception
	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

 	// display a message if connected to the PostgreSQL successfully
	if($conn){
		// echo "Connected to the "; echo $host; echo " database successfully!";

		$mSQL = "INSERT INTO Order_Head (CO_NO, CO_CUNO, CO_CUNM, CO_VRNO, CO_CORG, CO_TERM, CO_DATE, CO_PYDT, CO_DLRY, CO_CUA1, CO_CUA2, CO_USER, CO_PO, CO_FLAG)
		VALUES (:CO_NO, :CO_CUNO, :CO_CUNM, :CO_VRNO, :CO_CORG, :CO_TERM, :CO_DATE, :CO_PYDT, :CO_DLRY, :CO_CUA1, :CO_CUA2, :CO_USER, :CO_PO, :CO_FLAG)";

		// prepare sql and bind parameters
		$mQuery = $conn->prepare($mSQL);

		$mCO_NO = "180010001";
		$mCO_CUNO = "TH01050485";
		$mCO_CUNM = "บจก";
		$mCO_VRNO = "0105545116515";
		$mCO_CORG = "00000";
		$mCO_TERM = "30 Days";
		$mCO_DATE = "2018-04-02";
		$mCO_PYDT = "2018-05-04";
		$mCO_DLRY = "Cash Van";
		$mCO_CUA1 = "โรงแรม";
		$mCO_CUA2 = "แขวงวัดพระยาไกร";
		$mCO_USER = "TEST";
		$mCO_PO = "001";
		$mCO_FLAG = "5";

		$mQuery->bindParam(':CO_NO', $mCO_NO);
		$mQuery->bindParam(':CO_CUNO', $mCO_CUNO);
		$mQuery->bindParam(':CO_CUNM', $mCO_CUNM);
		$mQuery->bindParam(':CO_VRNO', $mCO_VRNO);
		$mQuery->bindParam(':CO_CORG', $mCO_CORG);
		$mQuery->bindParam(':CO_TERM', $mCO_TERM);
		$mQuery->bindParam(':CO_DATE', $mCO_DATE);
		$mQuery->bindParam(':CO_PYDT', $mCO_PYDT);
		$mQuery->bindParam(':CO_DLRY', $mCO_DLRY);
		$mQuery->bindParam(':CO_CUA1', $mCO_CUA1);
		$mQuery->bindParam(':CO_CUA2', $mCO_CUA2);
		$mQuery->bindParam(':CO_USER', $mCO_USER);
		$mQuery->bindParam(':CO_PO', $mCO_PO);
		$mQuery->bindParam(':CO_FLAG', $mCO_FLAG);

		$mQuery->execute();

	}
}catch (PDOException $e){
 // report error message
	echo $e->getMessage();
}

$conn = null;

?>