<?

class SQLLayer {

    var $server;

    var $user;

    var $passwd;

    var $dbname;

    var $link;



    function SQLLayer ($server = "", $user = "", $pass = "", $dbname = "") {

        $this->server = $server;

        $this->user = $user;

        $this->passwd = $pass;

        $this->dbname = $dbname;



        $this->connect ();

    }



    function connect () {

        $this->link = mysql_connect ($this->server, $this->user, $this->passwd);

        mysql_select_db ($this->dbname, $this->link);

    }



    function close () {

        return (mysql_close($this->link));

    }



    function query ($query) {

        $this->rs = mysql_query ($query, $this->link);

        if (!$this->rs)

        {

            echo("Error: Invalid query \"".$query."\"...<br>");

            echo("Error: ".mysql_errno()."<br>");

            die("Error: ".mysql_error()."<br>");

        } else {

            return ($this->rs);

        }

    }



    function data_seek ($row = "") {

        if ($row == "")

            $row = 0;



        mysql_data_seek ($rs, $row);

        return (true);

    }



    function fetch_array ($rs = "") {

        if ($rs == "")

            $rs = $this->rs;



        $this->row = mysql_fetch_array ($rs, MYSQL_BOTH);

        return ($this->row);

    }

    function fetch_object ($rs = "") {

        if ($rs == "")

            $rs = $this->rs;



        $this->row = mysql_fetch_object ($rs);

        return ($this->row);

    }

    function num_rows ($rs = "") {

        if ($rs == "")

            $rs = $this->rs;

        return (mysql_num_rows($rs));

    }



    function affected_rows() {

        return (mysql_affected_rows());

    }



    function free_result($rs = "") {

        if ($rs == "")

            $rs = $this->rs;



        return (mysql_free_result($rs));

    }

}

?>