admin 관리자
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::
***index.html
<?session_start();?>
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<style>
input {background:#ffdcd7}
</style>
</HEAD>
<BODY>
<table border=1 width=800>
<tr>
<td colspan=2><img src=http://www.pcall.co.kr/img/98.gif height=150></td>
</tr>
<tr>
<td width=30% height=300 valign=top>
메뉴
<br>
<a href=index.html?mode=home>처음으로</a>
<?
if($id){
echo <br>{$name}님 환영합니다.<br>;
echo <br><a href=logout.php>로그아웃</a><br>;
}else{
?>
<form method=post action=login.php>
<table border=1 width=200>
<tr>
<td>아이디</td>
<td><input type=text name=userid size=15 value=아이디를 입력 onFocus=this.value=\></td>
</tr>
<tr>
<td>비밀번호</td>
<td><input type=password name=userpass size=15 value=비밀번호입력 onFocus=this.value=\ ></td>
</tr>
<tr>
<td colspan=2 align=center>
<input type=submit value=로그인></td>
</tr>
</table>
</form>
<!--
***********************
<input type= ext name=
ame value=이름 style=order:black 1px solid;background-color:ivory onMouseOver= his.style.backgroundColor=ccffcc\ onMouseOut= his.style.backgroundColor=ivory\ onFocus= his.value=\ size=10>
<input type= ext name=email value=이메일 style=order:black 1px solid;background-color:ivory onMouseOver= his.style.backgroundColor=ccffcc\ onMouseOut= hes.style.backgroundColor=ivory\ onFocus= his.value=\ size=10>
<input type= ext name=memo value=내용 style=order:black 1px solid;background-color:ivory onMouseOver= his.style.backgroundColor=ccffcc\ onMouseOut= hes.style.backgroundColor=ivory\ onFocus= his.value=\ size=30>
**********************
-->
<p>
<a href=index.html?mode=join>회원가입</a>
<p>
<?}?>
<a href=index.html?mode=board>게시판</a>
<p>
<a href=index.html?mode=memo>메모장</a>
<p>
</td>
<td align=center>
뷰
<?
if(!$mode){
$mode=home;
}
switch($mode){
case home: include
ull.html;
break;
case oard: include oard1/list.html;
break;
case memo: include ..memo/memolist.html;
break;
case join: include
egist.html;
break;
case dview : include ./board1/view.html;
break;
}
?>
</td>
</tr>
</table>
</BODY>
</HTML>
:::::::::::::::::::::::::::::::::::::::::::::::::::::
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.
C:\Documents and Settings\Administrator>cd \
C:\>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.22-nt
Type help; or \h for help. Type \c to clear the buffer.
mysql> use appledb
Database changed
mysql> select * from member \G
*************************** 1. row ***************************
num: 1
userid: 1
userpass: 1
question:
answer: 1
username: 1
email: 1
jumin: 11
tel: 1-1-1
zip: 1-1
address: 1-1/1
job: 1
hobby: 1
*************************** 2. row ***************************
num: 2
userid: 2
userpass: 2
question:
answer: 2
username: 2
email: 2
jumin: 22
tel: 2-2-2
zip: 2-2
address: 2-2/2
job: 2
hobby: 2
*************************** 3. row ***************************
num: 3
userid: 11
userpass: 11
question:
answer: 11
username: 11
email: 11
jumin: 1111
tel: 1-1-1
zip: 11-1
address: 11-1/11
job: 11
hobby: 11
*************************** 4. row ***************************
num: 4
userid: fsad
userpass: fds
question:
answer: fsd
username: fsda
email: sdaf
jumin: dfsafsda
tel: fsd-fsad-fsa
zip: 1-1
address: 1-1/11
job: 11
hobby: 11
*************************** 5. row ***************************
num: 5
userid: a
userpass: aaa
question:
answer: aaa
username: aaa
email: aaa
jumin: aaaa
tel: a-a-a
zip: a-a
address: a-a/a
job: a
hobby: aa
5 rows in set (0.00 sec)
mysql>
----------------------------------------
***substr.php
<?
$str=abcde12345;
$tmp1=substr($str,0,1);
$tmp2=substr($str,0,2);
$tmp3=substr($str,0,3);
$tmp4=substr($str,0,4);
$tmp5=substr($str,0,5);
$tmp6=substr($str,0,6);
echo mp1 --- $tmp1<br>;
echo mp2 --- $tmp2<br>;
echo mp3 --- $tmp3<br>;
echo mp4 --- $tmp4<br>;
echo mp5 --- $tmp5<br>;
echo mp6 --- $tmp6<br>;
include ../connect.php;
$query=create table test33( add);;
$result=mysql_query($query);
echo
esult --- $result<br>;
?>
***explode.php
<?
$str=aaa-bbb-ccc;
$tmp=explode(-,$str);
echo mp[0] --- $tmp[0]<br>;
echo mp[1] --- $tmp[1]<br>;
echo mp[2] --- $tmp[2]<br>;
include ../connect.php;
$query=select * from member where num=2;
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$tel=explode(-, $row[tel]);
echo el[0] --- $tel[0]<br>;
echo el[1] --- $tel[1]<br>;
echo el[2] --- $tel[2]<br>;
?>
php스터디 2004 12 21
소스상세보기
http://www.6VJ.com/php/php1221.txt
| 
방송
