Post form and update multiple rows with mysql

by

Since you have multiple html fields with same names, you have to submit them as an arrays:

echo "<input type="text" name="photo_title[]" value="$title" /><br />";
echo "<input type="text" name="photo_tags[]" value="$tags" />";
echo "<input type="hidden" name="photo_id[]" value="$id" />";

After submitted, loop through any array variable like

foreach ($_POST['photo_id'] as $key => $photo_id) {
    $id = $photo_id;
    $title = $_POST['photo_title'][$key];
    $tags = $_POST['photo_tags'][$key];

    $sql = "UPDATE photos SET title=?, tags=? WHERE id=?";
    $query = $db->prepare($sql);
    $query->execute(array($title, $tags, $id));
}

More Related Contents:

  1. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in? [duplicate]
  2. regarding installation of php in windows
  3. save user images in MYSQL database by which method? [closed]
  4. How to apply bindValue method in LIMIT clause?
  5. Best way to INSERT many values in mysqli?
  6. Importing CSV data using PHP/MySQL
  7. php/mysql with multiple queries
  8. Notice: Array to string conversion in
  9. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  10. Find total number of results in mySQL query with offset+limit
  11. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  12. PDO multiple queries
  13. Export MySQL database using PHP [closed]
  14. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  15. How to add new column to MYSQL table?
  16. Do SQL connections opened with PDO in PHP have to be closed
  17. mysql select query within a serialized array
  18. mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in php [duplicate]
  19. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  20. Category Hierarchy (PHP/MySQL)
  21. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  22. How to convert ISO8601 to Date format in php
  23. belongsToMany relationship in Laravel across multiple databases
  24. Algorithm for generating a random number
  25. return one value from database with mysql php pdo
  26. How can I pass an array of PDO parameters yet still specify their types?
  27. MySQL & PHP Parameter 1 as Resource
  28. Is mysql_real_escape_string enough to Anti SQL Injection?
  29. How to make mysqli connect function?
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment