// HTML Submit Test Example

// The following code is used for the Online PDF Form Example 
// the PHP Code for this example: http://www.pdfill.com/example/submit/html_submit_test.php

<?php
// Save the name and value pair into a tab limited excel file 
$xlsString = "Field Name\tField Value\n";

    //Remove slash 
    $value1 = stripslashes($value);

   //Save into excel xls string 
   $xlsString .= "$key\t$value1\n";

   //URL Encode
   $value2 = urlencode($value1);

   //Display to the browser
   echo " <tr> <td>$key </td> <td>$value2</td> </tr>";

}

echo 

"</table> <p>If you see your table of names and values, you may have a working PDF form that you can submit into your database just like HTML Form.</p>
<p><font face=\"Verdana\" size=\"2\"><a style=\"color: blue; text-decoration: underline\" href=\"http://www.pdfill.com\"> PDFill</a> Copyright 2002-2007 by <a style=\"color: blue; text-decoration: underline\" href=\"http://www.plotsoft.com/\">PlotSoft L.L.C</a>..&nbsp; All rights reserved</font></p> 
</BODY></HTML>";

// Create an Excel File based on the time stamp
$time = strval(time());
$excelFileName = "$time.xls"; 

//You can use the email as the file name (you must have a field name 'email')
//$email_value = $_POST['email'];
//$excelFileName = "$email_value.xls"; 

// Write into an excel file
$fp = fopen($excelFileName, "w");   
    fwrite($fp, $xlsString, strlen($xlsString)); 
fclose($fp);

?>

/////////////////////////////////////////////////////////////////////////////
//Some other code may be useful to PHP beginner
//If you know your PDF Form has the following field names, you can get the value directly
$first_name_value = $_POST['first_name'];
$last_name_value = $_POST['last_name'];
$email_value = $_POST['email'];


//Code for sending email for checking 
$message = "First Name: $first_name_value ";
$message .= " Last Name: $last_name_value ";

$mailheaders = "From: Your Name<sale@yourname.com>\n";
$mailheaders .= "Reply-To:sale@yourname.com\n\n";

mail("$email_value", "my email title", $message, $mailheaders);

//Database to store your information from Online PDF Form Submit 

// Step 1: create database connection; substitute your own information
$conn = @mysql_connect("localhost", "my database account", "your password") or die (mysql_error());

// Step 2: select database; substitute your own database name
$db = @mysql_select_db("your own database name", $conn) or die(mysql_error());

//Step 3: Check to see if there is a old order
$sql = "SELECT txn_id FROM customers WHERE txn_id = '$txn_id'";
$sql_result = @mysql_query($sql,$conn) or die (mysql_error());

//Step 4: Update or insert the data
if(mysql_num_rows($sql_result) ==1)
{
   // Update an old record
   $sql = "UPDATE customers SET time_stamp = '$time_stamp', parent_txn_id = '$parent_txn_id', receipt_id = '$receipt_id', quantity = '$quantity', item_name = '$item_name', mc_gross = '$mc_gross', payment_date = '$payment_date', payment_status = '$payment_status', payer_email = '$payer_email', first_name = '$first_name', last_name = '$last_name', address_street = '$address_street', address_city = '$address_city', address_state = '$address_state', address_zip = '$address_zip', address_country = '$address_country' where txn_id = '$txn_id'";
   $sql_result = @mysql_query($sql,$conn) or die (mysql_error());
}
else
{
   //It is empty, need to insert, no matter what result inside
   // Add a new record!
   $sql = "INSERT INTO customers ( txn_id, time_stamp, parent_txn_id, receipt_id, quantity, item_name, mc_gross, payment_date, payment_status, payer_email, first_name, last_name, address_street, address_city, address_state, address_zip, address_country ) VALUES ('$txn_id', '$time_stamp', '$parent_txn_id', '$receipt_id', '$quantity', '$item_name', '$mc_gross', '$payment_date', '$payment_status', '$payer_email', '$first_name', '$last_name', '$address_street', '$address_city', '$address_state', '$address_zip', '$address_country' )";
   $sql_result = @mysql_query($sql,$conn) or die (mysql_error());
}

//Display your database information 

// Step 1: create database connection; substitute your own information
$conn = @mysql_connect("localhost", "my database account", "your password") or die (mysql_error());

// Step 2: select database; substitute your own database name
$db = @mysql_select_db("your own database name", $conn) or die(mysql_error());

//Step 3:  Create SQL statement
$sql = "SELECT txn_id, time_stamp, parent_txn_id, address_zip, address_country FROM customers ORDER BY time_stamp DESC";

//Step 4:  execute SQL query and get result
$sql_result = mysql_query($sql, $conn) or die(mysql_error());

//Step 5: format results by row
while ($row = mysql_fetch_array($sql_result)) 
{
   $txn_id = $row['txn_id'];
   $time_stamp = $row['time_stamp'];
   .....

    //use echo to print your information

}

//You can vist here to get php information
http://www.php.net

// How to set up a web server
http://www.apache.org/

//How to add PHP Support for your Web Server
http://www.php.net