気づいた点・不具合・要望など、何でもひとことくださいませ
※返信が必要な場合は問い合わせフォームへお願いします
送信
索引
prepare($sql);
$stmt->execute([':jid' => $_GET["jid"]]);
//全件を配列として取得
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//ループで出力
foreach ($dic_data as $dic_datum) {
$l_head = mb_convert_encoding($dic_datum['l_head'],'UTF-8', 'EUC-JP');
$CNT = $dic_datum["CNT"];
array_push($lhead_arr,$l_head);
array_push($cnt_arr,$CNT);
}
$stmt->closeCursor();
}
if( count($lhead_arr)!=0 && count($lhead_arr)!=1 ){
$lhead_cnt = 0;
foreach($lhead_arr as $lhead_key => $lhead_value){
if( $lhead_value == @$_GET["lhead"] ){
if( $lhead_value!="" ){
print "- ";
print "".$lhead_value."(".$cnt_arr[$lhead_cnt].")";
print "
";
}
}else{
if( $lhead_value!="" ){
print "- ";
print "".$lhead_value."(".$cnt_arr[$lhead_cnt].")";
print "
";
}
}
$lhead_cnt++;
}
}
?>
細かい索引
prepare($sql);
$stmt->execute([
':jid' => $_GET["jid"],
':lhead_hex' => $lhead_hex
]);
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//echo '取得件数：' . count($dic_data);
//ループで出力
foreach ($dic_data as $dic_datum) {
$l_head = mb_convert_encoding($dic_datum['s_head'],'UTF-8', 'EUC-JP');
$CNT = $dic_datum["CNT"];
array_push($lhead_arr,$l_head);
array_push($cnt_arr,$CNT);
}
$stmt->closeCursor();
}
if( count($lhead_arr)!=0 && count($lhead_arr)!=1 ){
$lhead_cnt = 0;
foreach($lhead_arr as $lhead_key => $lhead_value){
if( $lhead_value == @$_GET["shead"] ){
if( $lhead_value!="" ){
print "- ";
print "".$lhead_value."(".$cnt_arr[$lhead_cnt].")";
print "
";
}
}else{
if( $lhead_value!="" ){
print "- ";
print "".$lhead_value."(".$cnt_arr[$lhead_cnt].")";
print "
";
}
}
$SAKUIN_FLAG = TRUE;
$lhead_cnt++;
}
}
?>
収録語一覧
prepare($sql);
$stmt->execute([
':jid' => $_GET["jid"],
':lhead_hex' => $lhead_hex,
':shead_hex' => $shead_hex
]);
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//echo '取得件数：' . count($dic_data);
//ループで出力
foreach ($dic_data as $dic_datum) {
$word = mb_convert_encoding($dic_datum['word'],'UTF-8', 'EUC-JP');
print "- ";
print "".$word."";
print "
";
}
$stmt->closeCursor();
}
}else{
$lhead_arr = array();
$cnt_arr = array();
if($_GET["jid"]!=NULL && $_GET["jid"]!="" && @$_GET["lhead"]!=NULL && @$_GET["lhead"]!=""){
// UTF-8「あ行」→ EUC-JPのバイト列 → HEX文字列
$lhead_hex = bin2hex(
mb_convert_encoding($_GET["lhead"], 'EUC-JP', 'UTF-8')
);
$sql = "
SELECT id,word
FROM dictionary_free
WHERE jid = :jid
AND l_head = UNHEX(:lhead_hex)
ORDER BY id
";
$stmt = $pdo->prepare($sql);
$stmt->execute([
':jid' => $_GET["jid"],
':lhead_hex' => $lhead_hex
]);
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//echo '取得件数：' . count($dic_data);
//ループで出力
foreach ($dic_data as $dic_datum) {
$word = mb_convert_encoding($dic_datum['word'],'UTF-8', 'EUC-JP');
print "- ";
print "".$word."";
print "
";
}
$stmt->closeCursor();
}
}
?>
辞典内検索
prepare($sql);
$stmt->execute([':jid' => $_GET["jid"]]);
//全件を配列として取得
$dic_data = $stmt->fetchAll(PDO::FETCH_ASSOC);
//ループで出力
foreach ($dic_data as $dic_datum) {
if($dic_datum["jids"]!="" && $dic_datum["jids"]!=NULL){
$jid_arr = explode(",",$dic_datum["jids"]);
}
}
$stmt->closeCursor();
if( count($jid_arr)>0 ){
?>
|
$jid_value){
$GAZO_FLG = FALSE;
$url = "../images/hyoshi/".$jid_value.".jpg";
if(file_exists($url)){
$GAZO_FLG = TRUE;
}else{
$GAZO_FLG = FALSE;
}
$sql = "SELECT id,jid,name_s,name_m,name_l,gosu,COMMENT,pub,writer,pub_date FROM t_DICTools WHERE jid = :jid";
$stmt2 = $pdo->prepare($sql);
$stmt2->execute([':jid' => $jid_value]);
//全件を配列として取得
$dic_data2 = $stmt2->fetchAll(PDO::FETCH_ASSOC);
$kanren_name_l = "";
//ループで出力
foreach ($dic_data2 as $dic_datum2) {
$kanren_name_l = mb_convert_encoding($dic_datum2['name_l'],'UTF-8', 'EUC-JP');
}
$stmt2->closeCursor(); // カーソルを閉じる（接続は維持）
print "";
if($GAZO_FLG == TRUE){
print "![\"".$kanren_name_l."\"](\"../images/hyoshi/".$jid_value.".jpg\") ";
}else{
print "![\"".$kanren_name_l."\"](\"https://jlogos.com/docomosp/images/list/list-img01.png\") ";
}
print "";
print " ";
}
?>
|
","
",$line);
array_push($rank_array,$line);
}
@fclose($fp);
if( count($rank_array)>0 ){
?>
|
$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($dic_datum['word'],'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($dic_datum['name_l'],'UTF-8', 'EUC-JP');
print "[";
print $pub = mb_convert_encoding($dic_datum['pub'],'UTF-8', 'EUC-JP');
print "]";
}
$stmt->closeCursor(); // カーソルを閉じる（接続は維持）
print "";
print " | ";
}
print "";
print " ";
if( $j > 9 ) break;
}
?>
|
|
|
$value){
print "";
if( $j > 9 ) break;
}
?>
|
getMessage();
exit;
}
?>