관리-도구
편집 파일: membergrpList.php
<? include("../connect.php"); session_start(); $sql = "select * from memgroup group by grpname"; $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; } .style2 {color: #FF0000} --> </style> <script language="javascript"> function doEdit(p) { var x; x = confirm("Do you wish to Edit Member Group"); if (x==true) window.location="memberGrouping.php?baseTask=EditGroup&memberGrpID=" + p; } function doView(p) { var x; x = confirm("Do you wish to Delete Member Group?"); if (x==true) window.location="memberGrouping.php?baseTask=DeleteGroup&memberGrpID=" + 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"><table width="100%" border="0" cellspacing="2" cellpadding="4"> <tr> <td width="72%"><strong>Each1 Bless1 -> Members Groups List </strong></td> <td width="28%" class="TblHeading"><div align="right"><a href="memberGrouping.php?baseTask=CreateGroup">Click here</a> to Create new Member Group </div></td> </tr> </table></td> </tr> <?php if ($_GET['type'] != '') {?> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8"><div align="center"><span class="style1"><?php echo $_GET['actionmessage']; ?></span></div></td> </tr> <?php } if (mysql_num_rows($res) > 0) {?> <tr> <td width="4%" bgcolor="#F8F8F8" class="TblHeading">ID</td> <td width="14%" bgcolor="#F8F8F8" class="TblHeading">Group Name</td> <td width="15%" bgcolor="#F8F8F8" class="TblHeading">Group Description</td> <td width="5%" align="center" valign="middle" bgcolor="#F8F8F8" class="TblHeading">Edit Group</td> <td width="9%" align="center" valign="middle" bgcolor="#F8F8F8" class="TblHeading">Delete Group</td> </tr> <? while ($row = mysql_fetch_row($res)) { ?> <tr valign="top"> <td bgcolor="#FFFFFF" class="datarow"> <? echo $row[0]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[1]; ?></td> <td bgcolor="#FFFFFF" nowrap 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"> <a><img src="../images/view.jpg" width="20" height="20" onClick="doView(<?php echo $row[0]; ?>)"></a></td> </tr> <? } } else {?> <tr> <td height="33" colspan="7" bgcolor="#F8F8F8" class="datarow"><div align="center" class="style2">No Member Group Eists.</div></td> </tr> <?php } ?> </table></td> </tr> </table> </body> </html>