회원정보 list

list.php

<?php header("Content-Type: text/html; charset=utf-8")  //UTF-8 설정 ?>   <? $mydb = @mysql_connect("localhost", "mydb", "db123"); if(!mysql_select_db('info', $mydb)) die("데이터베이스를 선택할 수 없습니다."); $result = mysql_query('SELECT * FROM test'); if($result)  { echo ("<table border=1> <tr> <td bgcolor=skyblue>이름</td> <td bgcolor=skyblue>전화번호</td> <td bgcolor=skyblue>최초등록일</td> <td bgcolor=skyblue>만료일</td> <td bgcolor=skyblue>기타</td> <td bgcolor=skyblue>설정</td> </tr>"); while($row = mysql_fetch_row($result))  { echo(" <tr> <td> $row[1] </td>  <td> $row[2] </td> <td> $row[3] </td> <td> $row[4] </td> <td> $row[5] </td> <td> <a href='mod.php?id=$row[0]'>수정</a>,<a href='del.php?id=$row[0]'>삭제</a></td> </tr> "); } echo ("</table>"); } else die('SQL 에러 발생 : ' . mysql_error($mydb)); mysql_close($mydb); echo (" <form action='insert.php'> <br> <input type=submit value='입력'> </form>"); ?>