묻고답하기
page_full_width" class="col-xs-12" |cond="$__Context->page_full_width">
회원정보 관련 최근로그인 나타내기..
2004.04.30 15:00
안녕하세요....초보자입니다..^^
최근로그인을 나타내려고 하는데 팁을 찾아봐도 없는것 같아서 대충 만들어보았는데
가로가 아니 세로로 출력이 되네요...가로로 나타내는 방법을 아려주시면 감사하겠습니다.
아래는 소스입니다..
<-- 시작 -->
<?
$conn=mysql_connect("localhost", "id", "pw");
mysql_select_db("dbname", $conn);
$_zb_url = "제로보드 경로";
$c_result = mysql_query( "select * from zetyx_member_table", $conn );
$result=mysql_query("select * from zetyx_member_table where group_no=1 order by lastlogin desc limit 10",$conn);
$data=mysql_fetch_array(mysql_query("select * from zetyx_member_table where group_no=1 order by lastlogin desc limit 10", $conn));
// 화면에 출력
echo"
";
while($data=mysql_fetch_array($result))
{
if($data[picture]!="") {
$picture="<img src='$_zb_url/$data[picture]' width=120 height=80>";
}
else
{$picture="<img src='http://greentokai.net/zboard/mlist_image/noimage.gif' width=120>";
}
$user_id=stripslashes($data[user_id]);
$data[user_id] = stripslashes($data[user_id]);
$data[name] = stripslashes($data[name]);
$data[job] = stripslashes($data[job]);
$data[email] = stripslashes($data[email]);
$data[homepage] = stripslashes($data[homepage]);
$data[birth] = stripslashes($data[birth]);
$data[hobby] = stripslashes($data[hobby]);
$data[icq] = stripslashes($data[icq]);
$data[msn] = stripslashes($data[msn]);
$data[home_address] = stripslashes($data[home_address]);
$data[home_tel] = stripslashes($data[home_tel]);
$data[office_address] = stripslashes($data[office_address]);
$data[office_tel] = stripslashes($data[office_tel]);
$data[handphone] = stripslashes($data[handphone]);
$data[comment] = stripslashes($data[comment]);
if($data[lastlogin] != "")
$data[lastlogin] = date("Y-m-d H:i:s a",stripslashes($data[lastlogin]));
else
$data[lastlogin] = "기록 없음";
$temp = mysql_query("select * from avatar_member_table where user_id = '$data[user_id]'");
while($data1 = mysql_fetch_array($temp)) {
$avatar_display = "
<DIV style=' width:120; height:160; overflow:hidden;border:0'>
<DIV ID=Layer51 STYLE='position:absolute; left:0; top:0; z-index:1'><img id=ImgChar1 src=$_zb_url/charimg/$data1[ava1] border=0></DIV>
<DIV ID=Layer52 STYLE='position:absolute; left:0; top:0; z-index:3'><img id=ImgChar2 src=$_zb_url/charimg/$data1[ava2] border=0></DIV>
<DIV ID=Layer53 STYLE='position:absolute; left:0; top:0; z-index:2'><img id=ImgChar3 src=$_zb_url/charimg/$data1[ava3] border=0></DIV>
<DIV ID=Layer54 STYLE='position:absolute; left:0; top:0; z-index:5'><img id=ImgChar4 src=$_zb_url/charimg/$data1[ava4] border=0></DIV>
<DIV ID=Layer55 STYLE='position:absolute; left:0; top:0; z-index:4'><img id=ImgChar5 src=$_zb_url/charimg/$data1[ava5] border=0></DIV>
<DIV ID=Layer56 STYLE='position:absolute; left:0; top:0; z-index:6'><img id=ImgChar6 src=$_zb_url/charimg/$data1[ava6] border=0></DIV>
<DIV ID=Layer57 STYLE='position:absolute; left:0; top:0; z-index:7'><img id=ImgChar7 src=$_zb_url/charimg/$data1[ava7] border=0></DIV>
<DIV ID=Layer58 STYLE='position:absolute; left:0; top:0; z-index:8'><img id=ImgChar8 src=$_zb_url/charimg/$data1[ava8] border=0></DIV>
<DIV ID=Layer59 STYLE='position:absolute; left:0; top:0; z-index:0'><img id=ImgChar9 src=$_zb_url/charimg/$data1[ava9] border=0></DIV>
<DIV ID=Layer60 STYLE='position:absolute; left:0; top:0; z-index:10'><img id=ImgChar10 src=$_zb_url/charimg/img_blank.gif border=0 width=120 heigh=160></DIV>
</DIV>
";
}
echo "
<table border=1 width=301>
<tr>
<td width=291 height=50>
<table border=1 width=293>
<tr>
<td width=283 height=129>
<p>$avatar_display<br>$data[user_id]<br>$data[lastlogin]</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
";
}
mysql_close($conn);
?>
<----끝 ---->
미리보기 : http://greentokai.net/test3/test1.php
최근로그인을 나타내려고 하는데 팁을 찾아봐도 없는것 같아서 대충 만들어보았는데
가로가 아니 세로로 출력이 되네요...가로로 나타내는 방법을 아려주시면 감사하겠습니다.
아래는 소스입니다..
<-- 시작 -->
<?
$conn=mysql_connect("localhost", "id", "pw");
mysql_select_db("dbname", $conn);
$_zb_url = "제로보드 경로";
$c_result = mysql_query( "select * from zetyx_member_table", $conn );
$result=mysql_query("select * from zetyx_member_table where group_no=1 order by lastlogin desc limit 10",$conn);
$data=mysql_fetch_array(mysql_query("select * from zetyx_member_table where group_no=1 order by lastlogin desc limit 10", $conn));
// 화면에 출력
echo"
";
while($data=mysql_fetch_array($result))
{
if($data[picture]!="") {
$picture="<img src='$_zb_url/$data[picture]' width=120 height=80>";
}
else
{$picture="<img src='http://greentokai.net/zboard/mlist_image/noimage.gif' width=120>";
}
$user_id=stripslashes($data[user_id]);
$data[user_id] = stripslashes($data[user_id]);
$data[name] = stripslashes($data[name]);
$data[job] = stripslashes($data[job]);
$data[email] = stripslashes($data[email]);
$data[homepage] = stripslashes($data[homepage]);
$data[birth] = stripslashes($data[birth]);
$data[hobby] = stripslashes($data[hobby]);
$data[icq] = stripslashes($data[icq]);
$data[msn] = stripslashes($data[msn]);
$data[home_address] = stripslashes($data[home_address]);
$data[home_tel] = stripslashes($data[home_tel]);
$data[office_address] = stripslashes($data[office_address]);
$data[office_tel] = stripslashes($data[office_tel]);
$data[handphone] = stripslashes($data[handphone]);
$data[comment] = stripslashes($data[comment]);
if($data[lastlogin] != "")
$data[lastlogin] = date("Y-m-d H:i:s a",stripslashes($data[lastlogin]));
else
$data[lastlogin] = "기록 없음";
$temp = mysql_query("select * from avatar_member_table where user_id = '$data[user_id]'");
while($data1 = mysql_fetch_array($temp)) {
$avatar_display = "
<DIV style=' width:120; height:160; overflow:hidden;border:0'>
<DIV ID=Layer51 STYLE='position:absolute; left:0; top:0; z-index:1'><img id=ImgChar1 src=$_zb_url/charimg/$data1[ava1] border=0></DIV>
<DIV ID=Layer52 STYLE='position:absolute; left:0; top:0; z-index:3'><img id=ImgChar2 src=$_zb_url/charimg/$data1[ava2] border=0></DIV>
<DIV ID=Layer53 STYLE='position:absolute; left:0; top:0; z-index:2'><img id=ImgChar3 src=$_zb_url/charimg/$data1[ava3] border=0></DIV>
<DIV ID=Layer54 STYLE='position:absolute; left:0; top:0; z-index:5'><img id=ImgChar4 src=$_zb_url/charimg/$data1[ava4] border=0></DIV>
<DIV ID=Layer55 STYLE='position:absolute; left:0; top:0; z-index:4'><img id=ImgChar5 src=$_zb_url/charimg/$data1[ava5] border=0></DIV>
<DIV ID=Layer56 STYLE='position:absolute; left:0; top:0; z-index:6'><img id=ImgChar6 src=$_zb_url/charimg/$data1[ava6] border=0></DIV>
<DIV ID=Layer57 STYLE='position:absolute; left:0; top:0; z-index:7'><img id=ImgChar7 src=$_zb_url/charimg/$data1[ava7] border=0></DIV>
<DIV ID=Layer58 STYLE='position:absolute; left:0; top:0; z-index:8'><img id=ImgChar8 src=$_zb_url/charimg/$data1[ava8] border=0></DIV>
<DIV ID=Layer59 STYLE='position:absolute; left:0; top:0; z-index:0'><img id=ImgChar9 src=$_zb_url/charimg/$data1[ava9] border=0></DIV>
<DIV ID=Layer60 STYLE='position:absolute; left:0; top:0; z-index:10'><img id=ImgChar10 src=$_zb_url/charimg/img_blank.gif border=0 width=120 heigh=160></DIV>
</DIV>
";
}
echo "
<table border=1 width=301>
<tr>
<td width=291 height=50>
<table border=1 width=293>
<tr>
<td width=283 height=129>
<p>$avatar_display<br>$data[user_id]<br>$data[lastlogin]</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
";
}
mysql_close($conn);
?>
<----끝 ---->
미리보기 : http://greentokai.net/test3/test1.php
<table><tr> 는 반복되지 않아야 가로가 될듯 싶네요.