PHP update SQL from multiple HTML checkbox

Question

So, I need to make sure this sets the right parameters to the DB when pressing the buttons. I just want to get the calls and comparisons right so it does what it should when I hit the buttons. There should be one delete button for each row from database, and update page when I press it.

It should be possible to update the text/numbers in the forms presented by MySQL by changing the forms and press Save-button, then refresh the page.

$counter = 1;

if(isset($_POST['save']) and something is changed from the forms compared to DB) {
Update MySQL

Refresh page
<script>
window.location.replace("thispage.php");
</script>

}

if(isset($_POST['del'])) {
DELETE MySQL

Refresh page
<script>
window.location.replace("thispage.php");
</script>

}

echo "<tr><td>ID</td><td>Namn</td><td>Platser</td><td>Fullbokad</td><td>Ta bort</td></tr>";

$sqlListSections = "SELECT * FROM avdelningar WHERE user = {$_SESSION['id']}";
$queryListSections = mysqli_query($mysqli, $sqlListSections);
$del = [];

while($rowListSections = mysqli_fetch_array($queryListSections)) 
{   

    if($counter%2) 
    {
        echo "\n<tr bgcolor=#F1F1F2>\n\n";
    }else
    {
        echo "\n<tr bgcolor=#FFFFFF>\n\n";
    }

    $counter++;



    echo "

    <td>".$rowListSections['id']."</td>
    <td>
        <input type=text value=".$rowListSections['namn']."></td>

    <td>
        <input type=text value=".$rowListSections['platser']."></td>
    <td>";
    if($rowListSections['prio'] == 1) 
    {
        echo "<select name=platser>
            <option selected value=".$rowListSections['prio'].">".$rowListSections['prio']."</option>
            <option value='0'>0</option>".$rowListSections['prio'];
    }elseif($rowListSections['prio'] == 0)
    {
        echo "<select name=platser>
            <option selected value=".$rowListSections['prio'].">".$rowListSections['prio']."</option>
            <option value='1'>1</option>".$rowListSections['prio'];
    }
    echo "</td>
    <td>
        <form method=post action=thispage.php>
        <input type=submit value=Delete name=del>";
    </td>
    </form>
    </tr>";


}

echo "<form method=post action=thispage.php>
<input type=submit value=Save name=save>";
`

can you please give detail idea about this? what you want to achieve? — Sanjun Dev
– Sanjun Dev, Commented Sep 16, 2019 at 10:58
I want to mark those sections I want to delete, press Save button and delete all that are checked and show the new result — RobinJakobsson
– RobinJakobsson, Commented Sep 16, 2019 at 11:13

Sanjun Dev · Accepted Answer · 2019-09-17 07:54:14Z

1

in your checkbox change naming as array.

<input type=checkbox name="del[]" value={$rowListSections['id']}>

like

echo $rowListSections["id"].' '.$rowListSections["namn"].' '.$rowListSections["platser"].' '.

$rowListSections["prio"].'';

and in your if(isset($_POST)) you can get a del array so you can loop this array like below.

foreach($del as $val){
    $id = $val;
    $sql_query_for_update = "update table_name set field = 1 where id= '$id' ";
}

edited Sep 17, 2019 at 7:54

user11533977

answered Sep 16, 2019 at 11:35

Sanjun Dev

5189 silver badges20 bronze badges

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

34 Comments

RobinJakobsson Over a year ago

I don't understand. I can't write name=del[] without errors in my checkbox row. Could you give me all the code example?

RobinJakobsson Over a year ago

I still dont understand. I cant write del[] in <checkbox>? And is that an array, without the $?

Sanjun Dev Over a year ago

Yes! if you put [] in name, it will be treated as array. for eg: if you submit this form then you will get all the checked checkboxes are as an array. ( $_POST['del'] = [0 => 'val', 1 => 'val1'] )

Sanjun Dev Over a year ago

let me know if you don't get this :)

RobinJakobsson Over a year ago

Looks Great! I will try it later tonight when I get home! I hope The del[] will work now! Thanks!

|

Collectives™ on Stack Overflow

PHP update SQL from multiple HTML checkbox

1 Answer 1

34 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

34 Comments

Your Answer

Sign up or log in

Post as a guest

Related