简单的数据库连接类

PHP CODE:
class recordset{
  var $show;
  //主機
  var $host="主機";
  //帳號
  var $dbid="帳號";
  //密碼
  var $passwd="密碼";
  //資料庫
  var $database="資料庫";
  
  var $conn;
  
  function connect(){
    $this->conn=mysql_connect($this->host,$this->dbid,$this->passwd);
    mysql_select_db($this->database);
  }  
  function recordset($sql){
    if(!is_resource($this->conn))
      $this->connect();
    if(is_resource($this->conn)) {
      $q=mysql_query($sql,$this->conn);
      $this->show=mysql_fetch_array($q);
    }
  }  
}
$sql="select * from login_list where sn='02'  ";
$get_db = new recordset($sql);
$A = $get_db->show["id"];
echo $A ;
?>