如何使用php将多条记录插入到mysql中

Question

i am fetching different record from the database but using single quantity field trying to insert multiple records into MYSQL but every time for loop or any other loop overriding single value in all rows(inserting single first value in every field), badly stuck. kindly suggest what kind of appropriate steps should be done.

<input type="text" name="qty[]" id="qtyid" style="width:40px;">

<?php   
if(isset($_POST["update"])) {
  $usersCount=count($_POST['qty']);

  $qtys=implode(",",$_POST['qty']);
  for($i=0;$i<$usersCount;$i++) {
    $query="UPDATE cart set qty='".$qtys."' WHERE prodid='$cartid'";
    $dbh->query($query);
    echo $qtys; 
  }
}
$total=$total*$qtys;
?>

Answer 1

Your "question" is unclear. I read it couple times nad i still dont know what is your problem.

Anyway. I'll try to explain what your code do in case it would help you to understand where the problem is.

//if form was submited and input of name "update" was in
if(isset($_POST["update"])) {

  // count array created by inputs of name="qty[]"
  $usersCount=count($_POST['qty']);

  // make a string from that array, separating the keys by a "," char
  $qtys=implode(",",$_POST['qty']);

  // loop as many times as number of elements in that array = <input name="qty[]"> you had in submited form
  for($i=0;$i<$usersCount;$i++) {

    // and finally, do always the same for each loop repeat
    $query="UPDATE cart set qty='".$qtys."' WHERE prodid='$cartid'";
    $dbh->query($query);
    echo $qtys; 
  }
}

So in conclusion your loop is doing always the same - every each repeat:

`$query="UPDATE cart set qty='".$qtys."' WHERE prodid='$cartid'";`

Basically to do that you would't need to have loop. Because in that query you change value of column qty wherever column prodid is equal to something