db_insert_commantry.php 2.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125
  1. <?php
  2. require_once "install_head.php";
  3. ?>
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7. </head>
  8. <body>
  9. <h2>提取小括号里的内容</h2>
  10. <p><a href="index.php">Home</a></p>
  11. <?php
  12. include "./_pdo.php";
  13. $thisFileName=basename(__FILE__);
  14. if(isset($_GET["from"])==false){
  15. ?>
  16. <form action="<?php echo $thisFileName;?>" method="get">
  17. From: <input type="text" name="from"><br>
  18. To: <input type="text" name="to"><br>
  19. <input type="submit">
  20. </form>
  21. <?php
  22. return;
  23. }
  24. $from=$_GET["from"];
  25. $to=$_GET["to"];
  26. $filelist=array();
  27. $fileNums=0;
  28. $log="";
  29. echo "<h2>$from</h2>";
  30. if(($handle=fopen("filelist.csv",'r'))!==FALSE){
  31. while(($filelist[$fileNums]=fgetcsv($handle,0,','))!==FALSE){
  32. $fileNums++;
  33. }
  34. }
  35. if($to==0 || $to>=$fileNums) $to=$fileNums-1;
  36. $FileName=$filelist[$from][1].".htm";
  37. $fileId=$filelist[$from][0];
  38. $fileId=$filelist[$from][0];
  39. $dirLog=_DIR_LOG_."/";
  40. $dirDb="db/";
  41. $inputFileName=$FileName;
  42. $outputFileNameHead=$filelist[$from][1];
  43. $bookId=$filelist[$from][2];
  44. $vriParNum=0;
  45. $wordOrder=1;
  46. $dirXmlBase="xml/";
  47. $dirXml=$outputFileNameHead."/";
  48. $currParNum="";
  49. $xmlfile = $inputFileName;
  50. echo "doing:".$xmlfile."<br>";
  51. $log=$log."$from,$FileName,open\r\n";
  52. $outputFile = fopen("xml/commantry.csv", "a") or die("Unable to open file!");
  53. // 打开文件并读取数据
  54. $strOutput="";
  55. $Begin=false;
  56. $count=0;
  57. if(($fp=fopen($dirXmlBase.$dirXml.$outputFileNameHead.".csv", "r"))!==FALSE){
  58. while(($data=fgetcsv($fp,0,','))!==FALSE){
  59. if($data[15]=="paranum"){
  60. $currParNum=$data[4];
  61. }
  62. if($data[4]=="("){
  63. $Begin=true;
  64. }
  65. else if($data[4]==")"){
  66. $book=substr($data[2],1);
  67. $strOutput = str_replace(" .",".",$strOutput);
  68. fwrite($outputFile, "\"{$book}\",\"{$currParNum}\",\"{$data[3]}\",\"{$strOutput}\"\r\n");
  69. $Begin = false;
  70. $strOutput="";
  71. $count++;
  72. }
  73. else{
  74. if($Begin){
  75. $strOutput.=$data[4];
  76. }
  77. }
  78. }
  79. fclose($fp);
  80. echo "单词表load:".$dirXmlBase.$dirXml.$outputFileNameHead.".csv<br>";
  81. }
  82. else{
  83. echo "can not open csv file. filename=".$dirXmlBase.$dirXml.$outputFileNameHead.".csv";
  84. }
  85. /*
  86. $myLogFile = fopen($dirLog."insert_db.log", "a");
  87. fwrite($myLogFile, $log);
  88. fclose($myLogFile);
  89. */
  90. fclose($outputFile);
  91. echo "count:$count";
  92. ?>
  93. <?php
  94. if($from==$to){
  95. echo "<h2>齐活!功德无量!all done!</h2>";
  96. }
  97. else{
  98. echo "<script>";
  99. echo "window.location.assign(\"{$thisFileName}?from=".($from+1)."&to=".$to."\")";
  100. echo "</script>";
  101. echo "正在载入:".($from+1)."——".$filelist[$from+1][0];
  102. }
  103. ?>
  104. </body>
  105. </html>