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."; } ?>