PHP Classes

File: index.php

Recommend this page to a friend!
  Classes of Bimal Poudel   MySQL access class   index.php   Download  
File: index.php
Role: Example script
Content type: text/plain
Description: Basic example file
Class: MySQL access class
MySQL database access wrapper
Author: By
Last change:
Date: 15 years ago
Size: 1,927 bytes
 

Contents

Class file image Download
<?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 />
      poudel@bimal.org.np<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>