'; echo "\n"; echo " \n"; echo " pcdsset\n"; echo " package\n"; echo " 1\n"; echo " \n"; echo " \n"; echo " {$book}-{$paralist[0]}\n"; echo " \n"; 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); foreach($paralist as $para){ $albumId = UUID::v4(); $query="SELECT * FROM wbw_block WHERE channal=? AND book = ? AND paragraph = ? "; $stmt = $dh_wbw->prepare($query); $stmt->execute(array($channal,$book,$para)); $FetchBlock = $stmt->fetch(PDO::FETCH_ASSOC); if($FetchBlock){ echo "\n"; echo "\n"; echo "wbw"; echo "{$book}"; echo "{$para}"; echo "100"; echo ""; echo ""; echo ""; echo "{$FetchBlock["owner"]}"; echo "{$FetchBlock["lang"]}"; echo "1"; echo "1"; echo "{$FetchBlock["id"]}"; echo "\n"; echo "\n"; $block_id = $FetchBlock["id"]; $query="select * from wbw where block_id= ? "; $stmt = $dh_wbw->prepare($query); $stmt->execute(array($block_id)); $wbw_data = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach($wbw_data as $word){ echo $word["data"]; echo "\r\n"; } echo ""; echo "\n"; } } echo "\n"; echo ""; ?>