mail form driller
HejJeg har spurgt til dette script før men det driller stadig.
http://www.web-peter.dk/test/formular.php
en simpel form hvor brugeren skal indtaste sin email som så bliver gemt i en database.
Men når den indtastede email adr. havner ikke i databasen når jeg forsøger at indsætte en ny. Den vi derimod gerne slette adresser som står i databasen? Jeg er helt ny i php og det er en opgave jeg laver ud fra en bog.
Koden er gennem tjeckte op til flere gange.
Hjæælp
-----
<?php
function doDB()
{
global $conn;
$conn = mysql_connect ("localhost", "xx", "xx") or die(mysql_error());
mysql_select_db("xx", $conn) or die(mysql_error());
}
Function emailChecker ($email) {
global $conn, $check_result;
$check = "select id from subscribers where email =
'$email'";
$check_result = mysql_query ($check,$conn) or die (mysql_error());
}
if ($_POST[op] != "ds")
{
$display_block =" <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
<input type=\"hidden\" name=\"op\" value=\"ds\">
<p><input type=submit name=\"submit\" value=\"Submit Form\"><p>
</form>";
}
else if (($_POST[op] == "ds") && ($_POST[actino] == "sub"))
{
if ($_POST[email] == "")
{
header ("Location: manage.php");
exit;
}
doDB();
emailChecker($_POST[email]);
if (mysql_num_rows($check_result) < 1 ) {
$sql = "insert into subscribers values('', '$_POST[email]')";
$result = mysql_query($sql,$conn) or die(mysql_error());
$display_block = "<p>Tanks for signing up!</p>";
} else {
$display_block = "<P>You're already subscribed!</p>";
}
}
else if (($_POST[op] == "ds") && ($_POST[action] == "unsub"))
{
if ($_POST[email] == "")
{
header("Location: manage.php");
exit;
}
doDB();
emailChecker($_POST[email]);
if (mysql_num_rows($check_result) <1)
{
$display_block = "<p>Couldnt find your address</p><p> No action was taken.</p>";
}
else
{
$id = mysql_result($check_result, 0, "id");
$sql = "delete from subscribers where id = '$id'";
$result = mysql_query($sql, $conn) or die(mysql_error());
$display_block = "<P>Youér unsubscribed!</P>";
}
}
?>
<html>
<head>
<title>tilmelding af nyhedsbrev</title>
</head>
<body>
<h1>Subscribe/unsubscribe</h1>
<?php echo "$display_block";?>
</body>
</html>
