Passing Variables

Posted on 16th Feb 2014 07:03 pm by admin

What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's wanting to see the list of Arenas for but 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?

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 ( $result, MYSQL_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>
';
} 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 ( $result, MYSQL_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>
';
} 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
}
}
}
?>

Your Answer:

Login to answer

Other forums

connect() succeeds but accept() does not?
Please help me with this problem. I'm working on a time-sensitive project where I'm using TCP socket

Unique Visitor Tracking
Hello. Currently, I run a voting site where voters are tracked by their IP address and can only vote

Remove Rows From Database ad
Hi All,

I have this:

Code: [Select]<?php
session_start();
include('../com

Cloud Computing?
Hello,

I was wondering if anyone could help explain this term to me. I'm starting to hear it

send() and recv() parameters confusion
On server Side:
int recv (Socket,Buffer, Length, Flags)
On Client Side:
int send (Soc

Best way to cross matching large datasets
Hi,

Im running a script where am I cross matching about 200 000 data sets with each other. Ea

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

update sql when refresh - php
hi
I have made a table (attachement)

the users can update the sql database using + or x bu

Problems with returning true or false in eval()'d code
Hi guys,

Would appreciate some help with a problem when running eval() on a function that sho

how to populate a drop down box
Hi buddies!

PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLO