mysqli结果的While循环 [英] While loop for mysqli results

问题描述

所以我试图将一些记录从一个数据库插入到另一个数据库..到目前为止，我有这个记录:

So I am trying to insert some record from one database to another.. So far I have this:

// $records_r = mysqli_fetch_assoc(mysqli_query($conn_r, "SELECT * FROM `TABLE_export` WHERE ID > 100"));   If do this -> it inserts only one record    

$records_r = mysqli_query($conn_r, "SELECT * FROM `TABLE_export` WHERE ID > 100");      

while (mysqli_fetch_array($records_r, MYSQL_ASSOC)) { //I need some while loop, but this is not working

    $values_r_implode = implode(",", array_values($records_r)); // I get an error:  array_values() expects parameter 1 to be array, object given in
    $values_r_array = explode(",", $values_r_implode);                  

    $stmt = $conn_i->prepare("INSERT INTO `TABLE_import` (`COLUMN1`, `COLUMN2`, `COLUMN3`) 
    VALUES (?,?,?)");       

    $stmt->bind_param("sss", $value1, $value2, $value3);

    $value1 = $values_r_array[0];
    $value2 = $values_r_array[1];           
    $value3 = $values_r_array[2];                   

    $stmt->execute();   
}

我需要做的就是循环遍历所有我要插入的新记录.

All I need is to loop trough every new record that I have to insert.

推荐答案

尝试一下

$records_r = mysqli_query($conn_r, "SELECT * FROM `TABLE_export` WHERE ID > 100");      

while($row = mysqli_fetch_array($records_r)){ //I need some while loop, but this is not working

 $stmt = $conn_i->prepare("INSERT INTO `TABLE_import` (`COLUMN1`, `COLUMN2`, `COLUMN3`) 
VALUES (?,?,?)");

$value1 = $row[0];
$value2 = $row[1];           
$value3 = $row[2];  

$stmt->bind_param("sss",$value1, $value2, $value3);

 $stmt->execute();               


}

这篇关于mysqli结果的While循环的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！