passing an unknown var with a submit button

flash-genie

Hi again!:rolleyes:

Im trying to make an admin table where if the user has admin rights he can delete a user by pressing on the related "delete" button. I want to send the "id" to deleteuser.php which I can then use to delete that line from the databank.

How do I go about sending an unknown hidden value once someone clicks the submit button?

As you can see in my code snippet, the table entries are getting called from a database.

Do i have to just use a link with a value of something like echo '<a href="deleteuser.php?bin='.$line->id.'">Delete this user</a>'; on each line or is there a guru solution?

I dont know why, but I seem to try to avoid placing vars in the address if I can.

This is what im using atm:

<form action="deleteuser.php" method="post">
<?
if($_SESSION['admin']==true){
	$counter = 1;
	while($line = @mysql_fetch_object($adminquery)) {
		echo '<tr>';
		echo '<td width="30" bgcolor="#004080" align="right">'.$counter.'</td>';
		echo '<td width="250" bgcolor="#004080">'.$line->user.'</td>'; 
			echo '<td width="120" bgcolor="#004080">';
			//this doesnt work as it just keeps overwriting $line - > id
			echo '<input type="hidden" name="id" value="'.$line->id.'">';
			//$line->id is placed correctly in the next line
			echo '<input type="submit" name="delete" value="L&ouml;schen" class="button">'.$line->id.'</td>';	
			echo '<td width="120" bgcolor="#004080">&nbsp;</td>';
			}
		echo '</tr>';
		$counter++;
	}
	?>
	</form>

I would appreciate any help, even if its just a link to another thread or a keyword i could use to search i couldnt find anything

:queasy: which I find hard to believe.

Thanks for your help,
FG

Bloodwine

not 100% what you are wanting, so excuse me if I don't answer the question properly.

If you are wanting to be able to delete multiple users or one user in a list and know which id was used, then change the '<input type="hidden" name="id" value=...' to '<input type="checkbox" name="id[]" value=...'

then on the next page do

if (is_array($_POST['id'])) {
   if (sizeof($_POST['id']) > 0) {
      foreach ($_POST['id'] as $id_del) {
         // delete each user one at a time here
     }
   }
   else {
      echo 'You did not specify any users to delete.<br />';
   }
}

And either only have one 'Delete' submit button or maybe place every 10-20 users so they don't have to scroll too far up or down to perform the deletion

flash-genie

Thanks for your answer,
so...

<input type="checkbox" name="id[]" value="$line->id">

when selected will "push" the value to an array called id as soon as I click my submit btn?

Thanks again!

Bloodwine

Originally posted by flash-genie
when selected will "push" the value to an array called id as soon as I click my submit btn?

Yep, works great when wanting to deal with processing checkbox values and you don't know how many entries you'll be receiving. Only validation needed is to make sure it is an array before foreach()'ing over it.

flash-genie

Cool thanks,
Ill give it a shot 🙂

Taff

flash-genie

Thanks again for that bit of code, unfortunately Im lacking in the knowledge to make it do anything else than you described here.

As soon as I try to go one step further I take about a 4km run backward.

I can get the code to the next page. I want to be able to place the list of users Im planning on deleting in to a table, along these lines:

 
$query =@mysql_query("select id, user FROM users") or die ("looks like Ive screwed up again");

<table>
<?
if (is_array($_POST['id'])){
   if(sizeof($_POST['id'])>0){
         //make a tr/td
         <tr><td>Sure you want to delete the following?</td></tr>
     foreach($_POST['id'] as $id_del){
        echo "<tr><td>".$id_del."</td></tr>";
	//returns for example 3, 6, 8 as one would expect
     }
}else{
     echo "No users selected"}
}

Now how would i get it to say:
echo the user relating to $id_del ?

I played with

 $query =@mysql_query("select id, user FROM users" WHERE id='$id_del')

but to no avail obviously.

In the same way Im lost as to how i would then carry on to delete the users in the same manner

 (DELETE FROM users WHERE id='$id_del')

or something.

As always grateful for any pointers.

tekky

if you want this to work using submit buttons as you originally described I believe you would be required to make a seperate form for each submit button, or to rename each submit button something else so that you can verify which button they clicked on for deleting "user X"

I would just make it loop out and print seperate forms for each that way only the information pertinent to that user they want to delete is sent

hope that makes sense?

flash-genie

Thanks for answering,
before I go stumbling in maybe I could ask about a setup, maybe:

When I create each <TR> with all the users at the beginning I make a new <form> tag for each row containing a submit button and a hidden value.

Then when the user clicks the submit value it passes the hidden value and gives me the chance to delete it, so along these lines you think?

<? 
if($_SESSION['admin']==true){ 
    $counter = 1; 
    while($line = @mysql_fetch_object($adminquery)) { 
        echo '<tr>'; 
        echo '<td width="30" bgcolor="#004080" align="right">'.$counter.'</td>'; 
        echo '<td width="250" bgcolor="#004080">'.$line->user.'</td>';  

            echo '<td width="120" bgcolor="#004080">'; 

echo '<form name="form'.$counter.'" action="deleteuser.php">
            echo '<input type="hidden" name="id" value="'.$line->id.'">'; 
            //$line->id is placed correctly in the next line 
            echo '<input type="submit" name="delete" value="Delete.'.$line->user.'" class="button">'.$line->id.'</td>';     

            echo '<td width="120" bgcolor="#004080">&nbsp;</td>'; 
            } 
        echo '</tr></form>'; 
        $counter++; 
    } 
    ?>

That looks like a good plan, Ill give it a shot.
Id like to get the checkbox to work too if possible. I want to be able to delete news entries and I think checkboxes are a great way of doing that.
So if anyone has any ideas as to where im going wrong, or know of any tutorials along those lines, Id be your best friend 😃

Thanks again tekky & bloodwine for your help getting me this far, and back in off the window sill 😉

flash-genie

Thanks again, its worrking great now.