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> </td>
<td width="20" align="center">ID</td>
<td>Country</td>
<td> </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> </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
}
}
}
?>
No comments posted yet
Your Answer:
Login to answer
291 41
Other forums calculator I can't figure out why this code doesn't work. No error messages. Page loads. Code: <
Hi, explode and strstr. Hi, I seem to be confused about the strstr function, eg. i have a string like: "a.b.c.d.e.f&
Deleting Partners on the Customer Master. Does SAP handle removing the Partner from Open Sales Orders when a Partner is deleted in the Custome
Checking BOM Authorization Group Hai Friends,
I have developed a mulitilevel BOM display report. End users have been assig
Multiple Options for a Single Page For this example I want to use the Handlers option which is under Fed Admin and all the related codi
Remove values in array2 from array1 I have two arrays. Array 1 is where the array key holds various different numbers. For exampl
Multiple while loops I have several DB queries that I know should be returning results and aren't. I have a feeling it ha
Good Programming and Web Design Books Hi, I recived a pm today from a fellow phpfreaker regarding php books, i replied with the fo
need help about i store the value of my select statement result to an array and stored it to a variable named $fname
filesize() returns 0 I have a socket program that runs in an infinite loop, listening for connections, in this socket I h