mint/app/palicanon/get_chapter_info.php

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

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

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

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

$dns = "sqlite:"._FILE_DB_RESRES_INDEX_;
$dbh_res = new PDO($dns, "", "",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 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 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 '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);
}


?>