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

foreach iterator
Hi Guys
Does the foreach loop have an inbuilt iterator ?

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

Cron Job and Output
I have php codes running under a cron job.
But everytime i output (echo) , it comes out as comple

Quick Syntax Question
Hi folks,

I'm getting the following error: "unexpected T_LNUMBER". I'm trying to b

Calander Basic Spript help
hi, just starting out with PHP and have the following script:

<?php
//This gets t

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite

ob_ dynamic content
i was wondering about the potential to use ob to create a <div then remove it when the page

start new row of pictures
on my site www.budstreasureauctions.com there is a featured auctions box that users will pay to get

problem with refreshing
in my site, i have an index page, it has a main div. this main div's content is changing according t