0) {
$id = $FetchRes[0]["id"];
$hit = $FetchRes[0]["hit"] + 1;
$query = "UPDATE 'index' SET hit = $hit WHERE id = $id";
$stmt = @PDO_Execute($query);
if (!$stmt || ($stmt && $stmt->errorCode() != 0)) {
$error = PDO_ErrorInfo();
print_r($error[2]);
}
}
}
//获取段落信息 如 父段落 下一个段落等
$query = "select * from 'paragraph_info' where book='$book' and paragraph='$paragraph'";
$FetchParInfo = PDO_FetchAll($query);
if (!$FetchParInfo) {
echo "Error:no paragraph info";
}
$par_begin = $paragraph + 1 - 1;
$par_end = $par_begin + $FetchParInfo[0]["length"] - 1;
$par_next = $FetchParInfo[0]["next"];
//生成一个段落空壳 等会儿查询数据，按照不同数据类型填充进去
for ($iPar = $par_begin; $iPar <= $par_end; $iPar++) {
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
echo "
";
}
//先查pali text 因为要获取段落标题级别
PDO_Connect(_FILE_DB_PALITEXT_);
if ($par_begin == -1) {
$query = "SELECT * FROM \"pali_text\" WHERE book = '{$book}' ";
} else {
$query = "SELECT * FROM \"pali_text\" WHERE book = '{$book}' and (\"paragraph\" BETWEEN " . $PDO->quote($par_begin) . " AND " . $PDO->quote($par_end) . ") ";
}
//查询pali text内容
$FetchText = PDO_FetchAll($query);
$iFetchText = count($FetchText);
if ($iFetchText > 0) {
for ($i = 0; $i < $iFetchText; $i++) {
$currParNo = $FetchText[$i]["paragraph"];
$currParLevel = $FetchText[$i]["level"];
$par_level["$currParNo"] = $currParLevel;
echo "
" . $FetchText[$i]["text"] . "
";
echo "";
}
}
//巴利原文加载结束
if (isset($album)) {
/*
//自动逐词译
$db_file = "../appdata/palicanon/templet/p".$book."_tpl.db3";
PDO_Connect("$db_file");
for($iPar=$par_begin;$iPar<=$par_end;$iPar++){
$query="SELECT * FROM \"main\" WHERE (\"paragraph\" = ".$PDO->quote($iPar)." ) ";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
echo "
";
for($i=0;$i<$iFetch;$i++){
$type=$Fetch[$i]["type"];
if($type!=".ctl."){
echo "
";
echo "
".$Fetch[$i]["word"]."
";
echo "
".$Fetch[$i]["mean"]."
";
echo "
";
}
}
echo "
";
echo "";
}
}
////自动逐词译结束
*/
PDO_Connect(_FILE_DB_RESRES_INDEX_);
$query = "select * from 'album' where id='$album'";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
switch ($Fetch[0]["type"]) {
case 1: //巴利原文
break;
case 2: //逐词译
$db_file = _DIR_PALICANON_WBW_ . "/p{$book}_wbw.db3";
PDO_Connect("sqlite:{$db_file}");
for ($iPar = $par_begin; $iPar <= $par_end; $iPar++) {
$table = "p{$book}_wbw_data";
$query = "SELECT * FROM \"{$table}\" WHERE (\"paragraph\" = " . $PDO->quote($iPar) . " ) and album_id={$album} ";
$Fetch = PDO_FetchAll($query);
$iFetch = count($Fetch);
if ($iFetch > 0) {
echo "
";
for ($i = 0; $i < $iFetch; $i++) {
$wordtype = $Fetch[$i]["type"];
if ($wordtype != ".ctl.") {
echo "
";
echo "
{$Fetch[$i]["word"]}
";
echo "
{$Fetch[$i]["mean"]}
";
echo "
{$wordtype}#{$Fetch[$i]["gramma"]}
";
echo "
";
}
}
echo "
";
echo "";
}
}
break;
case 3:
//译文
$tocHtml = "";
//打开翻译数据文件
$db_file = _DIR_PALICANON_TRAN_ . "/p{$book}_translate.db3";
PDO_Connect("sqlite:{$db_file}");
$this_album_id = $album;
$table = "p{$book}_translate_info";
if ($par_begin == -1) {
//全文
$query = "SELECT * FROM '{$table}' WHERE album_id=$this_album_id ";
} else {
//部分段落
$query = "SELECT * FROM '{$table}' WHERE (\"paragraph\" BETWEEN " . $PDO->quote($par_begin) . " AND " . $PDO->quote($par_end) . ") and album_id=$this_album_id ";
}
//查询翻译经文内容
$FetchText = PDO_FetchAll($query);
$iFetchText = count($FetchText);
if ($iFetchText > 0) {
for ($i = 0; $i < $iFetchText; $i++) {
$currParNo = $FetchText[$i]["paragraph"];
//查另一个表，获取段落文本。一句一条记录。有些是一段一条记录
$table_data = "p{$book}_translate_data";
$query = "SELECT * FROM '{$table_data}' WHERE info_id={$FetchText[$i]["id"]}";
$aParaText = PDO_FetchAll($query);
$par_text = "";
foreach ($aParaText as $sent) {
$par_text .= $sent["text"];
}
//获取段落文本结束。
$par_text = str_replace("
", "
", $par_text);
echo "
";
echo "
";
echo "
" . $par_text . "
";
echo "";
echo "
";
echo "";
//目录字符串
$tocLevel = $par_level["$currParNo"] + 1 - 1;
if ($tocLevel > 0 && $tocLevel < 8) {
$tocHtml .= "
";
}
}
//设置标题栏的经文名称
echo "";
}
break;
case 4:
break;
case 5:
break;
case 6:
break;
case 7:
break;
}
}
//添加注解
PDO_Connect( _FILE_DB_COMMENTS_);
if ($par_begin == -1) {
$query = "SELECT * FROM \"comments\" WHERE album='$album' order by id DESC";
} else {
$query = "SELECT * FROM \"comments\" WHERE album='$album' AND (\"paragraph\" BETWEEN " . $PDO->quote($par_begin) . " AND " . $PDO->quote($par_end) . ") order by id DESC ";
}
//查询注解内容
$FetchText = PDO_FetchAll($query);
$iFetchText = count($FetchText);
if ($iFetchText > 0) {
for ($i = 0; $i < $iFetchText; $i++) {
$currParNo = $FetchText[$i]["paragraph"];
$comm_id = $FetchText[$i]["id"];
echo "";
echo "";
}
}
if ($par_next != -1) {
echo "
Next";
}
}
?>