Problème avec une classe

Marsh Posté le 30-10-2008 à 13:54:54

Bonjour,

J'ai un problème avec une classe, en fait pour faire simple, cela ne m'affiche rien. Voila le code :

Code :

class Mycv{
private $dbhote = '',
private $dbbase = '',
private $dbuser = '',
private $dbpass = '',
private $dsn = '';
private $dbh = '';
public function __construct($dbhote = 'localhost', $dbbase = 'test', $dbuser = 'root', $dbpass = '')
{
$this->dbhote = $dbhote;
$this->dbbase = $dbbase;
$this->dbuser = $dbuser;
$this->dbpass = $dbpass;
$this->dsn = 'mysql:dbname=$this->dbbase;host=$this->dbhote';
$this->dbh = new PDO($this->dsn, $this->dbuser, $this->dbpass);
}
public function viewData(){
$sql = 'SELECT * FROM fic_opex_cla';
$res = $this->dbh->query($sql);
while($row = $res->fetch(PDO::FETCH_NUM)){
echo $row[1].'<br/>';
}
}
}
$test = new Mycv();
$test->viewData();

Je ne vois pas d'ou vient l'erreur. Si quelqu'un pouvait m'aider.

Marsh Posté le 30-10-2008 à 13:54:54

Marsh Posté le 30-10-2008 à 14:29:18

C'est bon j'ai corrigé et cela fonctionne :

Code :

1. class Mycv{
2.
3. private $dbhote = '';
4. private $dbbase = '';
5. private $dbuser = '';
6. private $dbpass = '';
7. private $dsn = '';
8. private $dbh = '';
9.
10. public function __construct($dbhote = 'localhost', $dbbase = 'test', $dbuser = 'root', $dbpass = '')
11. {
12. $this->dbhote = $dbhote;
13. $this->dbbase = $dbbase;
14. $this->dbuser = $dbuser;
15. $this->dbpass = $dbpass;
16. $this->dsn = 'mysql:dbname=$this->dbbase;host=$this->dbhote';
17. $this->dbh = new PDO($this->dsn, $this->dbuser, $this->dbpass);
18. }
19.
20. public function viewData(){
21. $this->sql = 'SELECT * FROM fic_opex_cla';
22. $this->res = $this->dbh->query($sql);
23. while($this->row = $this->res->fetch(PDO::FETCH_NUM)){
24. echo $this->row[1].'<br/>';
25. }
26. }
27. }
28.
29. $test = new Mycv();
30. $test->viewData();

Make sure you enter the(*)required information where indicate.HTML code is not allowed

Name *

Email *

URL

Message *