:::::::::::::::::::::::::::::::::::::::::::::::::::::::::
***index.html
New Document
|
¸Þ´º
óÀ½À¸·Î
if($id){
echo " {$name}´Ô ȯ¿µÇÕ´Ï´Ù. ";
echo " ·Î±×¾Æ¿ô ";
}else{
?>
ȸ¿ø°¡ÀÔ
}?>
°Ô½ÃÆÇ
¸Þ¸ðÀå
|
ºä
if(!$mode){
$mode="home";
}
switch($mode){
case "home": include "null.html";
break;
case "board": include "board1/list.html";
break;
case "memo": include "..memo/memolist.html";
break;
case "join": include "regist.html";
break;
case "bdview" : include "./board1/view.html";
break;
}
?>
|
:::::::::::::::::::::::::::::::::::::::::::::::::::::
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 "tmp1 --- $tmp1
";
echo "tmp2 --- $tmp2
";
echo "tmp3 --- $tmp3
";
echo "tmp4 --- $tmp4
";
echo "tmp5 --- $tmp5
";
echo "tmp6 --- $tmp6
";
include "../connect.php";
$query="create table test33( add);";
$result=mysql_query($query);
echo "result --- $result
";
?>
***explode.php
$str="aaa-bbb-ccc";
$tmp=explode("-",$str);
echo "tmp[0] --- $tmp[0]
";
echo "tmp[1] --- $tmp[1]
";
echo "tmp[2] --- $tmp[2]
";
include "../connect.php";
$query="select * from member where num=2";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$tel=explode("-", $row[tel]);
echo "tel[0] --- $tel[0]
";
echo "tel[1] --- $tel[1]
";
echo "tel[2] --- $tel[2]
";
?>
php½ºÅ͵ð 2004 12 21
¼Ò½º»ó¼¼º¸±â
http://www.6VJ.com/php/php1221.txt