Unique URL Displayed by Submission id

leblanc

Hello everyone,

I am in need of some help 🙁
I have been trying to figure out how to display a page with a unique url by the submission_id of a table.
Example: www.mysite.com/display.php?id=4

I figured out how to display the tables information stored in the database through the submission_id with:
WHERE submission_id='4'

But I need figure out how to create a unqiue url by using the submission_id=4....
Here is what I started with to display the table with the submission_id=4 on display.php
Thanks in advance for any help.

<?php
$username = "user";
$password = "pass";
$hostname = "localhost";




$dbh = mysql_connect($hostname, $username, $password) 



or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("s52_form",$dbh) 



or die("Could not select s52_form");

$data = mysql_query("SELECT * FROM ft_form_1" WHERE submission_id='4'") 



or die(mysql_error()); 


 Print "<div id=\"container\">"; 
 while($info = mysql_fetch_array( $data )) 
 { 
 Print "<br />"; 
 Print "<b>Name:</b>" .$info['col_2'] . "<br />"; 
 Print "<b>Email:</b>" .$info['col_3'] . "<br />"; 
 Print "<b>Phone:</b>" .$info['col_4'] . "<br />";
 Print "<b>Phone2:</b>" .$info['col_5'] . "<br />";
 Print "<b>Subject:</b>" .$info['col_6'] . "<br />"; 
 Print "<b>Blob:</b>" .$info['col_7'] . "<br />"; 
 Print "<b>Date:</b>" .$info['submission_date'] . "<br />";   

 } 
 Print "</div>"; 

?>

leblanc

So ideally, I have gotten my self to add this:

$submission_id = $_GET['id'];

and this:

$data = mysql_query("SELECT * FROM ft_form_1" WHERE id='$submission_id'") 
 or die(mysql_error());

But I still cannot get it work. I think I am on the right path, but am lost.

leblanc

Wow, Kept with trial and error and finally got it to work with this.

<?php
$id =$_GET['submission_id'];

$username = "s52_tools";
$password = "sss";
$hostname = "localhost";	
$dbh = mysql_connect($hostname, $username, $password) 
	or die("Unable to connect to MySQL");
print "Connected to MySQL<br>";
$selected = mysql_select_db("s52_form",$dbh) 
	or die("Could not select s52_form");

$data = mysql_query("SELECT * FROM ft_form_1 WHERE submission_id='$id'") 
 or die(mysql_error()); 


 Print "<div id=\"container\">"; 
 while($info = mysql_fetch_array( $data )) 
 { 
 Print "<br />"; 
 Print "<b>Name:</b>" .$info['col_2'] . "<br />"; 
 Print "<b>Email:</b>" .$info['col_3'] . "<br />"; 
 Print "<b>Phone:</b>" .$info['col_4'] . "<br />";
 Print "<b>Phone2:</b>" .$info['col_5'] . "<br />";
 Print "<b>Subject:</b>" .$info['col_6'] . "<br />"; 
 Print "<b>Blob:</b>" .$info['col_7'] . "<br />"; 
 Print "<b>Date:</b>" .$info['submission_date'] . "<br />";   

 } 
 Print "</div>"; 

?>

If anyone knows anything I don't about why this isn't right lol, please let me know.