help with post

scottbarry

I need help writing a page that will (method)post.

to be more specific. I need a page that will create the following.

http://www.mydomain.com/scripts/submit.php?name=JOHN%20DOE&email=JDOE@hotmail.com&ref=REF4

can anyone help?

thank you
Scott

adi

Be more explicit.

scottbarry

i created a php page that works with a database on my server. the php page(submit.php) looks for input for 3 fields (name,email,ref).

if i type the url from this original thread it works fine..now i just need to write a user interface to submit that info to the php page.

I hope that this is more specific..if not..let me know and i will try even harder.

Thank you

adi

Sorry, i dont understand what you are trying to explain.
Its this the case? :

You have a list of users and when somebody clicks on a specific user you want to show the details about that user.

scottbarry

ok..ill try to explain the whole senario...

this is what im tryingto accomplish...the user enters his name,email address and a reference #. after he submits this info, a serial number is automatically emailed to them.

I have the database all set and I also have the php page set up. I will include this php page below.

my problem is getting the info from the user to this php page.

<?php

// Check if we have all the nessasary information

if(!(isset($GET[name]) && isset($GET
$link = mysql_connect("db.xxxx.com", "xxxx" ,"xxxx");

mysql_select_db("database");

$query = "SELECT * FROM email_serials WHERE refno='$_GET[refno]'";

$result = mysql_query($query);

if(mysql_num_rows($result))

$row = mysql_fetch_array($result);

else {

$query = "UPDATE email_serials SET refno='$GET[refno]', name='$GET[name]', email='$_GET[email]' WHERE ISNULL(refno) LIMIT 1";

mysql_query($query);

$result = mysql_query("SELECT * FROM email_serials WHERE refno='$_GET[refno]'");

$row = mysql_fetch_array($result);

}

$subject = "Your serial";

$message = "Dear $row[name],

Your serial is: $row[serial]

Your registration code is: $_GET[refno]

Please keep this information for future reference.

mail("$row[name] <$row[email]>", $subject, $message, "From: [email]webmaster@xxxx.com"> ) && isset($_GET[refno])))

exit;

$row = "";

$link = mysql_connect("db.xxxx.com", "xxxx" ,"xxxx");

mysql_select_db("database");

$query = "SELECT * FROM email_serials WHERE refno='$_GET[refno]'";

$result = mysql_query($query);

if(mysql_num_rows($result))

$row = mysql_fetch_array($result);

else {

$query = "UPDATE email_serials SET refno='$GET[refno]', name='$GET[name]', email='$_GET[email]' WHERE ISNULL(refno) LIMIT 1";

mysql_query($query);

$result = mysql_query("SELECT * FROM email_serials WHERE refno='$_GET[refno]'");

$row = mysql_fetch_array($result);

}

$subject = "Your serial";

$message = "Dear $row[name],

Your serial is: $row[serial]

Your registration code is: $_GET[refno]

Please keep this information for future reference.

mail("$row[name] <$row[email]>", $subject, $message, "From: [email]webmaster@xxxx.com");

<HTML>

<BODY>

Serial have been submitted to <?php echo $row[name] ?> at <?php echo $row[email] ?>.

</BODY>

</HTML>

adi

The form: form.php

 
<form method="GET"  action="submit.php" name="myform" >
<input type="TEXT" name="name">
<input type="TEXT" name="email">
<input type="TEXT" name="address">
<input type="TEXT" name="reff_no">
<input type="SUBMIT" name="ok" value="Ok">

---The processing script : submit.php

<?
if (isset($_GET['ok']))
{
$name=$_GET['name'];
$email=$_GET['email'];
$address=$_GET['address'];
$reff_no=$_GET['email'];

$result = mysql_query("SELECT * FROM `email_serials` WHERE refno='$reff_no' "); 
}

//.....
//.....
//.....
?>

scottbarry

shouldnt the form be PUT not GET?

scottbarry

and how do i link it to the submitref.php?

adi

There are two ways of submiting a form: GET and POST.

adi

The form - form.php sends the data to submit.php wich takes the variables and uses them.
You "link" the form.php to submit.php by specifying the action="submit.php" :

<form method="GET"  action="[COLOR=red]submit.php[/COLOR] " name="myform" >

scottbarry

thank you soo much..I will try that