quote($currBook)." AND \"paragraph\" = ".$PDO->quote($currParagraph)." ORDER BY vri "; } else{ $query = "SELECT * FROM \"main\" WHERE \"book\" = ".$PDO->quote($currBook)." AND \"paragraph\" = ".$PDO->quote($currParagraph)." AND \"language\" = ".$PDO->quote($language)." AND \"author\" = ".$PDO->quote($author)." AND \"editor\" = ".$PDO->quote($editor)." AND \"edition\" = ".$PDO->quote($edition)." AND \"subver\" = ".$PDO->quote($subver)." ORDER BY vri "; } break; case "heading": if($author=="templet"){ $query = "SELECT * FROM \"data\" WHERE \"book\" = ".$PDO->quote($currBook)." AND \"paragraph\" = ".$PDO->quote($currParagraph); } else{ $query = "SELECT * FROM \"data\" WHERE \"book\" = ".$PDO->quote($currBook)." AND \"par_num\" = ".$PDO->quote($currParagraph)." AND \"language\" = ".$PDO->quote($language)." AND \"author\" = ".$PDO->quote($author)." AND \"editor\" = ".$PDO->quote($editor)." AND \"edition\" = ".$PDO->quote($edition)." AND \"subver\" = ".$PDO->quote($subver);; } break; case "translate": $query="SELECT * FROM \"data\" WHERE \"paragraph\" = ".$PDO->quote($currParagraph)." AND \"language\" = ".$PDO->quote($language)." AND \"author\" = ".$PDO->quote($author)." AND \"editor\" = ".$PDO->quote($editor)." AND \"edition\" = ".$PDO->quote($edition)." AND \"subver\" = ".$PDO->quote($subver); break; case "note": $query="SELECT * FROM \"data\" WHERE \"paragraph\" = ".$PDO->quote($currParagraph)." AND \"language\" = ".$PDO->quote($language)." AND \"author\" = ".$PDO->quote($author)." AND \"editor\" = ".$PDO->quote($editor)." AND \"edition\" = ".$PDO->quote($edition)." AND \"subver\" = ".$PDO->quote($subver); break; case "file": $query="SELECT * FROM \"data\" WHERE \"paragraph\" = ".$PDO->quote($currParagraph)." AND \"language\" = ".$PDO->quote($language)." AND \"author\" = ".$PDO->quote($author)." AND \"editor\" = ".$PDO->quote($editor)." AND \"edition\" = ".$PDO->quote($edition)." AND \"subver\" = ".$PDO->quote($subver); break; } $Fetch = PDO_FetchAll($query); $iFetch=count($Fetch); if($iFetch>0){ $outXml = ""; echo $outXml; //pakege head switch($res_type){ case "wbw": $outXml = ""; $outXml .= "$guid$res_type$currBook$currParagraph$language$author$editor$revision$edition$subver"; $outXml .= ""; echo $outXml; break; case "heading": break; case "translate": $outXml = ""; $outXml .= "$guid$res_type$currBook$currParagraph$language$author$editor$revision$edition$subver"; $outXml .= ""; echo $outXml; break; case "note": $outXml = ""; $outXml .= "$guid$res_type$currBook$currParagraph$language$author$editor$revision$edition$subver"; $outXml .= ""; echo $outXml; break; case "file": $outXml = ""; $outXml .= "$guid$res_type$currBook$currParagraph$language$author$editor$revision$edition$subver"; $outXml .= ""; echo $outXml; break; } for($i=0;$i<$iFetch;$i++){ switch($res_type){ case "wbw": $outXml = ""; $outXml = $outXml."".$Fetch[$i]["wid"].""; $outXml = $outXml."".$Fetch[$i]["word"].""; $outXml = $outXml."".$Fetch[$i]["real"].""; $outXml = $outXml."".$Fetch[$i]["type"].""; $outXml = $outXml."".$Fetch[$i]["gramma"].""; $outXml = $outXml."".$Fetch[$i]["type"]."#".$Fetch[$i]["gramma"].""; $outXml = $outXml." "; $outXml = $outXml."".$Fetch[$i]["mean"].""; $outXml = $outXml."".$Fetch[$i]["note"].""; $outXml = $outXml."".$Fetch[$i]["part"].""; $outXml = $outXml."".$Fetch[$i]["partmean"].""; $outXml = $outXml."".$Fetch[$i]["bmc"].""; $outXml = $outXml."".$Fetch[$i]["bmt"].""; $outXml = $outXml."".$Fetch[$i]["un"].""; $outXml = $outXml.""; $outXml = $outXml."".$Fetch[$i]["vri"].""; $outXml = $outXml.""; echo $outXml; break; case "heading": $outXml = ""; $outXml .= "$guid$res_type$currBook$currParagraph$language$author$editor$revision0$subver"; $outXml .= "".$Fetch[$i]["level"].""; $outXml .= ""; $outXml .= ""; $outXml .= ""; if($Fetch[$i]["level"]==0){ $outXml .= "".substr($Fetch[$i]["text"],0,10).""; } else{ $outXml .= "".$Fetch[$i]["text"].""; } $outXml .= ""; echo $outXml; break; case "translate": $outXml = ""; $outXml = $outXml."".$Fetch[$i]["anchor"].""; $outXml = $outXml."".$Fetch[$i]["text"].""; $outXml = $outXml.""; echo $outXml; break; } } } /*直接查询结束*/ switch($res_type){ case "wbw": $outXml = ""; break; case "heading": $outXml = ""; break; case "translate": $outXml = ""; break; case "note": $outXml = ""; break; case "file": $outXml = ""; break; } echo $outXml; ?>