mint/app/studio/file_index_refresh.php

<?php
include "./config.php";
include "./_pdo.php";

//获取服务器端文件列表
$dir= $dir_user_base.$_COOKIE["userid"].$dir_mydocument."/";
$db_file = $dir.'fileindex.db';
PDO_Connect("sqlite:$db_file");

$files = scandir($dir);
$arrlength=count($files);

// 开始一个事务，关闭自动提交
$PDO->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] <br>";
}
else{
	echo "updata $arrlength recorders.";
}
?>