Mailing list

[sudsy1970]

hi all,

 

am trying to set up a mailing list but am have some problems with it all. 

 

 

1) have the following error

Fatal error: Call to undefined function doDB() in C:\xampp\htdocs\mail\manage.php  on line 27

yet i have defined that function in a file called include.php that the first item called.

 

2) i wish to place the file into a table, how can i place it into a table cell ?  have tried

include 'manage.php';

in the correct cell put that does not seem to work.

 

Any help greatly appreciated, code attached.

 

[attachment deleted by admin]

[joePHP]

Hi,

 

Regarding question number 1, your are missing

<?php

in include.php

Regarding question number 2, I am not sure what you mean.

 

Thanks,

Joe

 

[sudsy1970]

ok thanks joe,  solved the first issue.

 

2) the file i have created is called manage.php.  if i wanted to have this code on a page i would use the include function in php, i think, which is normally at the start of the page. If i wanted include just this section

<form method=\"POST\" action=\"".$_SERVER["PHP_SELF"]."\">

<p><strong>Your E-Mail Address:</strong><br/>
<input type=\"text\" name=\"email\" size=\"40\" maxlength=\"150\">

<p><strong>Action:</strong><br/>
<input type=\"radio\" name=\"action\" value=\"sub\" checked> subscribe
<input type=\"radio\" name=\"action\" value=\"unsub\"> unsubscribe

<p><input type=\"submit\" name=\"submit\" value=\"Submit Form\"></p>
</form>";

 

in say a cell in a table how could i do that ?

 

is that clearer or not ?

[joePHP]

I am still not sure I understand. What you are asking is: If you can only include a certain part of a file?

[sudsy1970]

yes if thats possible, if not how can i keep that code and reference it back  ?

[joePHP]

Why don't you just make a file lets say form.php with that code and then just include it as you need.

[sudsy1970]

Get more errors that way. put that code into a file called mailform.php and then called it like so, my problem i think is i am not sure of the first line. think that i have included it correctly though

 

<?php
        
        <form method=\"POST\" action=\"".$_SERVER["PHP_SELF"]."\">

<p><strong>Your E-Mail Address:</strong><br/>
<input type=\"text\" name=\"email\" size=\"40\" maxlength=\"150\">

<p><strong>Action:</strong><br/>
<input type=\"radio\" name=\"action\" value=\"sub\" checked> subscribe
<input type=\"radio\" name=\"action\" value=\"unsub\"> unsubscribe

<p><input type=\"submit\" name=\"submit\" value=\"Submit Form\"></p>
</form>";

?>

 

Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\Cosford\mailform.php  on line 3

 

[hcdarkmage]

Try putting an echo before your code:

<?php
        
echo "<form method=\"POST\" action=\"".$_SERVER["PHP_SELF"]."\">

<p><strong>Your E-Mail Address:</strong><br/>

<input type=\"text\" name=\"email\" size=\"40\" maxlength=\"150\">

<p><strong>Action:</strong><br/>

<input type=\"radio\" name=\"action\" value=\"sub\" checked> subscribe

<input type=\"radio\" name=\"action\" value=\"unsub\"> unsubscribe

<p><input type=\"submit\" name=\"submit\" value=\"Submit Form\"></p>

</form>";

?>

[joePHP]

Use this:

 

<form method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?> ">
<p><strong>Your E-Mail Address:</strong><br/>
<input type="text" name="email" size="40" maxlength="150" />
<p><strong>Action:</strong><br/>
<input type="radio" name="action" value="sub" checked="checked" /> subscribe
<input type="radio" name="action" value="unsub" /> unsubscribe
<p><input type="submit" name="submit" value="Submit Form" /></p>
</form>

[sudsy1970]

the echo seems to work as in i now have the form in the correct place however, i can add the same email as many times as i want and am unable to unsubscribe.

 

if i keep the code seperate then it all works so i am thinking that the somewhere i am not referencing back to the correct part of the script.  Because i now have the form in the correct place does this mean i need to remove it from manage.php, could this cause a conflict.

 

Tried your for Joephp and still get a parse error.

[joePHP]

To use mines you need to get rid of the opening

<?php

and the closing

?>

and then paste my code. Also, in manage.php you can get rid of it and just include it there instead.

[sudsy1970]

ok thanks for your patience guys, i now have it kind of working.  once i have unsubscribed i have a message coming up telling me that i have done so see code below. How can i add a link to return me me to another address, such as index,php but still keep the code to tell me whats happening.  have tried the normal href but that does not work.

 

	//unsubscribe the address
		$del_sql = "DELETE FROM subscribers WHERE id = '".$id."'";
		$del_res = mysqli_query($mysqli, $del_sql) or die(mysqli_error($mysqli));
		$display_block = "<P>You're unsubscribed!</p>";
	}    
	mysqli_close($mysqli);
}
}

[joePHP]

You could have

header('Location: index.php?unsub=1');

 

And in index.php

if(isset($_GET['unsub']) && $_GET['unsub'] == 1)
{
   $display_block = "<p>You're unsubscribed!</p>";
}

[sudsy1970]

with reference to the index part, i placed it at the very top of my code.  the redirect worked but no message

[joePHP]

In index.php where you want the message to show put this in:

 

<?php
if(isset($display_block))
{
   echo $display_block;
}
?>