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
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
music.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;
}
}
?>
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...
<?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;
}
}
?>