<?php
$host='localhost';
$username='abc';
$password='abc1';
$database='abc2';
class dbCLass{

    var $link;
    function dbClass()
    {
        global $host,$username,$password,$database;
        $this->link=mysql_connect($host,$username,$password)or die(mysql_error());
        mysql_select_db($database,$this->link)or die(mysql_error());
    }
    function showsql($sql)
    {
            $rs=mysql_query($sql,$this->link)or die(mysql_error());
            $rsarray=array();
            if(mysql_num_rows($rs)>0)
            {
                while($row=mysql_fetch_array($rs,MYSQL_ASSOC))
                {
                    $rsarray[]=$row;
                }
                return $rsarray;
            }
        return NULL;
    }

    function select($sql)
    {
        $pos2=stripos("select",$sql);
        if($pos2 >=0)
        {
            $rs=mysql_query(trim($sql),$this->link)or die($sql.mysql_error($this->link));
            $rsarray=array();
            if(mysql_num_rows($rs)>0)
            {
                while($row=mysql_fetch_array($rs,MYSQL_ASSOC))
                {
                    $rsarray[]=$row;
                }
            }
            return $rsarray;
        }
        return NULL;
    }

    function update($sql)
    {
        $rs=mysql_query($sql,$this->link)or die(mysql_error());
        return $rs;
    }
    function insert($sql)
    {
        $rs=mysql_query($sql,$this->link)or die(mysql_error());
        return mysql_insert_id($this->link);
    }
    function delete($sql)
    {
        $rs=mysql_query($sql,$this->link)or die(mysql_error());
        return $rs;
    }

}

$dbObj=new dbCLass();
?>