quote($id); $Fetch = PDO_FetchAll($query); if(count($Fetch)>0){ echo "\n"; echo $Fetch[0]["doc_info"]; echo "\n\n"; echo "\n"; echo "\n"; $dh_wbw = new PDO("sqlite:"._FILE_DB_USER_WBW_, "", "",array(PDO::ATTR_PERSISTENT=>true)); $dh_wbw->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $dh_sent = new PDO("sqlite:"._FILE_DB_SENTENCE_, "", "",array(PDO::ATTR_PERSISTENT=>true)); $dh_sent->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $blockList = explode("\n",$Fetch[0]["content"]) ; foreach($blockList as $block){ $info = explode("-",$block); switch($block->type){ case "6": { $albumId = UUID::v4(); $query="select * from wbw_block where id='".$block->block_id."'"; $stmt = $dh_wbw->query($query); $FetchBlock = $stmt->fetchAll(PDO::FETCH_ASSOC); echo "\n"; echo "\n"; echo "wbw"; echo "{$FetchBlock[0]["book"]}"; echo "{$FetchBlock[0]["paragraph"]}"; echo "100"; echo ""; echo "{$block->channal}"; echo "{$block->channal}"; echo "{$FetchBlock[0]["owner"]}"; echo "{$FetchBlock[0]["lang"]}"; echo "1"; echo "1"; echo "{$block->block_id}"; echo "\n"; echo "\n"; $query="select * from wbw where block_id='".$block->block_id."'"; $stmt = $dh_wbw->query($query); $wbw_data = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach($wbw_data as $word){ echo $word["data"]; echo "\r\n"; } echo ""; echo "\n"; break; } case 2: { $albumId = UUID::v4(); $query="select * from sent_block where id='".$block->block_id."'"; $stmt = $dh_sent->query($query); $FetchBlock = $stmt->fetchAll(PDO::FETCH_ASSOC); if(count($FetchBlock)>0){ echo "\n\n"; echo "\n"; echo "translate"; echo "{$FetchBlock[0]["book"]}"; echo "{$FetchBlock[0]["paragraph"]}"; echo "100"; echo ""; echo "{$block->channal}"; echo "{$block->channal}"; echo "{$FetchBlock[0]["author"]}"; echo "{$FetchBlock[0]["editor"]}"; echo "{$FetchBlock[0]["lang"]}"; echo "1"; echo "1"; echo "{$block->block_id}"; echo "{$FetchBlock[0]["parent_id"]}"; echo "\n"; echo "\n"; $query="select * from sentence where block_id='".$block->block_id."'"; $stmt = $dh_sent->query($query); $sent_data = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach($sent_data as $sent){ echo ""; echo "{$sent["id"]}"; echo "{$sent["begin"]}"; echo "{$sent["end"]}"; echo "{$sent["text"]}"; echo "{$sent["status"]}"; echo ""; } echo "\n"; echo "\n"; } break; } } } echo "\n"; echo ""; } ?>