getting Vars to pass to next page.

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

Hello all,
I have a confusing situation on my hands, i am a member of a gaming community and we are setting up a website (yay i get to be teh techie!!) im not exactly a noob with php but i am by far not an expert, so i need some help please.

I have a table populated with mysql data, and i am using multiple submit buttons to perform actions to the selected row of information. i have 2 of the 3 buttons working great however the third is not passing on all the information that i need to pass to the next page. the only thing that is not passing is the var $name that is returned from mysql.

Below are the codes i am using. any help with how to get the var $name to pass with the $_POST information would be great, thanks in advance!

The Table:
Code: (php) <?php
include 'config.php';
include 'access.php';

$db = mysql_connect ($hostname, $username, $password) or die ('Failed to connect to database: ' . mysql_error());
mysql_select_db($database);

$query = "SELECT clan_members.authid, clan_members.rank, clan_members.name, admins.access FROM imagest5_bioclan.clan_members LEFT OUTER JOIN imagest5_bioclan.admins ON clan_members.name = admins.name WHERE clan_members.rank = 9 ORDER BY clan_members.rank DESC, clan_members.name";
$result = mysql_query($query) or die ('Failed to query ' . mysql_error());
?>
<form method="post" action="./process.php">
<table width="100%" border="1">
<tr>
<th scope="col">&nbsp;</th>
<th scope="col">SteamID</th>
<th scope="col">Name</th>
<th scope="col">Rank</th>
<th scope="col">Flags</th>
</tr>
<?php
while ($row = mysql_fetch_assoc($result))
{
$auth = $row['authid'];
$name = $row['name'];
$rank = $ranks[$row['rank']];
$flags = $row['access'];
?>
<tr>
<td><div align="center">
<input type="radio" name="auth" id="radio" value="<?php echo "$auth";?>">
</div></td>
<td><?php echo "$auth";?></td>
<td><?php echo "$name";?></td>
<td><?php echo "$rank";?></td>
<td><?php echo "$flags";?></td>
</tr>
<?php
}
?>
</table>
<table width="100%">
<tr>
<td width="11%"><div align="center">
<input type="submit" name="submit[edit]" value="Edit">
</div></td>
<td width="20%"><div align="center">
<input type="submit" name="submit[delete]" value="Delete">
</div></td>
<td width="69%"><div align="center">
<select name="access" id="access">
<option selected="selected">Quick Admin----</option>
<option value='abcdefghijklmnopqrstu'>Leader/CoLeader</option>
<option value='abcdefghijklmnopqrstu'>Tech</option>
<option value='bcdefijmnopqrstu'>Upper Admin</option>
<option value='bcefijnprstu'>Mid Admin</option>
<option value='cfu'>Recruit Admin</option>
<option value='u'>Member</option>
</select>
<input type="submit" name="submit[access]" value="Set">
</div></td>
</tr>
</table>
</form>
<?php
mysql_free_result($result);
mysql_close($db);
?>

The table posts to this page:
Code: (php) <?php
//print_r($_POST);
$submit_array = array_keys($_POST['submit']);
$action = $submit_array[0];
if ($_POST)
{
switch ($action)
{
case 'edit':
echo include('./includes/edit.inc');
break;

case 'delete':
echo include('./includes/delete.inc');
break;
case 'access':
echo include('./includes/mem2admin1.inc');
break;
}
}
?>

and if the set button on the table is clicked the above page loads this:
Code: (php) <?php
if(!isset($_SESSION['clan_id']))
{
die("You are not logged in and cannot view this page.");
}
echo '<center>';
$auth = $_POST['auth'];
$name = $_POST['name'];
$access = $_POST['access'];
echo "

Are you sure you want to give '$access' flags to:

";
echo "SteamID: $auth<br />Name: $name";
echo "

<a href="admin_add3.php?auth=$auth&name=$name&access=$access">Yes</a>&nbsp;&nbsp;<a href="main.php">No</a></center>;"
?>

Your Answer:

Login to answer

Other forums

PHP4 to PHP5 Conversion
Hi Everyone,

I am working on a site that is built up on PHP4 and each page is being started f

help understanding hidden input w/ php
hello i'm doing a tutorial where there are multiple forms for an edit page for a user to update thei

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to a

GET * FROM _____ Except?
I have a site that is for stock photography.

This section of the code calls images to display

Adding meta tags under Zend FW
Hello there, recently has come to my hands the FTP of a website which is running under Zend, I would

Scene graph using Direct3D?
There are several C++ scene graph based packages available for OpenGl, like say OSG,

http://w

[Need Help] php timing issues
I don't know what is going wrong. I need some help with being able to set an image at 9:00am Colorad