mint/app/studio/note/note.php

<?php
require_once '../../public/config.php';
require_once "../../public/_pdo.php";
require_once "../public.inc";
require_once "../book_list_en.inc";
require_once "../../public/function.php";

if(isset($_GET["id"])){
	$id=$_GET["id"];
}
else{
	echo "error: no id";
	return;
}
if(isset($_GET["info"])){
	$info=$_GET["info"];
}
else{
	echo "error: no info";
	return;
}
$arrInfo = str_getcsv($info,"@");
$arrSent = str_getcsv($arrInfo[0],"-");
$bookId=$arrSent[0];
$para=$arrSent[1];
$begin=$arrSent[2];
$end=$arrSent[3];
$db_file = "../{$dir_palicanon}templet/p".$bookId."_tpl.db3";					
PDO_Connect("sqlite:$db_file");
$query="SELECT * FROM 'main' WHERE (\"paragraph\" = ".$PDO->quote($para)." ) ";
$sth = $PDO->prepare($query);
$sth->execute();
$palitext="";
while($result = $sth->fetch(PDO::FETCH_ASSOC))
{
	$index = str_getcsv($result["wid"],"-")[2];
	if($index>=$begin && $index<=$end){
		if($result["type"]!=".ctl."){
			$paliword=$result["word"];
			if($result["style"]=="bld"){
				if(strchr($result["word"],"{")!=FALSE && strchr($result["word"],"}")!=FALSE ){
					$paliword = str_replace("{","<strong>",$paliword);
					$paliword = str_replace("}","</strong>",$paliword);
				}
				else{
					$paliword = "<strong>{$paliword}</strong>";
				}
			}
			$palitext .= $paliword." ";
		}
	}
}
$para_path=_get_para_path($bookId,$para);
//find out translation
$tran="";
$db_file="../".$dir_palicanon."sentence.db3";
PDO_Connect("sqlite:$db_file");
$query="select * from sentence where book='{$bookId}' and paragraph='{$para}' and begin='{$begin}' and end='{$end}' ";
$Fetch = PDO_FetchAll($query);
$iFetch=count($Fetch);
if($iFetch>0){
	$tran = $Fetch[0]["text"];
}
		

$output=array("id"=>$id,"palitext"=>$palitext,"tran"=>$tran,"ref"=>$para_path);
echo json_encode($output, JSON_UNESCAPED_UNICODE);