conection class

pcwizzzz

Hi,
I wrote a conection class that doesn't work and i can't figure out why. Maybe someone sees what i dont. Thanks.
Here's the code:

class conectare
{
  private $server;
  private $username;
  private $passwd;
  private $conect;
  public $db;

function __construct($db)
  {
    $this->server="localhost";
    $this->username="user";
    $this->passwd="pass";
    $this->conect="mysql_connect($this->server,$this->username,$this->passwd)";
    $this->db=$db;
    mysql_select_db($this->db) or die ("Cannot connect!");
    }
}

And then create the instance in the file i need it:

$obj=new conectare("mydatabase");

The only message i get is "Cannot connect". It doesn't execute the mysql_select_db part. WHY?

Weedpacket

Looking at the syntax highlighting, my guess would be because you've got your entire database connection command inside a string.

pcwizzzz

You mean the mysql_connect sintax? Then how else should i put it if not as a string?

Norman_Graham

Hi Pcwizz

Your db connection command - mysql_connect - is inside string markers, as Weedpacket has pointed out. Your command is not a command at all, but a string. That's why it won't work.

Change it to:

$this->conect=mysql_connect($this->server,$this->username,$this->passwd);

Norm

pcwizzzz

Thanks alot. You are right, now it works. Still, i wandering, putting between " " means it gets parsed so ......why it didn't work that way? For my curiousity.

alexu_

putting it between " " doesn't mean it gets parsed. PHP will only parse simple variables.

for example
this works:

echo "the value is $a";
echo "the value is $a[0]";

but this doesn't work:

echo "the value is $a['name']";
echo "the value is strtolower($a)";

to be sure, I always put the variables and functions outside the strings.

pcwizzzz

Thanks. So it's better to keep variable and function outside de " ". Good to keep in mind.