[Resolved] [Resolved] Checking things before unsubscribing

[NetRoam]

Hey all!

I have created a little newsletter for my website, but I seem to have run into a little bit of problems. I have this little form:

 
<form action="<?= $PHP_SELF ?>" method="post">

<input type="text" name="nl_email2" size="30" class="form2" value="<? echo $nl_email2 ?>">
<input type="submit" value="Unsubscribe">

</form>

But I want PHP to check a few things before submitting. When I click the submit button it should both check if the e-mail address is valid, but it should also check if the e-mail address really IS in my database - for some reason I have a bit of difficulty with that.

One little thing about it is that I will not delete e-mail addresses that are located in the database but haven't been confirmed yet (when they subscribe they get a confirmation mail - if it isn't confirmed it should give them an error saying "e-mail isn't confirmed yet" or something like that)

Normally I do something like this in the top of the document:

if($_SERVER['REQUEST_METHOD']=="POST")
{
  $nl_email2 = isset($_POST["nl_email2"]) ? $_POST["nl_email2"] : "";

... and then start testing but it doesn't work now.

Anyone have any idea how to do this?

[rangalo]

I dont know much about your database, but I assume that you must have kept one field to check conformation.

your query should go like this..

query = "SELECT is_conformed  from table_name WHERE email_id = '$postvariable' ;
/*according to your database check no_of rows and get the value to the variables*/
if($no_rows != 0)
{
 if($is_conformed == true)
 {
    $message = "you have already subscribed";
 }
 else
 {
   $message = "you have subscribed before, but not conformed   

    your subscription, an email will be sent to you to conform   

    again";
  //send a new email for conformation 
}
else
{
  //insert into database and write a fresh email for conformation.
}

[NetRoam]

Well, I can tell you a bit more about my database. I got a table called "newslettermails" and it includes the following fields:

nl_mailID
nl_company
nl_contact
nl_email
nl_language
nl_online

When a person registers for the newsletter the database inserts the data and sets "nl_online" to "No" by default. After receiving the confirmation mail he clicks the link and "nl_online" changes status to "Yes".
I use nl_language since I both offer a newsletter in Danish and English.

So what I wanna do is to write the e-mail address - click the unsubscribe button and it should then first check if the e-mail address can be found in the database while it also checks if the language and online status is correct. It isn't good if you go to the Danish part of the site - put in the info and delete the e-mail if you wanted to receive it in English.

• So if the e-mail in the database IS online but has a different language it should say "E-mail doesn't exist" - same thing should happen if the e-mail isn't in the database of course 🙂
• If the e-mail IS online with the right language, it should go through with the deletion
• If the e-mail ISN'T online but is in the database, it should say "E-mail isn't confirmed yet"

Is that a tough process you think?

[rangalo]

Hi,

now again I assume that you have some session variable or cookie to keep track of the langauage of the page, because user is not specifying language while unsubscribing
suppose it is $pagelanguage.

$query = "SELECT nl_language,nl_online FROM table_name WHERE nl_email = '$inputemail';
/*get the no_of_rows and all the variables according toyour database*/

if($no_or_rows == 0 || $nl_language != $pagelanguage)
{
  echo "E-mail doesnt exist";
  exit;
}
else if($nl_online != 1) //if not conformed
{
  echo "your subscription was not conformed!";

  exit;
}
else
{
  $query = "delete FROM table_name WHERE nl_email = 'inputemail';
  //execute the query
  echo "you have successfully unsubscribed";
}

hope this will help you.

[NetRoam]

I found a solution to my problem a bit differently but it was somewhat similar to your solution, so thank you for your help!

/// NetRoam