mint/app/palicanon/get_chapter_info.php

<?php
require_once '../config.php';

try {
    $redis = new redis();
    $r_conn = $redis->connect('127.0.0.1', 6379);
} catch (Exception $e) {
    $r_conn = false;
}

$dns = _FILE_DB_PALI_TOC_;
$dbh_toc = new PDO($dns, _DB_USERNAME_, _DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true));
$dbh_toc->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

$dns = _FILE_DB_PALITEXT_;
$dbh_pali_text = new PDO($dns, _DB_USERNAME_, _DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true));
$dbh_pali_text->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

$dns = _FILE_DB_RESRES_INDEX_;
$dbh_res = new PDO($dns, _DB_USERNAME_, _DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true));
$dbh_res->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

if (isset($_GET["book"])) {
    $book = (int) $_GET["book"];
}
if (isset($_GET["para"])) {
    $para = (int) $_GET["para"];
}

$query = "SELECT * FROM "._TABLE_PALI_TEXT_." WHERE book = ? and paragraph = ?";
$stmt = $dbh_pali_text->prepare($query);
$stmt->execute(array($book, $para));
$paraInfo = $stmt->fetch(PDO::FETCH_ASSOC);
if ($paraInfo) {
    # 查进度
    $paraProgress = array();
    if ($r_conn) {
        $count = $redis->hLen("progress_chapter_{$book}_{$para}");
        if ($count > 0) {
            $prog = $redis->hGetAll("progress_chapter_{$book}_{$para}");
            foreach ($prog as $keylang => $valuetrans) {
                # code...
                $paraProgress[] = array("lang" => $keylang, "all_trans" => $valuetrans);
            }
        }

    } else {
        $query = "SELECT lang, all_trans from "._TABLE_PROGRESS_CHAPTER_." where book=? and para=?";
        $stmt = $dbh_toc->prepare($query);
        $sth_toc = $dbh_toc->prepare($query);
        $sth_toc->execute(array($book, $para));
        $paraProgress = $sth_toc->fetchAll(PDO::FETCH_ASSOC);
    }
    $paraInfo["progress"] = $paraProgress;

    #查标题
    if (isset($_GET["lang"])) {
        $query = "SELECT title from "._TABLE_RES_INDEX_." where book=? and paragraph=? and language=?";
        $stmt = $dbh_res->prepare($query);
        $sth_title = $dbh_res->prepare($query);
        $sth_title->execute(array($book, $para, $_GET["lang"]));
        $trans_title = $sth_title->fetch(PDO::FETCH_ASSOC);
        if ($trans_title) {
            $paraInfo["trans_title"] = $trans_title['title'];
        }
    }
    echo json_encode($paraInfo, JSON_UNESCAPED_UNICODE);
} else {
    echo json_encode(array(), JSON_UNESCAPED_UNICODE);
}