PHP inserts data into the MySQL database in a loop. How to determine whether each item is inserted successfully?

Question

Just like the title.

            while(! feof($file)){
                $data= fgets($file);//fgets()函数从文件指针中读取一行
                $res = $this->Model->function($data);//插入数据的方法
            }
            //比如这种的怎么判断每一行都插入成功

Answer 1

//Define variable num
$num = 0;
while (! feof($file)) {

$data= fgets($file);//fgets()函数从文件指针中读取一行
$res = $this->Procesratio->promction($data);

// 直接在这里判断
if (!$res) {
    $num += 1;
}

}

// Judge the value of num here
if ($num == 0) {

// 全部成功

} else {

// $num即为失败条数

}

Answer 2

Start the transactiontransaction, and as long as there is an error, it will rollback and throw an exception

Answer 3

if($res == true){
   echo "success";
}else{
    echo "fault";
}

Answer 4

while(! feof($file)){
    $data= fgets($file);//fgets()函数从文件指针中读取一行
    $res = $this->Model->function($data);//插入数据的方法
    if($res){
        echo "success！";
    }else{
        echo "error！。。。try again....";
        $this->Model->function($data)
    }
}

After the insertion is successful, data will be returned. Just make a judgment based on the return! !

Answer 5

For this large amount of data insertion method, if the online business is not so busy, you can consider inserting in batches. After batch inserting, the returned result is the number of affected rows. The returned results are easier to search and the efficiency will be higher than this. Or business, simple violence.

Answer 6

It is recommended to use things, so that you can at least ensure the consistency of the data.