PHP_SELF

theslug

I have a fairly simple PHP script.

The first portion is a FORM which queries a
mysql database for a serialnumber

<?php
  unset ($stage);
  if (!isset($stage))
    {
?>

<FORM METHOD="POST" ACTION="<?php print("$PHP_SELF"); ?>">

 -- HTML TABLE FORM STUFF HERE --

Now from my understanding, it should not process when happens in the else statement because $stage is not set yet (I have a hidden value setting stage to 1 in the first form), it will only look at the else portion if $stage is set with a value

However, when I test the page out, it gives me a parse error for one of the queries in the else statement (pasted below).
Obviously the queries will not work because i need the 5 digit number to be queried first!... From what I've read on php.net/manual the following should work...
Can someone shed some light on this subject?
<?php
}
else
{
include("/var/www/phpincludes/info.inc");

      // Connect to database
      $global_dbh = mysql_connect($hostname, $username, $password);
      if (!$global_dbh)
        die("Cannot Connect to Database");
      mysql_select_db($db, $global_dbh);

      // Find the spa
      // Insert sanity checking here someday
      $query = "SELECT * from spaserial where serialnum=\"wspanumquery\"";
      $result_query = mysql_query($query);
      $row = mysql_fetch_row($result_query);

      // Find the Dealer
      $dealer_query = "SELECT store_name from dealer where dealer_id=\"$row[3]\"";
      $result_dealer = mysql_query{$dealer_query);
      $row_dealer = mysql_fetch_row($result_dealer);

      // Find the Model
      $model_query = "SELECT modelname from spamodel where modelabbr=\"$row[5]\"";
      $result_model = mysql_query($model_query);
      $row_model = mysql_fetch_row($result_model);
?>

theslug

Here's all the code.

<TITLE>
SPA STATUS>
</TITLE>

<BODY BGCOLOR=white>
<CENTER> SPA STATUS
</CENTER>

<?php
  unset ($stage);
  if (!isset($stage))
    {
?>

<FORM METHOD="POST" ACTION="<?php print("$PHP_SELF"); ?>">

  <TABLE WIDTH=100%>
    <TR>
      <TD WIDTH=30%>
        FIVE DIGIT SPA NUMBER:
      </TD>
      <TD WIDTH=70%>
        <INPUT TYPE=TEXT NAME="wspanumquery" SIZE=6>
      </TD>
    </TR>
  </TABLE>

  <BR><BR>
  <CENTER>
    <INPUT TYPE=HIDDEN NAME="stage" VALUE=1>
    <INPUT TYPE=SUBMIT VALUE="FIND SPA">
  </CENTER>

</FORM>

<?php
    }
  else
    {
      include("/var/www/phpincludes/info.inc");

      // Connect to database
      $global_dbh = mysql_connect($hostname, $username, $password);
      if (!$global_dbh)
        die("Cannot Connect to Database");
      mysql_select_db($db, $global_dbh);

      // Find the spa
      // Insert sanity checking here someday
      $query = "SELECT * from spaserial where serialnum=\"wspanumquery\"";
      $result_query = mysql_query($query);
      $row = mysql_fetch_row($result_query);

      // Find the Dealer
      $dealer_query = "SELECT store_name from dealer where dealer_id=\"$row[3]\"";
      $result_dealer = mysql_query{$dealer_query);
      $row_dealer = mysql_fetch_row($result_dealer);

      // Find the Model
      $model_query = "SELECT modelname from spamodel where modelabbr=\"$row[5]\"";
      $result_model = mysql_query($model_query);
      $row_model = mysql_fetch_row($result_model);
?>

<BR><BR><HR><BR><BR>

<TABLE WIDTH=100%>
  <TR>
    <TD WIDTH=30%>
      DEALER:
    </TD>
    <TD WIDTH=70%>
      <?php print("$row_dealer[0]");
      ?>
    </TD>
  </TR>

  <TR>
    <TD WIDTH=30%>
      5 DIGIT NUMBER:
    </TD>
    <TD WIDTH=70%>
      <?php print("$row[6]\n"); ?>
    </TD>
  </TR>

  <TR>
    <TD WIDTH=30%>
      MODEL:
    </TD>
    <TD WIDTH=70%>
      <?php print("$row_model[0]\n"); ?>
    </TD>
  </TR>
</TABLE>

<?php
    }
?>

</BODY>

ccalzaretta

what are the errors where.

theslug

Parse error: parse error in /var/www/html/arctic/spastatus.php on line 57

knickerlas

Let's see line 57 then?

theslug

I just tried changing my if statement to

$stage = 0;
if (empty($stage))

the same thing occured.

So I commented out
$result_dealer, $row_dealer, $result_model and
$row_model

After that it worked okay.
My first condition printed, I submitted my value and then the condition for else printed up (except for the fact that i didn't get my data printed out..)

So now i'm curious, even though there is an
if statement, does the else portion get processed in php (btw I'm using PHP4)?
Or did I miss something really stupid and should go back to PHP 101 ??

theslug

My entire code is in the second posting I made at 14:31:06

What I'm having problems with is the fact that the script is processing my else statement.
When it does that, it errors out at my query which is being processed on line 57. That would happen because if it processes the else statement then it hasn't gotten the information yet necessary to process the query

LINE 56: $dealer_query = "SELECT store_name from dealer where dealer_id=\"$row[3]\"";
LINE 57: $result_dealer = mysql_query{$dealer_query);
row[3] comes from this:
$query = "SELECT * from spaserial where serialnum=\"wspanumquery\"";
$result_query = mysql_query($query);
$row = mysql_fetch_row($result_query);

theslug

SIGH

I had a REALLY stupid syntax error which I just clued into...

I found my problem.. fixed it..
working great now...

/me feels sheepish!

Thanks for all of your help!!! 🙂