위화면에서 수정 버튼을 누르면 아래화면으로 이동
mod.php
<?php header("Content-Type: text/html; charset=utf-8") //UTF-8 설정 ?> <? $id = $_GET['id'];
// MySQL 접속 $host = "localhost"; $user = "mydb"; $password = "db123"; $mydb = mysql_connect($host, $user, $password);
$db_id = mysql_select_db('info', $mydb); // SQL 만들기(데이터 추가) $sql = "SELECT * FROM test WHERE id=$id"; $result = mysql_query($sql, $mydb);
$row = mysql_fetch_row($result); echo(" <html> <head> <title>fareastbarbellgym 회원정보 입력</title>
</head> <body> <h1>회원정보 입력</h1> <form method=post action='inmod.php'>
<table> <tr> <td>이름</td> <td valign=middle width=50> <input type=text size=50 name=name value=$row[1]> </td> </tr> <tr> <td>전화번호</td> <td valign=middle width=50> <input type=text size=50 name=tel value=$row[2]> </td> </tr> <tr> <td>최초 등록일</td> <td valign=middle width=50> <input type=text size=50 name=start value=$row[3]> </td> </tr> <tr> <td>만료일</td> <td valign=middle width=50> <input type=text size=50 name=end value=$row[4]> </td> </tr> <tr> <td valign=top>기타</td> <td> <textarea cols=50 rows=5 name=text>$row[5]</textarea> <input type= hidden name=id value=$row[0]> </td>
</tr>
</table> <input type=submit value='입력'> <input type=reset value='취소'> </form>
<form action='output.php'> <br> <input type=submit value='출력'> </form>
<br>
</body> </html>"); ?> |
'php 공부' 카테고리의 다른 글
| 삭제 del.php (0) | 2014.10.10 |
|---|---|
| 수정정보 입력 inmod.php (0) | 2014.10.10 |
| 회원정보 입력 indb.php (0) | 2014.10.10 |
| 회원정보 입력폼 insert.php (0) | 2014.10.10 |
| 회원정보 list (0) | 2014.10.10 |
