PHP/SQL Submit button inside while loop

Question

I got a php code that prints a table using while loop:

while ($data = mysqli_fetch_array ($result)) {

    echo '<tr>';
    echo '<td>' .$data ['commodity']. '</br>'. '</td>';
    echo '<td>' .$data ['region'].'</br>'.'</td>';
    echo '<td>' .$data ['member'].'</br>'. '</td>';
    echo '<td>' .$data ['size']. '</br>'. '</td>';
    echo '<td>' .$data ['price']. '</br>'.'</td>';
    echo '<td>' .$data ['posted']. '</br>'.'</td>';

    echo '<TD><INPUT TYPE=BUTTON OnClick="submit_btn" NAME="accepted" VALUE="accept"></TD>';
    echo '</tr>';

            $id=$data ['id'];

This fetches the data + submit_btn. now I need the button to get the current id and store it in a variable.

big thanks for all help !

Can you clarify your question? Seems ambiguous, like button needs to do something which might imply javascript, but your saying it's a PHP problem. — brady.vitrano
– brady.vitrano, Commented Jul 13, 2011 at 0:11

Ofir Baruch · Accepted Answer · 2012-01-16 21:11:37Z

1

Very simple. Add a counter variable (for instance $i) with starting value of 1. before the end of the loop increase it by one ($i++). This counter will help us creating a new name for each button, because eventually having more than one button with the same name will make things go wrong. (Especially when using JS).

change the line of the button:

 echo '<TD><INPUT TYPE=BUTTON OnClick="submit_btn(this)" NAME="accepted'.$i.'" VALUE="'.$data['id'].'"></TD>';

Notice the paramater for the submit_btn function, by using it you can access "this.value" which its value is the id of the row.

answered Jan 16, 2012 at 21:11

Ofir Baruch

10.3k2 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP/SQL Submit button inside while loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related