Problems showing form values on thanks page

[shala]

First of all, thanks Ben for this excellent tool.

Everything is going great, except for one last detail: we'd like the "thank you" page to display the form values so the user can print them. However, I can't get the values to show up. I've followed the tutorial and looked into past threads about the issue, but I still only get a blank space on my thank you page where the php coding is. It doesn't show any errors and the form otherwise submits as it should. I've noticed that up in the URL, a submission id is displayed but not a unique key (it's just blank after &unique_key=)

I'm new to Form Tools and PHP so I'm probably just missing something obvious somewhere! I appreciate any help, thanks.

At the top of the form page:

PHP Code:

<?php
require_once("/data/18/1/10/67/1662067/user/1792427/htdocs/ourforms/global/api/api.php");
 $fields = ft_api_init_form_page(1);

$submission_id = $fields["form_tools_submission_id"];
$unique_key = $fields["unique_key"];

$params = array(
  "submit_button" => "Submit",
  "next_page" => "templates/giftcertificatesuccess.php?submission_id=$submission_id&unique_key=$unique_key",
  "form_data" => $_POST,
  "finalize" => true
    );
ft_api_process_form($params);
?>

At the top of the thanks page:

PHP Code:

<?php
require_once("/data/18/1/10/67/1662067/user/1792427/htdocs/ourforms/global/api/api.php");
$fields = ft_api_init_form_page();
ft_api_clear_form_sessions();
?>

In the thanks page:

PHP Code:

<?php
if (isset($_GET["submission_id"]) && isset($_GET["unique_key"]))
{
  $form_id = 1;
  $view_id = 1;
  $export_type_id = 3;
 
  $submission_info = ft_api_get_submission($form_id, $_GET["submission_id"]);
 
  // now confirm that the unique_key matches
  if (isset($submission_info["unique_key"]) && 
    $submission_info["unique_key"] == $_GET["unique_key"])
  {
    ft_api_show_submission($form_id, $view_id, $export_type_id, $_GET["submission_id"]);
  }    
}
?>

[JanEllen]

This is the exact same scenario that I am trying to accomplish as well. I would like for our Thank You page to display the contents of the form all filled out so that the user can print it out, because there is a signature line at the bottom where they need to sign and date and mail back to us.

Any clues on how to go about this. I know only a tiny bit of PHP (I am basically a graphic designer - trying to be a programmer...lol...) but am willing to learn what I need to pull this off... If anyone out there can help, I would be OH so appreciative!

Our form is quite lengthy (I didn't put it into multiple pages because that just seemed too complicated for me...lol) but I REALLY need to "re-display" the completed form in its entirety so the user may print it out. OR, alternatively, maybe export to a PDF? (if there's a way to do that? if not, no biggie...)

Thanks in advance!

[TechOnPurpose]

Hi,
I'm new to Form Tools, but I think I can answer this question.

The problem is that you are following the suggested placement of the session and field reset code.

At the top of the thank you page, only put the code:

PHP Code:

<?php
require_once("/data/18/1/10/67/1662067/user/1792427/htdocs/ourforms/global/api/api.php");
$fields = ft_api_init_form_page();
// according to the api docs, this may have to be $fields = ft_api_init_form_page(X); where X is the form ID. See the documentation page on the function ft_api_clear_form_sessions().
?>

Then at the very bottom of your thank you page, put:

PHP Code:

<?php
ft_api_clear_form_sessions();
?>

What is happening is that you are clearing the session info and post fields before you display them.

I hope this works for you. I haven't tried it, but it seems to be the logical reason for your failure to be able to print the data.

[JanEllen]

Thanks, I ended up just ditching the API method and using the Direct one. I was able to make it work.

I am not sure that would have worked, maybe? It never was even getting to the Thank You page... it stayed on the application form page and just showed a blank white page.

Anyway, I decided that we could get away with using the Direct method for now, in the interest of getting this thing working. ;-)

---

Oh, and I also decided to have it just email the user instead of them printing the screen results since I could not figure that part out. ;-)

[robert]

Hi,

I'm new to this forum but think I can help with a solution.

First of all create a Connections folder with following php file (dbf.php) in it

PHP Code:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_dbf = "localhost";
$database_dbf = "your_database_name";
$username_dbf = "the_database_user_name";
$password_dbf = "the_database_user_password";
$dbf = mysql_pconnect($hostname_dbf, $username_dbf, $password_dbf) or trigger_error(mysql_error(),E_USER_ERROR); 
?>

Let your 'thanks' page start with following PHP code
(replace 'dbf' on filename and code with any name of your choice)

PHP Code:

<?php require_once('Connections/dbf.php'); ?>
<?php 
session_start();

   mysql_select_db($database_dbf, $dbf);
    
   $query_rsAnyName = "SELECT * FROM ft_form_1 ORDER BY submission_id DESC";
                      
   $rsAnyName = mysql_query($query_rsAnyName, $dbf) or die(mysql_error());
   $row_rsAnyName = mysql_fetch_assoc($rsAnyName);
   $totalRows_rsAnyName = mysql_num_rows($rsAnyName);

   $cfieldname1  = $row_rsAnyName['col_1'];   
   $cfieldname2  = $row_rsAnyName['col_2']; 

?>

The $cfieldname variables are those you wish to show wherever on your thanks page. For example if you wish to show a submitted Name and E-mail address:

PHP Code:

<table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr>
                    <td width="22%">Name</td>
                    <td width="78%"><?php print $cfieldname1; ?></td>
                  </tr>
                  <tr>
                    <td>E-mail</td>
                    <td><?php print $cfieldname2; ?></td>
                  </tr>

</table> 


Hope this helps. It works fine on my thanks pages.

Cheers,
Robert

[Hannes]

Hi Robert,

one solution can also be to use http_get_vars...
on the last page of the form you modify the parameter "next_page"...

PHP Code:

"next_page" => "submit.php?variable=".$fields['myfield'], 


and on the submit page you use...

PHP Code:

<?php
echo $HTTP_GET_VARS["variable"];
?>

Cheers,
Hannes

[JMW]

Hi, I'm relatively new to form tools.
But I have been using the "registration" demo form as a guide in creating my own form. The third page of the demo is a review page that displays all the form content entered and provides the option to print it out. Could that be the answer your looking for?