get_path.php 1.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <?php
  2. require_once "../public/function.php";
  3. /*
  4. $dns = ""._FILE_DB_PALITEXT_;
  5. $dbh = new PDO($dns, "", "",array(PDO::ATTR_PERSISTENT=>true));
  6. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  7. $path="";
  8. $parent = $paragraph;
  9. $deep=0;
  10. $sFirstParentTitle="";
  11. //循环查找父标题 得到整条路径
  12. while($parent>-1){
  13. $query = "select * from pali_text where \"book\" = ? and \"paragraph\" = ? limit 0,1";
  14. $stmt = $dbh->prepare($query);
  15. $stmt->execute(array($book,$parent));
  16. $FetParent = $stmt->fetch(PDO::FETCH_ASSOC);
  17. $toc="<chapter book='{$book}' para='{$parent}' title='{$FetParent["toc"]}'>{$FetParent["toc"]}</chapter>";
  18. if($path==""){
  19. if($FetParent["level"]<100){
  20. $path=$toc;
  21. }
  22. else{
  23. $path="<para book='{$book}' para='{$parent}' title='{$FetParent["toc"]}'>{$paragraph}</para>";
  24. }
  25. }
  26. else{
  27. $path=$toc.$path;
  28. }
  29. if($sFirstParentTitle==""){
  30. $sFirstParentTitle = $FetParent["toc"];
  31. }
  32. $parent = $FetParent["parent"];
  33. $deep++;
  34. if($deep>5){
  35. break;
  36. }
  37. }
  38. $dbh = null;
  39. */
  40. echo _get_para_path($_GET["book"], $_GET["para"]);