Having trouble with passed variable

stanforrest

Okay I have created a form with one text field. This text field is named "tbl_name". when you type a name of a table within a mysql data base and then click the submit button, you are taken to a details page which retirne records from the chosen table.

I have added the following code at the top of the details page;

<?
$variable=$_POST['tbl_name'];
?>

<?php // Content Source
$Tickets = WrapMySQLDatabaseResults("ticketwizard", "select * from $varname where TicketLevel like '%" . pageParameter("TicketLevel","") . "%' and TicketSection like '%" . pageParameter("TicketSection","") . "%' and TicketRow like '%" . pageParameter("TicketRow","") . "%' and TicketSeat like '%" . pageParameter("TicketSeat","") . "%' and TicketStatus like '%" . pageParameter("TicketStatus","") . "%' and TicketFName like '%" . pageParameter("TicketFName","") . "%' and TicketLName like '%" . pageParameter("TicketLName","") . "%'", "block=20","Tickets");
?>

The variable types in the privious form passes correctly, however once on thie deatils page I can not page through records or update records. When I try all I get is a blank screen with the following error in the source code.

ERROR Number="8" Description="Error: "Undefined index: tbl_name" on line 12 of /home/virtual/site20/fst/var/www/html/details_test3.php.

I guess thats because once you have pass the variable to the details page all php is stripped from that page and any action on that page then can not recognise the passed avriable.

Is there a way to code the details page in such a way that it will retain the variable that was passed?

Below is the code that is used on the details page to page through records and run searches.

<! Search Form -->

      <FORM action="details_test3.php" method="get" name="FormName">
        <P><SELECT name="TicketLevel">
            <OPTION value="">Select Level</OPTION>
            <OPTION value="Orchestra">Orchestra</OPTION>
            <OPTION value="Terrace">Terrace</OPTION>
            <OPTION value="Balcony">Balcony</OPTION>
          </SELECT></P>
        <P><SELECT name="TicketSection">
            <OPTION value="">Select Section</OPTION>
            <OPTION value="A">A</OPTION>
            <OPTION value="B">B</OPTION>
            <OPTION value="C">C</OPTION>
            <OPTION value="D">D</OPTION>
            <OPTION value="E">E</OPTION>
            <OPTION value="F">F</OPTION>
            <OPTION value="G">G</OPTION>
          </SELECT></P>
        <P><SELECT name="TicketRow">
            <OPTION value="">Select Row</OPTION>
            <OPTION value="A">A</OPTION>
            <OPTION value="B">B</OPTION>
            <OPTION value="C">C</OPTION>
            <OPTION value="D">D</OPTION>
            <OPTION value="E">E</OPTION>
            <OPTION value="F">F</OPTION>
            <OPTION value="G">G</OPTION>
            <OPTION value="H">H</OPTION>
            <OPTION value="I">I</OPTION>
            <OPTION value="J">J</OPTION>
            <OPTION value="K">K</OPTION>
            <OPTION value="L">L</OPTION>
            <OPTION value="M">M</OPTION>
            <OPTION value="N">N</OPTION>
            <OPTION value="O">O</OPTION>
            <OPTION value="P">P</OPTION>
            <OPTION value="Q">Q</OPTION>
            <OPTION value="R">R</OPTION>
            <OPTION value="S">S</OPTION>
            <OPTION value="T">T</OPTION>
            <OPTION value="U">U</OPTION>
          </SELECT></P>
        <P><SELECT name="TicketSeat">
            <OPTION value="">Select Seat</OPTION>
            <OPTION value="01">1</OPTION>
            <OPTION value="02">2</OPTION>
            <OPTION value="03">3</OPTION>
            <OPTION value="04">4</OPTION>
            <OPTION value="05">5</OPTION>
            <OPTION value="06">6</OPTION>
            <OPTION value="07">7</OPTION>
            <OPTION value="08">8</OPTION>
            <OPTION value="09">9</OPTION>
            <OPTION value="10">10</OPTION>
            <OPTION value="11">11</OPTION>
            <OPTION value="12">12</OPTION>
            <OPTION value="13">13</OPTION>
            <OPTION value="14">14</OPTION>
          </SELECT></P>
        <P><INPUT type="text" name="TicketFName" size="24">First Name</P>
        <P><INPUT type="text" name="TicketLName" size="24">Last Name</P>
        <P><SELECT name="TicketStatus">
            <OPTION value="">Select Status</OPTION>
            <OPTION value="Available">Available</OPTION>
            <OPTION value="Sold">Sold</OPTION>
            <OPTION value="Season">Season</OPTION>
            <OPTION value="NoSale">NoSale</OPTION>
          </SELECT><INPUT class="MainButton" type="submit" name="submitButtonName" value="Search for Tickets">
      </FORM>

      <FORM action='config/actions/mysql.actions6.php?<?php echo URLArgs(array())?>' method="post" name="Form2">
        <DIV align="center">

        </DIV>
        <P><B><?php echo $Tickets->RecordCount()?></B> Tickets found.</P>
        <TABLE width="80%" border="0" cellspacing="2" cellpadding="0">
          <TR>
            <TD><A <?php echo LinkToPreviousRecord($Tickets)?>>&lt;&lt;Previous Page</A></TD>
            <TD>
              <DIV align="right">
                <A <?php echo LinkToNextRecord($Tickets)?>>Next Page&gt;&gt;</A></DIV>
            </TD>
          </TR>
        </TABLE>
        <TABLE width="80%" border="0" cellspacing="0" cellpadding="4">
          <TR>
            <TD class="TableRow" width="41">Level</TD>
            <TD class="TableRow" width="42">Section</TD>
            <TD class="TableRow" nowrap width="22">Row</TD>
            <TD class="TableRow" nowrap width="23">Seat#</TD>
            <TD class="TableRow" nowrap width="157">First Name</TD>
            <TD class="TableRow" nowrap width="157">Last Name</TD>
            <TD class="TableRow" nowrap width="86">Status</TD>
          </TR>
        </TABLE>
        <TABLE width="80%" border="0" cellspacing="0" cellpadding="4">
						<?php $Tickets->MoveFirst(); ?>
						<?php $Tickets->Move($Tickets->FirstRecordOnPage() - 1); ?>
						<?php while (!$Tickets->EOF() && !$Tickets->EOB()) { ?>
						<TR>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> width="41"><?php echo $Tickets->Value("TicketLevel")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> width="42"><?php echo $Tickets->Value("TicketSection")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="22"><?php echo $Tickets->Value("TicketRow")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="23"><?php echo $Tickets->Value("TicketSeat")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="157"><INPUT type="text" name='TicketFName(<?php echo $Tickets->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($Tickets->Value("TicketFName")) ?>' size="24"></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="157"><INPUT type="text" name='TicketLName(<?php echo $Tickets->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($Tickets->Value("TicketLName")) ?>' size="24"></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="102"><SELECT name='TicketStatus(<?php echo $Tickets->AbsolutePosition()?>)' size="1">
                <OPTION value="Available"         <?php echo selected($Tickets->Value("TicketStatus") == "Available") ?>>Available</OPTION>
                <OPTION value="Sold"         <?php echo selected($Tickets->Value("TicketStatus") == "Sold") ?>>Sold</OPTION>
                <OPTION value="Season"         <?php echo selected($Tickets->Value("TicketStatus") == "Season") ?>>Season</OPTION>
                <OPTION value="NoSale"         <?php echo selected($Tickets->Value("TicketStatus") == "NoSale") ?>>NoSale</OPTION>
              </SELECT></TD>
          </TR>
						<?php $Tickets->MoveNext(); ?>
						<?php } ?>
        </TABLE>

        <TABLE width="80%" border="0" cellspacing="2" cellpadding="0">
          <TR>
            <TD><A <?php echo LinkToPreviousRecord($Tickets)?>>&lt;&lt;Previous Page</A></TD>
            <TD>
              <DIV align="right">
                <A <?php echo LinkToNextRecord($Tickets)?>>Next Page&gt;&gt;</A></DIV>
            </TD>
          </TR>
        </TABLE>
        <DIV align="center">
          <P><INPUT type="submit" name="_SubmitChanges"           <?php SetupMySQLUpdate('$return', '$return', $Tickets) ?>></P>
        </DIV>
					<?php SetupMySQLForm($Tickets); ?>

      </FORM>

Please help I am at a loss as to what to do next.

kevinsequeira

correct me if im wrong, the form input tbl_name is passed to the details page and you are able to capture and display it
as $variable=$_POST['tbl_name'];

then u say

The variable types in the privious form passes correctly, however once on thie deatils page I can not page through records or update records. When I try all I get is a blank screen with the following error in the source code.
. ....

Is there a way to code the details page in such a way that it will retain the variable that was passed?

on what line are u using this variable and also what is the code on line 12 where u are getting the error ??

is this site available on the net so that i can take a look or is it hosted on a local machine

reg
kevin

kevinsequeira

aah, add a hidden field in your forms on details page
<form ........>
.
.
.
.
<input type="hidden" name="tbl_name" value=<?php print($varaible); ?>">
.
.
.
.
</form>

reg
kevin

stanforrest

Line 12 contains

$varname=$_POST['tbl_name'];

This is the code that works fine when the variable from the previous form is submitted, and this is the line of code that is returnint the undefined error when I try to page through records or update records once on the page after the variable has been passed.

I also tried adding the

as you has stated in the forms on the details page, however I am still getting the following error in the spurce code.

ERROR Number="8" Description="Error: "Undefined index: tbl_name" on line 12 of /home/virtual/site20/fst/var/www/html/details_test3.php

Any Ideas?

kevinsequeira

try changing line 12 to this

if(isSet($POST['tbl_name')){
$varname = $POST['tbl_name');
}else{
$varname = $_GET['tbl_name');
}

is this code that you have written or are u modifying older code ?

EDIT :
another way for you to go is to use sessions to store the tbl_name
reg
kevin

stanforrest

The following code you gave

if(isSet($POST['tbl_name')){
$varname = $POST['tbl_name');
}else{
$varname = $_GET['tbl_name');
}

does not work it is returning errors.

However I did discover the search is now working when the following code you suggested;

is placed in the search form.

Now all we need to do is get the next and previous record links working as well as the update record working. The link for the next record looks like the following;

details_test3.php?tbl_name=Master_Table&TicketLevel=Terrace&TicketSection=&TicketRow=&TicketSeat=&TicketFName=&TicketLName=&TicketStatus=&submitButtonName=Search+for+Tickets&RECORD_INDEX%28Tickets%29=21

as you can see there is a lot of extra code placed in the link, why I have no idea.

Now here is what the link looks like when a variable is not pass from the previous form.

details_test2.php?RECORD_INDEX%28Tickets%29=21

May be I need to dump adobe golive's database code all together. Seems all code I have written my self is working.

Again here is the code that is generated by adobe golive for the update, next and previous navigation

<FORM action='config/actions/mysql.actions6.php?<?php echo URLArgs(array())?>' method="post" name="FormName">
<DIV align="center">

        </DIV>
        <P><B><?php echo $Tickets->RecordCount()?></B> Tickets found.</P>
        <TABLE width="80%" border="0" cellspacing="2" cellpadding="0">
          <TR>
            <TD><A <?php echo LinkToPreviousRecord($Tickets)?>>&lt;&lt;Previous Page</A></TD>
            <TD>
              <DIV align="right">
                <A <?php echo LinkToNextRecord($Tickets)?>>Next Page&gt;&gt;</A></DIV>
            </TD>
          </TR>
        </TABLE>
        <TABLE width="80%" border="0" cellspacing="0" cellpadding="4">
          <TR>
            <TD class="TableRow" width="41">Level</TD>
            <TD class="TableRow" width="42">Section</TD>
            <TD class="TableRow" nowrap width="22">Row</TD>
            <TD class="TableRow" nowrap width="23">Seat#</TD>
            <TD class="TableRow" nowrap width="157">First Name</TD>
            <TD class="TableRow" nowrap width="157">Last Name</TD>
            <TD class="TableRow" nowrap width="86">Status</TD>
          </TR>
        </TABLE>
        <TABLE width="80%" border="0" cellspacing="0" cellpadding="4">
						<?php $Tickets->MoveFirst(); ?>
						<?php $Tickets->Move($Tickets->FirstRecordOnPage() - 1); ?>
						<?php while (!$Tickets->EOF() && !$Tickets->EOB()) { ?>
						<TR>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> width="41"><?php echo $Tickets->Value("TicketLevel")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> width="42"><?php echo $Tickets->Value("TicketSection")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="22"><?php echo $Tickets->Value("TicketRow")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="23"><?php echo $Tickets->Value("TicketSeat")?></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="157"><INPUT type="text" name='TicketFName(<?php echo $Tickets->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($Tickets->Value("TicketFName")) ?>' size="24"></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="157"><INPUT type="text" name='TicketLName(<?php echo $Tickets->AbsolutePosition()?>)' value='<?php echo fixHTMLquotes($Tickets->Value("TicketLName")) ?>' size="24"></TD>
            <TD <?php echo Alternate($Tickets->AbsolutePosition(), "class", "1:ColumnItem,1:ColumnItemAlt")?> nowrap width="102"><SELECT name='TicketStatus(<?php echo $Tickets->AbsolutePosition()?>)' size="1">
                <OPTION value="Available"         <?php echo selected($Tickets->Value("TicketStatus") == "Available") ?>>Available</OPTION>
                <OPTION value="Sold"         <?php echo selected($Tickets->Value("TicketStatus") == "Sold") ?>>Sold</OPTION>
                <OPTION value="Season"         <?php echo selected($Tickets->Value("TicketStatus") == "Season") ?>>Season</OPTION>
                <OPTION value="NoSale"         <?php echo selected($Tickets->Value("TicketStatus") == "NoSale") ?>>NoSale</OPTION>
              </SELECT></TD>
          </TR>
						<?php $Tickets->MoveNext(); ?>
						<?php } ?>
        </TABLE>

        <TABLE width="80%" border="0" cellspacing="2" cellpadding="0">
          <TR>
            <TD><A <?php echo LinkToPreviousRecord($Tickets)?>>&lt;&lt;Previous Page</A></TD>
            <TD>
              <DIV align="right">
                <A <?php echo LinkToNextRecord($Tickets)?>>Next Page&gt;&gt;</A></DIV>
            </TD>
          </TR>
        </TABLE>
        <DIV align="center">
          <P><INPUT type="submit" name="_SubmitChanges"           <?php SetupMySQLUpdate('$return', '$return', $Tickets) ?>></P>
        </DIV>
					<?php SetupMySQLForm($Tickets); ?>

      </FORM>

What do you think?