使用while循环将多个数据插入到mysql数据库表中

Question

the script is supposed to insert multiple data into the database but for some reason its inserting only the first data. This is the aspect of my code that gives the issue.

$pledge_amount = "400";
$getDonors = mysqli_query($connection, "SELECT * FROM `highck39_earn`.`users` WHERE `tomerge` = '2' AND `role`='0' AND `status` = '0'  AND `username` != '$username' ORDER BY `reward_date` ASC LIMIT 0, 2"); 

    $i=0;
    while($resultObj = mysqli_fetch_assoc($getDonors)){

          $rewardBal = $resultObj['reward_balance'];
          $ind_amt = $pledge_amount/2;

         $do_donation = mysqli_query($connection, "INSERT INTO `highck39_earn`.`donations` (`id`, `transaction_id`, `sender`, `sender_name`, `sender_number`, `sender_momo_number`, `receiver`, `receiver_name`, `receiver_number`, `receiver_momo_number`, `amount`, `date`, `status`) VALUES (NULL, '{$transcode}', '{$username}', '{$fullname}', '{$phone}', '{$momo}', '{$resultObj['username']}', '{$resultObj['fullname']}', '{$resultObj['phone']}', '{$resultObj['momo']}', '{$ind_amt}', '{$pledge_date}', '1')");

          $i++;
          echo $i;
          echo $resultObj['fullname']. ' - '. $ind_amt.'<br>';    
          // if($cnt % 2 == 0) echo "<br>";


          // $data2 = array("fullname" => $fullname, "receiver"=>$resultObj['fullname']);
            //echo json_encode($data2,JSON_FORCE_OBJECT); 
    }

Answer 1

Do you have any sql error in your log when you try to do the insert ?

You can check if the insert worked correctly with something like :

if (mysqli_query($connection, "INSERT INTO...") === TRUE) {
    printf("Insert ok");
}

Hope it helps