Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    Regular Coder
    Join Date
    Jun 2008
    Posts
    680
    Thanks
    114
    Thanked 2 Times in 2 Posts

    Passing Variables

    What I'm wanting to do is when the user clicks on Arenas it will pass the name of the country on to the next form from case 0 to case when it shows that countries list of Arenasbut don't know how to pass it. I'm sure it's with a hidden input tag but if this is true where at do I place it and what do I do to option case 3 where it displays the list of arenas at?

    PHP Code:
    <?php 
       $e 
    = <<<here
           <script src="./jscripts/scriptaculous/prototype.js" type="text/javascript"></script>
          <script src="./jscripts/scriptaculous/scriptaculous.js" type="text/javascript"></script>
          <script type="text/javascript" src="./jscripts/ajax.js"></script>
    here;
       switch (
    $_REQUEST['option']) {
          case 
    0:
             echo 
    $e;
             
    ?>
                <h1 class=backstage>Arena Management</h1><br />
                <h2 class="backstage">Countries :: <a href="#" onclick="ajaxpage('backstage_libs/arenas.php?option=1', 'content'); return false;">Add New</a></h2><br />
                <table width="100%" class="table1">
                    <tr class="rowheading">
                        <td>&nbsp;</td>
                        <td width="20" align="center">ID</td>
                        <td>Country</td>
                        <td>&nbsp;</td>
                    </tr>
                <?php    
                $query 
    "SELECT * FROM efed_list_arenas_countries ORDER BY `country`";
                
    $result mysql_query $query ); 
        
                if (
    $result) {
                
    $i 0;
                while ( 
    $row mysql_fetch_array $resultMYSQL_ASSOC ) ) {
                   
    $sClass 'row2';
                   if (
    $i++ % 2$sClass 'row1';
                   
    printf "<tr class=\"%s\">"$sClass );
                        print 
    "<td valign=\"top\" align=\"center\" width=\"30\"><a href=\"#\" onclick=\"ajaxpage('backstage_libs/arenas.php?option=2', 'content'); return false;\">Edit</a></td>";
                        
    printf "<td align=\"center\" width=\"20\">%s</td>"$row [id] );
                        
    printf "<td valign=\"top\">%s</td>"$row [country] );
                        print 
    "<td valign=\"top\" align=\"center\" width=\"80\"><a href=\"#\" onclick=\"ajaxpage('backstage_libs/arenas.php?option=3', 'content'); return false;\">Arenas</a></td>";
                        echo 
    '</tr>';
                    }
                echo 
    '</table><br>';
             } else {
                echo 
    '<span>There are no match types.</span><br />';
             }
             
    returnmain();
          break;
          case 
    1:
             echo 
    $e;
             require_once(
    '../backstagefunctions.php');
             
    ?> 
                <h1 class="backstage">Arena Management</h1><br />
                <h2 class="backstage">Add Country</h2><br />
                <form name="addcountry" method="post">
                <input type="hidden" name="action" value="arenas" />
                    <table width="100%" class="table2">
                        <tr>
                            <td width="120" class="rowheading" valign="center">Country:</td><td class="row3"><input type="text" name="country" class="fieldtext490"></td>
                        </tr>
                    </table><br />
                    <input type="hidden" name="newadded" value="true">
                    <input type="submit" value="Save Country" class=button></form><br />
                    <input type="button" value="Return to Country List" class="button200"><br />
                </form><br />
             <?php
             returnmain
    ();
          break;
          case 
    2:
             echo 
    $e;
             require_once(
    '../backstagefunctions.php');
             
    ?>
                <h1 class="backstage">Arena Management</h1><br />
                <h2 class="backstage">Edit Country</h2><br />
                <table width="100%" class="table2">
                    <tr>
                        <td width="120" class="rowheading" valign="center">Country:</td><td class="row3"><input type="text" name="country" class="fieldtext490" value=""></td>
                    </tr>
                </table><br />
                <input type="checkbox" name="deletecountry"><span class="table1heading">Delete Country and Arenas?</span><br /><br />
                <input type="submit" value="Edit Country" class=button><br /><br />
                <input type="button" value="Return to Country List" class="button200"><br /><br />
            </form><br />
                <?php
                returnmain
    ();
            break;
          case 
    3:
             echo 
    $e;
             require_once(
    '../backstagefunctions.php');
             
    ?>
                <h1 class=backstage>Arena Management</h1><br />
                <h2 class=backstage>Arenas :: <a href="#" onclick="ajaxpage('backstage_libs/arenas.php?option=4', 'content'); return false;">Add New</a></h2><br />
                <table width="100%" class="table1">
                    <tr class="rowheading">
                        <td>&nbsp;</td>
                        <td>Location</td>
                        <td>Arena</td>
                        <td align=center>Capacity</td>
                    </tr>
                <?php
                $query 
    "SELECT * FROM efed_list_arenas";
                
    $result mysql_query $query ); 
        
                if (
    $result) {
                
    $i 0;
                while ( 
    $row mysql_fetch_array $resultMYSQL_ASSOC ) ) {
                   
    $sClass 'row2';
                   if (
    $i++ % 2$sClass 'row1';
                   
    printf "<tr class=\"%s\">"$sClass );
                        print 
    "<td valign=\"top\" align=\"center\" width=\"30\"><a href=\"#\" onclick=\"ajaxpage('backstage_libs/arenas.php?option=5', 'content'); return false;\">Edit</a></td>";
                        
    printf "<td valign=\"top\">%s</td>"$row [city] );
                        
    printf "<td valign=\"top\">%s</td>"$row [arena] );
                        
    printf "<td align=\"center\" valign=\"top\">%s</td>"$row [capacity] );
                        echo 
    '</tr>';
                    }
                echo 
    '</table><br>';
             } else {
                echo 
    '<span>There are no match types.</span><br />';
             }
             
    returnmain();
          break;
          case 
    4:
             echo 
    $e;
             require_once(
    '../backstagefunctions.php');
             
    ?> 
                <h1 class="backstage">Arena Management</h1><br />
                <h2 class="backstage">Add New Arena</h2><br />
                <form name="addarena" method="post">
                    <table width="100%" class="table2">
                        <tr>
                            <td width="120" class="rowheading" valign="center">Arena:</td><td class="row3"><input type="text" name="name" class="fieldtext490"></td>
                        </tr>
                        <tr>
                            <td width="120" class="rowheading" valign="center">City, State:</td><td class="row3"><input type="text" name="location" class="fieldtext490"></td>
                        </tr>
                        <tr>
                            <td width="120" class="rowheading" valign="center">Capacity:</td><td class="row3"><input type="text" name="capacity" class="fieldtext140"></td>
                        </tr>
                    </table><br />
                    <input type="hidden" name="newadded" value="true">
                    <input type="submit" value="Save Arena" class="button" name="addarena"><br /><br />
                    <input type="button" value="Return to Arena List" class="button200"><br /><br />
                </form><br />
             <?php
             returnmain
    ();
          break;
          case 
    5:
             echo 
    $e;
             require_once(
    '../backstagefunctions.php');
             
    ?>
                <h1 class="backstage">Arena Management</h1><br />
                <h2 class="backstage">Edit Arena</h2><br />
                <form name="editarena" method="post">
                    <table width="100%" class="table2">
                        <tr>
                            <td width="120" class="rowheading" valign="center">Arena:</td><td class="row3"><input type="text" name="name" class="fieldtext490"></td>
                        </tr>
                        <tr>
                            <td width="120" class="rowheading" valign="center">City, State:</td><td class="row3"><input type="text" name="location" class="fieldtext490"></td>
                        </tr>
                        <tr>
                            td width="120" class="rowheading" valign="center">Capacity:</td><td class="row3"><input type="text" name="capacity" class="fieldtext140"></td>
                        </tr>
                    </table><br />
                    <input type="submit" value="Save Arena" class="button" name="addarena"><br /><br />
                    <input type="button" value="Return to Arena List" class="button200"><br /><br />
                </form>
             <?php
             returnmain
    ();
          break;
       }
       function 
    arenas() {
          if ((!empty(
    $_POST['newadded']))) {
             
    $country mysql_real_escape_string($_POST['country']);
             
    $query "INSERT INTO `efed_list_arenas_countries` (country) VALUES ('".$country."')";
             if (
    mysql_query($query)) {
                
    //success
             
    } else {
                
    //fail
             
    }
          }
       }
    ?>
    Last edited by CoolAsCarlito; 12-14-2009 at 11:19 AM.

  • #2
    Senior Coder tomws's Avatar
    Join Date
    Nov 2007
    Location
    Arkansas
    Posts
    2,644
    Thanks
    29
    Thanked 330 Times in 326 Posts
    Since you're only using links and not a form, you'll need to pass it as another parameter in the URL.
    Are you a Help Vampire?

  • #3
    Regular Coder
    Join Date
    Jun 2008
    Posts
    680
    Thanks
    114
    Thanked 2 Times in 2 Posts
    So for example how would it look?

  • #4
    Senior Coder tomws's Avatar
    Join Date
    Nov 2007
    Location
    Arkansas
    Posts
    2,644
    Thanks
    29
    Thanked 330 Times in 326 Posts
    Code:
    <a href="#" onclick="ajaxpage('backstage_libs/arenas.php?option=x&itsNotBrainSurgery=true', 'content'); return false;">Some Link</a>
    Are you a Help Vampire?

  • #5
    Regular Coder
    Join Date
    Jun 2008
    Posts
    680
    Thanks
    114
    Thanked 2 Times in 2 Posts
    This is the tag I have. I"m wanting to pass along the number of the id in the table.

    <a href=\"#\" onclick=\"ajaxpage('backstage_libs/arenas.php?option=3', 'content'); return false;\">Arenas</a>

  • #6
    Regular Coder
    Join Date
    Jun 2008
    Posts
    680
    Thanks
    114
    Thanked 2 Times in 2 Posts
    Could it be something like :

    <a href=\"#\" onclick=\"ajaxpage('backstage_libs/arenas.php?option=3?id="'.row['id'].'"', 'content'); return false;\">Arenas</a>

    It as a guess but i have no clue. Even if for some odd reason that is right i know my quotes are wrong how shoudl that look.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •