Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING o

cpmross · #1 (**permalink**) 07-10-07, 09:20 AM

Hey guys having some problems with a bit of code, if anyone can help out that would be excellent.

Error : Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\xampp\htdocs\sites\Project\adminmodsubown.php on line 75

PHP Code:


			
case "accept":



$validid = set_validid();

$sql = "SELECT mod_subowner.sub_id, subjects.subject, users.id AS userid, users.username, users.email FROM mod_subowner INNER JOIN subjects ON 

mod_subowner.sub_id = subjects.id LEFT JOIN users ON 

mod_subowner.user_id = users.id WHERE mod_subowner.id = " . $validid . ";";

$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);

$numrows = mysql_num_rows($result);



$mail_username = $row['username'];

$main_email = $row['email'];

$mail_subject = $row['subject'];



$mail_body=<<<_MESSAGE_

Hi, $mail_username,I am pleased to inform you that you have been accepted as the new owner of the '$mail_subject' subject.When you next log into '$config_sitename' you will see the subject in your Control Panel.King Regards,$config_sitename Administrator _MESSAGE_;

mail($mail_email, "Ownership Request For " . $mail_subject . " accepted!", $mail_body);



$addsql = "UPDATE subjects SET owner_id = " . $row['userid'] . " WHERE id = " . $row['sub_id'] . ";";

mysql_query($addsql);



$delsql = "DELETE FROM mod_subowner WHERE sub_id = " . $row['sub_id'] . ";";

mysql_query($delsql);



header("Location: " . $config_basedir . "adminmodsubown.php?func=main");

break;

Line 75 :

PHP Code:


			
$addsql = "UPDATE subjects SET owner_id = " . $row['userid'] . " WHERE id = " . $row['sub_id'] . ";";

any ideas i have searched and searched but i cannot find the problem.

Nikas · #2 (**permalink**) 07-10-07, 09:26 AM

Try this:

PHP Code:


			
$addsql = "UPDATE subjects SET owner_id =".$row['userid']." WHERE id =".$row['sub_id']";

cpmross · #3 (**permalink**) 07-10-07, 09:32 AM

Hey Nikas, comes back with same error, I will paste full page so you get more of an idea whats going on in the script.

PHP Code:


			
 <?php

session_start();

if(!$_SESSION['SESS_ADMINUSER']) {

header("Location: " . $config_basedir);

}



require("db.php");

require("functions.php");



function set_validid() {

if(pf_check_number($_GET['id']) == TRUE) {

return $_GET['id'];

}

else {

header("Location: " . $config_basedir);

}

}

switch($_GET['func']) {



case "main":

require("header.php");

$subssql = "SELECT subjects.subject, subjects.id FROM subjects INNER JOIN mod_subowner ON subjects.id = mod_subowner.sub_id

GROUP BY subject.id;";

$subsresult = mysql_query($subssql);

$subsnumrows = mysql_num_rows($subsresult);



echo "<h1>Subjects and Ownership</h1>";



if($subsnumrows == 0) {

echo "No requests have been made.";

}

else {

while($subrow = mysql_fetch_assoc($subsresult)) {

$reqsql = "SELECT users.id AS userid, users.username,

 mod_subowner.* FROM users INNER JOIN mod_subowner ON

    mod_subowner.user_id = users.id WHERE mod_subowner.sub_id = " . $subsrow['id'] . ";";

    $reqresult = mysql_query($reqsql);

    

echo "<table class='visible' cellpadding=10 cellspacing=0>";

echo "<tr><th class'visible' colspan='4'> Ownership requests for <i>" . $subrow['subject'] . "</i></th></tr>";

while($reqrow = mysql_fetch_assoc($reqresult)) {

echo "<tr>";

echo "<td>Requeted By <strong>" . $reqrow['username'] . "</strong></td>";

echo "<td>" . $reqrow['reasons'] . "</td>";

echo "<td><a href='" . $SCRIPT_NAME . "?func=accept&id=" . $reqrow['id'] . "'>Accept</a></td>";

echo "<td><a href='" . $SCRIPT_NAME . "?func=deny&id=" . $reqrow['id'] . "'>Deny</a></td>";

echo "</tr>";

}



echo "</table>";

echo "<br />";

}

}

break;





case "accept":



$validid = set_validid();

$sql = "SELECT mod_subowner.sub_id, subjects.subject, users.id AS userid, users.username, users.email FROM mod_subowner INNER JOIN subjects ON 

mod_subowner.sub_id = subjects.id LEFT JOIN users ON 

mod_subowner.user_id = users.id WHERE mod_subowner.id = " . $validid . ";";

$result = mysql_query($sql);

$row = mysql_fetch_assoc($result);

$numrows = mysql_num_rows($result);



$mail_username = $row['username'];

$main_email = $row['email'];

$mail_subject = $row['subject'];



$mail_body=<<<_MESSAGE_

Hi, $mail_username,I am pleased to inform you that you have been accepted as the new owner of the '$mail_subject' subject.When you next log into '$config_sitename' you will see the subject in your Control Panel.King Regards,$config_sitename Administrator _MESSAGE_;

mail($mail_email, "Ownership Request For " . $mail_subject . " accepted!", $mail_body);



$addsql = "UPDATE subjects SET owner_id = " . $row['userid'] . " WHERE id = " . $row['sub_id'] . ";";

mysql_query($addsql);



$delsql = "DELETE FROM mod_subowner WHERE sub_id = " . $row['sub_id'] . ";";

mysql_query($delsql);



header("Location: " . $config_basedir . "adminmodsubown.php?func=main");

break;



case "deny":



$validid = set_validid();

require("header.php");

echo "<h1>Are you sure that you want to deny this request?</h1>";

echo "<p>[<a href='adminmodsubown.php?func=denyconf&id=" . $validid . "'>Yes</a>]

[<a href='adminmodsubown.php?func=main'>No</a>]";

break;



case "denyconf":

 $validid = set_validid();

    $sql = "SELECT mod_subowner.sub_id, subjects,subject, users.id AS userid, users.username, users.email FROM mod_subowner INNER JOIN

    subjects ON mod_subowner.sub_id = subjects.id LEFT JOIN users ON mod_subowner.user_id = users.id WHERE mod_subowner.id = " . $validid . ";";

    $result = mysql_query($sql);

    $row = mysql_fetch_assoc($result);

    $numrows = mysql_num_rows($result);

    

    $mail_username = $row['username'];

    $mail_email = $row['email'];

    $mail_subject = $row['subject'];

    

    $mail_body=<<<_MESSAGE_

    Hi $mail_username,    I am writing to infom you that your request for ownership of the '$mail_subject' subject has been declined.    Better luck next time.    King Regards,    $config_sitename Administrator    _MESSAGE_;    

    mail($mail_email, "Ownership Request For " . $mail_subject . " Denied!", $mail_body);

    

    $delsql = "DELETE FROM mod_subowner WHERE id = " . $validid . ";";

    mysql_query($delsql);

    

    header("Location: " . $config_basedir . "adminmodsubown.php?func=main");

    break;

    

}

    require("footer.php");

?>

Nikas · #4 (**permalink**) 07-10-07, 09:38 AM

Sorry, I missed out a " at the end.

Try this and see how it goes. Meanwhile, I try to look for other problem.

PHP Code:


			
$addsql = "UPDATE subjects SET owner_id =".$row['userid']." WHERE id =".$row['sub_id']"";

cpmross · #5 (**permalink**) 07-10-07, 09:41 AM

Its cool,
tried that code same error i think its to do with the mail function
$mail_body=<<<_MESSAGE , I could be wrong tho i had spaces and i closed them all off and then it started displayed that new error! if that helps any
thanks

Nikas · #6 (**permalink**) 07-10-07, 09:49 AM

Seem like it's the quote problem.

PHP Code:


			
$addsql = "UPDATE subjects SET owner_id=$row['userid'] WHERE id=$row['sub_id']";

cpmross · #7 (**permalink**) 07-10-07, 09:51 AM

Tried that also nikas also doesnt work, Iam really stump'd i have been looking at this code for the past 2 hours and not getting anywhere fast!

Nikas · #8 (**permalink**) 07-10-07, 09:58 AM

For HereDoc Synatax,

You need to close the message when you have come to an end.

For example,

PHP Code:


			
$message = <<<_message_ // start of HereDoc
some some content
_message_; // indicate end of HereDoc

I'm not sure where you want to close yours, so try it and see how is it.

cpmross · #9 (**permalink**) 07-10-07, 09:59 AM

PHP Code:


			
$mail_body=<<<_MESSAGE_ 

Hi, $mail_username,I am pleased to inform you that you have been accepted as the new owner of the '$mail_subject' subject.When you next log into '$config_sitename' you will see the subject in your Control Panel.King Regards,$config_sitename Administrator _MESSAGE_;

its at end of text do you think it needs to be on a new line?