pali_sent_list.php 899 B

1234567891011121314151617181920212223242526272829
  1. <?php
  2. /*
  3. get user sentence from db
  4. */
  5. require_once "../config.php";
  6. require_once "../public/_pdo.php";
  7. require_once "../public/function.php";
  8. $para = $_POST["para"];
  9. $paraList = json_decode($para);
  10. $output = array();
  11. $dns = _FILE_DB_PALI_SENTENCE_;
  12. $dbh = new PDO($dns, _DB_USERNAME_, _DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true));
  13. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  14. $query = "SELECT word_begin as begin,word_end as end ,text FROM "._TABLE_PALI_SENT_." WHERE (book = ? AND paragraph = ? ) ";
  15. $stmt = $dbh->prepare($query);
  16. foreach ($paraList as $key => $value) {
  17. # code...
  18. $stmt->execute(array($value->book, $value->para));
  19. $Fetch = $stmt->fetchAll(PDO::FETCH_ASSOC);
  20. $sent["info"] = array("book" => $value->book, "para" => $value->para);
  21. $sent["data"] = $Fetch;
  22. $output[] = $sent;
  23. }
  24. echo json_encode($output, JSON_UNESCAPED_UNICODE);