관리-도구
편집 파일: customersList.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); $sql = "select * from personaldetails order by id"; $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;} --> </style> </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>Online Ticket Booking System -> Customers List </strong></td> </tr> <tr> <td bgcolor="#F8F8F8" class="TblHeading">ID</td> <td bgcolor="#F8F8F8" class="TblHeading">Name</td> <td bgcolor="#F8F8F8" class="TblHeading">Email Address </td> <td bgcolor="#F8F8F8" class="TblHeading">Phone No. </td> <td bgcolor="#F8F8F8" class="TblHeading">Address</td> <td bgcolor="#F8F8F8" class="TblHeading">Type of Card</td> <td bgcolor="#F8F8F8" class="TblHeading">CC Number</td> <td bgcolor="#F8F8F8" class="TblHeading">CC Expiry </td> <td bgcolor="#F8F8F8" class="TblHeading">CVV Code </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"> <a href="bookingsList.php?target=Customer&id=<? echo $row[0]; ?>"><? echo $row[3]; ?></a></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[4]; ?></td> <td bgcolor="#FFFFFF" class="datarow"> <? echo $row[5] . " " . $row[6] . " " . $row[7] . " " . $row[8]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[2]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[9]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[10]; ?></td> <td bgcolor="#FFFFFF" nowrap class="datarow"> <? echo $row[11]; ?></td> </tr> <? } ?> <tr> <td height="40" colspan="9" bgcolor="#F8F8F8" class="TblHeading"><strong>Note - </strong>Click on email address to view all bookings for this customer.</td> </tr> </table></td> </tr> </table> </body> </html>