I have been working with PHP for a few months now and I wanted to make a simple mailing list script to add to a website I am helping redesign. I think that a mailing list will be a welcome upgrade. Anyway the error I am getting is
PHP Parse error: syntax error, unexpected T_VARIABLE in F:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\manage.php on line 22Not sure what is causing this. My code is below.
<?php
//functions
function doDB() {
global $conn;
//connect to the server and select databases; you may need it
$conn = mysql_connect("localhost","root","jakpot")
or die(mysql_error());
mysql_select_db("test","$conn") or die(mysql_error());
}
function emailChecker($email) {
global $conn, $check_result;
//check that the email is not already in list
$check = "select id from subscribers where email = '$email'";
$check_result = mysql_query($check,$conn) or die mysql_error());
}
//determine if they need to see the form or not
if ($_POST[op] != "ds") {
//they do, so create form block
$display_block = "
<form method=POST action=\ "$_SERVER[PHP_SELF]\">
<p><strong>Your Email 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[action] == "sub")) {
//trying to subscribe so validate email address
if ($_POST[email] == "" {
header("Location: manage.php");
}
//connect to database
doDB();
//check that email is in list
emailChecker($_POST[email]);
//get number of results and do action
if (mysql_num_rows($check_result) < 1) {
//add record
$sql = "insert into subscribers values(' ', '$_POST[email]')";
$result = mysql_query($sql,$conn) or die(mysql_error());
$display_block = "<p>Thanks for signing up!</p>";
} else {
//print failure message
$display_block = "<p>You're already subscribed!</p>";
}
} else if (($_POST[op] == "ds") $$ ($_POST[action] == "unsub")) {
//trying to unsubscribe; validate email adress
if ($_POST[email] == "") {
header("Location: manage.php");
exit;
}
//connect to database
doDB();
//check that email is in list
emailChecker($_POST[email]);
//get number of results and do action
if (mysql_num_rows($check_result) < 1) {
//print failure message
$display_block = "<p>Couldn't find your address!</p>
<p>No action was taken.</p>";
} else {
//unsubscribe the address
$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're unsubscribed!</p>";
}
}
?>
<html>
<head>
<title>Subscribe/Unsubscribe</title>
</head>
<body>
<h1>Subscribe / Unsubscribe</h1>
<?php echo "$display_block"; ?>
</body>
</html>Thanks in advance to anybody who can point me in the right direction.