왕초보가 문의 드립니다... 정보
왕초보가 문의 드립니다...본문
안녕하세요...
그누에 가입하고 하나하나 배워나가고 있습니다.
그누팁에서 회원검색이 있던데..
요기의 회원검색에서 아이디로 검색이 되어 지는데 이걸 아이디검색으로 말고 회원이름으로 검색을 하고 검색결과에도 회원아이디가 아닌 회원이름으로 나오게 하고 싶은데...제 상식으로는 힘드네요..ㅠㅠ
지금까지 혼자 끙끙대다가 도움을 요청합니다...
고수님들 도움을 주시면 감사하겠습니다~
댓글 전체

<?
include_once("./_common.php");
$g4[title] = "";
//if (!$member[mb_id]) { alert("로그인해야 사용가능합니다."); }
//else { // 로그인후 사용가능
include_once("./_head.php");
$sql_common = " from $g4[member_table] ";
$qstr = "";
if (isset($Usex)) $qstr .= '&Usex=' . urlencode($Usex);
if (isset($UageF)) $qstr .= '&UageF=' . urlencode($UageF);
if (isset($UageT)) $qstr .= '&UageT=' . urlencode($UageT);
if (isset($Uid)) $qstr .= '&Uid=' . urlencode($Uid);
if (isset($Uname)) $qstr .= '&Uname=' . urlencode($Uname);
if (isset($UregF)) $qstr .= '&UregF=' . urlencode($UregF);
if (isset($UregT)) $qstr .= '&UregT=' . urlencode($UregT);
$sql_search = " where (1) ";
if ($Usex) { $sql_search .= " and (mb_sex = '$Usex') "; }
if ($UageF) { $sql_search .= " and (mb_birth <= '$UageF') "; }
if ($UageT) { $sql_search .= " and (mb_birth >= '$UageT') "; }
//if ($Uid) { $sql_search .= " and (mb_id = '$Uid') "; }
if ($Uid) { $sql_search .= " and (mb_id like '%$Uid%') "; }
if ($Uname) { $sql_search .= " and (mb_name = '$Uname') "; }
if ($UregF) { $sql_search .= " and (mb_datetime >= '$UregF') "; }
if ($UregT) { $sql_search .= " and (mb_datetime <= '$UregT') "; }
if (!$sst) {
$sst = "mb_datetime";
$sod = "desc";
}
$sql_order = " and mb_level != '10' order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
//$rows = $config[cf_page_rows];
$rows = "15";
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$listall = "<a href='$_SERVER[PHP_SELF]' class=tt>처음</a>";
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
?>
<style type="text/css">
<!--
.padd5 { padding:5px; }
.Cgreen { color:#88aa88; }
.Cred { color:#aa8888; }
.Cwhite { color:#ffffff; }
.line { background:#FBBA42; height:1px; }
.line0 { height:5px; }
.inputO { background:#eeeccc; border: solid #DC9003 1px; }
.inputOr { background:#eeeccc; border: solid #DC9003 1px; text-align:right;padding:0 5 0 0; }
.inputW { background:#ffffcc; border: solid #DC9003 1px; }
.td_pdL { padding:5 5 5 0; }
.dotO { font-size:10pt;color:#DC9003; }
.small5 { font-size:8pt;font-family:돋움;color:#555555; }
-->
</style>
<div style='border:dashed #999999;border-width:0 0 1 0;padding:5px;margin:0 0 10 0;'>
▶<a href='<?=$g4[path]?>/search_member.php' style='color:#333333;'><b>회원검색
</b></a>
</div>
<form name="frmMemSearch" action="<?=$g4[path]?>/search_member.php" method="get" style='margin:0px;'>
<div style='margin:10 0 10 0;background:#cccaaa;padding:0 0 0 0;'>
<table cellpadding=0 cellspacing=0 align=center width=630>
<tr>
<td class='td_pdL' colspan=2><span class='dotO'>●</span> <b>아이디</b>
<input type=text size=10 class=inputO name='Uid' value='<?=$Uid?>'>
<td class='td_pdL' colspan=2>
<span class='dotO'>●</span> <b>이름</b>
<input type=text size=10 class=inputO name='Uname' value='<?=$Uname?>'>
<td class='td_pdL'><span class='dotO'>●</span> <b>성별</b>
<select name='Usex'>
<option value=''>선택
<option value='M' <? if ($Usex == 'M') { echo "selected"; } ?>>남자
<option value='F' <? if ($Usex == 'F') { echo "selected"; } ?>>여자
</select>
<td class='td_pdL'><span class='dotO'>●</span> <b>나이</b>
<select name='UageF'>
<option value=''>선택
<?
$thisY = date("Y"); //올해
for ($a=0; $a<23; $a++) {
$b=($a * 2)+18; //18세 부터 2살씩 증가
$birthY = $thisY - $b + 1 ;
if ($UageF == $birthY."1231") { $selectedUageF[$a] = "selected"; } else { $selectedUageF[$a] = ""; }
echo "<option value='{$birthY}1231' $selectedUageF[$a]>$b";
} ?>
</select>
~
<select name='UageT'>
<option value=''>선택
<?
$thisY = date("Y"); //올해
for ($a=0; $a<23; $a++) {
$b=($a * 2)+18; //18세 부터 2살씩 증가
$birthY = $thisY - $b + 1 ;
if ($UageT == $birthY."0101") { $selectedUageT[$a] = "selected"; } else { $selectedUageT[$a] = ""; }
echo "<option value='{$birthY}0101' $selectedUageT[$a]>$b";
} ?>
</select>
<tr><td colspan=6 height=1 bgcolor=#DC9003>
</table>
<table cellpadding=0 cellspacing=0 align=center width=630>
<tr>
<td class='td_pdL'><span class='dotO'>●</span> <b>가입일</b>
<input class='field' type=text name='UregF' size=8 value='<?=$UregF?>' readonly>
<a href="javascript:win_calendar('UregF', document.getElementById('UregF').value, '');">
<img src='<?=$g4[path]?>/img/calendar.gif' border=0 align=absmiddle title='달력 - 날짜를 선택하세요'></a>
~
<input class='field' type=text name='UregT' size=8 value='<?=$UregT?>' readonly>
<a href="javascript:win_calendar('UregT', document.getElementById('UregT').value, '');">
<img src='<?=$g4[path]?>/img/calendar.gif' border=0 align=absmiddle title='달력 - 날짜를 선택하세요'></a>
<span class='small'>(달력을 클릭하세요)</span>
<td class='td_pdL'>
<input type=submit value=' 회 원 검 색 '>
</table>
</div>
</form>
<!-----------회원검색 목록------------->
<table width="100%" cellpadding=0 cellspacing=0>
<colgroup width='130'><colgroup width=''><colgroup width=''><colgroup width='120'>
<tr align=center bgcolor=#aaa888 height=25>
<td class=Cwhite>아이디<td class=Cwhite>이름<td class=Cwhite>성별<td class=Cwhite>나이<td class=Cwhite>가입일<td class=Cwhite>
<?
$colspan = 6;
for ($i=0; $row=sql_fetch_array($result); $i++) {
$pf = get_member($row[mb_id]);
if ($pf[mb_sex] == 'M') { $pf_sex = "男"; }
else if ($pf[mb_sex] == 'F') { $pf_sex = "女"; }
$thisY = date("Y");
$birthY = substr($pf[mb_birth],0,4);
$pf_age = $thisY - $birthY + 1;
echo "<tr><td colspan='$colspan' class=line0>";
echo "<tr align=center>";
echo "<td><b>".$pf[mb_id]."</b>";
echo "<td><b>".$pf[mb_name]."</b>";
echo "<td>".$pf_sex;
echo "<td>".$pf[mb_birth]."(".$pf_age.")";
echo "<td>".$pf[mb_datetime];
echo "<td><a href='#none' OnClick=\"window.open('$g4[bbs_path]/memo_form.php?me_recv_mb_id=$pf[mb_id]','','scrollbars=yes,resizable=no,width=650,height=500')\">";
echo "쪽지보내기</a>";
echo "<tr><td colspan='$colspan' class=line0><tr><td colspan='$colspan' class=line>";
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100>자료가 없습니다.</td></tr>";
?>
</tr></table>
<?
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "<br /><table width=100% cellpadding=3 cellspacing=1>";
echo "<tr>";
echo "<td align=center>$pagelist</td></tr></table>";
?>
<?
include_once("./_tail.php");
//} // 로그인후 사용가능
?>
include_once("./_common.php");
$g4[title] = "";
//if (!$member[mb_id]) { alert("로그인해야 사용가능합니다."); }
//else { // 로그인후 사용가능
include_once("./_head.php");
$sql_common = " from $g4[member_table] ";
$qstr = "";
if (isset($Usex)) $qstr .= '&Usex=' . urlencode($Usex);
if (isset($UageF)) $qstr .= '&UageF=' . urlencode($UageF);
if (isset($UageT)) $qstr .= '&UageT=' . urlencode($UageT);
if (isset($Uid)) $qstr .= '&Uid=' . urlencode($Uid);
if (isset($Uname)) $qstr .= '&Uname=' . urlencode($Uname);
if (isset($UregF)) $qstr .= '&UregF=' . urlencode($UregF);
if (isset($UregT)) $qstr .= '&UregT=' . urlencode($UregT);
$sql_search = " where (1) ";
if ($Usex) { $sql_search .= " and (mb_sex = '$Usex') "; }
if ($UageF) { $sql_search .= " and (mb_birth <= '$UageF') "; }
if ($UageT) { $sql_search .= " and (mb_birth >= '$UageT') "; }
//if ($Uid) { $sql_search .= " and (mb_id = '$Uid') "; }
if ($Uid) { $sql_search .= " and (mb_id like '%$Uid%') "; }
if ($Uname) { $sql_search .= " and (mb_name = '$Uname') "; }
if ($UregF) { $sql_search .= " and (mb_datetime >= '$UregF') "; }
if ($UregT) { $sql_search .= " and (mb_datetime <= '$UregT') "; }
if (!$sst) {
$sst = "mb_datetime";
$sod = "desc";
}
$sql_order = " and mb_level != '10' order by $sst $sod ";
$sql = " select count(*) as cnt
$sql_common
$sql_search
$sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];
//$rows = $config[cf_page_rows];
$rows = "15";
$total_page = ceil($total_count / $rows); // 전체 페이지 계산
if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함
$listall = "<a href='$_SERVER[PHP_SELF]' class=tt>처음</a>";
$sql = " select *
$sql_common
$sql_search
$sql_order
limit $from_record, $rows ";
$result = sql_query($sql);
?>
<style type="text/css">
<!--
.padd5 { padding:5px; }
.Cgreen { color:#88aa88; }
.Cred { color:#aa8888; }
.Cwhite { color:#ffffff; }
.line { background:#FBBA42; height:1px; }
.line0 { height:5px; }
.inputO { background:#eeeccc; border: solid #DC9003 1px; }
.inputOr { background:#eeeccc; border: solid #DC9003 1px; text-align:right;padding:0 5 0 0; }
.inputW { background:#ffffcc; border: solid #DC9003 1px; }
.td_pdL { padding:5 5 5 0; }
.dotO { font-size:10pt;color:#DC9003; }
.small5 { font-size:8pt;font-family:돋움;color:#555555; }
-->
</style>
<div style='border:dashed #999999;border-width:0 0 1 0;padding:5px;margin:0 0 10 0;'>
▶<a href='<?=$g4[path]?>/search_member.php' style='color:#333333;'><b>회원검색
</b></a>
</div>
<form name="frmMemSearch" action="<?=$g4[path]?>/search_member.php" method="get" style='margin:0px;'>
<div style='margin:10 0 10 0;background:#cccaaa;padding:0 0 0 0;'>
<table cellpadding=0 cellspacing=0 align=center width=630>
<tr>
<td class='td_pdL' colspan=2><span class='dotO'>●</span> <b>아이디</b>
<input type=text size=10 class=inputO name='Uid' value='<?=$Uid?>'>
<td class='td_pdL' colspan=2>
<span class='dotO'>●</span> <b>이름</b>
<input type=text size=10 class=inputO name='Uname' value='<?=$Uname?>'>
<td class='td_pdL'><span class='dotO'>●</span> <b>성별</b>
<select name='Usex'>
<option value=''>선택
<option value='M' <? if ($Usex == 'M') { echo "selected"; } ?>>남자
<option value='F' <? if ($Usex == 'F') { echo "selected"; } ?>>여자
</select>
<td class='td_pdL'><span class='dotO'>●</span> <b>나이</b>
<select name='UageF'>
<option value=''>선택
<?
$thisY = date("Y"); //올해
for ($a=0; $a<23; $a++) {
$b=($a * 2)+18; //18세 부터 2살씩 증가
$birthY = $thisY - $b + 1 ;
if ($UageF == $birthY."1231") { $selectedUageF[$a] = "selected"; } else { $selectedUageF[$a] = ""; }
echo "<option value='{$birthY}1231' $selectedUageF[$a]>$b";
} ?>
</select>
~
<select name='UageT'>
<option value=''>선택
<?
$thisY = date("Y"); //올해
for ($a=0; $a<23; $a++) {
$b=($a * 2)+18; //18세 부터 2살씩 증가
$birthY = $thisY - $b + 1 ;
if ($UageT == $birthY."0101") { $selectedUageT[$a] = "selected"; } else { $selectedUageT[$a] = ""; }
echo "<option value='{$birthY}0101' $selectedUageT[$a]>$b";
} ?>
</select>
<tr><td colspan=6 height=1 bgcolor=#DC9003>
</table>
<table cellpadding=0 cellspacing=0 align=center width=630>
<tr>
<td class='td_pdL'><span class='dotO'>●</span> <b>가입일</b>
<input class='field' type=text name='UregF' size=8 value='<?=$UregF?>' readonly>
<a href="javascript:win_calendar('UregF', document.getElementById('UregF').value, '');">
<img src='<?=$g4[path]?>/img/calendar.gif' border=0 align=absmiddle title='달력 - 날짜를 선택하세요'></a>
~
<input class='field' type=text name='UregT' size=8 value='<?=$UregT?>' readonly>
<a href="javascript:win_calendar('UregT', document.getElementById('UregT').value, '');">
<img src='<?=$g4[path]?>/img/calendar.gif' border=0 align=absmiddle title='달력 - 날짜를 선택하세요'></a>
<span class='small'>(달력을 클릭하세요)</span>
<td class='td_pdL'>
<input type=submit value=' 회 원 검 색 '>
</table>
</div>
</form>
<!-----------회원검색 목록------------->
<table width="100%" cellpadding=0 cellspacing=0>
<colgroup width='130'><colgroup width=''><colgroup width=''><colgroup width='120'>
<tr align=center bgcolor=#aaa888 height=25>
<td class=Cwhite>아이디<td class=Cwhite>이름<td class=Cwhite>성별<td class=Cwhite>나이<td class=Cwhite>가입일<td class=Cwhite>
<?
$colspan = 6;
for ($i=0; $row=sql_fetch_array($result); $i++) {
$pf = get_member($row[mb_id]);
if ($pf[mb_sex] == 'M') { $pf_sex = "男"; }
else if ($pf[mb_sex] == 'F') { $pf_sex = "女"; }
$thisY = date("Y");
$birthY = substr($pf[mb_birth],0,4);
$pf_age = $thisY - $birthY + 1;
echo "<tr><td colspan='$colspan' class=line0>";
echo "<tr align=center>";
echo "<td><b>".$pf[mb_id]."</b>";
echo "<td><b>".$pf[mb_name]."</b>";
echo "<td>".$pf_sex;
echo "<td>".$pf[mb_birth]."(".$pf_age.")";
echo "<td>".$pf[mb_datetime];
echo "<td><a href='#none' OnClick=\"window.open('$g4[bbs_path]/memo_form.php?me_recv_mb_id=$pf[mb_id]','','scrollbars=yes,resizable=no,width=650,height=500')\">";
echo "쪽지보내기</a>";
echo "<tr><td colspan='$colspan' class=line0><tr><td colspan='$colspan' class=line>";
}
if ($i == 0)
echo "<tr><td colspan='$colspan' align=center height=100>자료가 없습니다.</td></tr>";
?>
</tr></table>
<?
$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "<br /><table width=100% cellpadding=3 cellspacing=1>";
echo "<tr>";
echo "<td align=center>$pagelist</td></tr></table>";
?>
<?
include_once("./_tail.php");
//} // 로그인후 사용가능
?>

아이디 출력 부분은 지우지 않았습니다.
이이디와 이름 모두 필요할 테니까요...
이이디와 이름 모두 필요할 테니까요...
정말 감사합니다..........^^