dbcon class

require_once 'config.php';

class DBCon
{
var $conn;
var $host;
var $port;
var $db_name;
var $db_username;
var $db_password;
var $result;

function __construct($id=0){
$this->host = DB_HOST;
$this->port = DB_PORT;
$this->db_username = DB_USER;
$this->dbpass = DB_PWD;
$this->db_name = DB_NAME;
}

function getInstance()
{
$this->conn = mysql_connect($this->host.':'.$this->port,$this->db_username,$this->dbpass);
if($this->conn)
{
mysql_select_db($this->db_name);
}
else
{
echo "Error connecting to database.".mysql_error();
exit();
}

}

function sqlQuery($sql) {
if( (isset($this -> conn)) && ($sql != '') ){
$this->result = mysql_query($sql);

if ($this->result)
{
return $this->result;
}
else
{
return false;
}
}
}

function getLastInsertId($tableName)
{
$sql = "SELECT LAST_INSERT_ID() AS 'LAST_ID' FROM ".$tableName;
$lastInsertId = -1;
$this->result = mysql_query($sql);
while ($row = mysql_fetch_assoc($this->result))
{
$lastInsertId = $row['LAST_ID'];
break;
}
return $lastInsertId;
}


}

?>