Update value if the checkbox if checked multiple rows php

Question

I am trying to update each row with a value of 1 if the checkbox is checked and do nothing if not.

$query= "SELECT Name, Surname, Age, Club, age_group, School, team_select FROM players WHERE Age < 9";
$statement = $db->prepare($query);
$statement->execute();
$players = $statement->fetchAll(PDO::FETCH_ASSOC);
echo '<form nethod="POST" action="add_to_team.php">';
echo '<p align="center"><a href="new.php" >Add Player</a></p>';
echo '<table class="table table-bordered"';
echo '<tr><th>Name</th>
      <th>Surname</th>
      <th>Club</th>
      <th>Age Group</th>
      <th>School</th>
      <th>Edit</th>
      <th>Delete</th>
      <th>Add to Team</th></tr>';


// loop through results of database query, displaying them in the table
 foreach ($players as $player) {
// echo out the contents of each row into a table
echo '<tr>';
echo '<td>' . $player['Name'] . '</td>';
echo '<td>' . $player['Surname'] . '</td>';
echo '<td>' . $player['Club'] . '</td>';
echo '<td>' . $player['age_group'] . '</td>';
echo '<td>' . $player['School'] . '</td>';
echo '<td><a href="edit.php?id=' . $player['Name'] . '">Edit</a></td>';
echo '<td><a href="delete.php?id=' . $player['Name'] . '">Delete</a></td>';
echo '<td><input type="checkbox" name="team_select" value="1"> </td>';


echo '</tr>';

}
echo '</table>';
echo'<input type="submit" value="Submit" name="submit"><br/>';

Code (It just won't work)

<?php
include 'connect.php';//database connection
isset($_POST['team_select'])
?>

isset($_POST['team_select']) does nothing on its own - Where is the insert or update statement? also never call anything name="submit". What is the expected and actual output of this code — mplungjan
– mplungjan, Commented Apr 8, 2017 at 5:42
Apart from isset($_POST['team_select']) where is the other code? — Mayank Pandeyz
– Mayank Pandeyz, Commented Apr 8, 2017 at 5:44
@MayankPandeyz I think Cindi wants us to just provide that part... — mplungjan
– mplungjan, Commented Apr 8, 2017 at 5:45
That is where I am stuck I will post all the different ways I have tried I keep getting error on error so it is a lot hence why I did not post it. Give me a sec will post it. — Cindi Liebenberg
– Cindi Liebenberg, Commented Apr 8, 2017 at 5:47
Start by naming the checkbox team_select[] which will automatically make an array for PHP to consume and give the value the player id or team select — mplungjan
– mplungjan, Commented Apr 8, 2017 at 5:49

Barmar · Accepted Answer · 2017-04-08 05:52:11Z

2

You need to give the checkboxes different names. If they're all named team_select there will just be one $_POST['team_select'], but you won't be able to tell which checkboxes were checked.

Use name="team_select[]" and they'll all be put into an array. Then you can put the player name into the value, so the array will contain the names of all the players who should be added.

echo '<td><input type="checkbox" name="team_select[]" value="' . $player['Name'] . '"> </td>';

When you're processing the form, you can do:

foreach ($_POST['team_select'] as $name) {
    ...
}

to process all the players who were selected.

answered Apr 8, 2017 at 5:52

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

Collectives™ on Stack Overflow

Update value if the checkbox if checked multiple rows php

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