Adding database name within the initial parameters

9three · 02-12-2009, 04:09 PM

Hey,

What I'm trying to accomplish is add the database name within the first line to avoid having two lines. This is what I mean:

PHP Code:


			
$connection = new mysql('localhost', 'root', '', 'cms');

$query = "SELECT ID, Username, Password, Email FROM admins";

$connection->query($query);

It's throwing me an exception saying that I did not select a database.

I'm trying to avoid this:

PHP Code:


			
$connection = new mysql('localhost', 'root', '');

$connection->select(cms);

$query = "SELECT ID, Username, Password, Email FROM admins";

$connection->query($query);

Here is my class file:

PHP Code:


			
  public function __construct($host = '', $username = '', $password = '', $dbname = '')

  {

    $this->host = $host;

    $this->username = $username;

    $this->password = $password;

    $this->dbname = $dbname;

    $this->connect();

  }

  

  public function connect()

  {

    $this->link = mysql_connect($this->host, $this->username, $this->password);

    if (!is_resource($this->link))

      Throw New Exception(mysql_error());

    else

      return $this->link;

  }

  

  public function select()

  {

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

    if (!is_resource($this->select))

      Throw New Exception(mysql_error());

    else

      return $this->select;

  }

I thought this was the way to do it but I guess I was wrong. Anyone know how to fix the parameters?