unexpected T_STRING?

frijole

it says the error is on line 29???? im lost. :eek:

<?php
/*Program:  email.php
 *Desc:     PHP program that sends an email address to the DB for a mailing list.          

 */

if(ini_get("magic_quotes_gpc") == "1")
{
   $_POST['email'] = stripslashes($_POST['email']);
}

$host="localhost";
$user="removed";
$password="removed";

if(!empty($_POST['form']))
{
  mysql_connect($host,$user,$password);
  mysql_select_db(thinksna_email);
  $result = mysql_query($_POST['email']);

  if($result == false)
  {
     echo "<h4>Error: ".mysql_error($cxn)."</h4>";
  }
  else
  {
     $email = $_POST['email'];

INSERT INTO email (email, email_id, dateTime) VALUES ('$email', "" , NOW());

echo "'$email' was added to the list";

  }

?>

and here is the html form too:

<DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xml:lang="en">
<meta http-equiv="Content-Type" content="text/html"; charset="UTF-8" />

<head>

<title>thinksnack.com</title>

<link rel="stylesheet" type="text/css" href="web.css">

<link rel="Shortcut Icon" type="image" href="favicon.ico">

</head>

<body>

<form action="email.php" method="POST">
<input type="text" email="email">
<input type="submit" value="add my e-mail">
</form>

</body>

</html>

thanks for helping if you can.

tron00

The problem is here:

else
{
$email = $_POST['email'];
INSERT INTO email (email, email_id, dateTime) VALUES ('$email', "" , NOW());
echo "'$email' was added to the list";
}

You need to have your mysql string in mysql_query() function in order for it to work. Otherwise, all php reads is a string and your will get errors.

$email = $_POST['email'];
mysql_query("INSERT INTO email (email, email_id, dateTime) VALUES ('$email', "" , NOW())");
echo "'$email' was added to the list";

frijole

ill try that.🙂

frijole

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING Line 29

this error popped up now that the previous one was dealt with, any ideas?

<?php
/*Program:  email.php
 *Desc:     PHP program that sends an email address to the DB for a mailing list.          

 */

if(ini_get("magic_quotes_gpc") == "1")
{
   $_POST['email'] = stripslashes($_POST['email']);
}

$host="localhost";
$user="removed";
$password="removed";

if(!empty($_POST['form']))
{
  mysql_connect($host,$user,$password);
  mysql_select_db(thinksna_email);
  $result = mysql_query($_POST['email']);

  if($result == false)
  {
     echo "<h4>Error: ".mysql_error($cxn)."</h4>";
  }
  else
  {
     $email = $_POST['email'];

mysql_query("INSERT INTO email (email, email_id, dateTime) VALUES ('$email', "" , NOW())");

echo "'$email' was added to the list";

  }

?>

frijole

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /home/thinksna/public_html/email.php on line 29

<?php
/*Program:  email.php
 *Desc:     PHP program that sends an email address to the DB for a mailing list.          

 */

if(ini_get("magic_quotes_gpc") == "1")
{
   $_POST['email'] = stripslashes($_POST['email']);
}

$host="localhost";
$user="removed";
$password="removed";

if(!empty($_POST['form']))
{
  mysql_connect($host,$user,$password);
  mysql_select_db(thinksna_email);
  $result = mysql_query($_POST['email']);

  if($result == false)
  {
     echo "<h4>Error: ".mysql_error($cxn)."</h4>";
  }
  else
  {
     $email = $_POST['email'];

mysql_query("INSERT INTO email (email, email_id, dateTime) VALUES ('$email', "" , NOW())") or die(mysql_error());

echo "'$email' was added to the list";

  }

?>

frijole

Parse error: syntax error, unexpected $end in /home/thinksna/public_html/email.php on line 35

<?php
/*Program:  email.php
 *Desc:     PHP program that sends an email address to the DB for a mailing list.          

 */

if(ini_get("magic_quotes_gpc") == "1")
{
   $_POST['email'] = stripslashes($_POST['email']);
}

$host="localhost";
$user="removed";
$password="removed";

if(!empty($_POST['form']))
{
  mysql_connect($host,$user,$password);
  mysql_select_db(thinksna_email);
  $result = mysql_query($_POST['email']);

  if($result == false)
  {
     echo "<h4>Error: ".mysql_error($cxn)."</h4>";
  }
  else
  {
     $email = $_POST['email'];

mysql_query("INSERT INTO email (email, email_id, dateTime) VALUES ('$email', '' , NOW())") or die(mysql_error());

echo "'$email' was added to the list";

  }

?>

NogDog

You have un-escaped double quotes within a double-quoted string:

mysql_query("INSERT INTO email (email, email_id, dateTime) VALUES ('$email', [color=red][b]""[/b][/color] ,
 NOW())") or die(mysql_error());

Either change them to single quotes or escape them with backslashes.

NogDog

You did not close the 2nd IF block.

Also, please use the

 tag for your code samples instead of the [code] tag, it results in more easily read text.

NogDog

OK, you've posted essentially the same code snippet in at least 3 different threads now. I'm going to try to merge them all together.