fwbbetsy Posted September 2, 2007 Share Posted September 2, 2007 i have set up a site and I have an error and the site won't load becuase of an error ... This is the error: arning: mysql_connect() [function.mysql-connect]: Access denied for user 'nicevill_fwbbets'@'localhost' (using password: YES) in /home/nicevill/public_html/includes/mysql.php on line 35 Database error: Link-ID == false, connect failed MySQL Error: 0 () Session halted. I am not sure what kind of information you might need to help me so just let me know. Thanks Betsy Link to comment https://forums.phpfreaks.com/topic/67667-need-some-help-with-database/ Share on other sites More sharing options...
fwbbetsy Posted September 2, 2007 Author Share Posted September 2, 2007 maybe this wll help this is the file I used to input the info on the database <? class DB_Sql { var $Host = "localhost"; // Hostname of our MySQL server. var $Database = "nicevill_ptc"; // Logical database name on that server. var $User = "123"; // User und Password for login. var $Password = "123"; var $Link_ID =0; // Result of mysql_connect(). var $Query_ID =0; // Result of most recent mysql_query(). var $Record = array(); // current mysql_fetch_array()-result. var $Row; // current row number. var $Errno = 0; // error state of query... var $Error = ""; var $num_queries = 0; function halt($msg) { printf("</td></tr></table><b>Database error:</b> %s<br>\n", $msg); printf("<b>MySQL Error</b>: %s (%s)<br>\n", $this->Errno, $this->Error); die("Session halted."); } function free_result($sql) { $this->free_result($sql); } function connect() { if ( 0 == $this->Link_ID ) { $this->Link_ID=mysql_connect($this->Host, $this->User, $this->Password); if (!$this->Link_ID) { $this->halt("Link-ID == false, connect failed"); } if (!mysql_query(sprintf("use %s",$this->Database),$this->Link_ID)) { $this->halt("cannot use database ".$this->Database); } } } function fetch_array($query_id=-1,$query_string="") { if ($query_id!=-1) { $this->query_id=$query_id; } if ( isset($this->query_id) ) { $this->record = mysql_fetch_array($this->query_id); } else { if ( !empty($query_string) ) { $this->halt("Invalid query id (".$this->query_id.") on this query: $query_string"); } else { $this->halt("Invalid query id ".$this->query_id." specified"); } } return $this->record; } function query($Query_String) { // $this->connect(); $this->num_queries++; #printf("<br><font color=red><b>Debug: query = %s</b></font><br>", $Query_String); // Use for debugging $this->Query_ID = mysql_query($Query_String,$this->Link_ID); $this->Row = 0; $this->Errno = mysql_errno(); $this->Error = mysql_error(); if (!$this->Query_ID) { $this->halt("Invalid SQL: ".$Query_String); } return $this->Query_ID; } function next_record() { $this->Record = mysql_fetch_array($this->Query_ID); $this->Row += 1; $this->Errno = mysql_errno(); $this->Error = mysql_error(); $stat = is_array($this->Record); if (!$stat) { mysql_free_result($this->Query_ID); $this->Query_ID = 0; } return $stat; } function seek($pos) { $status = mysql_data_seek($this->Query_ID, $pos); if ($status) $this->Row = $pos; return; } function num_rows() { return mysql_num_rows($this->Query_ID); } function num_fields() { return mysql_num_fields($this->Query_ID); } function f($Name) { return $this->Record[$Name]; } function p($Name) { print $this->Record[$Name]; } function affected_rows() { return @mysql_affected_rows($this->Link_ID); } function get_temps() { while ($row = mysql_fetch_array($this->Query_ID)) { $templ[$row["id"]] = $row['con']; } echo "$templ[1]<br>$templ[2]"; } function get_temp() { return mysql_fetch_array($this->Query_ID); } function query_first($query_string) { // does a query and returns first row $query_id = $this->query($query_string); $returnarray=$this->fetch_array($query_id, $query_string); $this->free_result($query_id); return $returnarray; } function sql_close() { if($this->db_connect_id) { if($this->query_result) { @mysql_free_result($this->query_result); } $result = @mysql_close($this->db_connect_id); return $result; } else { return false; } } } ?> Link to comment https://forums.phpfreaks.com/topic/67667-need-some-help-with-database/#findComment-339952 Share on other sites More sharing options...
fenway Posted September 4, 2007 Share Posted September 4, 2007 You have the wrong login credentials. Link to comment https://forums.phpfreaks.com/topic/67667-need-some-help-with-database/#findComment-341543 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.