Location: PHPKode > scripts > MySQL access class > mysql-access-class/index.php
<?php
require_once('config.inc.php');

$db = new mysql();

$sql_domains="
SELECT
	IF(domain_name != '', CONCAT(domain_name, '.', domain_server), domain_server) domain,
	domain_comments comments
FROM domains
;";

$db->query($sql_domains);
?>
<!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>The database class</title>
<style type="text/css">
<!--
body,td,th {
	font-family: Verdana, Arial, Helvetica, sans-serif;
	font-size: 12px;
	color: #003366;
}
body {
	background-color: #FFFFFF;
	margin-left: 20px;
	margin-top: 20px;
	margin-right: 20px;
	margin-bottom: 20px;
}
a{
	color: #0000FF;
	text-decoration:none;
}
a:hover
{
	text-decoration:underline;
	color:#000000;
}
h1 {
	font-size: 16px;
}
th
{
	text-align:left;
	font-weight:bold;
	color:#660033;
	border-bottom:1px solid #0099FF;
	background-color:#CCCCCC;
}
table
{
	border:1px solid #0099FF;
}
-->
</style></head>
<body>
<h1>The database class</h1>
<table border="0" cellspacing="0" cellpadding="4">
  <tr>
    <th>Domain</th>
    <th>Comments</th>
  </tr>
<?php
while($db->next_record())
{
?>
  <tr>
    <td><a href="http://<?=$db->row_data['domain']?>"><?=$db->row_data['domain']?></a></td>
    <td><?=$db->row_data['comments']?></td>
  </tr>
<?php
}
?>
  <tr>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td><p><strong>Please visit these websites.</strong></p>
    <p><strong>Made by:</strong></p>
    <p><strong>Bimal Poudel<br />
      hide@address.com<br />
      http://bimal.org.np</strong></p>
    <p><strong>Contact for high quality database and website programming needs.</strong></p></td>
  </tr>
</table>
</body>
</html>
Return current item: MySQL access class