
<?php

include('config1.php');
/*$a = $_POST[''];
$b = $_POST['product_name'];
$c = $_POST['product_size'];
$d = $_POST['product_price'];
$e = $_POST['product_m_date'];
$z = $_POST['product_e_date'];
*/

$a = "";
$b = $_POST['CustomerName'];
$c = $_POST['CustomerTin'];
$d = $_POST['Address'];
$e = $_POST['EfdSN'];
$f = $_POST['Street'];
$g = $_POST['Phone'];
$h = $_POST['Business'];
$i = $_POST['TaxOffice'];
$j = $_POST['EfdPurchaseDate'];
$k = $_POST['EfdStatus']='NotApplied';
$l = 'FromHQ';
$m = $_POST['amount'];
$n = $_POST['model'];
$o = $_POST['printer'];
$p = $_POST['PaymentMode'];
$z = "EfdDescription10";



$sql = "INSERT INTO defd (DEfdId,CustomerName,CustomerTin,Address,EfdSN,Street,Phone,Business,TaxOffice,EfdPurchaseDate,EfdStatus,soldfrom,Amount,Model,Printer,PaymentMode, EfdDescription) VALUES (:a,:b,:c,:d,:e,:f,:g,:h,:i,:j,:k,:l,:m,:n,:o,:p,:z)";
$q = $db->prepare($sql);
$q->execute(array(':a'=>$a,':b'=>$b,':c'=>$c,':d'=>$d,':e'=>$e,':f'=>$f,':g'=>$g,':h'=>$h,':i'=>$i,':j'=>$j,':k'=>$k,':l'=>$l,':m'=>$m,':n'=>$n,':o'=>$o,':p'=>$p,':z'=>$z));
header("location: addnewefd.php");
exit();

// query



?>