Problems showing form values on thanks page

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Problems showing form values on thanks page

robert Offline

Junior Member

Posts: 1
Threads: 0
Joined: Feb 2011
Reputation: 0

Feb 2nd, 2011, 5:37 AM (This post was last modified: Feb 2nd, 2011, 6:08 AM by 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:
<?php 

<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

Find

« Next Oldest | Next Newest »

Messages In This Thread

Problems showing form values on thanks page - by shala - Jun 28th, 2010, 1:49 PM

RE: Problems showing form values on thanks page - by JanEllen - Jan 26th, 2011, 7:35 AM

RE: Problems showing form values on thanks page - by TechOnPurpose - Jan 28th, 2011, 9:10 AM

RE: Problems showing form values on thanks page - by JanEllen - Jan 28th, 2011, 9:21 AM

RE: Problems showing form values on thanks page - by robert - Feb 2nd, 2011, 5:37 AM

RE: Problems showing form values on thanks page - by Hannes - Feb 5th, 2011, 11:56 AM

RE: Problems showing form values on thanks page - by JMW - Apr 13th, 2011, 9:32 PM

View a Printable Version

Users browsing this thread: 1 Guest(s)

FORUMS