checkbox value fetch in foreach loop not working

Question

With the below given code i am trying to fetch data of check boxes from MySQL database, Which is not working and fetches only last checked value.

With var_dump($checked); its giving correct result.

PHP Script

$group_id = $_POST['group_id'];
$team_id = $_POST['team_id'];
if(!empty($_POST['team_id'])) {
        foreach($_POST['team_id'] as $checked) {
            // var_dump($checked);
                $sql = $db->prepare("SELECT a.team, a.player, a.result, a.note, b.category FROM teams a INNER JOIN  groups b ON a.team_id = b.id WHERE a.team_id = :team_id_id AND a.group_id = :group_id ");
                $sql->execute(array(':team_id' => $checked, ':group_id' => $group_id));
        }
        while($row = $sql->fetch(PDO::FETCH_ASSOC) ) {
            $row1[] = $row;
        }

}

Can you add the part of the code where you define $row1 and where you read it out?. And I guess you'll want to move the while loop inside the foreach. Now the $sql variable might not be defined inside your while statement — jrswgtr
– jrswgtr, Commented Sep 1, 2018 at 9:27
@jrswgtr I am getting data via ajax, It will be a bit difficult for me to share a bunch of code. — SamDasti
– SamDasti, Commented Sep 1, 2018 at 9:31
because with in your foreach sends last value. did you try while loop inside foreach? — Nawin
– Nawin, Commented Sep 1, 2018 at 10:07

Mooni · Accepted Answer · 2018-09-01 10:17:41Z

1

Use while loop inside foreach loop because its causing id problem

$group_id = $_POST['group_id'];
$team_id = $_POST['team_id'];
if(!empty($_POST['team_id'])) {
    foreach($_POST['team_id'] as $checked) {
            $sql = $db->prepare("SELECT a.team, a.player, a.result, a.note, b.category FROM teams a INNER JOIN  groups b ON a.team_id = b.id WHERE a.team_id = :team_id_id AND a.group_id = :group_id ");
            $sql->execute(array(':team_id' => $checked, ':group_id' => $group_id));
    while($row = $sql->fetch(PDO::FETCH_ASSOC) ) {
        $row1[] = $row;
    }
}
}

answered Sep 1, 2018 at 10:17

Mooni

1431 silver badge13 bronze badges

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

Collectives™ on Stack Overflow

checkbox value fetch in foreach loop not working

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