Submit to DB & server new page

[cspgsl]

I have a form submitting data to a Db and echoing the results. I would like to have the results echoed and then provide a link to submit another entry on an entirely new page. Right now $_SERVER['../PHP_SELF' is returning the page with the results on it. I suspect atht I want it to return another page but (my newness) I cannot see what must be changed to serve up a new page and still insert the data into the Db.
Thanks,

<?php 

if (!isset($_POST['submit'])) { 
// form not submitted 
?> 

<form action="<?=$_SERVER['../PHP_SELF']?>" method="post"> 
Country: <input type="text" name="country"> 
National animal: <input type="text" name="animal"> 
<input type="submit" name="submit"> 
<input type="hidden" name="redirect" value="http://linkslandgolf.com/store/1r.php">
</form> 

<?php 
} 
else { 
// form submitted 
// set server access variables 
$host = "localhost";
$user = "llgg_test";
$pass = "test";
$db = "llgg_testdb";

// get form input 
    // check to make sure it's all there 
    // escape input values for greater safety 
    $country = empty($_POST['country']) ? die ("ERROR: Enter a country") : mysql_escape_string($_POST['country']); 
    $animal = empty($_POST['animal']) ? die ("ERROR: Enter an animal") : mysql_escape_string($_POST['animal']); 

// open connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// create query 
$query = "INSERT INTO symbols (country, animal) VALUES ('$country', '$animal')"; 

// execute query 
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 

// print message with ID of inserted record 
echo "New record inserted with ID ".mysql_insert_id(); 

// close connection 
mysql_close($connection); 
} 
?> 

[Houdini]

Kind of like this maybe?

// print message with ID of inserted record 
    echo "New record inserted with ID ".mysql_insert_id(); 

// close connection 
mysql_close($connection); 
echo "<a href=\"somepath/somefile.php\">Click to add more</a>";

[devinemke]

you already have the code for the form. why not simply wrap it into a function that you call again on the same page request? here is the basic idea (with some pseudo-code):

<?php
function form()
{
	echo '
	<form action="' . $_SERVER['PHP_SELF'] . '" method="post">
	Country: <input type="text" name="country">
	National animal: <input type="text" name="animal">
	<input type="submit" name="submit">
	</form>
	';
}

if (!isset($_POST['submit']))
{
	// display form
	form();
}
else
{
	// connect to db
	// validate form data
	// run INSERT query
	// echo  confirmation

// display form again
form();
}
?>

[cspgsl]

Never would have figured it to be that simple... Good thing this isn't rocket science... or, is it?
Thanks

[cspgsl]

Sorry devinemke, I am not with you... I'm too new to this

[devinemke]

cspgsl wrote:

Sorry devinemke, I am not with you... I'm too new to this

if i understand correctly what you are trying to do:

1. you are displying a form
2. the user fills out the form and submits
3. the form data is entered into the db
4. you then want the same form to be displayed so the user can insert another record

that is why i suggest to making the code that displays the form into a re-usable function that can be run before the form is submitted and after.

[cspgsl]

I have the form inserting the data into the Db sucessfully but now I want to receive the results by e-mail too. I know that the form cannot have two actions so where might I set the results to be mailed to me?
Thanks

<?php 

if (!isset($_POST['submit'])) { 
// form not submitted 
?> 

<form action="<?=$_SERVER['../PHP_SELF']?>" method="post"> 
<p> 	Customer Name: <input type="text" name="customer_name"></p>
<p>   	Address: <input type="text" name="customer_address"></p>
<p>		Province: <input type="text" name="customer_province"> </p>
<p>    	Phone Number: <input type="text" name="customer_phone"> </p>
		<input name="submit" type="submit" value="Submit">    	
<!--	"<a href="mailto:[e-mail]">[e-mail]</a>"; -->

</form> 

<?php 
} 
else { 
// form submitted 
// set server access variables 
$host = "localhost";
$user = "llgg_tom";
$pass = "tom";
$db = "llgg_info";

// get form input 
    // check to make sure it's all there 
    // escape input values for greater safety 
    $customer_name = empty($_POST['customer_name']) ? die ("ERROR: Enter your name") : mysql_escape_string($_POST['customer_name']); 
    $customer_address = empty($_POST['customer_address']) ? die ("ERROR: Enter address") : mysql_escape_string($_POST['customer_address']); 
    $customer_province = empty($_POST['customer_province']) ? die ("ERROR: Enter your province") : mysql_escape_string($_POST['customer_province']); 
    $customer_phone = empty($_POST['customer_phone']) ? die ("ERROR: Enter your phone number") : mysql_escape_string($_POST['customer_phone']); 

// open connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// create query 
$query = "INSERT INTO user (customer_name, customer_address, customer_province, customer_phone) VALUES ('$customer_name', '$customer_address', '$customer_province', '$customer_phone')"; 

// execute query 
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 

// print message with ID of inserted record 
echo "New record inserted with ID ".mysql_insert_id(); 

// close connection 
mysql_close($connection); 
echo "<a href=\"1r.php\">Click to add more</a>"; 
} 
?> 

[cspgsl]

devinemke wrote:

if i understand correctly what you are trying to do:

1. you are displying a form
2. the user fills out the form and submits
3. the form data is entered into the db
4. you then want the same form to be displayed so the user can insert another record

that is why i suggest to making the code that displays the form into a re-usable function that can be run before the form is submitted and after.

Thanks for the reply. I am formulating this as I go along and I realize how green I really am.
This is really going to be a multi step process where the user will go through an interview of sorts providing details that will ultimately be inserted into a webpage. The user enters data into the form and submits it and this opens a second page where they are to insert more information.
On the 2nd page there is a choice to reveiw what they have entered thus far or submit and move on to the third page... and so on.
In my last post I introduced the idea of sending me an email when the data is submitted to the Db.
Am I making any sense here?
There is no doubt an easier way to do this but again, it's a starting point.
Thanks again

[Houdini]

There is no rule that you can't continue your code and use the $_POST variables and then process them and create an e-mail and do that after you have finished entering the data in to the database, so just come up with what you want to send in the mail and continue within the script you already have.