parsing error

DKY

I keep getting this parsing error, and cant figure it out. What exactly does it mean?

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in c:\apache\htdocs\golesnew\cat\showtable.php on line 78

<html>
  <head>
    <title>Display the Categories for Item Editing/Deleting</title>
    <LINK HREF="catalogwhite.css" REL="STYLESHEET">
  </head>
  <body>
<?php
require('connect.php');

database_connect();
display_tables();

if ($_GET['mode'] != 'edit' && $_GET['mode'] != 'delete') {

echo "<form action=\"".$_SERVER['PHP_SELF']."?mode=changedropdown\" method=\"post\" NAME=\"show_tables\">";
echo "<br />";
echo "<table align=\"center\">";
echo "<tr>";
echo "<td width=\"100%\" valign=\"top\" align=\"center\">";
echo "<select name=\"view_category\" onchange=\"this.form.submit();\">";
echo "<option value=\"ViewTheContentsofaTable\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;View a Category&nbsp;&nbsp;";
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
echo "</option>;";


while($row= mysql_fetch_array($result)) {
    echo "\t\t\t\t<option>{$row[0]}</option>\n";
}

echo  "</select>";
echo  "</td></tr></table></form>";
}    

######################################## DROPDOWN SELECTED SECTION ######################################## 


if('changedropdown' == $_GET['mode']) {
    #if (isset($_POST['Select'])) {
    $table = $_POST['view_category'];
    if ('ViewTheContentsofaTable' == $table) {
        ?>
    <br /><br /><br /><br />
    <font id="title">Please Select a Category</font>
        <?php
    } else {
        $query = "SELECT * FROM $table";
        $result = mysql_query($query) or die(mysql_error().'<br />');
        ?>
    <form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post" name="tables_themselves">
      <p align="center">
        <font id="title"><?php echo $table;?></font>
        <table width="90%" CELLSPACING="15">
          <tr><td colspan="7">&nbsp;</td></tr>
          <tr id="headers">
            <td align="left">Number</td>
            <td align="left">Picture</td>
            <td align="left">Thumbnail</td>
            <td align="left">Item</td>
            <td align="left">Description</td>
            <td align="right">Price&nbsp;&nbsp;&nbsp;&nbsp;</td>
            <td align="left">&nbsp;</td>
          </tr>
          <tr>
            <td colspan="7"><hr /></td>
          </tr>
        <?php
          while ($row = mysql_fetch_assoc($result)) {
            $edit = '<a href="?mode=edit&table=' . $table . '&Product_Number=' . $row['Product_Number'] . '">Edit</a>';
            $delete = '<a href="?mode=delete&table=' . $table . '&Product_Number=' . $row['Product_Number'] . '">Delete</a>';
            echo "<tr><td>{$row['Product_Number']}</td><td>{$row['Picture']}</td><td>{$row['Thumbnail']}</td>
            <td>{$row['Item_Name']}</td><td>{$row['Description']}</td><td align=\"right\">\${$row['Price']}</td>
            <td>$edit&nbsp;&nbsp;$delete</td></tr><tr><td colspan=\"7\"><hr /></td></tr>\n";
        }
    }}

echo "</table></form>\n";

######################################## EDIT SECTION ########################################   

if('edit' == $_GET['mode']) { 
    $table=$_GET['table'];

        $editquery = "SELECT Item_Name, Picture, Price, Description FROM $table WHERE Product_Number='{$_GET['Product_Number']}'";
        $editresult = mysql_query($editquery) or die(mysql_error().'<br />');
        if (!$_POST) 
{
    while ($editrow = mysql_fetch_array($editresult)) {


echo "<div class='outer'><div class='inner'><P ALIGN=CENTER>
<FORM ENCTYPE='multipart/form-data' ACTION='$_SERVER['PHP_SELF']' METHOD='POST' NAME='input_item'>
<input type=hidden name='max_file_size' value='2000000'>   

   <br><TABLE WIDTH='600' CELLPADDING='0' CELLSPACING='0' BORDER='0'>
   <TR><TD VALIGN=top><p align='center'>

<TABLE WIDTH='50%' bordercolor='black' CELLPADDING='0' CELLSPACING='0' BORDER='0'><TR>
        <TD style='border-bottom-style: solid; border-bottom-width:1'
        style='border-right-style: solid; border-right-width: 1'
        style='border-top-style: solid; border-top-width:1'
        style='border-left-style: solid; border-left-width: 1'
        WIDTH='250' BGCOLOR='#CCD6CD' VALIGN=top id='headers'>&nbsp;Name of the Item:</TD></TR>
        <TR>
        <TD WIDTH='250' VALIGN=TOP>
        <input type='text' name='item' size=40 maxlength='255' value=$editrow[Item_Name]>  

        </TD></TR>
</TABLE>

</TD><TD VALIGN=top><p align='center'>

<TABLE WIDTH='50%' bordercolor='black' CELLPADDING='0' CELLSPACING='0' BORDER='0'><TR>
        <TD style='border-bottom-style: solid; border-bottom-width:1'
        style='border-right-style: solid; border-right-width: 1'
        style='border-top-style: solid; border-top-width:1'
        style='border-left-style: solid; border-left-width: 1'
        WIDTH='250' BGCOLOR='#CCD6CD' VALIGN=top id='headers'>&nbsp;Upload a Thumbnail From:</TD></TR>
        <TR>
        <TD WIDTH='250' VALIGN=TOP>
        <input type='File' name='tn_upload' size=26 maxlength='255' value=$editrow[Thumbnail]>  

        <br></TD></TR>        

</TABLE>

</TD></TR><TR><TD VALIGN=top><p align='center'>

<TABLE WIDTH='50%' bordercolor='black' CELLPADDING='0' CELLSPACING='0' BORDER='0'><TR>
        <TD style='border-bottom-style: solid; border-bottom-width:1'
        style='border-right-style: solid; border-right-width: 1'
        style='border-top-style: solid; border-top-width:1'
        style='border-left-style: solid; border-left-width: 1'
        WIDTH='250' BGCOLOR='#CCD6CD' VALIGN=top id='headers'>&nbsp;Price of the Item:</TD></TR>
        <TR>
        <TD WIDTH='250' VALIGN=TOP><p align='center'>
        <input type='text' name='price' size=40 value=$editrow[Price]>  

        <BR></TD></TR>        

</TABLE>

</TD><TD VALIGN=top><p align='center'>

<TABLE WIDTH='50%' bordercolor='black' CELLPADDING='0' CELLSPACING='0' BORDER='0'><TR>
        <TD style='border-bottom-style: solid; border-bottom-width:1'
        style='border-right-style: solid; border-right-width: 1'
        style='border-top-style: solid; border-top-width:1'
        style='border-left-style: solid; border-left-width: 1'
        WIDTH='250' BGCOLOR='#CCD6CD' VALIGN=top id='headers'>&nbsp;Upload a Picture From:</TD></TR>
        <TR>
        <TD WIDTH='250' VALIGN=TOP>
        <input type='File' name='pic_upload' size=26 maxlength='255' value=$editrow[Picture]>  

        </TD></TR>        

</TABLE>

</TD></TR><TR><TD colspan='2'><p align='center'>

<TABLE WIDTH='250' bordercolor='black' CELLPADDING='0' CELLSPACING='0' BORDER='0'><TR>
        <TD style='border-bottom-style: solid; border-bottom-width:1'
        style='border-right-style: solid; border-right-width: 1'
        style='border-top-style: solid; border-top-width:1'
        style='border-left-style: solid; border-left-width: 1'
        WIDTH='250' BGCOLOR='#CCD6CD' VALIGN=top id='headers'>&nbsp;Description of the Item:</TD></TR>
        <TR>
        <TD WIDTH='250' VALIGN=TOP>
        <textarea name='description' cols='50' rows='10' wrap>$editrow[Description]</textarea>  

        <BR></TD></TR>
</TABLE>

</TD></TR></TABLE>

        <br><input type='submit' name='Update' value='Update'>

</form></div></div></body></html>";
}}           


if ($_POST["Update"])
{

$itemupdatequery = "UPDATE `$table` SET Picture='{$_POST['pic_upload']}', Item_Name='{$_POST['item']}', Description='{$_POST['description']}', Price='{$_POST['price']}', Thumbnail='{$_POST['tn_upload']}' WHERE Product_Number='{$_GET['Product_Number']}'";
 $itemupdateresult           = mysql_query($itemupdatequery);
if (!$itemupdateresult)
{
    $mcrmessage = mysql_error();
     echo "$mcrmessage<br>";
     die();
} 
else
   {
     echo "<div class='returnouter'><div class='returninner'><p align='center'><font id='headers'><br>
     You have successfully edited the item named \"$item\"<br><br><a href='showtable.php'>
     Click the link to return to the categoryviewing page.</a></font></div></div></body></html>";
     exit();
   }
   }

   }

######################################## DELETE SECTION ######################################## 

   if('delete' == $_GET['mode']) { 
    $table=$_GET['table'];
    echo "table: $table<br>"; 

        $deletequery = "DELETE FROM `$table` WHERE Product_Number='{$_GET['Product_Number']}'";
        $deleteresult = mysql_query($deletequery) or die(mysql_error().'<br />');
        echo "<p align='center'><font id='headers'><br>good job, <a href='showtable.php'>";
        echo "click here to go back</a></font></body></html>";


}


database_disconnect();
?>
</body>
</html>

pete_bisby

It usually means that it's confused with the use of single and double quotes within your code, and it's found something that it doesn't like.

If I'm reading it right, line 78 should be near the while loop, just before the ### EDIT SECTION ###. Start looking there, and hopefully you'll find the problem.

DKY

It is exactly that section, yes....I can't figure this thing out though, its driving me nuts.

mmilano

that line looks fine, so i'd look at the lines closely above it .. maybe it is your query string format .. maybe try this?

$editquery = "SELECT Item_Name, Picture, Price, Description FROM $table WHERE Product_Number='" . $_GET['Product_Number'] . "'";

pete_bisby

I always try and keep some consistency with the single and double quotes.

I know it is personal preference on which you use, and I'm unsure whether there is a right/wrong/long/short way of doing things, but you could try the following:

while ($row = mysql_fetch_assoc($result)) {
  $edit = "<a href=\"?mode=edit&table=" . $table . "&Product_Number=" . $row["Product_Number"] . "\">Edit</a>";
  $delete = "<a href=\"?mode=delete&table=" . $table . "&Product_Number=" . $row["Product_Number"] . "\">Delete</a>";
  printf("<tr><td>{" . $row["Product_Number"] . "}</td><td>{" . $row["Picture"] . "}</td><td>{" . $row["Thumbnail"] . "}</td><td>{" . $row["Item_Name"] . "}</td><td>{" . $row["Description"] . "}</td><td align=\"right\">\${" . $row["Price"] . "}</td>" . stripslashes($edit) . "&nbsp;&nbsp;" . stripslashes($delete) . "</td></tr><tr><td colspan=\"7\"><hr /></td></tr>\n"); 
}

The stripslashes() function simply removes the slashes within the strings, which in this case are the $edit and $delete strings.

DKY

I do what mmilano suggested, and nothing happens,

I do what pete_bisby suggested, and I get the parse error still on the same line that the

######################################## EDIT SECTION ########################################

is on, anything else? I'm so confused

Weedpacket

From what I looked at the error was in this line:

    <FORM ENCTYPE='multipart/form-data' ACTION='$_SERVER['PHP_SELF']' METHOD='POST' NAME='input_item'>

Changing that to

    <FORM ENCTYPE='multipart/form-data' ACTION='$_SERVER[PHP_SELF]' METHOD='POST' NAME='input_item'>

or, better yet

    <FORM ENCTYPE='multipart/form-data' ACTION='".$_SERVER['PHP_SELF']."' METHOD='POST' NAME='input_item'>

Fixed that error.

DKY

Thats it, you're awesome. Thank you so much. I've been looking in the wrong spot alltogether. Works beautifully now.