Parse error: syntax error, unexpected T_STRING

nineteen77

can anyone help with this bit of code there is an Parse error: syntax error, unexpected T_STRING

$username="ace01";
$password="ace01";
$database="ace";

$link = mysql_connect('nineteen77couk.fatcowmysql.com', 'ace01', 'ace01');

if (!
{

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

mysql_select_db(ace,$link);

$value=$POST['visitor'];
$value2=$POST['visitormail'];

$sql = "INSERT INTO ACE (visitor, visitormail) VALUES ('$value', '$value2');"
;

mysql_query($sql) or die (mysql_error());

mysql_close();

the error occurs between line echo 'Connected successfully'; and mysql_select_db(ace,$link); even though theres no code on that line
please can you help

Derokorian

First

if (!

If what? You never finish this statement.

mysql_select_db(ace,$link);

ace is not a string, you are attempting to represent it as a constant, which I'm sure isn't what you meant. Put quotes around it.

nineteen77

can any one help with this little bit of code it says Parse error: syntax error, unexpected T_STRING on line 67 and line dosent exist

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=hp8_english_ci" />
<title>jobs made 4 u says thanks</title>
</head>
<body>

<?php

if($POST['submit'] == "Submit")
{
$visitor = $POST['visitor'];
}
else
{
if($visitor == '')

echo '<li>You forgot to enter a name!</li>';
}

$username="ace01";
$password="ace01";
$database="ace";

$link = mysql_connect('nineteen77couk.fatcowmysql.com', 'ace01', 'ace01');

if (!link)
{

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';

mysql_select_db('ace',$link);

$value=$_POST['visitor'];

$value2=$_POST['visitormail'];

$sql = "INSERT INTO ACE (visitor, visitormail) VALUES ('$value', '$value2');"

mysql_query($sql) or die (mysql_error());

mysql_close();

mant thanks

Weedpacket

When posting, please use the formatting tags described in the FAQ to make your code readable. Formatting your code is also a good idea, especially when it comes to finding parse errors.

if (!link)

You mean

if (!$link)

nineteen77

yes thats what i meant i have changed that line of code and still the same error on a line which contains no code can yopu help

Bonesnap

This line:

$sql = "INSERT INTO `ACE` (`visitor`, `visitormail`) VALUES ('$value', '$value2');"

Has the semicolon inside the string. It should be:

$sql = "INSERT INTO `ACE` (`visitor`, `visitormail`) VALUES ('$value', '$value2')";

nineteen77

can anyone help with this bit of code it says theres a Parse error: syntax error, unexpected T_STRING on line 65 there is no code on this line can anyone help



<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=hp8_english_ci" />
<title>jobs made 4 u says thanks</title>
</head>
<body>

<!-- Reminder: Add the link for the 'next page' (at the bottom) -->
<!-- Reminder: Change 'YourEmail' to Your real email -->



<?php




if($_POST['submit'] == "Submit") 
{ 
    $visitor = $_POST['visitor']; 
} 
else 

   if($visitor == '') 
{
   echo '<li>You forgot to enter a name!</li>'; 
} 






$username="ace01";
$password="ace01";
$database="ace";




$link = mysql_connect('nineteen77couk.fatcowmysql.com', 'ace01', 'ace01');

if (!$link)
{

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';



mysql_select_db('ace',$link);


$value=$_POST['visitor'];



$sql = "INSERT INTO 'ACE' ('visitor') VALUES ('$value');"


mysql_query($sql) or die (mysql_error()); 





mysql_close();






?>

can any one say why there is an error on a line of code with no code
cheers

Bonesnap

No need to create two threads for the same issue.

In any case, you can see my correction here.

nineteen77

i have sorted the error it was changing the code


$sql = "INSERT INTO `ACE` (`visitor`) VALUES ('$value');"

into


$sql = "INSERT INTO `ACE` (`visitor`) VALUES ('$value')";

but the code still dont work it says you forgot to enter the name this is the error message i want to see if i dont fill out the form but i get this message if i fill in the visitor box as well cna anyone help
cheers

nineteen77

thanks but now i am having trouble with the fields it says fill in name even if the name is filled in



<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=hp8_english_ci" />
<title>jobs made 4 u says thanks</title>
</head>
<body>

<!-- Reminder: Add the link for the 'next page' (at the bottom) -->
<!-- Reminder: Change 'YourEmail' to Your real email -->



<?php




if($_POST['formsubmit'] == "Submit") 
{ 
    $visitor = $_POST['visitor']; 
} 
else 

   if($visitor =='') 

{
   echo '<li>You forgot to enter a name!</li>'; 
} 


?>

it says You forgot to enter a name! even if the name is entered

can you help

cheers

Weedpacket

Applying a bit of logic:

if($_POST['formsubmit'] == "Submit")
{
    $visitor = $_POST['visitor'];
    if($visitor =='')
    {
        echo '<li>You forgot to enter a name!</li>';
    }
}

nineteen77

thanks for your help i have attached the code you sent but now the connected successfully text displays even if the text box isnt filled in. what i want is for the fill in name text to display when no text has been entered and the connected succesfully text to display when it is filled in can you help i am sorry for all the questions but im new to php
cheers

Weedpacket

nineteen77 wrote:
thanks for your help i have attached the code you sent but now the connected successfully text displays even if the text box isnt filled in. what i want is for the fill in name text to display when no text has been entered and the connected succesfully text to display when it is filled in can you help i am sorry for all the questions but im new to php
cheers

You accidentally left some punctuation in your post. A shame: to come so close to showing complete contempt for anyone trying to read your writing - only to slip up and allow a stray dot through.

More logic:

if($visitor == '')
{
  echo '<li> You forgot to enter a name</li';
}
else
{
  // Do what you're supposed to if they did enter a name.
}

nineteen77

thanks for the last bit of code,but now i am totally confused!! i want the error message to appear and not to connect to the database,which it is doing at the moment.
then if the name is filled in i want it to connect to the database.
it dosent seem to reconise that text has been entered into the form.

please can you help


Your Name: <br />
<input type="text" name="visitor" maxlength="20" size="35" />


<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=hp8_english_ci" />
<title>jobs made 4 u says thanks</title>
</head>
<body>

<!-- Reminder: Add the link for the 'next page' (at the bottom) -->
<!-- Reminder: Change 'YourEmail' to Your real email -->




<?php

   $visitor = $_POST['visitor'];


if($visitor == '') 
{ 
  echo '<li> You forgot to enter a name</li>'; 
} 
else 
{ 
  // Do what you're supposed to if they did enter a name. 




$username="ace01";
$password="ace01";
$database="ace";




$link = mysql_connect('nineteen77couk.fatcowmysql.com', 'ace01', 'ace01');

if (!$link)
{

die('Could not connect: ' . mysql_error());

}

echo 'Connected successfully';



mysql_select_db('ace',$link);


$value=$_POST['visitor'];



$sql = "INSERT INTO `ACE` (`visitor`) VALUES ('$value')";


mysql_query($sql) or die (mysql_error()); 





mysql_close();

}




?>





[/php}

please can you help