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"> </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> <a href="main.php">No</a></center>;"
?>
Can I call a class inside a function?
I have a class written in another file that handles my image resizing.Can I do this (php says I can't calling a non-existent class), but I know its there becuase the require doesn't fail aboveCode:
Find only certain URLs from page ... regex (semi-complete script)
Hi guys,What I need to do is take a page & extract all the URLs from the page & place them in an array.However I only need to grab certain
Need help with an email blocker for a guessbook
I am new with php and here is a simple guessbook page but I am being hit with spam from a group of the same email. I know I need to do an IF statement but I am kinda foggy on how to do the code.What I
ereg_replace()
Basically what i need to do is $title = "This Suck's"$striped = ereg_replace("[^A-Za-z0-9]", " ", $title ); However, I only want it to strip the " ' "
How do i use vars in an array
Hiya peeps!How do I use a var in an array. You will see $id but it isnt working.array('MAINCONTENT' => '<div id="registration"><form id="register"
PHP time (deadline within one week)
I have a column ['projdue'], which stores the deadline for a project.I have PHP code and <span class>'s to show projects that are within timescale, due today and overdue:Code:
mail() problem
Hi Guys,I've set up a contact email form. It sends the information fine, but it sends it to the junk folder.If I just use this command:$headers = "MIME-Version: 1.0 \n";It will send it to
If a record matches an existing record do nothing
So I don't know if I should put this here or in mysql, but what my script is for is for people to add their emails to our mailing list. Pretty simple, I got that working. But what I want it do now
LSB (PHP 5.3) problem with static value!
hello,i'm having a problem. static::$text variable gets lost at some point. can someone please correct and explain it to me?Line number On/Off| Expand/Contract <?phpclass A { protected
form submit at godaddy?
Trying to test form submission at GoDaddy and it does not seem to work. Here's the page...http://brinsterinc.com/tireclick/test.phpHere's the source...Code: