[Resolved] Posting form values and link creation

bulldog317

My Current Setup:

I have a form that the user fills out and submits. The user receives a confirmation or "fix the errors" message, the values are stored into my MySQL database and an e-mail is sent to me with the information just posted.

What I want to do is have the information not only stored into my MySQL database but posted to a webpage, for example, and instead of having all the values sent in an e-mail, I would like for a link to this webpage automagically sent in an e-mail. The reason for this is I would also add radio buttons to this webpage for a "I have read" kind of set up. I'm assuming I would need a new page everytime as the information will change with each new posting.

Here is my form:

<html>
<head>
<title>Memo</title>
<link rel="stylesheet" href="style.css" >
</head>
<body bgcolor="#FFFFFF">
<form enctype='multipart/form-data' action='process.php' method='post'>
<table border=0>
<tr>
<td>Prepared By:</td><td><select name='staff'><option value='user'>User
<option value='user2'>User2</select></td>
</tr>
<tr>
<td>Case No.:</td><td><input type=text name='cnum'>*</td>
</tr>
<tr>
<td>Boss:</td><td><select name='boss'><option value='boss1'>Boss1
<option value='boss2'>Boss2</select></td>
</tr>
<tr>
<td>Jury Demand:</td><td><select name='jury'><option value='Yes'>Yes<option value='No'>No
<option value='Unknown'>Unknown<option value='Not Applicable'>Not Applicable</select></td>
</tr>
<tr>
<tr>
<td>Rate:</td><td><input type=text name='rate'></td>
</tr>
<tr>
<td>Comments:</td><td><textarea name='comments' rows=6 cols=70></textarea></td>
</tr>
</table><br>
<input type=submit value='Submit Form'> <input type=reset value='Reset Form'></form>

And here's the process.php file as referenced in the above form:

<?
include("global.inc.php");
$errors=0;
$error="The following errors occured while processing your form input.<ul>";
pt_register('POST','staff');
pt_register('POST','cnum');
pt_register('POST','boss');
pt_register('POST','jury');
pt_register('POST','rate');
pt_register('POST','comments');
$comments=preg_replace("/(\015\012)|(\015)|(\012)/"," <br />", $comments);if($staff=="" || $cnum=="" || $boss=="" ){
$errors=1;
$error.="<li>You did not enter one or more of the required fields. Please go back and try again.";
}
if($errors==1) echo $error;
else{
$where_form_is="http".($HTTP_SERVER_VARS["HTTPS"]=="on"?"s":"")."://".$SERVER_NAME.strrev(strstr(strrev($PHP_SELF),"/"));
$message="Prepared By: ".$staff."
Case No.: ".$cnum."
Boss: ".$boss."
Jury: ".$jury."
Rate: ".$rate."
Comments: ".$comments."
";
mail("me@here.com","Memo - $cnum",$message,"From: $staff");
$link = mysql_connect("blah","blah","blah");
mysql_select_db("memos",$link);
$query="insert into conflicts (staff,cnum,boss,jury,rate,comments) values ('".$staff."','".$cnum."','".$boss."','".$jury."','".$rate."','".$comments."')";
mysql_query($query);

}
?>
<HTML>
<HEAD><TITLE>Memo Confirmation</TITLE></HEAD>
<link rel="stylesheet" href="style.css" >
<BODY>
<? $time = date("H:i"); ?><? $date = date("n/d/y"); ?>
<font face="century gothic,tahoma,verdana" color="#000000" size="5">
MEMO SENT SUCCESSFULLY...</font><br><br>

<font face="century gothic,tahoma,verdana" color="#000000" size="3">

Thanks <? echo "$staff"; ?>.  The conflict check re: <? echo "$cnum"; ?> was sent successfully on <? echo "$date"; ?> at <? echo "$time"; ?>.
<br><br>If you need to create a new conflict check, hit the back button to return to the previous
form and hit the 'reset form' button.
<br><br>Click <a href="mailto:me@here.com">here</a> to e-mail any questions or problems you have.<br><br>
</font>
</BODY>
</HTML>

I hope what I am asking is not too confusing. Any help would be great!!

Pig

The easiest way to do that would be create a page with a query to display the information based on the entry's ID. Then when you send the link, you send the ID in the url:
http://www.domain.com/my_page?id=34

So the user enters data.
Data get's entered into database and emailed to you.
Get the inserted id, and send that as part of the link.
The page is displayed with the entries information, pulled from the database, and identified by that id.

bulldog317

Thanks Pig....

So pretty much I just need code to reference id=$id. So then can a script be created so that the user enters the data, it is entered into the database and the id of that row automatically inserted at the end of something like this: http://localhost/page?id=xx and then e-mailed to whoever? I think I'm liking where this is going.....

Pig

Yep, you got it. You only need one page. The content is just changed based on the id passed to the the query.

Make sure you have an if statement to check to see if an id was passed to the page. You can either put a simple message that says you must have an item selected to perform that operation, or go a step further and create an autopopulated drop down list of every item, so they can still get where they want.

bulldog317

Great. Thanks again for the help Pig. It appears to be a lot easier than I had expected. But then again PHP has been making a lot of things easier.