Jump to content

Need some help with database ...


fwbbetsy

Recommended Posts

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

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;

}

}

 

 

 

}

 

 

 

 

 

 

?>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.