update table in mysql with dynamically created input field from database

Question

I want to update fields in database. here is the code in which i fetch the records from database and show them in a form.

<form name="create_album" method="POST" action="" style="width:auto;">

<label for="First Name">Album Name</label>

<input type="text" name="album" id="album" placeholder="Album Name"value="<?php echo $album_name; ?>" />


<?php 
$result = mysql_query("select * from user_uploads where album = '$album_name' ");
while($row=mysql_fetch_array($result))
{
?>
<img src="<?php echo $row['image_name']; ?>" height="140" width="140" /> 
<input type="text" name="des[]" value="<?php echo $row['image_description']; ?>" placeholder="Image Description Here"/>
<input type="text" name="id[]" value="<?php echo $row['id']; ?>" placeholder="Image Description Here"/>

<?php } ?>
<input type="submit" name="submit" value="Upload Album"/>

but now when i want to update the records in database it update all the records into the table with the value of last input field. here is the php code.

  <?php 
if(IsSet($_POST["submit"]))
{
     $album = $_POST["album"];
             $des=$_POST["des"];
    foreach($_POST['id'] as $id)
    {

$update_qry = "update user_uploads set album='$album', image_description='$des' where id = '$id' ";

     $result_update_image = mysql_query($update_qry);
  if (!$result_update_image) 
  {
            header("location:create_album.php?errmsg=Album Not Updated");
        }



        }

    }
    }
 ?>

But i dont know how to get all the values of des form array to update in table according to id.

<input type="text" name="des[<?php echo $row['id']; ?>]" value="<?php echo $row['image_description']; ?>" placeholder="Image Description Here"/> this field is creadted dynamically from db records. now i want to update each image description simuntainously. but my code update all records by last image description value. — The CodeBlaster
– The CodeBlaster, Commented Nov 11, 2013 at 8:47

Sanal K · Accepted Answer · 2013-11-11 12:57:10Z

2

Change the code like this and check.

   $i=0;
    $des=$_POST["des"];
    foreach($_POST['id'] as $id)
        {

          $update_qry = "update user_uploads set album='".$album."', image_description='".$des[$i]."' where id = '".$id."' ";

         $result_update_image = mysql_query($update_qry);
    $i++;
    }

answered Nov 11, 2013 at 12:57

Sanal K

7334 silver badges14 bronze badges

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

Comments

Shafeeque · Accepted Answer · 2013-11-11 08:54:04Z

1

try this

<input type="text" name="des[]" value="<?php echo $row['image_description']; ?>" placeholder="Image Description Here"/>

I have changed the name.

answered Nov 11, 2013 at 8:54

Shafeeque

2,0692 gold badges13 silver badges28 bronze badges

11 Comments

The CodeBlaster Over a year ago

i already tried this but same problm. only last image description value update in all records

Shafeeque Over a year ago

@ApoorvaChauhan, just try print of post values as print_r($_POST) and check what values your getting in variables. what is that $album_name value

Sanal K Over a year ago

@ApoorvaChauhan check your where condition.Will your album_name be unique as the loop proceeds??

The CodeBlaster Over a year ago

@Shafeeq if i print the values it printsonly last input field value. $album_ name value is the album name in which image description will be updated. album name successfully updated. in this code.

The CodeBlaster Over a year ago

@sanal k yes album name is unique. but in a album there are several images. so i want to update each row where album name is $album_name simuntainously with the image name.

|

Collectives™ on Stack Overflow

update table in mysql with dynamically created input field from database

2 Answers 2

Comments

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related