HELP: connect mysql with opp

[omar-do]

I have 2 files :

 

Index.php

 

<?php

 

require_once 'class.php';

//

$db = new db;

$db -> connect('localhost','root','NULL');

 

?>

 

And class.php

 

<?php

class db {

  public $host, $user, $password;

 

 

  public function connect() {

     

      print mysql_connect($this->host,$this->user,$this->password ) or die (mysql_error());

     

  }

 

}

?>

 

Where am i making mistake ?

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user ''@'localhost' (using password: NO) in C:\server\www\opp\class.php on line 8

[gizmola]

Your mistake is in your lack of understanding of parameters to functions/methods.  You have a method connect() that has no parameters, then you attempt to call it passing parameters to it, which php ignores. 

[omar-do]

when i add the parameters in connect() i have the same error ...

 

public function connect($host,$user,$password)

[Maq]

Are you really passing in the string NULL?

[ManiacDan]

You're still not doing it right.  Take the $this-> out of the mysql_connect call, just use $host, $user, and $pass that you're passing in.

 

Research variable scope and OOP

 

-Dan

[omar-do]

public function connect($host,$user,$password) {

     

      print mysql_connect($host,$user,$password ) or die (mysql_error());

     

  }

 

 

same error ? what's wrong

[ManiacDan]

The EXACT same error?  Or now it's saying "access denied for user 'root'@'localhost' (using password: NO)"?

 

If it's exactly the same, your code isn't what you say it is, paste the whole thing again.

 

If it's changed the one I posted above, then your password for root is not "null," you probably just want an empty string ""

 

-Dan

[omar-do]

Thanks the password must be empty thanks