Access denied for user 'www-data'@'localhost'

leandro_gs
(usa Ubuntu)

Enviado em 10/02/2012 - 18:52h

Pessoal, estou com graves problemas! Preciso fazer uma conexão com o banco de dados mas sempre obtenho o seguinte erro:
Warning: mysql_query(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/acervomusical/models/database.php on line 74 Warning: mysql_query(): A link to the server could not be established in /var/www/acervomusical/models/database.php on line 74 Access denied for user 'www-data'@'localhost' (using password: NO)

Segue o código:

dataBase.php

<?php



class dataBase {



    private $host;

    private $user;

    private $pass;

    private $dBase;

    private $queryFields = NULL;

    private $queryValues = NULL;

    private $queryIquality = NULL;

    private $sql;

    private $query;

    public $table;

    public $fields; //array

    public $values; //array

    private $connection;



    public function __construct() {

        $this->connection();

    }



    private function connection() {

        $this->host = 'localhost';

        $this->user = 'root';

        $this->pass = '12345';

        $this->dBase = 'collection';



        $connection = mysql_connect($this->host, $this->user, $this->pass) or die(mysql_error());

        mysql_select_db($this->dBase, $connection);

    }



    //$type == 1 -> Insert

    //$type == 2 -> Update

    //$type == 3 -> Delete

    private function buildQuery($type) {

        $cont = count($this->fields);



        for ($i = 0; $i < $cont; $i++) {

            //Se tiver mais de 1

            if ($i < $cont - 1) {

                if ($type == 1) {

                    $this->queryFields .= $this->fields[$i] . ", ";

                    $this->queryValues .= "'" . $this->values[$i] . "', ";

                } elseif ($type == 2) {

                    

                } elseif ($type == 3) {

                    //$this->queryFields .= $this->fields[$i] . "=" . "'" .

                    //      $this->values[$i] . "' AND ";

                }

                //Se tiver apenas 1

            } else {

                if ($type == 1) {

                    $this->queryFields .= $this->fields[$i];

                    $this->queryValues .= "'" . $this->values[$i] . "'";

                } elseif ($type == 2) {

                    

                } elseif ($type == 3) {

                    $this->queryIquality .= $this->fields[$i] . "=" . "'" .

                            $this->values[$i] . "'";

                } elseif ($type == 4) {

                    $this->queryIquality .= $this->fields[$i] . "=" . "'" .

                            $this->values[$i] . "'";

                }

            }

        }

    }



    public function insertValues() {

        $this->buildQuery(1);



        $this->sql = "INSERT INTO " . $this->table . " (" . $this->queryFields .

                ") VALUES (" . $this->queryValues . ")";

        $this->query = mysql_query($this->sql) or die(mysql_error());

        $this->result = mysql_affected_rows();



        return $this->result;

    }



    public function updateValues() {

        

    }



    public function deleteValues() {

        $this->buildQuery(3);



        $this->sql = "DELETE FROM " . $this->table . " WHERE " .

                $this->queryFields;

        $this->query = mysql_query($this->sql);

        $this->result = mysql_affected_rows();



        return $this->result;

    }



    public function selectValues($string) {

        $this->buildQuery(4);



        $this->sql = "SELECT * FROM " . $this->table . " WHERE " .

                $this->queryIquality . " ORDER BY " . $string . " ASC";

        $this->query = mysql_query($this->sql);

        $this->result = mysql_affected_rows();



        return $this->result;

    }



}



?>

 

music.php

<?php



require_once ("database.php");



class music extends dataBase {



    private $track;

    private $alb_id;

    private $title;

    private $artist;



    function __construct() {

        

    }



    public function setTrack($int) {

        $this->track = $int;

    }



    public function setAlb_id($int) {

        $this->alb_id = $int;

    }



    public function setTitle($string) {

        $this->title = $string;

    }



    public function setArtist($string) {

        $this->artist = $string;

    }



    public function getTrack() {

        return $this->track;

    }



    public function getAlb_id() {

        return $this->alb_id;

    }



    public function getTitle() {

        return $this->title;

    }



    public function getArtist() {

        return $this->artist;

    }



    public function insert() {

        $this->table = "music";

        $this->fields = array("track", "alb_id", "title", "artist");

        $this->values = array($this->getTrack(), $this->getAlb_id(),

            $this->getTitle(), $this->getArtist());

        $result = $this->insertValues();



        return $result;

    }



    public function delete($id) {

        $this->fields = array("id");

        $this->values = array($id);

        $result = $this->deleteValues();

        

        return $result;

    }



}



?>

 

Ps.: Estou tentando fazer um DAO aí, e estou tentando utilizar os padrões MVC. Eu sei que tem muita coisa fora dos padrões, mas pra início está bom...