Need Help, Hard To Explain, Please Read

bradleydh

Hello Everyone...

I have wrote a script (part of a mailing list) which subscribes users by adding the users to the database.

Now, I am using this in a PostNuke block, so whenever the form is submitted, I would like the page to refresh, and have the confirmation message where the original form was. I have seen this done a lot with polls, and I am wondering how I am supposed to do this.

In english, here is what I want the PHP to do:
- If the script has already been executed successfully, display message 1 in the block.
- If the script has already been executed unsucessfully, display message 2 in the block.
- If the script hasn't been executed (or else), just display the subscription form.

If anyone could help me, it would be great. I know this is a little hard to understand, probably because of the way I have worded it.

sgoku01

if ( isset($HTTP_POST_VARS['submit']) )
{
  if ( $form == 'oké' )
  {
  echo "message 1";
  }
  else
  {
  echo "message 2";
  }
}
else
{
echo "<form name=\"form\" method=\"post\">";
echo "<input type=\"submit\" name=\"submit\" value=\"submit\">";
echo "</form>";
}

You have to name the submit-button 'submit', so you can check with the if-statement if it's pressed or not.

bradleydh

Thanks for the help... what does "oké" mean...

I am still a little stuck.. what will my form action be for the mailing list script... I want to make sure the stuff is written to the database.

bradleydh

Here is the subscription code:

<?
//This is our IF statement.
//if the person selected subscribe...
if ($_POST['action'] == "subscribe") {
//they selected subscribe? Lets connect to database
//Connects to the database using mysql_connect()
mysql_connect("localhost","username","password");

//Select the database
mysql_select_db("db_name");

//connected to DB, and they selected subscribe, so lets add them!
//The e-mail from the form they submitted
$email = $_POST['email'];

//Now lets do a query to add the email
$sql = "
INSERT INTO mailinglist SET
Email = '$email'
";

//run the query
$query = mysql_query($sql);

//if statement to check if query was a success
if ($query) {
echo("Email added");
} else {
echo("Could not add e-mail");
}

} ELSE {
//If subscribe was NOT selected, we want to unsubscribe them.
//We need to establish a connection to MySQL
//Connects to the database using mysql_connect()
mysql_connect("localhost","username","password");

//Select the database
mysql_select_db("db_name");

//The e-mail from the form they submitted
$email = $_POST['email'];

//We're connected, lets delete the person from table
$sql = "
DELETE FROM mailinglist WHERE
Email = '$email'
";

//run the query
$result = mysql_query($sql);

//if statement to check if query was a success
if ($result) {
echo("Email Deleted");
} else {
echo("Could not delete e-mail");
}
}

?>

And here is the form code:

<html>
<head></head>
<body>
<form action="program.php" method="post">
E-mail address: <input type=text name="email">
<select name="action">
<option value=subscribe>Subscribe
<option value=unsubscribe>Unsubscribe
</select>
<input type=submit name=submit value=submit>
</form>
</body>
</html>

How am I going to put these two scripts together to make the mailing list subscription script work?

sgoku01

hehe, In the Netherlands oké mean OK/good 🙂
Aah, now I see what you mean..
Forget what I said before, and work with an else if-statement. Like this:

<?php
//This is our IF statement.
//if the person selected subscribe...

if ($_POST['action'] == "subscribe") {

//they selected subscribe? Lets connect to database

//Connects to the database using mysql_connect()

mysql_connect("localhost","username","password");

//Select the database
mysql_select_db("db_name");

//connected to DB, and they selected subscribe, so lets add them!

//The e-mail from the form they submitted

$email = $_POST['email'];

//Now lets do a query to add the email
$sql = "
INSERT INTO mailinglist SET
Email = '$email'
";

//run the query
$query = mysql_query($sql);

//if statement to check if query was a success

if ($query) {
echo("Email added");
} else {
echo("Could not add e-mail");
}

} 
[b]else if ( $_POST['action'] == "unsubscribe" )[/b]
{

//If subscribe was NOT selected, we want to unsubscribe them.

//We need to establish a connection to MySQL

//Connects to the database using mysql_connect()

mysql_connect("localhost","username","password");

//Select the database
mysql_select_db("db_name");

//The e-mail from the form they submitted

$email = $_POST['email'];

//We're connected, lets delete the person from table
$sql = "
DELETE FROM mailinglist WHERE
Email = '$email'
";

//run the query
$result = mysql_query($sql);

//if statement to check if query was a success

if ($result) {
echo("Email Deleted");
} else {
echo("Could not delete e-mail");
}

}
[b]// None of the options is selected, so show the form..[/b]
else
{
echo "<html>";
echo "<head></head>";
echo "<body>";
echo "<form action=\"program.php\" method=\"post\">";

echo "E-mail address: <input type=\"text\" name=\"email\">";

echo "<select name=\"action\">";

echo "<option value=\"subscribe\">Subscribe";

echo "<option value=\"unsubscribe\">Unsubscribe";

echo "</select>";

echo "<input type=\"submit\" name=\"submit\" value=\"submit\">";

echo "</form>";
echo "</body>";
echo "</html>";
}
?>

bradleydh

Thank you very much for your help! ...You are very knowledgeable, and extremely polite and patient. Thank you!

sgoku01

blush Well, thanks for the compliments blush