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("$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("$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 {
}