php数据库操作类

test.php
<?
require_once("my sqlClass.ini.php");

$dbHanle = new mysqlClass();
$user_res = $dbHanle->query("select * from user limit 5");
?>
<table width="500" border="0" align="center" cellpadding="0" cellspacing="0">
  <?
  while ($user_row = $dbHanle->fetch_array($user_res))
  {
  ?>
  <tr>
    <td align="left"><?=$user_row['user_id'];?></td>
    <td align="left"><?=$user_row['username'];?></td>
    <td align="left"><?=$user_row['name'];?></td>
  </tr>
  <?
  }
  ?>
</table>




mysql.ini.php
<?php
class mysqlClass
{
        private $conn;
       
        function __construct()
        {
                require_once('conn.ini.php');
                $this->conn = mysql_connect($dbhost, $dbuser, $dbpass);
                mysql_select_db($dbname, $this->conn);
                mysql_query('set names gb2312', $this->conn);
        }
       
        function query($sql)
        {
                return mysql_query($sql);
        }
       
        function fetch_array($result)
        {
                return mysql_fetch_array($result);
        }

        function num_rows($result)
        {
                return mysql_num_rows($result);
        }
}
?>





conn.ini.php
<?
$dbhost = '127.0.0.1';
$dbuser = 'root';
$dbpass = '';
$dbname = 'user';
?>