All pastes #353152 Raw Edit

Jstr

public php v1 · immutable
·published 2007-02-13 06:00 UTC
rendered paste body
<?phpinclude 'library/config.php';include 'library/opendb.php';// if no id is specified, list contacts   if(!isset($_GET['id']))    {     $self   = $_SERVER['PHP_SELF'];     $query  = "SELECT id, lname FROM contacts ORDER BY lname ASC";     $result = mysql_query($query) or die('Error : ' . mysql_error()); 	// create the contact list       $contact_list = '<ol>';       while($row = mysql_fetch_array($result, MYSQL_NUM))	{	 list($id, $lname,) = $row;	 $contact_list .= "<li><a href=\"$self?id=$id\">$lname</a></li>\r\n";	}		$contact .= '</ol>';	$page_title  = 'Address Book';// get the contact info from database         }           else          {          $query  = "SELECT lname, fname FROM contacts WHERE id=".$_GET['id'];	  $result = mysql_query($query) or die('Error : ' . mysql_error()); 	  $row   = mysql_fetch_array($result, MYSQL_ASSOC); 	  $lname = $row['lname'];	  $fname = $row['fname'];         }	include 'library/closedb.php';?><html><head><title><?php echo $page_title;?></title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"><style type="text/css"><!--h1 {	font-family: Arial, Helvetica, sans-serif;	font-size: 18px;	color: #006699;	font-weight: bold;}.main {	padding: 10px;	border: 1px solid #006699;	position: relative;	width: 580px;	margin-top: 20px;	margin-bottom: 20px;	font-family: Arial, Helvetica, sans-serif;	font-size: 12px;}--></style></head><body><table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699"> <tr>   <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $page_title;?></h1><?php echo $contact_list;// when displaying an contact show a link to see the contact list   if(isset($_GET['id']))   {  ?>   <p>&nbsp;</p>   <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back</a></p><?php}?>    </td> </tr>  <tr>   <td bgcolor="#FFFFFF"><a href="admin.php">Admin</a></td></tr></table></body></html>