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 因为要获取段落标题级别
$db_file = _FILE_DB_PALITEXT_;
PDO_Connect("sqlite:"._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("sqlite:$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("sqlite:"._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("sqlite:"._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";
}
}
?>