관리-도구
편집 파일: seatReserve.php
<? session_start(); $dbhost = 'internal-db.s3783.gridserver.com'; $dbusername = 'aaronmeyer'; $dbuserpassword = 'CQDZZDsu'; $default_dbname = 'db3783_ticketingSystem'; $link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword); $dbid = mysql_select_db($default_dbname); ?> <!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"> <!-- .style1 { font-family: "Berlin Sans FB"; font-size: 18px; } .style4 {font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } --> </style> </head> <body><form id="form1" name="form1" method="post" action="tix_details.php"> <table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#333333"> <tr> <td> <table width="100%" border="0" cellspacing="1" cellpadding="6"> <tr> <td height="40" colspan="2" align="center" valign="middle" bgcolor="#FFFFFF"><span class="style1">Seat Reservation Administration Panel </span></td> </tr> <tr> <td width="48%" align="right" valign="middle" bgcolor="#FFFFFF"><span class="style4">Select Event</span></td> <td width="52%" align="left" valign="middle" bgcolor="#FFFFFF"> <select name="eid" id="eid"> <? $esql = "select * from eventmaster order by id"; $eres = mysql_query($esql); while ($erow = mysql_fetch_row($eres)) {?> <option value="<? echo $erow[0]; ?>"><? echo $erow[1] . " " . $erow[2]; ?></option> <? } ?> </select> </td> </tr> <tr> <td align="right" valign="middle" bgcolor="#FFFFFF"><span class="style4">Select Count of Reserved Seats </span></td> <td align="left" valign="middle" bgcolor="#FFFFFF"> <select name="res_seating" id="res_seating"> <option value="0" selected="selected">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> </select> </td> </tr> <tr> <td align="right" valign="middle" bgcolor="#FFFFFF"><span class="style4">Select Count of General Admission (Adult) </span></td> <td align="left" valign="middle" bgcolor="#FFFFFF"><select name="gen_1_seating" id="gen_1_seating"> <option value="0" selected="selected">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> </select></td> </tr> <tr> <td align="right" valign="middle" bgcolor="#FFFFFF"><span class="style4">Select Count of General Adminssion for Seniors, Children, Students </span></td> <td align="left" valign="middle" bgcolor="#FFFFFF"><select name="gen_2_seating" id="gen_2_seating"> <option value="0" selected="selected">0</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> </select></td> </tr> <tr> <td colspan="2" bgcolor="#FFFFFF"><div align="center"> <input type="submit" name="Submit" value="Proceed with Selection" /> </div></td> </tr> </table> </td> </tr> </table></form> </body> </html>