how to use a php loop to update database?

Question

I have look all over youtube and forms and I still can't find an answer that works. I want use a php loop to update database values. I need something like the two last loops below. Thanks in advance.

<?php

    if (isset($_POST['update'])) {

        for ($i = 1; $i <= 6; $i++) {
             $heading[$i] = $_POST['heading' . $i];
        }

        for ($i = 1; $i <= 9; $i++) {
             $des[$i] = $_POST['des' . $i];
        }

        for ($i = 1; $i <= 6; $i++) {
             $update = mysqli_query($connect, "UPDATE info1 SET heading[$i]='$heading[$i]' WHERE id= $i");
        }

        for ($i = 1; $i <= 9; $i++) {
            $update = mysqli_query($connect, "UPDATE info1 SET des[$i]='$des[$i]' WHERE id= $i");
        }

        header('Location: admin.php?success');
        exit();
    }
?>

stop assuming your queries succeeded. if (!$update) { die(mysqli_error($connect)); } so you can get told about your sql syntax errors. — Marc B
– Marc B, Commented Jan 7, 2016 at 21:31
I recommend doing more research on how to build modern applications with PHP. webdeveloper.gdemolished.com/… — Halfstop
– Halfstop, Commented Jan 7, 2016 at 21:32
Unless you have a column named des[0], - des[100], these queries are going to fail — Derek Pollard
– Derek Pollard, Commented Jan 7, 2016 at 21:33
Also, consider using name=heading[] and name=des[] in your form, so that the $_POST variables will be arrays. Then you don't need the first two loops. — Barmar
– Barmar, Commented Jan 7, 2016 at 21:43

MistaJase · Accepted Answer · 2016-01-07 21:34:31Z

1

Remove the first [i] from your queries... try these

    for ($i = 1; $i <= 6; $i++) {
         $update = mysqli_query($connect, "UPDATE info1 SET heading='$heading[$i]' WHERE id= $i");
    }

    for ($i = 1; $i <= 9; $i++) {
        $update = mysqli_query($connect, "UPDATE info1 SET des='$des[$i]' WHERE id= $i");
  }

answered Jan 7, 2016 at 21:34

MistaJase

8597 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

how to use a php loop to update database?

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