[MySQL] Update Multiple Rows At Once

[Adrian Schneider]

Try this...

PHP Code:

<?php

$conn = mysql_connect(" ", " ", " ")
or die(mysql_error());
mysql_select_db(" ", $conn) or die(mysql_error());

if ($_POST['submit'])
{
    foreach ($_POST['ids'] as $id)
    {
        $id = intval($id);

        $name = mysql_real_escape_string($_POST['names'][$id]);
        $lastname = mysql_real_escape_string($_POST['lastnames'][$id]);
        $email = mysql_real_escape_string($_POST['emails'][$id]);

        $result = mysql_query("
            UPDATE test_mysql
            SET
                name = '$name',
                lastname = '$lastname',
                email = '$email'
            WHERE id = '$id'
        ");

        if (!$result) die(mysql_error());
    }
}

echo("

<form name='form1' method='post' action=''>
      <table width='500' border='0' cellspacing='1' cellpadding='0'>

");

$query = mysql_query("
    SELECT *
    FROM test_mysql
");

while($row = mysql_fetch_array($query))
{
    $userid = $row['id'];
    echo("

            <tr>
              <td align='center'>
    <input name='ids[]' type='hidden' id='id' value='$row[id]'>$row[id]
              </td>
              <td align='center'>
    <input name='names[$userid]' type='text' id='name' value='$row[name]'>
              </td>
              <td align='center'>
    <input name='lastnames[$userid]' type='text' id='lastname' value='$row[lastname]'>
              </td>
              <td align='center'>
    <input name='emails[$userid]' type='text' id='email' value='$row[email]'>
              </td>
            </tr>

    ");
}

echo("

        <tr>
          <td colspan='4' align='center'>
<input type='submit' name='submit' value='Submit'>
          </td>
        </tr>
      </table>
</form>

");

?>