How do I post data in php and mysql to insert multiple times (rows) using a for loop

Question

How would I go about creating a script that post data multiple times depending on how many times the user wants. I was thinking I could do it using a for loop but not sure where to start. The goal is to post this data row 1, 3, or maybe 5 times into the mySQL table. Anybody got any means on where to start?

Below is what I'm working with...

   // check if the form was submitted
if( isset($_POST['save_stuff']) ) {

  // create the website object
  $stuff = new stuff($_POST['stuff']);

  // prepare an SQL query
  $stmt = $dbh->prepare("INSERT INTO `".$example."` (`title`, `stuf`, `due`, `details`, `category`, `user`) VALUES (:title, :stuff, :due, :details, :category, :user)");

$id = mysql_real_escape_string($_GET['id']);


  // run the SQL query
  if(  $stmt->execute(array(
        'title' => $stuff->title,
        'stuff' => $id,
        'due' => $stuff->due,
        'details' => $stuff->details,
        'category' => $stuff->category,
        'user' => $stuff->user
      ))
  ) {

    // if successful then go back to home page
    header("Location: ../stuff/?id=".$id."");
  } else {

    // display an error if it failed
    echo "<p>failed to add stuff</p>";
  }

You don't need to escape a number before you're passing it to execute(). mysql_real_escape_string also makes no sense as soon as PDO provides its own one escape function — zerkms
– zerkms, Commented May 31, 2013 at 3:54
yes, how do I execute the array to submit multiple times in one instance? — Frank Aguilar
– Frank Aguilar, Commented May 31, 2013 at 4:51
what is "execute the array"? You need to invoke execute() method several times with different arguments — zerkms
– zerkms, Commented May 31, 2013 at 4:52

K. Kilian Lindberg · Accepted Answer · 2013-05-31 22:28:49Z

1

<?php 
// check if the form was submitted
if( isset($_POST['save_stuff']) ) {

    // create the website object
    $stuff = new stuff($_POST['stuff']);

    // prepare an SQL query
    $stmt = $dbh->prepare("INSERT INTO `".$example."` (`title`, `stuf`, `due`, `details`, `category`, `user`) VALUES (:title, :stuff, :due, :details, :category, :user)");

    // Unnecesary since PDO takes care of it anyway trough execute
    //$id = mysql_real_escape_string($_GET['id']);

    // number of times to run
    $timestorun = 10;
    for($i = 1; $i <= $timestorun; $i++){
        // Notice it will insert the same stuff multiple times! 
        // run the SQL query
        if(  $stmt->execute(array(
        'title' => $stuff->title,
        'stuff' => $id,
        'due' => $stuff->due,
        'details' => $stuff->details,
        'category' => $stuff->category,
        'user' => $stuff->user
        ))
        ) {
            $insertworkedArr[] = 1;
            $allIds .= $id . ",";
        } else {
            $insertworkedArr[] = 0;
        }
    }
    if(min($insertworkedArr) == 1){
        // if successful then go back to home page
        // $allIds contains all IDs that are inserted, accessible 
        // as an array trough an explode($allIds,",") at the next page
        header("Location: ../stuff/?id=".$id."&wasTheLastOneButAlso".$allIDs."");
    } else {
        // display an error if it failed
        echo "<p>failed to add stuff</p>";
    }
}
?>

edited May 31, 2013 at 22:28

answered May 31, 2013 at 15:15

K. Kilian Lindberg

2,97626 silver badges31 bronze badges

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

2 Comments

Frank Aguilar Over a year ago

It functions like it's suppose inserting multiple times but it comes up with the error "failed to add stuff" instead of redirecting to the header.

K. Kilian Lindberg Over a year ago

Sorry, alright now it's changed to if(min($insertworkedArr) == 1) instead of 0. Tell me if it's working as a solution for you.

Collectives™ on Stack Overflow

How do I post data in php and mysql to insert multiple times (rows) using a for loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related