0) { echo "\n"; echo $Fetch[0]["doc_info"]; echo "\n\n"; echo "\n"; echo "\n"; $dh_wbw = new PDO( _FILE_DB_USER_WBW_, _DB_USERNAME_, _DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true)); $dh_wbw->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $dh_sent = new PDO( _FILE_DB_SENTENCE_, _DB_PASSWORD_, _DB_PASSWORD_, 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 book_id,paragraph,creator_uid,lang from "._TABLE_USER_WBW_BLOCK_." where uid = ? "; $stmt = $dh_wbw->prepare($query); $stmt->execute(array($block->block_id)); $FetchBlock = $stmt->fetchAll(PDO::FETCH_ASSOC); echo "\n"; echo "\n"; echo "wbw"; echo "{$FetchBlock[0]["book_id"]}"; echo "{$FetchBlock[0]["paragraph"]}"; echo "100"; echo ""; echo "{$block->channal}"; echo "{$block->channal}"; echo "{$FetchBlock[0]["creator_uid"]}"; echo "{$FetchBlock[0]["lang"]}"; echo "1"; echo "1"; echo "{$block->block_id}"; echo "\n"; echo "\n"; $query = "SELECT data from "._TABLE_USER_WBW_." where block_uid=?"; $stmt = $dh_wbw->prepare($query); $stmt->execute(array($block->block_id)); $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 uid,word_start,word_end,content,status from "._TABLE_SENTENCE_." where block_uid=?"; $stmt = $dh_sent->query($query,array($block->block_id)); $sent_data = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($sent_data as $sent) { echo ""; echo "{$sent["uid"]}"; echo "{$sent["word_start"]}"; echo "{$sent["word_end"]}"; echo "{$sent["content"]}"; echo "{$sent["status"]}"; echo ""; } echo "\n"; echo "\n"; } break; } } } echo "\n"; echo ""; }