beginTransaction(); $query = "INSERT INTO fileindex ('id','file_name','title','create_time','modify_time','accese_time','file_size') VALUES (NULL,?,?,?,?,?,?)"; $stmt = $PDO->prepare($query); for ($x = 0; $x < $arrlength; $x++) { if (is_file($dir . $files[$x])) { $ctime = filectime($dir . $files[$x]); $mtime = filemtime($dir . $files[$x]); $atime = fileatime($dir . $files[$x]); $filesize = filesize($dir . $files[$x]); $newData = array($files[$x], "title", $ctime, $mtime, $atime, $filesize); $stmt->execute($newData); //echo $files[$x].','; } } // 提交更改 $PDO->commit(); if (!$stmt || ($stmt && $stmt->errorCode() != 0)) { $error = PDO_ErrorInfo(); echo "error - $error[2]
"; } else { echo "updata $arrlength recorders."; }