‘;

?>

> or / 検索 >

1 “;
$sql =
” SELECT ”
. ” ID USER_ID ”
. ” ,CONCAT(JA_NAME,'( ‘,KANA,’ )’) FULL_NAME ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_01 BELONGING_TO_01 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_02 BELONGING_TO_02 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_03 BELONGING_TO_03 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_04 BELONGING_TO_04 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_05 BELONGING_TO_05 ”
. ” FROM ”
. ” wp_users ”
. ” WHERE ”
. ” ID <> 1 “;

global $wpdb;

if (isset($_GET[“searchPre”])) {
// カナ検索の場合
$searchPre = TRIM($_GET[“searchPre”]);
$paramPre = $searchPre.’%’;
$searchWord .=”searchPre=”.$searchPre;
$sqlwhere = ” AND KANA LIKE %s “;
$stmt = $wpdb->prepare($sql.$sqlwhere.” ORDER BY KANA,ID LIMIT “.$start .”,” .$end.” “,$paramPre);
$stmtCnt = $wpdb->prepare($sqlCnt.$sqlwhere,$paramPre);
} else{
// 検索ワードありの場合
$searchName = split(” “,str_replace(” “, ” “,str_replace(“ ”, ” “,TRIM($_GET[“searchName”]))));
$searchKeyword = split(” “,str_replace(” “, ” “,str_replace(“ ”, ” “,TRIM($_GET[“searchKeyword”]))));
$searchBelong = split(” “,str_replace(” “, ” “,str_replace(“ ”, ” “,TRIM($_GET[“searchBelong”]))));
if (isset($_GET[“setsuzokushi”])) {
if($_GET[“setsuzokushi”] == 0){
$setsuzokushi = “AND”;
} else {
$setsuzokushi = “OR”;
}
}
if($searchName[0] != “” || $searchKeyword[0] != “” || $searchBelong[0] != “”){
$sqlwhere .= ” AND ( “;
}
$searchWord .=”searchName=”.TRIM($_GET[“searchName”]).”&searchKeyword=”.TRIM($_GET[“searchKeyword”]).”&searchBelong=”.TRIM($_GET[“searchBelong”]).”&setsuzokushi=”.TRIM($_GET[“setsuzokushi”]).” “;

$paramName0 = ‘%’.$searchName[0].’%’;
$paramKeyword0 = ‘%’.$searchKeyword[0].’%’;
$paramBelong0 = ‘%’.$searchBelong[0].’%’;

$paramName1 = ‘%’.$searchName[1].’%’;
$paramKeyword1 = ‘%’.$searchKeyword[1].’%’;
$paramBelong1 = ‘%’.$searchBelong[1].’%’;

$paramName2 = ‘%’.$searchName[2].’%’;
$paramKeyword2 = ‘%’.$searchKeyword[2].’%’;
$paramBelong2 = ‘%’.$searchBelong[2].’%’;

$searchArray = “”;
$searchIndex=0;
$isFirstWhere =true;
if($searchName[0] != “”){
if(!$isFirstWhere){
$sqlwhere .= ” AND ( “;
} else {
$sqlwhere .= ” ( “;
}
$sqlWhereName =” (JA_NAME LIKE %s OR KANA LIKE %s) “;

$sqlwhere .= $sqlWhereName;

for($i = 0 ; $i < 2; $i++){ $searchArray[$searchIndex] = $paramName0; $searchIndex++; } if($searchName[1] != ""){ $sqlwhere .= " ".$setsuzokushi." ".$sqlWhereName; for($i = 0 ; $i < 2; $i++){ $searchArray[$searchIndex] = $paramName1; $searchIndex++; } if($searchName[2] != ""){ $sqlwhere .= " ".$setsuzokushi." ".$sqlWhereName; for($i = 0 ; $i < 2; $i++){ $searchArray[$searchIndex] = $paramName2; $searchIndex++; } } } $sqlwhere .= " ) "; $isFirstWhere = false; } if($searchKeyword[0] != ""){ if(!$isFirstWhere){ $sqlwhere .= " AND ( "; } else { $sqlwhere .= " ( "; } $sqlWhereKeyword = " (JA_KEYWORD_01 LIKE %s " . " OR " . " JA_KEYWORD_02 LIKE %s " . " OR " . " JA_KEYWORD_03 LIKE %s " . " OR " . " JA_KEYWORD_04 LIKE %s " . " OR " . " JA_KEYWORD_05 LIKE %s " . " OR " . " JA_KEYWORD_06 LIKE %s " . " OR " . " JA_KEYWORD_07 LIKE %s " . " OR " . " JA_KEYWORD_08 LIKE %s " . " OR " . " JA_KEYWORD_09 LIKE %s " . " OR " . " JA_KEYWORD_10 LIKE %s) "; $sqlwhere .=$sqlWhereKeyword; for($i = 0 ; $i < 10; $i++){ $searchArray[$searchIndex] = $paramKeyword0; $searchIndex++; } if($searchKeyword[1] != ""){ $sqlwhere .= " ".$setsuzokushi." ".$sqlWhereKeyword; for($i = 0 ; $i < 10; $i++){ $searchArray[$searchIndex] = $paramKeyword1; $searchIndex++; } if($searchKeyword[2] != ""){ $sqlwhere .= " ".$setsuzokushi." ".$sqlWhereKeyword; for($i = 0 ; $i < 10; $i++){ $searchArray[$searchIndex] = $paramKeyword2; $searchIndex++; } } } $sqlwhere .= " ) "; $isFirstWhere = false; } if($searchBelong[0] != ""){ if(!$isFirstWhere){ $sqlwhere .= " AND ( "; } else { $sqlwhere .= " ( "; } $sqlWhereBelong = " ( JA_AFFILIATED_ACADEMIC_SOCIETY_01 LIKE %s " . " OR " . " JA_AFFILIATED_ACADEMIC_SOCIETY_02 LIKE %s " . " OR " . " JA_AFFILIATED_ACADEMIC_SOCIETY_03 LIKE %s " . " OR " . " JA_AFFILIATED_ACADEMIC_SOCIETY_04 LIKE %s " . " OR " . " JA_AFFILIATED_ACADEMIC_SOCIETY_05 LIKE %s) "; $sqlwhere .=$sqlWhereBelong; for($i = 0 ; $i < 5; $i++){ $searchArray[$searchIndex] = $paramBelong0; $searchIndex++; } if($searchBelong[1] != ""){ $sqlwhere .= " ".$setsuzokushi." ".$sqlWhereBelong; for($i = 0 ; $i < 5; $i++){ $searchArray[$searchIndex] = $paramBelong1; $searchIndex++; } if($searchBelong[2] != ""){ $sqlwhere .= " ".$setsuzokushi." ".$sqlWhereBelong; for($i = 0 ; $i < 5; $i++){ $searchArray[$searchIndex] = $paramBelong2; $searchIndex++; } } } $sqlwhere .= " ) "; $isFirstWhere = false; } if($searchName[0] != "" || $searchKeyword[0] != "" || $searchBelong[0] != ""){ $sqlwhere .= " ) "; } //echo "abc"; $stmt = $wpdb->prepare($sql.$sqlwhere.” ORDER BY KANA,ID LIMIT “.$start .”,” .$end.” “,$searchArray);
$stmtCnt = $wpdb->prepare($sqlCnt.$sqlwhere,$searchArray);
//echo “あべし”;
}

$rowsCnt = $wpdb->get_results($stmtCnt);
foreach ($rowsCnt as $rowCnt) {
$cnt = $rowCnt->CNT;
break;
}

if(0 < $cnt){ $startDisp = $start + 1; } else { $startDisp = 0; } $endDisp = $start + $pagingCnt; if($cnt < $endDisp){ $endDisp = $cnt; } // 件数 $cntDisplay = "件数:".$startDisp."件-".$endDisp."件 / ".$cnt."件 " ; // 前の20件 ※前の20件が存在する場合のみ if($start != 0){ $indexPast = $index - 1; $pastMove = '前の’.$pagingCnt.’件へ ‘;
}

// 次のx件 ※次の件数が1件以上存在する場合に、20件、または最大件数 – 現在のindex * 20 件

if($endDisp < $cnt){ if($cnt - $endDisp < $pagingCnt){ $pagingCntDisp = $cnt - $endDisp; } else { $pagingCntDisp = $pagingCnt; } $indexNext = $index + 1; $nextMove= '次の’.$pagingCntDisp.’件へ ‘;
}

// ページングの数だけリンクを作成 ※前後に10件を最大件数とする
$pageMax = ceil($cnt / $pagingCnt);

if(1 < $pageMax){ $indexCnt = 0; for ( $i = 0; $i < $pageMax; $i++ ) { $dispI = $i + 1; if($i == $index){ $dispPageIndex.= $dispI ." "; } else { $indexCntPrev = $index - $dispI; $indexCntNext = $dispI - $index; if($i == 0 || $i == $pageMax - 1){ $dispPageIndex.= '‘.$dispI .’ ‘;
} elseif($indexCntPrev <= 10 && $indexCntNext <= 10){ $dispPageIndex.= '‘.$dispI .’ ‘;
}
}

}
}

$rows = $wpdb->get_results($stmt);

$memberArray;
$rowIndex = 0;
foreach ($rows as $row) {
$memberArray[$rowIndex][0]= ‘‘.

  • ‘.$cntDisplay.’

    ‘; ?>
    ‘.$pastMove.$nextMove.’

    ‘; ?>
    ‘.$dispPageIndex.’

    ‘; ?>
    ‘;
    echo ‘

    ‘;
    echo ‘

    名前

    ‘;
    echo ‘

    所属

    ‘;
    echo ‘

    ‘;
    $bg = ‘#fafafa’;
    foreach ($memberArray as $member) {
    if($bg == ‘#fafafa’) {
    $bg = ‘#ffffff’;
    } elseif($bg == ‘#ffffff’) {
    $bg = ‘#fafafa’;
    }
    echo ‘

    ‘;
    echo ‘

    ‘.$member[0].’

    ‘;
    echo ‘

    ‘.$member[1].’

    ‘;
    echo ‘

    ‘;

    }
    echo ‘

    ‘;
    }

    ?>