관리-도구
편집 파일: queryRunner.php
<? include("../connect.php"); session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <style type="text/css"> <!-- .style3 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: bold; } .style5 {font-size: 12px; font-family: Verdana, Arial, Helvetica, sans-serif;} --> </style> </head> <body> <form id="form1" name="form1" method="post" action="membersList.php?action=search"> <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#333333"> <tr> <td><table width="100%" border="0" cellspacing="1" cellpadding="4"> <tr> <td height="40" colspan="2" bgcolor="#FFFFFF" class="style3"><span class="style5">Run Queries from Below Criteria </span></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Enter First Name : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><input name="txtfirstname" type="text" id="txtfirstname" /></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Enter Last Name : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><input name="txtlastname" type="text" id="txtlastname" /></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Enter Email Address : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><input name="txteaddress" type="text" id="txteaddress" /></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Enter City : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><input name="txtcity" type="text" id="txtcity" /></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Enter State : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><input name="txtstate" type="text" id="txtstate" /></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Enter Zipcode : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><input name="txtzip" type="text" id="txtzip" /></td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Select Group : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><select name="groupid" id="groupid"> <option value="0">Select Group</option> <?php $sql = "select distinct(grpname) from memgroup order by grpname"; $res = mysql_query($sql); while ($row = mysql_fetch_row($res)) {?> <option value="<?php echo $row[0]; ?>"><?php echo $row[0]; ?></option> <?php } ?> </select> </td> </tr> <tr> <td width="30%" align="right" bgcolor="#FFFFFF" class="style5">Sorting Order : </td> <td width="70%" align="left" bgcolor="#FFFFFF" class="style5"><select name="sortby" id="sortby"> <option value="First Name">First Name</option> <option value="Last Name">Last Name</option> <option value="City">City</option> <option value="State">State</option> <option value="Zip">Zip</option> <option value="Paperwork">Paperwork</option> <option value="signupdate" selected="selected">SignUp Date</option> </select> </td> </tr> <tr> <td height="43" colspan="2" bgcolor="#FFFFFF" class="style5"><div align="center"> <input type="submit" name="SubmitSearch" id="SubmitSearch" value="Search Members Now!!" /> </div></td> </tr> </table></td> </tr> </table> </form> </body> </html>