MYSQL- Update multiple rows with one submit button

Question

I want to update multiple mysql rows with one submit button. But there seems to be a problem in my php code.

    <?php
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'webtest');
define('DB_PASSWORD', '******');
define('DB_DATABASE', 'webtest');

$connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
$database = mysql_select_db(DB_DATABASE) or die(mysql_error());
mysql_set_charset("utf8", $connection);
?>

    <form action='' method='post'>
    <table border='1'>
        <?php
            $result = mysql_query("SELECT * FROM users ");

                    echo "<tr>";
                        echo "<td colspan='3'>CLASS 1</td>";
                    echo "</tr>";

                    while($row = mysql_fetch_array($result)){

                    echo "<tr>";
                        echo "<td><input type='text' name='id' value='".$row['id']."' /></td>";
                        echo "<td>Email  :<input type='text' name='email' value='".$row['email']."' /></td>";
                        echo "<td>Username  :<input type='text' name='username' value='".$row['username']."' /></td>";
                        echo "<td>Password  :<input type='text' name='password' value='".$row['password']."' /></td>";
                    echo "</tr>";

            }

            echo "<input type='submit' name='update' value='UPDATE' />";
        ?>
    <table>
</form>

<?php
    $id = $_POST['id'];
    $update = $_POST['update'];
    $email = $_POST['email'];
    $username = $_POST['username'];
    $password = $_POST['password'];

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

foreach($_POST['email'] as $email){


    mysql_query("   UPDATE users
                       SET email= '$email', username='$username', password='$password'
                     WHERE id = '$id' ");   

}
    header("location: updateusers.php");
    exit;
}   

?>

That's a really nice injection you have going on there... — The Blue Dog
– The Blue Dog, Commented Apr 18, 2014 at 19:04
mysql_query is now depreciated, see here for alternatives. php.net/mysql_query. — dave
– dave, Commented Apr 18, 2014 at 19:17
sorry, well I no longer appreciate it :p , deprecated may be a better phrase! — dave
– dave, Commented Apr 18, 2014 at 19:24

abmussani · Accepted Answer · 2014-04-18 19:01:54Z

0

$_POST['email'] is not an array. You cannot loop it. You must declare input tag of email as an array to use it in foreach.

replace this

echo "<td>Email  :<input type='text' name='email' value='".$row['email']."' /></td>";

with

echo "<td>Email  :<input type='text' name='email[]' value='".$row['email']."' /></td>";

answered Apr 18, 2014 at 19:01

abmussani

4612 silver badges10 bronze badges

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

1 Comment

user3549878 Over a year ago

Thank you a lot, But it seems to have another problem, This only ipdates the last row it does not affect on every row

Collectives™ on Stack Overflow

MYSQL- Update multiple rows with one submit button

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related