Convert to php &lt;input type&gt;??

Convert to php <input type>??

kpowning

Does anyone know how to convert an html input type to php. What I'm trying to do is when a member clicks on a link to go to a page, it inserts their email address into the field without them having to type it in manually. Basically just like if you go to unsubscribe from a mail list, you click on the link in the email and it puts your email address into the emailaddress field. Please help...

My Script:

<?php require_once('../Connections/EMALL.php'); ?>
<?php 
if ($REQUEST_METHOD=='POST') {
echo "An email has been sent.";}
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

if ((isset($HTTP_POST_VARS['EmailAddress'])) && ($HTTP_POST_VARS['EmailAddress'] != "")) {
  $deleteSQL = sprintf("DELETE FROM Emailcollector WHERE `Email Address`=%s",
                       GetSQLValueString($HTTP_POST_VARS['EmailAddress'], "text"));

  mysql_select_db($database_EMALL, $EMALL);
  $Result1 = mysql_query($deleteSQL, $EMALL) or die(mysql_error());
}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p align="center">[url]www.AmericanEmall.com[/url] </p>
<p align="center">(Email Database)</p>
<form action="" method="post" name="Unsubscribe" id="Unsubscribe">
  <p align="center">To unsubscribe from our Email Database, please type in your 
    email address and then click the &quot;Submit: button. You will be completely 
    deleted from our database. </p>
  <p align="center">EmailAddress: <input name="EmailAddress" type="text" value="EmailAddress" size="80" maxlength="120">

  </p>
  <p align="center"> 
    <input type="submit" name="Submit" value="Submit">
  </p>
</form>
<p>&nbsp;</p>
</body>
</html>

😕

Rodders

Where will your PHP script get the email address from in the first place?
If you are trying to do it from a link sent in an email, then I would suggest you append the email address to the URL:

If you want to unsubscribe from this service <a href="http://www.yoursite.com/unsubscribe.php?email=name@whatever.com">Click Here</a>

Then you PHP script can pick it up:

$unsubscribe_email = $_GET['email'];

Then you can use that variable in your DELETE statement.

Rodders

Or if you wanted to open a page with their email address in a text box and a button saying "Unsubscribe" you could do the same, except don't do the DELETE yet.

<?php
$unsubscribe_email = $_GET['email'];
?>
<INPUT TYPE=TEXT NAME=email VALUE='<?php echo $unsubscribe_email; ?>'>