Update Values of Entire Table

This code assumes you are connected to a MySQL database which has a table with Names and Emails. The idea is that it will output a table of every single value from that table, as text inputs. You can then alter the values of these inputs and re-submit, updating all the values in the database.

//get data from db
$sql = mysql_query("SELECT * FROM table");

//start a table
echo '<form name="form1" method="post" action="">
<table width="292" border="0" cellspacing="1" cellpadding="0">';

//start header of table
echo '<tr>

//loop through all results

//print out table contents and add id into an array and email into an array
echo '<tr>
<td><input type="hidden" name="id[]" value='.$r->id.' readonly></td>
<td><input name="email[]" type="text" id="price" value="'.$r->email.'"></td>

//submit button
<td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>

// if form has been submitted, process it
       // get data from form
       $name = $_POST['name'];
       // loop through all array items
   foreach($_POST['id'] as $value)
       // minus value by 1 since arrays start at 0
               $item = $value-1;
               //update table
       $sql1 = mysql_query("UPDATE table SET email='$email[$item]' WHERE id='$value'") or die(mysql_error());

// redirect user
$_SESSION['success'] = 'Updated';

Submitted values are not cleaned in this example, as it is assumed only an admin would have access to this type of powerful entry system.


  1. Zoran
    Permalink to comment#

    This is cool, actually i have found your website before, but today i found out how many cool stuff you got. I recently did a project that required me to update rows that had different id’s but same value for the name.

    $ids = array(1, 2, 3, 4, 5, 6);
    $name = 'Some name';
    $sql = "UPDATE table SET name ='".$name."' WHERE id IN ('".implode(',', $ids)."')";

    I think mysql is being underestimated by web developers for some reason, cause they are using only small part of it, essential for most of the applications, but is powerful tool indeed, especially if you learn how to manage triggers, views and stored procedures.
    Thank you for your tips, they are very helpful, especially the CSS stuff, you are very good at it.

  2. Lafaz
    Permalink to comment#

    Good tricks!

  3. niroshan
    Permalink to comment#

    thanks for this tutorial. This was very helpful to design my web page…

Leave a Comment

Posting Code

We highly encourage you to post problematic HTML/CSS/JavaScript over on CodePen and include the link in your post. It's much easier to see, understand, and help with when you do that.

Markdown is supported, so you can write inline code like `<div>this</div>` or multiline blocks of code in triple backtick fences like this:

  function example() {
    element.innerHTML = "<div>code</div>";

We have a pretty good* newsletter.