관리-도구
편집 파일: membersList.php
<? include("../connect.php"); session_start(); $sql = "select * from emailUsers order by username"; $res = mysql_query($sql); ?> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <style type="text/css"> <!-- .Header { font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 14px; } .TblHeading {font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; font-size: 12px; } .datarow {font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif;} .style1 { color: #0000FF; font-weight: bold; font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif; } --> </style> <script language="javascript"> function doEdit(p) { var x; x = confirm("Do you wish to Edit User Information"); if (x==true) window.location="userEdit.php?baseTask=EditUser&memberID=" + p; } function doView(p) { var x; x = confirm("Do you wish to Delete selected User?"); if (x==true) window.location="userEdit.php?baseTask=DeleteUser&memberID=" + p; } </script> </head> <body> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#000000"> <tr> <td><table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8" class="Header"><strong>List of Users</strong></td> </tr> <?php if ($_GET['actionname'] == 'editSuccess') {?> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8"><div align="center"><span class="style1">User Details has been Updated Successfully. </span></div></td> </tr> <?php } ?> <?php if ($_GET['actionname'] == 'deleteSuccess') {?> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8"><div align="center"><span class="style1">User Deleted Successfully. </span></div></td> </tr> <?php } ?> <?php if ($_GET['actionname'] == 'addSuccess') {?> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8"><div align="center"><span class="style1">Congratulations! New User has been created successfully. </span></div></td> </tr> <?php } ?> <tr> <td width="4%" bgcolor="#F8F8F8" class="TblHeading">ID</td> <td width="10%" bgcolor="#F8F8F8" class="TblHeading">User Name</td> <td width="21%" bgcolor="#F8F8F8" class="TblHeading">Password</td> <td width="14%" bgcolor="#F8F8F8" class="TblHeading">User Type</td> <td width="15%" bgcolor="#F8F8F8" class="TblHeading">User Status</td> <td width="5%" align="center" valign="middle" bgcolor="#F8F8F8" class="TblHeading">Edit</td> <td width="9%" align="center" valign="middle" bgcolor="#F8F8F8" class="TblHeading">Delete</td> </tr> <? $i = 1; while ($row = mysql_fetch_row($res)) { ?> <tr valign="top"> <td bgcolor="#FFFFFF" class="datarow"> <? echo $i;?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[0]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[1]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[3]; ?></td> <td bgcolor="#FFFFFF" class="datarow"> <? echo $row[2]; ?></td> <td align="center" valign="middle" nowrap bgcolor="#FFFFFF" class="datarow"> <a><img src="../images/edit.jpg" width="20" height="20" onClick="doEdit('<?php echo $row[0]; ?>')"></a></td> <td align="center" valign="middle" nowrap bgcolor="#FFFFFF" class="datarow"> <?php if ($row[1] != 'admin') { ?> <a><img src="../images/view.jpg" width="20" height="20" onClick="doView('<?php echo $row[0]; ?>')"></a> <?php $i = $i + 1; } ?> </td> </tr> <? } ?> </table></td> </tr> </table> </body> </html>