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;