[학습과정]-----------------
-메모장만들기(입력,DB연결)
-For문 (반복문활용)
----------------------------
:::메모장만들기:::::::::::::::::::
---memolist.html-------------
번호 |
이름 |
이메일 |
메모 |
include connect.php;
$query=select * from mymemo;
$result=mysql_query($query,$connect);
while($row=mysql_fetch_row($result)){
echo
$row[0] |
$row[1] |
$row[2] |
$row[3] |
;
}
?>
메모입력
---memoinput.html-------------------------------
echo 넘어온이름 --- $name
;
echo 넘어온메일 --- $email
;
echo 넘어온메모 --- $memo
;
$connect=mysql_connect(localhost,apple,1234);
$db=mysql_select_db(appledb,$connect);
$query=insert into mymemo values(NULL,$name,$email,$memo);
$result=mysql_query($query,$connect);
if($result){
echo 데이타 입력성공!;
}else {
echo 데이타 입력실패!;
}
echo
?>
:::반복문:::::::::::::::::::::::::::
---for.php-------------------------
$su=0;
for($i=1;$i<=10;$i++){
$sum+$i//echo hello --- $i
;
}
echo sum --=$sum;
?>
---forlist.php---------------
include connect.php;
$query=select count(*) from mymemo;
$result=mysql_query($query,$connect);
$data=mysql_num_row($result);
echo data --- $data
;
$cnt=mysql_fetch_row($result);
$cnt
for($i=0;$i<10;$i++){
$row=mysql_fetch_row($result);
echo $row[0] ---$row[1] --- $row[2] ---$row[3]
;
}
?>
--------------------------------
php 스트디 2004 11 25
소스자세히보기
(상단메뉴는 웹에서 보여줌으로 에러부분이 있습니다)
http://www.6VJ.com/php/php1125.txt
http://www.6VJ.com/php/php1125.html
| 
방송
