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_USERNAME_, _DB_PASSWORD_, array(PDO::ATTR_PERSISTENT => true)); $dh_sent->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $blockList = json_decode($Fetch[0]["doc_block"]); foreach ($blockList as $block) { switch ($block->type) { case "6": { $albumId = UUID::v4(); $query = "SELECT uid, book_id,paragraph,channel_uid , 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); #TODO 处理没找到数据的问题 echo "\n"; echo "\n"; echo "wbw"; echo "{$FetchBlock[0]["book_id"]}"; echo "{$FetchBlock[0]["paragraph"]}"; echo "100"; echo ""; echo "{$FetchBlock[0]["channel_uid"]}"; echo "{$FetchBlock[0]["channel_uid"]}"; echo "{$FetchBlock[0]["creator_uid"]}"; echo "{$FetchBlock[0]["lang"]}"; echo "1"; echo "1"; echo "{$FetchBlock[0]["uid"]}"; echo "\n"; echo "\n"; $query = "SELECT data FROM "._TABLE_USER_WBW_." WHERE block_uid=? order by wid ASC"; $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 book_id,paragraph,author,editor_uid,lang,parent_uid from "._TABLE_SENTENCE_BLOCK_." where uid=?"; $stmt = $dh_sent->query($query,array($block->block_id)); $FetchBlock = $stmt->fetchAll(PDO::FETCH_ASSOC); if (count($FetchBlock) > 0) { echo "\n\n"; echo "\n"; echo "translate"; echo "{$FetchBlock[0]["book_id"]}"; echo "{$FetchBlock[0]["paragraph"]}"; echo "100"; echo ""; echo ""; echo "channel"; echo "{$FetchBlock[0]["author"]}"; echo "{$FetchBlock[0]["editor_uid"]}"; echo "{$FetchBlock[0]["lang"]}"; echo "1"; echo "1"; echo "{$block->block_id}"; echo "{$FetchBlock[0]["parent_uid"]}"; 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 ""; }