$value){
print "";
print "";
$id = "";
$image = "";
$word = "";
$jid = "";
$data = explode("\t",$value);
$jid = $data[0];
$id = $data[1];
$word = $data[2];
$sql = "SELECT id,jid,word,pub FROM dictionary_free WHERE id=:id";
$stmt = $pdo->prepare($sql);
$stmt->execute([':id' => $id]);
//全件を配列として取得
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//ループで出力
foreach ($dic_data as $dic_datum) {
$url = "../images/hyoshi/".$dic_datum["jid"].".jpg";
if(file_exists($url)){
$image = "../images/hyoshi/".$dic_datum["jid"].".jpg";
}else{
$image = "../images/hyoshi/nowprinting.jpg";
}
$word = mb_convert_encoding(mb_convert_encoding($dic_datum['word'],'ISO-8859-1','UTF-8'),'UTF-8','EUC-JP');
$jid = $dic_datum["jid"];
}
if( $word!="" && $word!=NULL ){
print "";
print "";
print "![\"\"](\"".$image."\") ";
print "";
print " | ";
$j++;
print "";
print "";
print "[".$j."位] ".$word."
";
$sql = "SELECT id,jid,name_s,name_m,name_l,gosu,COMMENT,pub,writer,pub_date FROM t_DICTools WHERE jid = :jid";
$stmt = $pdo->prepare($sql);
$stmt->execute([':jid' => $jid]);
//全件を配列として取得
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//ループで出力
foreach ($dic_data as $dic_datum) {
print $name_l = mb_convert_encoding(mb_convert_encoding($dic_datum['name_l'], 'ISO-8859-1', 'UTF-8'),'UTF-8', 'EUC-JP');
print "[";
print $pub = mb_convert_encoding(mb_convert_encoding($dic_datum['pub'], 'ISO-8859-1', 'UTF-8'),'UTF-8', 'EUC-JP');
print "]";
}
$stmt->closeCursor(); // カーソルを閉じる（接続は維持）
print "";
print " | ";
}
print "";
print " ";
if( $j > 9 ) break;
}
?>
|
【】
![\"".$kanren_name_l."\"](\"../images/hyoshi/".$jid_value.".jpg\")
";
}else{
print "![\"".$kanren_name_l."\"](\"https://jlogos.com/docomosp/images/list/list-img01.png\")
";
}
print "";
print " ";
}
?>
getMessage();
exit;
}
?>