beginTransaction();
$query="INSERT INTO dighest_index ('id','title','summary','tag','user','time') VALUES (NULL,?,?,?,?,?)";
$stmt = $PDO->prepare($query);
$newData=array($title,$summary,$tag,4,time());
$stmt->execute($newData);
// 提交更改
$PDO->commit();
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
echo "error - $error[2]
";
}
else{
}
//获取刚刚插入的书摘记录的索引号
$new_index=$PDO->lastInsertId();
// 开始一个事务，关闭自动提交
$PDO->beginTransaction();
$query="INSERT INTO dighest ('id','index_id','album','book','paragraph') VALUES (NULL,?,?,?,?)";
$stmt = $PDO->prepare($query);
$dighest_par_array=str_getcsv($data);
$first_album=-1;
$first_book=-1;
$first_paragraph=-1;
foreach($dighest_par_array as $value){
$one_recorder=str_getcsv($value,"-");
if(count($one_recorder)>=3){
if($first_album==-1){
$first_album=$one_recorder[0];
$first_book=$one_recorder[1];
$first_paragraph=$one_recorder[2];
}
$newData=array($new_index,$one_recorder[0],$one_recorder[1],$one_recorder[2]);
$stmt->execute($newData);
}
}
// 提交更改
$PDO->commit();
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
echo "error - $error[2]
";
}
else{
}
//更新索引数据库
$db_file = _FILE_DB_RESRES_INDEX_;
PDO_Connect("sqlite:$db_file");
// 开始一个事务，关闭自动提交
$PDO->beginTransaction();
$query="INSERT INTO 'index' ('id','book','paragraph','level','type','language','title','author','editor','edition','share','album','update_time') VALUES (NULL,?,?,?,?,?,?,?,?,?,?,?,?)";
$stmt = $PDO->prepare($query);
$newData = array($first_book,$first_paragraph,$new_index,'dighest','sc',$title,4,4,1,4,$first_album,time());
$stmt->execute($newData);
// 提交更改
$PDO->commit();
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
echo "error - $error[2]
";
}
else{
}
//更新tag数据库
$db_file = _FILE_DB_RESRES_INDEX_;
PDO_Connect("sqlite:$db_file");
// 开始一个事务，关闭自动提交
$PDO->beginTransaction();
$query="INSERT INTO 'tag' ('id','book','paragraph','title','summary','tag','language','author','time') VALUES (NULL,?,?,?,?,?,?,?,?)";
$stmt = $PDO->prepare($query);
$newData=array(1024,$new_index,$title,$summary,$tag,'sc',1,time());
$stmt->execute($newData);
// 提交更改
$PDO->commit();
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
echo "error - $error[2]
";
}
else{
}
?>