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
}
}
}
?>
Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work. | <?$delid=$_GET['delid'];echo $delid;if(isset($_POST['submit'])){$delquery="DELETE FROM table
need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i wants to do other method. i have used this form to send info to paypal and everything is working ok
Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields but have a 30 sec execution limit on my host. im looking for advice on how to loop thrue up to 8
temporary objects
Until now i thought every temporary object in C++ is created as constant. I'm wondering why my compiler (gcc) is reporting an error on line k.f();, but not g().f(); and g() = k;. Does anyone
dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but is missing some functionality and I am very new at php so I need some help or advise please.What I
captcha error
I have been trying to implement a captcha in php...here is the code..Code: (php) [Select]<?php// Set the content-typeheader('Content-type: image/png');// Create the image$im =
Weekly Calendar
Hi, I am looking at creating a weekly calendar. The calendar will read from Monday - Sunday. Does anyone know of any examples or tutorails on how I can achieve this, as I have tried searching without
Trigger tag in aspx is not coming
hi all ,iam new to ajax, iam using file upload inside the update pannel but right now i want to use trigger tag but it is not coming, for that whether i want to install anything like toolkit ,please
turning an array into a string then poping it into a db
Hi im just wondering how you get a requested array into a single string then pop it into the db so far i gotprint_r($_REQUEST['choice_name']);whch echosArray ( => Colour=Blue [1] =>
db entry based on primary key
My "topics" table contains 10 entires*--------------*topicid topic------*--------------* 01 Bye 02 Hi 03 Hello..... 10 Morning*--------------*<?php
